…(1M rows) benchmark so data was well fitting in memory and Read Only one to simplify things and…single thread MySQL 5.5 is 11% faster than MySQL 5.6. If you disable Performance Schema in MySQL 5… have not tuned MySQL 5.6 for best performance going with defaults outside of few variables MySQL Sandbox …
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…claim that somewhere around of 99% of advice about tuning MySQL‘s key cache hit ratio is wrong, even… and forget it. If you have enough memory, who cares. The memory isn’t allocated until it’s used… instrumentation in MySQL to guide your decisions. It is also not the be-all and end-all of MySQL …
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… disable them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql… explicit MEMORY tables use in the benchmarks ? As otherwise you also need to boost tmp_table_size to deal with implicit memory tables. innodb_file_per_table – so I assume storing each table in its own file worked…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…tuning” in a generic way here — we focus on far more than my.cnf files. In… RAID controllers, installed memory, and so on in the boot output. In addition, at …disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… they estimate memory consumption by MySQL Server in given configuration. What is the formula they could use. The reasons to worry about memory usage… global memory allocations which are not tuned as buffers. Watch for these especially now with many storage engines being released for MySQL by… – so my advice would be measure what you get in practice and how memory consumption reacts to changing various variables. For example…
Post: MySQL performance: Impact of memory allocators (Part 2)
March 8, 2013 By 12 Comments
… of processor cores have on different memory allocators and what difference we will see in MySQL performance in this scenario? Let me share a… allocators can be tuned to handle such cases better – for instance allocate more arenas but that may notably increase memory footprint. Conclusion…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… 1: Default config for MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5.6 with … memory 4 disk 7200RPM RAID 10 array with 512MB write-back cache Star Schema Benchmark – Scale Factor 1 – Mysql 5…before being able to move to the hot list. In MySQL 5.6 the default value of innodb_old_blocks…
Post: Why Swapping is bad for MySQL Performance ?
January 18, 2010 By 11 Comments
… up all Algorithms The database internals algorithms are tuned for things being in memory and if they start dealing with data which is… these were designed before SSD era. For example Insert Buffer in MySQL makes a special effort to avoid (delay) IO. If it… some unexpected memory consumption spike you may prefer to see slowdown instead of MySQL being killed because of out of memory but do…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…tests concurrently because Sysbench should run completely in memory and use a lot of CPU … from buffer pool at all. For advanced tuning you might also look into changing …in MySQL 5.6 as it would offer much better “out of box” user experience. Summary As we can see in default configuration MySQL…
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 17 Comments
… number. Of course, mind you this is in memory insertion in the simple table and table with long rows … (per oprofile), which went down to about 15% in MySQL 5.5.8 with 8 concurrent threads. This … more performance optimizations. Dmitri has good suggestions on tuning MySQL 5.5 and this is what I used …
