June 20, 2013

Comment: When EXPLAIN estimates can go wrong!

…/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

Post: Heikki Tuuri answers to Innodb questions, Part II

… 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

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

…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)_…

Post: How innodb_open_files affects performance

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

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

my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodbinnodb_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

Post: Shard-Query EC2 images available

TOTALInnoDB 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

Post: How Percona does a MySQL Performance Audit

… 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,…

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

… = 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=…

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

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