…MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of connections but yet MySQL…size 7864319 Buffer pool size, bytes 128849002496 Free buffers 1 Database pages 8252672 Old database…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
…, row level locking databases also acquire gap …INNODB STATUS: —TRANSACTION 72C, ACTIVE 755 sec 4 lock struct(s), heap size 1248, 3 row lock(s), undo log entries 1 MySQL…innodb_locks_unsafe_for_binlog = 1. Disables the gap locks except for foreign-key constraint checking or duplicate-key checking…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the …innodb_change_bufferingblogpercona.commanual innodb_checksumsblogpercona.commanual innodb_commit_concurrencyblogpercona.commanual innodb_concurrency_ticketsblogpercona.commanual innodb_data_file_pathblogpercona.commanual Innodb_data_fsyncsblogpercona.commanual innodb…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… course depend on the workload. Hardware If you have large Innodb database size Memory is paramount. 16G-32G is the cost efficient value… on Innodb ones today. You can check about tuning other options here or read one of our MySQL Presentations. Application tuning for Innodb Especially…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
… most workloads if you will have your Innodb Buffer Pool 10% less than your database size you would not loose much anyway. You…. After you have decided with database size you need to check if there are any restrictions on Innodb Buffer Size you can use. Typically you… queries. It is usually much better to simply check it. Start MySQL With 10GB Innodb buffer pool for example and see how large…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… inside InnoDB 500 mysql tables in use 1, locked 1 3 lock struct(s), heap size 320 MySQL thread id … check if your innodb_log_buffer_size is optimal – if you see more than 30% of log buffer size… it probably means your active database size is smaller than allocated buffer pool size so you can tune it …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…database, it will fail. These things tend to happen at inconvenient times. The pmp-check-mysql-file-privs plugin checks whether MySQL…pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, … (the use of fixed-size connection pooling, for example, …
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
…looks at records and checks if these are already applied to the pages (Innodb log format has … Database Size This comes back to the data locality but with same data access distribution the larger database you…and undo phase – rolling back uncommitted transactions. As MySQL 5.0 these seems to be done …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1. row *************************** Name: ontime_fact Engine: InnoDB…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…mysql/var/ innodb_checksums = 0 innodb_doublewrite = 0 innodb_buffer_pool_size = 5000m innodb_additional_mem_pool_size = 20M innodb_log_file_size = 1600M innodb_log_buffer_size = 16M innodb…
