… still the tool serves well for benchmark purposes. OK, let’s start off with the configuration details. Configuration First of all… m2.4xlarge instance as that’s the instance type with highest memory available, and memory is what really really matters. High-Memory… name: m2.4xlarge As for the IO configuration I chose 8 x 200G EBS volumes in software RAID 10. Now let’s…
Post: Testing Virident FlashMAX 1400
May 4, 2012 By 3 Comments
… I use a mode “turbo=1″ for Virident card. What does that mean? Apparently PCIe specification has a … read throughput I’ve seen so far in my benchmarks. To see distribution of response time, the … 830 Follow @VadimTk !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
…/CentOS, because they come with generally outdated software and it’s hard to use newer versions or upgrade. At the time… benchmark above, we were using Linux 2.6.32, as my blog says. We’re now on 2.6.38, and… (depending what ‘x’ we use then, we’re currently on 3.0). But I agree with you that there’s a difference…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… we built all our MySQL DBs with ext4, and it’s been working great for the past 7 months. I recently… fragmentation), so maybe it’s time to do another benchmark. What I found with XFS is that, to my great surprise, changing the…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
The recording of yesterday’s webinar, as well as a PDF of my slide deck, is now available. You can watch the… purpose of the tool. Q: When you say bail out, what does that mean? Does the tool clean up (i.e., remove table / triggers?) About cleanup.. What about manual aborting a run. will that cleanup ? Q: dose…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… on RHEL 5. I add the following line to /etc/my.conf: innodb_log_file_size = 104857600 #also tried innodb_log…’t get what i’m doing wrong. I’ve posted this in a few other forums (i think that’s frowned up) but will update with any resolution. I can’t figure out what i’m overlooking. this…
Comment: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
I have innodb tables in my production database and i have set files_per_table variable. … following query to know the fragmentation SELECT TABLE_SCHEMA, TABLE_NAME, CONCAT(ROUND(data_length / ( 1024 * 1024 ), 2), ‘MB’) DATA, CONCAT… abc engine=innodb and re-executed SELECT TABLE_SCHEMA, TABLE_NAME, CONCAT(ROUND(data_length / ( 1024 * 1024 ), 2), ‘MB’) DATA, CONCAT…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
@Time Callaghan, I did not test with innodb_flush_log_at_trx_commit=1 because the durability requirements are not that stringent. And following is how I invoked iiBench: iibench -T $tbl_name -D iiBench -r 200000000 -M 1 -s 1000000 -t 100000 -I 1 -a -S
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
….) I claim that this schema is not properly indexed. Here’s a theory that seems to explain the performance you are… disk. Perhaps you could verify that by watching IOstat. Tim’s measurements (http://www.tokutek.com/2012/01/1-billion-insertions… hits the memory wall at about 100M rows, which matches my prediction that at 400M rows and 55GB RAM, Inno would…
Comment: Choosing proper innodb_log_file_size
May 15, 2012 By 12 Comments
… thing – you dont own the hardware, and maybe other people’s OSes and DBs are writing to the same physical disk… lot due to some other user’s VM doing heavy activity on the disk. Also, my DB has also slowed down other user’s apps. IMO, you have to test…
