…). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6… by the server either automatically on startup or on demand. Time interval between checks done by … of tables and slow IO then XtraBackup can spend a lot of time opening all the tablespaces…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6… by the server either automatically on startup or on demand. Time interval between checks done by … of tables and slow IO then XtraBackup can spend a lot of time opening all the tablespaces…
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
…like to. To avoid physical I/O all the time we need to get some reasonable amount of data… this without death-by-swapping, which would be extremely slow on this machine, so we need to stop the…The real solution is to disable this startup process. It’s not even needed for InnoDB. Sooner or later you’ll…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…thread is scheduled next time object will be free already. OS Waits are relatively slow, and if …competing to enter innodb queue at the same time Innodb makes thread to sleep for some time before trying to … also see number of rows operation since system startup as well as average values. This is also…
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 log… redo phase of recovery. It can take pretty long time and this time depends on number of variables – how large are rows…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… (Alexey Kopytov). QUERY_RESPONSE_TIME doesn’t respect QUERY_RESPONSE_TIME_STATS . #855312 (Oleg Tsarev). The mysqldump option –innodb-optimize-keys did not…, i.e. InnoDB waits until it is complete before reporting successful startup to the server. #785489 (Alexey Kopytov). The Slow Query Log did…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… for many tables at onces, which typically make system extremely slow and also can use up all allowed connections or run…. 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…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…innodb_changed_pages_limit option to innodb_max_changed_pages. Bug fixed #1105726 (Laurynas Biveinis). Time in slow query log was displayed incorrectly when slow… with innodb_force_recovery=6. When starting the server log tracking initialization would fail. The server would abort on startup. …
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… (Laurynas Biveinis). Log tracking was initialized too late during the InnoDB startup. Bug fixed #1076892 (Laurynas Biveinis). Temporary files created by binary… procedures correctly, this caused Query_time to increase for every query stored procedure logged to the slow query log. Bug fixed #719386…
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
… page tracking log files. Bugs Fixed: Time in slow query log was displayed incorrectly when slow_query_log_microseconds_timestamp variable was set… would fail. The server would abort on startup. Bug fixed #1083596 (Laurynas Biveinis). InnoDB monitor was prefetching the data pages for printing…
