…innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation, etc.). Rather than…buffer pool? PZ: I guess it may be bug in the status…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…buffer pool. For this workload with a small buffer pool (the buffer pool is smaller than the working set) having innodb…buffer pool in pages afterwards: mysql> select sq.*, pages / (@@innodb_buffer_pool_size / 16384) * 100 pct_buffer_pool…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…buffer pool is sized well – if you have constantly a lot of pages free, it probably means your active database size is smaller than allocated buffer pool size…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…buffer hit ratio, and a host of smaller…STATUS…InnoDB tuning? You might be wondering, what about InnoDB tuning? What is the best way to choose an innodb_buffer_pool_size…system‘s capabilities. MySQL doesn’t have good instrumentation for scientifically choosing a key_buffer_size…
Post: Wanted: Better memory profiling for MySQL
May 18, 2008 By 4 Comments
…system and find MySQL using too much memory. I would look at memory consumed by Innodb (it is often higher than innodb_buffer_pool_size…smaller fraction. Now. There are a lot of guesses I can make. Could it be memory allocated for per connection buffers… similary to SHOW STATUS – threads could account…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
….61) and a single test, innodb_plugin.innodb_bug53674. The test is chosen for…buffer pool stats, the I/O stats might be slightly smaller than they should be. ==9090== Possible data race during write of size…: show_status_array(THD*, char const*, st_mysql_show_var*, enum_var_type, system_status_var*, …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… or smaller than normal, …system I’m working with. System performance Next I investigate what the system…InnoDB buffer pool is set to 22GB, it’s much easier to see 22GB than…status values for Created_tmp_tables and Created_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size…
Post: How much memory Innodb locks really take ?
July 13, 2006 By 11 Comments
…Innodb row level locks are implemented by having special lock table, located in the buffer pool…size 503104 MySQL thread id 7429, query id 24542 localhost root show innodb status…systems. Furtermore you would unlikely need or want to lock every row in your table/database which makes it even smaller…
