… available here and from the Percona Software Repositories). Based on MySQL 5.5.22, including all the bug fixes in it…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…: 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 be using any other conf file other than /etc… /etc/my.cnf.old /etc/my.cnf.rpmnew [root@tstlx1 mysql]# cat /etc/my.cnf | grep log_file # Set .._log_file…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… still provides better numbers, but the question is how much MySQL can use. In his keynote Mark Callaghan mentioned that Fusion… good question how does it affect MySQL performance, and I am going to run some MySQL workloads on these cards to understand… you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May-9. It…
Comment: What to tune in MySQL Server after installation
April 28, 2012 By 116 Comments
… at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:276) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2641) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
… Server 12.04 LTS) the pacemaker mysql plugin (ocf:heartbeat:mysql) doesn’t work, because since mysql 5.5 the statement “CHANGE MASTER… in his the last version on gitub. But in my MySQL – installation a “SHOW SLAVE STATUS” will ALWAYS produce a completely…
Comment: Load management Techniques for MySQL
May 10, 2012 By 3 Comments
… slave is to write all batch jobs to use Gearman MySQL UDF interface to apply update transactions to the master (but… Gearman Worker to take update transactions to apply and pace MySQL transactions to the real master db. You can configure multiple… DB load increases. And better yet, you could use Percona MySQL Cluster to have a dedicated master for all batch job…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I…
Comment: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
… benchmarks. They are very informative. One question: when you configure MySQL, what portion of it resides on the Fusion-IO card… am going to do some testing with a couple of MySQL servers with ioDrive2 cards (two in each) with the 3…
Comment: TPC-H Run on MySQL 5.1 and 6.0
May 14, 2012 By 16 Comments
Hi Peter, Re utilising multi cores, MySQL does claim to be capable of utilising multiple CPU cores. (http://dev.mysql.com/doc/refman/5.5/en/faqs-general.html#qandaitem-B-1-1-8). Is that a different kind of assessment or different benchmarking? Cheers.
Comment: Multi Column indexes vs Index Merge
May 10, 2012 By 30 Comments
… query with a couple of mins gap on the same mysql prod instance . The first SQL query executed in 0.03… merge executes in 3.8 secs. I dont understand why MySQL uses index merge after a couple of mins when previously…
