June 20, 2013

Comment: When EXPLAIN estimates can go wrong!

October 15, 2011 By 7 Comments

…/my.sandbox.cnf extended-status | grep -i innodb_buffer_pool_pages | Innodb_buffer_pool_pages_data | 141 | | Innodb_buffer_pool_pages_dirty | 0 | | Innodb_buffer_pool_pages_flushed | 0 | | Innodb_buffer_pool_pages_free | 10098 | | Innodb_buffer_pool_pages_misc | 0 | | Innodb_buffer_pool_pages_total…

Filed Under: MySQL

Post: Heikki Tuuri answers to Innodb questions, Part II

November 4, 2007 By 13 Comments

… mean, if the database buffer pool can buffer many writes to the same page, then fewer disk writes …amounts of RAM, to give INNODB ~70-80% of the total RAM, and leave the …innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible to InnoDB‘s buffer pool…

Filed Under: Insight for Developers Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…SEO-stuffed web pages, wherein the document title is the page title, and the… the InnoDB buffer pool for my 5.6 instance is 128MB – smaller than the size of my DIR…_case_table_names = 1 in /etc/my.cnf), but I think it’s even…, I would expect some changes in total_word_count, or optimize_(start|end)_…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: How innodb_open_files affects performance

November 18, 2009 By 4 Comments

…pages in innodb buffer pool which had to be flushed before recycling. First ran however was done with clean buffer pool…InnoDB: allowed value would be 64. InnoDB: You may need to raise the value of innodb_max_files_open in InnoDB: my.cnf. InnoDB…

Filed Under: Insight for DBAs, MySQL Tagged With:

Post: Aligning IO on a hard disk RAID – the Benchmarks

June 9, 2011 By 13 Comments

…my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb…innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb…

Filed Under: MySQL

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

…TOTAL…InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool…

Filed Under: MySQL

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

… job; it will take many pages, and I’m not going …my.cnf quickly for anything weird: [percona@db1 ~]$ grep -v ‘^#’ /etc/my.cnf | grep . My goal here is to look at the my.cnf…s hard to read. If the InnoDB buffer pool is set to 22GB, it…top 10 most expensive queries, in total execution time. By the way,…

Filed Under: Insight for Developers Tagged With:

Comment: Should you have your swap file enabled while running MySQL ?

April 6, 2008 By 31 Comments

… = 4194304 My /proc/meminfo looks like this: HugePages_Total: 14336 HugePages_Free: 14336 HugePages_Rsvd: 0 Hugepagesize: 2048 kB My limits.conf looks like this: mysql soft memlock unlimited mysql hard memlock unlimited My my.cnf looks like this: large-pages innodb_buffer_pool_size=…

Filed Under: Insight for DBAs Tagged With: ,

Comment: How much memory can MySQL use in the worst case?

February 13, 2009 By 17 Comments

…BUFFER POOL AND MEMORY ———————- Total memory allocated 17475088; in additional pool allocated 864256 Buffer pool size 512 Multiply the buffer pool size by the page size (or just check my.cnf…

Filed Under: Insight for DBAs Tagged With: