… running MySQL on Debian or Ubuntu with InnoDB? You might want to disable /etc/mysql/debian-start. When you run /etc/init.d/mysql… to stop the buffer pool and the OS cache from competing. My chosen strategy for this was to set innodb_flush_method=O…;” at the top. The solution I chose in this case? mysql> KILL 7; Immediately afterward everything cleared up.
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… read. If the InnoDB buffer pool is set…| 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 9630066 | | Bytes_received …, so it’s clear what I’m …
Post: Getting real life query speeds with MySQL
January 10, 2007 By 10 Comments
… of other caches and QueryCache is only first in line. There is also all kinds of page caches inside MySQL (key_buffer and innodb_buffer_pool_size) which can be cleared by MySQL restart. Even if you restart MySQL server there is…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…over in both directions. Aside from MySQL Cluster, which is more special-purpose… is that the passive server’s caches start to get skewed to …information_schema.innodb_buffer_pool_content group by 1, 2, 3 into outfile ‘/tmp/buffer-pool-…89 0.48 The difference is clear. The buffer pool contains over 8G …
Post: InnoDB benchmarks
January 3, 2007 By 15 Comments
…/mysql- –with-innodb and next startup options were used: libexec/mysqld –no-defaults –user=root –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb… MHz : 1995.004 cache size : 4096 KB 16GB of RAM Disks do no matter, as I ran clear CPU-bound benchmarks. The…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…cache_size=0 query_cache_type=0 MySQL 5.6.5 Configuration innodb_file_per_table=1 innodb_file_format=barracuda innodb_log_file_size=512M innodb…cache_incremental=on’ optimizer_switch=’join_cache_hashed=on’ optimizer_switch=’join_cache_bka=on’ join_cache_level=4 join_buffer_size=32M join_buffer…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… we set key buffer to 128M ? mysql> show global status like “key%”; +————————+———+ | Variable_…buffer_size is set to accommodate needs of your temporary table. Do not forget about it especially if running only Innodb…pretty random IO. Clearly OS write caching is not effective …
Comment: When EXPLAIN estimates can go wrong!
October 15, 2011 By 7 Comments
…are actually cached within the buffer pool during query execution plan evaluation. I ran the test on a local MySQL …0 | | Innodb_buffer_pool_pages_flushed | 0 | | Innodb_buffer_pool_pages_free | 10015 | | Innodb_buffer_pool_pages_misc | 0 | | Innodb_buffer_pool_pages_total | 10239 | This test clearly…
Post: Living with backups
November 6, 2008 By 28 Comments
…especially true for MyISAM tables which have dedicated buffers only to store indexes, while the actual data… gains are quite clear. Now going back to flushing the data out of the cache. It happens by… though it’s always the case for InnoDB tablespaces, other MySQL data files do not comply with this …
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… file sql/sql_cache.cc patching file … -fstack-protector –param=ssp-buffer-size=4 -m64 -mtune=generic’ …proper flags set. To clear the filter just assign …InnoDB extensions msl patch for MySQL 5.0.51a with InnoDB extensions msl patch for MySQL 5.0.54a with InnoDB extensions msl patch for MySQL…
