…alignright” width=”247″] Percona Server for MySQL version 5.6.11-60…..3 release notes. Bugs Fixed: Transaction objects are now allocated calling …. Under very rare circumstances, deleting a zero-size bitmap file at the right … used to hold the log system mutex for the log reads needlessly, potentially…
Post: Percona XtraDB Cluster (PXC): what about GRA_*.log files ?
December 19, 2012 By Leave a Comment
… to apply one transaction. For each of those file, a corresponding warning or error message is present in the mysql error log file. Those error… GRA log file: [root@node2 mysql]# ls GRA_*.log GRA_3_3.log [root@node2 mysql]# file GRA_3_3.log GRA_3_3.log: data [root@node2 mysql]# ls… they really represent a problem or not, you can manually delete them. This was also discussed in galera-codership mailing list…
Post: Recovery deleted ibdata1
August 10, 2012 By 9 Comments
… case when a customer deleted the InnoDB main table space – ibdata1 – and redo logs – ib_logfile*. MySQL keeps InnoDB files open all the time… is the purge thread. It should purge all transactions up to very last ———— TRANSACTIONS ———— Trx id counter 0 16644 Purge done for…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…log_file_sizeblogpercona.commanual innodb_log_files_in_groupblogpercona.commanual innodb_log_group_home_dirblogpercona.commanual Innodb_log_waitsblogpercona.commanual Innodb_log_write_requestsblogpercona.commanual Innodb_log…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… innodb_log_file_size is important for MySQL Performance. However setting it too large will increase recovery time, so in case of MySQL crash… small log files. Undo phase takes considerable time if tranactions are long – Ie if you would delete 10000000 rows in the same transaction and…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…log, and examine the log. In MySQL 5.1 and newer with the InnoDB plugin, it’s easy to figure out which transaction… up the disk. #!/bin/bash # Begin by deleting things more than 7 days old find /root… –no-report –print” on the resulting tcpdump file (after inspecting the captured SHOW INNODB STATUS…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… mysql -e ‘select * from flexviews.binlog_consumer_status\G’ -uroot *************************** 1. row *************************** server_id: 999 master_log_file: binary_log.000001 master_log… 2 Duplicates: 0 Warnings: 0 And delete data in a second transaction: mysql> delete from test.demo where c1=1…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
…deleted) mysqld 6112 root 62u REG 7,0 62390272 26 /tmp/ML19sFCA (deleted) There are lot of files in deleted… INFILE MySQL send the rows to the Binary Log Cache before writing it to the Binary Log Files. … files won’t disappear, even after committing the transaction and with the rows on the binary log….
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…delete one of MySQL‘s log or data files from disk. The database server will continue to function, however, because the file isn’t really deleted…mysql-file-privs plugin checks whether MySQL owns every file and directory within its data directory. InnoDB is getting stuck, has long-running transactions…
Post: MVCC: Transaction IDs, Log Sequence numbers and Snapshots
December 19, 2007 By 3 Comments
MySQL Storage Engines implementing …transactions – changes from different transactions are intermixed in the log files and many LSNs can correspond to changes from the same transaction… by transaction 100 Value 4 created by transaction 50 Value 3 created by transaction 10, deleted by transaction 20….
