…size is bigger to help queries that don’t use indexes and that do use some of the new optimizer features. query_cache_size RAM is allocated even if query_cache…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…size, innodb_log_buffer_size, query_cache_size. If you’re using MyISAM seriously you can also add the size of Operation System cache you would like MySQL to…is impractical – so my advice would be measure what you get in practice and how memory consumption reacts to changing…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…where t.schema=’test’ group by i.index_id \G INDEX_NAME DATA_SIZE_MB test.md_cache…is the same. Note we ran test on virtualized system in this case so we would not be able to measure small variances in…to non zero value, if not I would strongly suggest changing default from zero in MySQL…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…is easy to miss, as is the absence of innodb_log_file_size. I won’t give you a full rundown over every option in the file…changed. Queries can be broken into pieces, combined, or even eliminated entirely (we may suggest caching, or tell the customer to…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…is for a large system with memory of 1G-2G where the system runs mainly # MySQL. # # You can copy this file to # /etc/my.cnf to…query-time=5 log-slow-queries=/apps/log/slow-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query_cache_size…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…size=32M # Only for MyISAM which isnt used. sort_buffer_size=2M query_cache_size=10M # Might be increased thread_cache_size=40 table_cache…to MySQL innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 innodb_lock_wait_timeout=15 # CHANGED from 50 innodb_log_files_in…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…the files to download, but first let me walk you through the installation and configuration because things changed along the way. Installation In order to use the…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…is always being written to the first file in the log file group? HT: InnoDB writes the checkpoint information to the first file. Q31: How often or what is the…Mysql is the main one with “innodb_buffer_pool_size=20480Mâ€) while the bulk of the rest (9 GB) is used for the OS cache…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…in to play when innodb_thread_concurrency is greater than zero. On a stock install of MySQL, here are some example queries and the…to estimate or wait for InnoDB to expose this information to us. What happens in the case where…query_cache_size=0 skip-name-resolve table_cache…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
MySQL Server has tons of variables which may be adjusted to change behavior or for performance purposes. They are documented in the…in general. Currently MyISAM and Innodb. Some SQL level items as Query Cache…
