… tuning” or prefer to expose tuning options to be available to the user. HT: I favor self tuning. PZ: I also like self tuning… situations where INNODB is using most of the system’s memory the kernel can decide (incorrectly) to swap out MySQL. There…€™re considering buying 40 8-core boxes with 32G of memory. Have any specific thoughts here? INNODB was originally written on…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… MySQL world started to come around. There are even tuning utilities (anti-tuning anti-utilities?) for Oracle, specifically designed to mock and… really big and forget it. If you have enough memory, who cares. The memory isn’t allocated until it’s used — if… more important to you, etc) and choose an amount of memory based on how important those tables are to you, how…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… lists for flushing (writing pages from the Innodb buffer pool memory to disk): the LRU list and the flush list. YouÂ… strategy which will give the biggest benefit is: Install more memory or upgrade the I/O subsystem. If you are flush…_io_capacity, and innodb_log_file_size are important for tuning. Also, upgrading to Percona Server, with a more advanced flushing…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… the workload. Hardware If you have large Innodb database size Memory is paramount. 16G-32G is the cost efficient value these… OS so it would not swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb_buffer… options here or read one of our MySQL Presentations. Application tuning for Innodb Especially when coming from MyISAM background there would…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… basically “zero copy” design one may have streaming data from memory when it fits there. Optimizer and Execution Storage engines are… handle all different cases in Optimizer – such as in memory nature of MEMORY storage engine, clustering by Primary key in Innodb and… with balancing – allocating resources to different storage engines and performance tuning becomes more complicated. Now what is interesting for probably 95…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…. There are also things like innodb additional memory pool (which can grow more than memory you allocated for it, especially in case… may kill MySQL Process running out of memory (or thinking it is running out of memory) which may happen ie in case… in case of memory pressure. But what is more important Innodb algorithms are finely tuned with consideration what is in memory and what…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… default-storage-engine=InnoDB bulk_insert_buffer_size=8M # Innobd Tuning #innodb_force_recovery=2 innodb_thread_concurrency=2 innodb_file… buffer pool size to 50-80% of your computer’s memory innodb_buffer_pool_size=4G innodb_additional_mem_pool_size…/run/mysqld/mysqld.pid The server (on amazon) has 7Go memory: [root@dom*************** log]# free -m total used free shared buffers…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… I bet the over vendors do the same thing of tuning database options for benchmark rather than running production reasonable options…’m not sure why is it set. Are any 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…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… can work with systems that are at any level of tuning, from completely untuned to a system that’s already had… little load. I see that mysqld is using 10g of memory with 17g virtual size, and there’s practically nothing else… information on the box’s hardware, including RAID controllers, installed memory, and so on in the boot output. In addition, at…
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
…. 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… tune you malloc settings so more buffers are allocated from the pools rather than mmap. This though will at least increase memory…
