I have been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting … challenge” for which this tool was originally built is long over, but still the tool serves well for benchmark purposes. OK, let’s… about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I made no code…
Post: SysBench - benchmark tool
August 18, 2006 By 18 Comments
Sysbench is benchmark developed by Alexey Kopytov (software engineer @ MySQL AB) – http://sysbench.sourceforge.net/ and I want to write a short intro about this tool as sysbench is… servers – I will write about in further notes. Regarding database benchmarks – in 0.4.7 and earlier versions Sysbench supported only…
Post: Introducing tpce-like workload for MySQL
February 8, 2010 By 3 Comments
We have been using tpcc-mysql benchmark for long time, and there many results published in our … looking into different benchmarks, and one of them is TPCE. Yasufumi made some efforts to make TPCE working with MySQL, and we are making it available for public consideration. You can download it from our Lauchpad Percona-tools project…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…. The tool I used was sysbench 0.4.10 that came with this Ubuntu system. I have run every fileio benchmark and… benchmark As the goal was to compare performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have been running these benchmarks for a…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
… was almost 2x faster then combining memcached and MySQL, and about 20% slower then the all memory… the appropriate place for storing data. A tool like Tokyo Tyrant may not be for everyone… try and continue this series by exploring and benchmarking other NOSQL options and comparing them to database …
Post: Is your MySQL Server Loaded ?
March 19, 2010 By 4 Comments
So you’re running the benchmark/stress test – how do you tell if MySQL server is really loaded ? This looks like the… generation and network really putting a lot less load on MySQL than expected. For example you may have 32 threads (or…. Looking at Threads_running is a very simple and powerful tool to see whenever you’re really putting sustained load on…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
… rarely important to MySQL users. If it is to you, then you probably did your own research and benchmarks already and this… MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security fix for something, 20x start/stop MySQL, upgrade MySQL, … . Restarting and changing MySQL… the other end there are Debian and Ubuntu. Both use tool called dpkg for package management. There isn’t a month…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
… on the process of alignment, if you’re curious about benchmark results, here they are. What is IO alignment I would… the partition table. On the system that I have been benchmarking, defaults worked out just fine because I was using a…’s also a more modern – GUID partition table (GPT). The tool for the task of working with GPT is typically parted…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
… it out. I could do benchmarks, but that would not be interesting — we already know that benchmarks are unrealistic, and we know… getting from its disks. I’m using the Aspersa diskstats tool to pull this data straight from /proc/diskstats. I’ll…. This is one of the reasons I wrote the diskstats tool — you can understand busy-ness and utilization correctly. The %util…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… not be available, especially for CPU bound MySQL Load. The benefit in this case is … uncompressed backup. What is about compression tool ? The classical tool used for backup compression is gzip – … backup process. Recently I did a little benchmark compressing 1GB binlog file with GZIP (compression …
