… 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!
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…
Comment: ext4 vs xfs on SSD
April 25, 2012 By 23 Comments
… do you think I should use to recommend that or another product/filesystem? For me – amount of bugs (how stable it is) is… are most interested in recommendation that they can use today, now in production deployment. How stable will be product is 2 years… logic, it seems I just should go ahead and recommend to use btrfs to everyone, because it has so great concept. Who counts…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 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…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
Partitioning probably reduces the stress on the insert buffer. Does XtraDB/Percona Server have an option to use more IO for insert buffer merges when the ibuf gets too big?
