…e. updates on CentOS. If you are using InnoDB, it is also important that your transaction logs…start Starting MySQL (Percona Server) [ OK ] You should shutdown MySQL first, then unmount the logical volume … cannot test restore your snapshots – they are one time use! However, if you can tolerate the …
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
Comment: Pitfalls of converting to InnoDB
March 8, 2007 By 16 Comments
… doing a basic insert into an InnoDB table. My database class starts a …attempting to insert takes 50 seconds to time-out with a “1205 – Lock wait …_in_progress = true; register_shutdown_function(array($this, “__shutdown_check”)); } public function __shutdown_check() { if ($this->transaction_in_…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
….commanual Innodb_row_lock_time_avgblogpercona.commanual Innodb_row_lock_time_maxblogpercona.commanual Innodb_row_lock_waitsblogpercona.commanual Innodb_rows_deletedblogpercona.commanual Innodb_rows_insertedblogpercona.commanual Innodb_rows_readblogpercona.commanual Innodb_rows_updatedblogpercona.commanual innodb…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… power can go down which all mean similar things – MySQL Shutdown is unexpected and there could be various inconsistences. And this… later” message, but also – warmup takes longer time on extreme load. Innodb statistics – Unlike MyISAM Innodb does not store index cardinality in tables…
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
… (Oleg Tsarev) response_time_distribution – Counts queries with very short execution times and groups them by time interval. (Oleg Tsarev) innodb_buffer_pool_…a crash during shutdown when userstat_running=1. Bug #612954 – Fixes a problem with SHOW PROCESSLIST displaying an incorrect time. Bug #610525…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… method, then # start replication for the first time (even unsuccessfully, for example # if you mistyped … of the master.info file, unless you shutdown # the slave server, delete master.info and … innodb_log_file_size = 1000M #innodb_log_buffer_size = 32M #innodb_flush_log_at_trx_commit = 1 #innodb_…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
…innodb_data_home_dir /rdsdbdata/db/innodb innodb_doublewrite ON innodb_fast_shutdown 1 innodb_file_format Antelope innodb_file_format_check Barracuda innodb_file_per_table ON innodb…
Post: Percona Server 5.1.49-rel11.3
September 10, 2010 By 1 Comment
… the ANALYZE TABLE command. A new session variable was introduced: innodb_flush_log_at_trx_commit_session. Fixed bugs Bug #576041… #592007 – More strictly enforces the maximum purge delay defined by innodb_max_purge_lag by removing the requirement that purge operations… a crash during shutdown when userstat_running=1 Bug #612954 – Fixes a problem with SHOW PROCESSLIST displaying an incorrect time Bug #610525…
Comment: xtrabackup-1.2
May 10, 2010 By 2 Comments
… 10 MB InnoDB: Database physically writes the file full: wait… InnoDB: Error: all log files must be created at the same time. InnoDB: All… errors in shutdown. InnoDB: Then delete the existing log files. Edit the .cnf file InnoDB: and start the database again. xtrabackup: innodb_init(): Error…
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
… 1.1.0. Bugs Fixed: Loading LRU dump was preventing shutdown. Bug fixed #712055 (George Ormond Lorch III). The kill idle… for some time. Bug fixed #882653 (Stewart Smith). Server started with skip-innodb crashes on SELECT * FROM INNODB_TABLE_STATS or INNODB_INDEX_STATS. Bug fixed #896439 (Stewart Smith). Removed the INFORMATION_SCHEMA table INNODB…
