… load situations where INNODB is using most of the system’s memory the kernel can decide (incorrectly) to swap out MySQL. There are… important parts of MySQL process. Q20: We’ve migrated to using INNODB so that it operates 100% out of memory. This way every… data and allows the user to tune the checkpointing values. HT: Hmm… we could tune the way InnoDB does the buffer pool flush…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL Server… grow dramatically do not oversize innodb_buffer_pool_size you might find better use for memory available. innodb_additional_mem_pool_size This… (sometimes larger) so you can see how much memory Innodb allocates for misc needs. innodb_log_file_size Very important for write intensive…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… a long time before the MySQL world started to come around. There are even tuning utilities (anti-tuning anti-utilities?) for Oracle, specifically… storage engines (some InnoDB, some MyISAM, which is more important to you, etc) and choose an amount of memory based on how… it? What about InnoDB tuning? You might be wondering, what about InnoDB tuning? What is the best way to choose an innodb_buffer_pool_size…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… mostly defined by available memory and the I/O subsystem. Also, it seems MySQL 5.1 with the InnoDB-plugin, MySQL 5.5, and… more memory or upgrade the I/O subsystem. If you are flush list bound, then for MySQL 5.1/InnoDB-plugin or MySQL 5.5 the setting of innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log_file_size are important for tuning…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… if you have dedicated MySQL Box and you’re only using Innodb tables you will want to give all memory you do not… to do different VM memory adjustments. You may want to make MySQL to use Large Pages for allocating Innodb Buffer Pool and few… in case of memory pressure. But what is more important Innodb algorithms are finely tuned with consideration what is in memory and what is…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… in Optimizer – such as in memory nature of MEMORY storage engine, clustering by Primary key in Innodb and distributed nature of NDB makes… it is not tuned to exploit full performance potential of any given storage engine. Synchronization The top level on MySQL side, such… having Innodb tables which do not log the changes, hence being faster for update operations. One could also lock them in memory…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
…-storage-engine=InnoDB bulk_insert_buffer_size=8M # Innobd Tuning #innodb_force_recovery=2 innodb_thread_concurrency=2 innodb_file_per_table=1 innodb_doublewrite=0 # Set buffer pool size to 50-80% of your computer’s memory innodb… of memory or not ? I hope you could help me, I know that this website is not a support platform for mysql…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…Memory, 16X2GB, 667MHz db_STRESS: 32 sessions, RW=1, dbsize = 1000000, no thinktime XtraDB: (mysql-5.1.39 + XtraDB-1.0.4-current) innodb_io_capacity = 4000 innodb_support_xa = false innodb_file_per_table = true innodb…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…at any level of tuning, from completely untuned … including RAID controllers, installed memory, and so on in …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…InnoDB tables whose .frm files exist but have been dropped from InnoDB…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… always where – these are key_buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, query_cache_size. If… global memory allocations which are not tuned as buffers. Watch for these especially now with many storage engines being released for MySQL by…
