… to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by one user to lock records…
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…? I’m new to Fusion-IO and I am going to do some testing with a couple of MySQL servers with ioDrive2 cards…
Comment: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
… set files_per_table variable. i executed the following query to know the fragmentation SELECT TABLE_SCHEMA, TABLE_NAME, CONCAT(ROUND… table could not be defragmented. is there any other way to defragment innodb tables? thanks Kuldeep
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;
Comment: Benchmarking single-row insert performance on Amazon EC2
May 17, 2012 By 11 Comments
Aaron, No particular reasons, it doesn’t matter if you have 4 1G or 2 2GB log files, as they are all concatenated together by InnoDB and written to in a circular fashion.
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… experience to degrade. The first thing you need to know it is not MySQL problem, might be even not problem with your MySQL configuration… would not use more than 4 parallel processes heavily writing to database. Introduce Throttling Sometimes even single process overloads system too…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
… the Linux asynchronous IO library to get time metrics for particular IO … sec to see how stable the performance is, and it really helps to … In general it shows stable throughput topping to 148 MiB/sec, but every …suitable to work with MySQL. I will publish sysbench oltp benchmarks running MySQL on…
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated to other nodes Improvements to XtraBackup SST methods, better….04, they are coming soon. If you want to know more how to migrate to XtraDB Cluster, we will be giving a free webinar…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
… SATA SSD performance is getting closer to PCIe cards. It really makes sense to test it under MySQL workload, but before getting to that, let me… for read-only workload to have such variety in throughput. It gets even more interesting when we go to read sync IO, with… and show them in timeline (from 0 to 1800 sec): I am not sure how to explain it, that with 4 and 8…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
…reliable way in the Linux asynchronous IO library to get time metrics for particular IO block. so my…metrics every 10 sec to see how stable the performance is, and it really helps to observe some artifacts…interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May-…
