… into the (application’s) logic which is simply a nightmare for developers in case of migration or major change in data profiles.
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. Investigating them we find out what the cause is some batch jobs, reports and other non response time critical activities are overloading the system causing user experience to …
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… worked really well out of the box, while XFS required poorly documented knobs to be turned and still couldn’t beat… we built all our MySQL DBs with ext4, and it’s been working great for the past 7 months. I recently… XFS (especially with regards to metadata fragmentation), so maybe it’s time to do another benchmark. What I found with XFS…
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… be to index 10B rows, not 1B rows. And it’s still a good challenge. The URL for iibench is slightly…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… still the tool serves well for benchmark purposes. OK, let’s start off with the configuration details. Configuration First of all… used. EC2 Configuration I chose m2.4xlarge instance as that’s the instance type with highest memory available, and memory is… x 200G EBS volumes in software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona…
Post: Percona Server 5.5.23-25.3 released!
May 16, 2012 By 2 Comments
… stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of…
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?
Comment: Announcement of Percona XtraDB Cluster 5.5.23
May 15, 2012 By 11 Comments
… to create another mysql instance to do this and it’s not really convenient.
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… being slowed down a 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 it out on a…
