…, but what I’ve always wanted is to have a benchmark tool that finds the system’s maximum usable capacity. It would… using the approach in my previous paragraph, and running many benchmarks at different numbers of threads until you find the workload…
Post: Is your MySQL Server Loaded ?
March 19, 2010 By 6 Comments
So you’re running the benchmark/stress test – how do you tell if MySQL server is …. Looking at Threads_running is a very simple and powerful tool to see whenever you’re really putting sustained load on…
Post: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
… and we’re really glad to have such a nice tool as new InnoDB plugin which now proved its usefulness in…
Post: Find unused indexes
June 30, 2012 By Leave a Comment
…_line | PRIMARY | 1164682 | +————–+————+————–+———–+ These are the index used during the benchmark. Let’s compare it with the data on INNODB_INDEX… follow tool‘s suggestion literally. These tools are here to help us and after that is our job to check and benchmark the…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 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 55 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
… requirements to transfer uncompressed backup. What is about compression tool ? The classical tool used for backup compression is gzip – it exists almost… for all the backup process. Recently I did a little benchmark compressing 1GB binlog file with GZIP (compression done from OS… the boxes (ie together with netcat) Now as in my benchmarks there is also overhead of reading (from file cache) and…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… higher number (say 64) to see how things scale. The tool I’m using for this is SysBench which was designed… result while running benchmarks for this articles (and this is always very exciting to find something unexpected while doing Benchmarks). Fortunately I….4.8: multi-threaded system evaluation benchmark There is also one trick running such larger scale benchmarks. SysBench by default has repeatable…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
… is the following: Before each benchmark, the database is reinitialized to ensure consistent benchmarks. During all the benchmarks, the CPU load on the… another series of benchmarks I’ll present soon, this time looking at the number active connections. For these benchmarks, I use pools… is spending its time, I am planning to use profiling tools to identify the culprit but I had no time yet…
Page: Presentations
May 3, 2006 By
…December 2007 Talk about Mercurial version systems, comparison with similar tools and basic usage patterns Download Query Optimization Web Tuesday , …, CA MySQL was benchmarked on different platforms – hardware operation systems, file systems etc. Large number of benchmarks with little explanations …
