… you can show a program where row-locks are used by one user to lock records for edit/update, so the transaction…
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: 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
… 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 you start all nodes from the same sources (i.e. backup) Ability to pass list of IP….04, they are coming soon. If you want to know more how to migrate to XtraDB Cluster, we will be giving a free webinar…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
…. Many DBAs like to assert that XFS is the way to go for MySQL, but I’m not sure how frequently they benchmark XFS vs ext4, and how much of their recommendation comes from the days of ext2/ext3. So I decided to use sysbench and plot some graphs to compare…
Comment: How to calculate a good InnoDB log file size
May 1, 2012 By 33 Comments
Hi! I come from Viet Nam. Now i want to check capacity (free space & used space) of datafile on InnoDB (MySQL). How to command? I just research for MySQL, hope you help me. Big thanks!
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
… use sysbench fileio, 16KiB block size (to match workload from InnoDB, as this is primary usage for me), and recently I switched to use async IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this… I gather metrics every 10 sec to see how stable the performance is, and it really helps to observe some artifacts, as you…
