… available here and from the Percona Software Repositories). Based on MySQL 5.5.23, including all the bug fixes in it… new SYS_STATS table. Bug fixed #978036 (Laurynas Biveinis). Release notes for Percona Server 5.5.23-25.3 are available in…
Post: Percona Server 5.1.62-13.3 released!
April 26, 2012 By Leave a Comment
… available here and from the Percona Software Repositories). Based on MySQL 5.1.62, including all the bug fixes in it… and sed but only for SBR, because with RBR database name is encoded within the BINLOG ‘….’ statement. Release notes for Percona Server 5…
Post: Percona Server 5.5.22-25.2 released!
April 26, 2012 By Leave a Comment
… available here and from the Percona Software Repositories). Based on MySQL 5.5.22, including all the bug fixes in it… return rows in non-deterministic order for equal keys. Bug fixed #892951 (Laurynas Biveinis). Release notes for Percona Server 5.5.22-25…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… 1120502 11:51:17 [Note] /usr/libexec/mysqld: ready for connections. Version: ’5.0.95′ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution Also, I don’t see how MySQL could… /etc/my.cnf.old /etc/my.cnf.rpmnew [root@tstlx1 mysql]# cat /etc/my.cnf | grep log_file # Set .._log_file…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… for the IO configuration I chose 8 x 200G EBS volumes in software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the… the graphs have a better view of the whole picture. Note, in the above graph, we have “millions of rows” on…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…are seeing. But first I’d like to note that this experiment isn’t really running the…good challenge. The URL for iibench is slightly incorrect. The correct URL for version you used is http… that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench….
Post: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
… to plan and promote it. Notes on a few things: The expo hall was a great success for sponsors and attendees. I… give special recognition to Oracle for their new development milestone release for MySQL 5.6, released on Monday. MySQL 5.6 just keeps looking… conference such a success for everyone. Our goal for future conferences remains the same as always: to help the MySQL ecosystem continue to…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… for MySQL 5.6, increase of 0.02s. But the query times for MariaDB 5.5 are greater than both MySQL 5.5 and MySQL… interesting thing to note is that MySQL 5.6 and MariaDB 5.5 are both reading more rows than MySQL 5.5, as… (this is the query time for MySQL 5.5) While when it sticks to plan ‘b’ for MySQL 5.6 and MariaDB 5.5…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… 5.4K disks in Software RAID5. Also note that the following changes were made on MySQL 5.6 config: optimizer_switch=’index… as follows: MySQL 5.6 (2) is for MySQL 5.6 w/ buffer size 6M MariaDB 5.5 (2) is for MariaDB 5.5… for MySQL 5.6 becomes approximately equal to that of MySQL 5.5. MariaDB 5.5 is quite slow as compared to both MySQL…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… 60 done Check for Table Cache Related Allocations There are cases when MySQL will allocate a lot of memory for table cache, especially…. Run “FLUSH TABLES” and see whenever memory usage goes down. Note though because of how memory is allocated from OS you… hopeful future releases of MySQL, MariaDB or Drizzle bring improvements in this space allowing us to see directly for what purpose memory…
