…memory available, and memory is what really really matters. High-Memory Quadruple Extra Large Instance 68.4 GB of memory…come to the MySQL configuration. MySQL Configuration I used …performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…’t graph the performance on the first 100M rows). The minimum performance troughs occur just as the partition switches. So performance gets worse… rows and 55GB RAM, Inno would hit a memory wall. Given that Memory sizes are perhaps 10 times bigger than they were….launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is that it measures query performance too, so if…
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 6 Comments
…than 1000 rows and doing it completely in memory. The plan optimizer picked was very good one…yet making it unusable to check the optimizer performance. Solution for this problem was to use … the following explanation from Timour Katchaounov in MySQL mailing list archives I have some recollection …
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… performed on table2. Of course this could mean a lot of random lookups in case the dataset does not fit into memory… a look at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read… for the best possible performance gain. This is not entirely visible in the manual either for MariaDB or MySQL, but you need…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…. MySQL Status Counters These status counters were captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w… in the buffer. But there is no performance improvement when the workload is in-memory, in fact MRR adds extra sorting overhead…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… overview of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t… contention. The performance improvements I got with Percona Server were similar to the performance improvements I saw versus stock MySQL 5.1. This…. The physical and logical database design influences greatly how much memory and disk resources are required. The application’s access patterns…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… about memory usage are quite understandable. If you configure MySQL Server so it uses too small amount of memory it will likey perform suboptimally. If you however configure it so it consumes too much memory it may be… small queries might only barely increase memory consumption for given thread, however if table will perform complex operations such as full table…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… out MySQL Performance on “Memory Appliance” by Violin Memory which can be used as extremely high speed storage system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory…
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
… – o_profile (often together with strace) are great tools for MySQL Performance analyses. Too many people end tuning on plans and indexes…. Indeed allocating with mmap is much slower than allocating from memory memory pool which process already “owns” and in real life it… 10 times slow down over time as memory becomes fragmented with 50.000+ of memory areas mapped. As the gap in the…
