…MySQL…truncated…transaction_alloc_block_sizeblogpercona.commanual transaction_isolationblogpercona.commanual transaction…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…size, name, access time, etc.), but for the transaction log and the doublewrite buffer, such sync of …51196 and #61790 in MySQL (Alexey Kopytov). Uninitialized values in the Slow Query Log patch. Bug Fixed: #… option led to an assertion error when truncating a table in some scenarios. Bug Fixed:#…
Post: Percona Server 5.5.14-20.5
August 17, 2011 By 4 Comments
…size, name, access time, etc.), but for the transaction log and the doublewrite buffer, such sync of …. Bugs Fixed #813587 / #51196 and#61790 in MySQL (Alexey Kopytov). Querying global_temporary_tables caused… option led to an assertion error when truncating a table in some scenarios. Bug Fixed:#…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
…shared tablespace (ibdata) and the transaction IDs and log sequence numbers that are …mysql/data/employees/ Import the new tablespace: mysql> set FOREIGN_KEY_CHECKS=0; mysql> ALTER TABLE salaries IMPORT TABLESPACE; mysql…instance, when table was altered or truncated in the meanwhile. Though this …
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… available here and from the Percona Software Repositories). Based on MySQL 5.1.66, including all the bug fixes in it… by binary log cache were not purged after transaction commit. Fixed by truncating the temporary file, if used for a binary log transaction cache, when committing or rolling back a statement or a transaction. Bug…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… you can use memcache + another mysql instance (or simply the database which is not replicated) to log updates in heap/myisam/archive… can implement all updates from the chunk in single transaction saving on log commits significantly. I mentioned you can use MyISAM or… – use two tables insert into one and process and truncate another. MySQL offers atomic RENAME TABLE call which can be used to…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…send_long_data’, ’0′ ‘Com_truncate‘, ’0′ ‘Com_unlock_tables’, ’102′…open_temp_tables’, ’0′ ‘Slave_retried_transactions‘, ’0′ ‘Slave_running’, ‘OFF’ ‘…mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
…MySQL slave. After the above setup completes, I am going to change data on the slave by truncating t1. After truncation… log mysql-bin.000001, end_log_pos…transaction. You should always set read_only = true on your MySQL slaves to prevent accidental changes in data from happening! *edit* The MySQL…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
…mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 320, undo log entries 1 MySQL…hex 306338386465646233353863643936633930363962373361353736383261; asc 0c88dedb358cd96c9069b73a57682a;…(truncated); 1: len 4; hex 00000005; asc ;; —————— —TRANSACTION 0 42304624, ACTIVE …
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… a large spike in number of connections to MySQL, which often happens when several transactions kill the database performance resulting in very… a long list of transactions or a large deadlock dump may easily exhaust the limit. MySQL in such situation truncates the output so… the full status to be periodically printed into MySQL error log. You can later disable logging by simply dropping the table. The problem…
