… very long execution times for even simplest queries, or a huge deadlock. In such rare cases SHOW ENGINE InnoDB STATUS often fails… make InnoDB to write the full status output into innodb_status.
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
Post: How to decrease InnoDB shutdown times
April 15, 2009 By 19 Comments
Sometimes a MySQL server running InnoDB takes a long time to shut down. The usual culprit is flushing dirty pages … just go through the recovery phase on startup, which can be even slower in stock InnoDB than the shutdown process, for a… to decrease the shutdown time is to pre-flush the dirty pages, like this: mysql> set global innodb_max_dirty_pages_pct…
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
… an InnoDB table is serialized by a mutex, for one thing, and the mysqlcheck script opens all tables. One at a time…’d like to. To avoid physical I/O all the time we need to get some reasonable amount of data into…. The real solution is to disable this startup process. It’s not even needed for InnoDB. Sooner or later you’ll find…
Post: SpyLOG Was sold the other day, time to look back
August 11, 2007 By 2 Comments
Friends are pointing me to the article saying SpyLOG, the startup which I co-founded back in 1999 was sold the…. It is especially Interesting another month we announced our own startup project ClickAider which operates in related market. This deal reassures… start using Innodb and instantly at TB scale. We found massive amount of MySQL and Innodb bugs and at that time Monty were…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… allowing only innodb_thread_concurrency threads to run inside Innodb kernel at the same time. If thread is not runniing inside innodb kernel status… many threads competing to enter innodb queue at the same time Innodb makes thread to sleep for some time before trying to wait (if…. You can also see number of rows operation since system startup as well as average values. This is also very good…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… Innodb tables decent size of innodb_log_file_size is important for MySQL Performance. However setting it too large will increase recovery time… happens on recovery and why large innodb_log_file_size slows down recovery. During startup after crash Innodb scans log files to find… redo phase of recovery. It can take pretty long time and this time depends on number of variables – how large are rows…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb For Falcon ./configure –prefix=/usr/local/mysqltest/mysql- –with-falcon mysqld startup params…_KEY_POINT queries. InnoDB is better than MyISAM by 2-26 times and than Falcon by 1.64 – 3.85 times. READ_PK… threads, but MyISAM scales a bit better in this case. InnoDB is better than Falcon by 2-3 times. // //
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
… Kopytov). QUERY_RESPONSE_TIME doesn’t respect QUERY_RESPONSE_TIME_STATS . #855312 (Oleg Tsarev). The mysqldump option –innodb-optimize-keys did …e. InnoDB waits until it is complete before reporting successful startup to the server. #785489 (Alexey Kopytov). Fixed assertion failure in InnoDB. #…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… startup until LRU dump is loaded Added a new boolean option, –innodb-blocking-buffer-pool-restore (in 5.1 it is –innodb-blocking… (Alexey Kopytov). QUERY_RESPONSE_TIME doesn’t respect QUERY_RESPONSE_TIME_STATS . #855312 (Oleg Tsarev). The mysqldump option –innodb-optimize-keys did not…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
…. Innodb statistics – Unlike MyISAM Innodb does not store index cardinality in tables, instead it computes them on first table access after startup. This may take significant time…
