… posting the benchmarks. They are very informative. One question: when you configure MySQL, what portion of it resides on the Fusion-IO… am going to do some testing with a couple of MySQL servers with ioDrive2 cards (two in each) with the 3…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… starting a new one. (If I read your graph correctly, you didn’t…buffer pool, we would expect the primary table to simply fit. But with all… than they were 4 years ago when the iiBench project started, today the… wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/…
Comment: How much memory Innodb locks really take ?
May 19, 2012 By 11 Comments
I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program…
Comment: ext4 vs xfs on SSD
May 18, 2012 By 23 Comments
Benoit, nice little script you’ve got there; using it!
Comment: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
… / ( 1024 * 1024 ), 2), ‘MB’)FREE from information_schema.TABLES where TABLE_SCHEMA=’xyz’ and table_name=’abc’ and Data_free > 0 limit 10… / ( 1024 * 1024 ), 2), ‘MB’)FREE from information_schema.TABLES where TABLE_SCHEMA=’xyz’ and table_name=’abc’ and Data_free > 0 limit 10…
Comment: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
May 18, 2012 By 21 Comments
Is there any option to save the result of show slave status in a table like insert into temp show slave status;
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 10 Comments
…(Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated to other nodes Improvements to XtraBackup SST methods, better error handling New SST wsrep_sst_method=skip, useful when…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
…watch the recording and get the slides here. I got a lot of questions, and did not have … Q: When you say bail out, what does that mean? Does the tool clean up (i.e., remove table / triggers?)…reliably on the __tmp_x table why ? The first question sounds like a potential MySQL bug. Are you sure this…
Post: Load management Techniques for MySQL
May 6, 2012 By 2 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5….to using secondary indexes. While secondary indexes cause read performance to improve, but they have an …to choose a table structure with no secondary indexes. Other important things to consider when you are …
