… where – these are key_buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, query_cache_size. If…, File Cache and other applications. For 32bit envinronment you also should keep 32bit limits into account and probably limit “mysqld” size to about 2…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… First – run 64bit operating system. We still see people running 32bit Linux on 64bit capable boxes with plenty of memory. Do… for more details, check out detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on your recovery speed… a lot of short write transactions. innodb_thread_concurrency=8 Even with current Innodb Scalability Fixes having limited concurrency helps. The actual number…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… out of space and gets killed. In 32bit systems it was even easier as all …Prepared Statements Number – Happily now there is a limit on total number of prepared statements (max_stmt…data until you have executed prepared statement. Innodb Table Cache Leak – Innodb never shrinks its internal table cache…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… MySQL 5.0.45 on 32bit Fedora Core 6 on Pentium 4…group by c order by null limit 10; +—-+————-+——-+——+—————+——+———+——+———+—————–+ | id | select_type | table | type | possible…about it especially if running only Innodb tables so you may think…
Comment: Percona build7 with latest patches
November 20, 2008 By 26 Comments
… MySQL 32bit) [mysqld] max_connections=2000 key_buffer_size=200M low_priority_updates=1 table_cache = 8000 sort_buffer_size = 2097152 innodb…=1600M innodb_additional_mem_pool_size=20M innodb_log_buffer_size=8M innodb_checksums=0 innodb_doublewrite=0 innodb_support_xa=0 innodb_thread_concurrency=0 innodb… innodb_max_dirty_pages_pct=15 NOTE: innodb_flush_log_at_trx_commit=0 because I’m interesting first on the scalability limits…
Comment: Innodb Performance Optimization Basics
June 16, 2012 By 75 Comments
… have a limit of 2GB on 32bit. When using Innodb, there is only one thing that counts, allocate as much as your innodb is…
Post: Debian / Ubuntu Percona builds
March 9, 2009 By 8 Comments
….10 box. It’s going to be only 64bit releases (32bit is dead, isn’t it?), and I tested binaries on… Build13 it contains InnoDB Data Dictionary restriction patch, which I mentioned before (http://www.mysqlperformanceblog.com/2009/02/11/limiting-innodb-data-dictionary…
