… chose 8 x 200G EBS volumes in software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I… all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I made… that the insert rate was decreased. Conclusion As we all now there are pros and cons to using secondary indexes. While…
Post: Percona Server 5.5.23-25.3 released!
May 16, 2012 By 2 Comments
… in it, Percona Server 5.5.23-25.3 is now the current stable release in the 5.5 series. All… internal SYS_STATS table was corrupted or overwritten. This is now fixed by detecting the corruption and creating a new SYS…
Post: Testing Fusion-io ioDrive2 Duo
May 10, 2012 By 12 Comments
…, rev 107004 Public, Fusion-io driver version: 3.1.1. Now to the results. For this test I also use Cisco… MiB/s for single and 2300 MiB/s for Duo. Now with separation per thread for random read synchronous IO: There…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… with some instability, which I will research in later charts. Now, random reads, still asynchronous It gives almost stable 370 MiB…. For 8 threads the 95% response time is 0.69ms. Now let me get back to random write case. I will…
Comment: Announcement of Percona XtraDB Cluster 5.5.23
May 15, 2012 By 11 Comments
Support for MyISAM, now changes to MyISAM tables are replicated to other nodes means is supported fulltext index and search?
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… changes: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated to other nodes Improvements…
Comment: mysql-proxy, urgh performance and scalability ?
May 13, 2012 By 27 Comments
… a long trial we have given up on mysqld, and now moving towards mysql-proxy as a solution for production server…
Comment: Testing Virident FlashMAX 1400
May 10, 2012 By 3 Comments
… remarkable performance from this vendor. That said, since there are now several variables in play (new harness, new wattage, “performance mode…
Comment: New distribution of random generator for sysbench - Zipf
May 10, 2012 By 3 Comments
… reconnect. Testing Percona XtraDB Cluster with HAProxy is a pain now as test is aborted once one of the nodes goes…
Post: New distribution of random generator for sysbench - Zipf
May 9, 2012 By 3 Comments
… only 0-100k level: I implemented Zipf for sysbench, right now it is in a separate tree https://code.launchpad.net…
