… VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by one user to lock…
Comment: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
…: when you configure MySQL, what portion of it resides on the Fusion-IO card? Do you just have your datadir on there? Or is it more complex than that? I’m new to Fusion-IO and I am going to do some testing with a couple of MySQL servers with ioDrive2 cards…
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
… 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: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
…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…to know more how to migrate to…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
…to use async IO mode. There are two reasons for that. First, MySQL/InnoDB uses…to see how stable the performance is, and it really helps to… time). When there …cache or something. To …MySQL Conference 2012, if you did not attend my talk – you are welcome to join the webinar. Follow @VadimTk !function…
Comment: Load management Techniques for MySQL
May 10, 2012 By 2 Comments
… when the DB load increases. And better yet, you could use Percona MySQL Cluster to have a dedicated master for all batch job processing and use Gearman Workers to apply updates to this dedicated master, using pacing…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
…to PCIe cards. It really makes sense to test it under MySQL workload, but before getting to…to have such variety in throughput. It gets even more interesting when we go to…timeline (from 0 to 1800 sec): I am not sure how to explain it, that…and read IO cases. Follow @VadimTk !function(d,s,id){var js,…
