… 05:52:02 UPDATE_TIME: NULL *************************** 3. row *************************** SESSION_ID: 7231 TABLE_SCHEMA: test TABLE_NAME: z ENGINE: InnoDB NAME: #sql516_1c3f…_LENGTH: 0 CREATE_TIME: NULL UPDATE_TIME: NULL 3 rows in set (0.00 sec) Innodb Memory Usage Finally it is often… good tools to detect memory leaks like valgrind are too slow to run in production. So the best thing to do…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… and information. I just made the MySQL, apache2 and php updates available to Debian Squeeze avalable on DotDeb.org, and I… terms of qps) with the last two or three minor updates since the end of last year; shortly after Oracle took… happening across the board to everyone? Have some updates made to INNOdb tables really slowed down mySQL as measured by qps, in the…
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 5 Comments
… well suddenly show up on slow query log until InnoDB again updates the statistics. But when does InnoDB perform the updates aside from the first… seconds to update all the tables’ statistics. Luckily, this can be controlled with Percona Server with the variable innodb_stats_auto_update (from MySQL Community 5.1.17 a similar variable exist called innodb_stats_on_metadata…
Post: Innodb Recovery Update - The tricks what failed.
May 24, 2007 By 3 Comments
… no way to make Innodb avoid touching it. Even when we dropped all Innodb tables (for test purposes) Innodb still was crashing if… faulty hardware. Primary keys are typically simple integer keys in Innodb while secondary keys may have very complex structure. Compex corruptions… reason. In fact dump and reload process can be so slow restoring even week old backup and running roll forward recovery…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…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…updatable…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
For a couple of months there have been no updates to our msl patch, however recently I managed some time … messages to your slow log will be. Multiple flags allowed in a comma-separated string. [microtime, query_plan, innodb] msl patch currently… you want to have in your slow log. For example to have microsecond query timing and InnoDB statistics you would need to…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
…. (Oleg Tsarev) Old system variable use_global_log_slow_control was renamed to slow_query_log_use_global_control. (Oleg Tsarev) Old… was renamed to innodb_recovery_update_relay_log. (Yasufumi Kinoshita) Old system variable innodb_pass_corrupt_table was renamed to innodb_corrupt_table_action…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… time object will be free already. OS Waits are relatively slow, and if you get tens of thousands of OS waits… to keep up with update rate, in this case difference between these values will also grow and innodb_max_purge_lag will… be “fetching rows”, “updating” and couple of other values. “Thread declared inside InnoDB 400″ means thread is running inside Innodb kernel and still…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…data into a temporary table, secondary indexes are updated by inserting individual rows rather than sorting; …” part will not be affected by a slow tmpdir, but rebuilding the indexes will obviously take…TABLE is mapped to ALTER TABLE … ENGINE=InnoDB for InnoDB tables and thus, is just a special …
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 1 Comment
… Percona Server the following can be helpful: mysql> select * from innodb_rseg; +———+———-+———-+———+————+———–+ | rseg_id | space_id | zip_size | page_no | max… is the most dangerous reason. It is possible for database updates happen faster than purge thread can purge records when they… this problem first you can use innodb_max_purge_lag to make a threads doing modifications slow down if purge thread can…
