… this statement to complete. Here is example how it can look: mysql> show processlist…to the database at all (use mysql -A in this case, to prevent it from getting field list from all tables…to let backup to proceed, but resolving server gridlock one way or another. If you’re just using Innodb tables…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…indicate similar problems to those discussed within InnoDB, but …all trying to open or close tables can indicate LOCK_open contention. Replication is delayed or stopped. Our plugins are structured to… recently. It is surprising how often a server crashes,… In addition to the checks in that list, there …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…SHOW INNODB STATUS output and how to use this info to improve MySQL Performance. To start with basics SHOW INNODB…0 History list length 6 Total number of lock structs in row lock hash table 0 LIST OF…performed. Innodb uses fuzzy checkpointing so this line hold log sequence, all changes up to which has…
Post: How much memory Innodb locks really take ?
July 13, 2006 By 11 Comments
… with INSERT … SELECT I decided to check is Innodb locks are relly as efficient …Table with rather small row size, containing 1638400 rows. Now lets lock all rows in this table and see how…INNODB STATUS we can see: History list length 5 Total number of lock structs in row lock hash table 6092 LIST…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…to be investigated. You might find that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB…how to write queries and how EXPLAIN works. At Percona, we have peer training constantly on our internal IRC channel and mailing list…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… manual is only partially correct in how to properly build the server to use it (bug 61587). We …THD*, TABLE_LIST*, Item*) (sql_show.cc:5522) ==9090== by 0x74E4DF: get_schema_tables_result(JOIN*, enum_schema_table_state)… about all this? If I had my way, I’d use atomic access primitives in InnoDB …
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…table_cache Innodb maintains its own (called data dictionary) which keeps all tables ever accessed since table start – there is no variable to…system tablespace. So if you create Innodb tables you better store some data …for replacing open files in the list. I guess Heikki knows how to implement LRU …
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
…InnoDB status. Baron once wrote an article on how to do this. There is not such easy way for the long transaction list…to create a special InnoDB table called innodb_monitor: CREATE TABLE innodb_monitor (a INT) ENGINE=InnoDB Creating it causes the full status to…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
…to newest, and simultaneously listed from least effective to most effective: innodb_max_dirty_pages_pct: This attempts to…tables and/or use the global tablespaces) *cough ext3 cough*. innodb_adaptive_flushing: An Innodb plugin/5.5 setting that tries to…
Post: Performance problem with Innodb and DROP TABLE
February 3, 2011 By 23 Comments
…list you really need to think how large it can get. We’re already seeing half a TB innodb…Innodb tables as transient tables where you create and drop them frequently you may avoid such design or use innodb_file_per_table…
