common_schema 2.1 is released! common_schema is your free & open source companion schema within your MySQL server, providing with a function library, scripting capabilities, powerful routines and ready-to-apply information and recommendations.
Run Ubuntu and want to try new features of
href="http://www.percona.com/software/percona-xtrabackup" target="_blank">Percona XtraBackup? Well, now you can. We have a Personal Package Archive (PPA)
href="https://launchpad.net/~percona-daily/+archive/percona-xtrabackup">percona-daily/percona-xtrabackup. Every time code is pushed to our main source code repository, the PPA is updated.
We are currently building for Ubuntu lucid (10.04LTS), Precise (12.04), Quantal (12.10) and Raring (13.04).
To add the repository to your Ubuntu system, simply run:
class="alignleft" alt="" src="http://www.veryicon.com/icon/png/System/NX10/Time.png" width="179" height="179" />MySQL 5.6 introduces a new feature – microseconds resolution in some temporal types. As of 5.6.4 TIME, TIMESTAMP and DATETIME can have a fractional part. To create a field with subseconds you can specify precision in brackets: TIME(3), DATETIME(6) etc.
On Thursday, Dr Charles Bell and I will be presenting a webinar on MySQL Utilities; there will be a heavy focus on what you can acheive with them and how you should use them. As well as listening to the presentation, this is a great chance to get your questions answered by the experts (Israel Gomez from the engineering team will also be on-line to help with the questions).
class="alignleft size-full wp-image-13396" alt="Percona Server for MySQL" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/03/Percona-Server.jpg" width="247" height="97" />Percona Server’s “crash-resistant replication” feature is useful in versions 5.1 through 5.5. However, in Percona Server 5.6 it’s replaced with Oracle MySQL 5.6′s “crash safe replication” feature, which has it’s own implementation (you can read more about it
class="wp-image-16885 alignright" style="margin-left: 5px; margin-right: 5px;" alt="Screen Shot 2013-07-12 at 10.45.58" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/07/Screen-Shot-2013-07-12-at-10.45.58.png" width="304" height="213" />Lefred and I spent a bit of time making
href="http://code.google.com/p/innotop/" target="_blank">innotop 1.9.1.