… production database and i have set files_per_table variable. i executed the following query to know the fragmentation SELECT TABLE_SCHEMA… table could not be defragmented. is there any other way to defragment innodb tables? thanks Kuldeep
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.
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 where row-locks are used by one user to lock records for edit/update, so the transaction is not…
Comment: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
… more complex than that? I’m new to Fusion-IO and I am going to do some testing with a couple of…
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
Any particular reason for choosing 4 1GB log files instead of 2 2GB?
Comment: Review of Virident FlashMAX MLC cards
April 25, 2012 By 14 Comments
…-0 stripe set is unable to write its portion of the data stripe, the volume is hopeless corrupted, even if the cause might be something that has nothing to do with the actual drive… the failure. There may of course be hacks or tools to recover data from a RAID-0 and ignore the incomplete stripe…
Comment: How to track down the source of Aborted_connects
May 15, 2012 By 17 Comments
I know this is an old post, but I’m hoping it’s still monitored. Do you have any suggestions on how to accomplish something similar but with a socket rather than TCP?
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….04, they are coming soon. If you want to know more how to migrate to XtraDB Cluster, we will be giving a free webinar…. This is an General Availability release. We did our best to eliminate bugs and problems during alpha and beta testing release…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
… with throughput 350-400 MiB/sec. Random reads, async: Interesting to see that there is quite unstable throughput in range 450… in throughput. It gets even more interesting when we go to read sync IO, with 1-64 threads. Throughput: Response time… and show them in timeline (from 0 to 1800 sec): I am not sure how to explain it, that with 4 and 8…
