…MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL…_END_F BINLOG ‘ L5cLURMBAAAALwAAAAUDAAAAABEAAAAAAAEABHRlc3QABHRlc3QAAwMD/gL+CQY= L5cLURgBAAAAOAAAAD0DAAAAABEAAAAAAAEAA///+AIAAAAAAAAAA2JhcvgCAAAAAAAAAANob3A= ….000008 | | freeing items | 0.000016 | | cleaning up | 0.000004 …
Post: Fun with the MySQL pager command
January 21, 2013 By 6 Comments
… result as the original one. Cleaning up SHOW PROCESSLIST If you have lots of connections on your MySQL, it’s very difficult… $6}’ | sort | uniq -c | sort -r’ mysql> show processlist; 309 Sleep 3 2 Query 2 Binlog Dump 1 Command Astute readers will… ORDER BY TOTAL DESC; +————-+——-+ | COMMAND | TOTAL | +————-+——-+ | Sleep | 344 | | Query | 5 | | Binlog Dump | 2 | +————-+——-+ True, but: It’s nice to know several…
Post: Percona XtraDB Cluster (PXC): what about GRA_*.log files ?
December 19, 2012 By Leave a Comment
…mysql]# ls -l GRA_3_3.log -rw-rw—-. 1 mysql mysql…binlog is either in use or was not closed properly. ROLLBACK/*!*/; BINLOG ‘ NHUCUA8BAAAAZwAAAGsAAAABAAQANS41LjI1LWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAA …(GRA_*.log) doesn’t clean up automatically and …
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… for point in time recovery it can go unnoticed. sync_binlog Is helping by syncing binary log, but at performance penalty… use innodb-safe-binlog option in MySQL 4.1 so your Innodb log and binary log are synchronized. In MySQL 5.0 XA… – If you restart MySQL server its caches (key_buffer, innodb_buffer_pool, query_cache,table_cache) are cleaned, so may be OS…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… from the Percona Software Repositories). Based on MySQL 5.1.66, including all the bug … Laurynas Biveinis). Crash-resistant replication would break with binlog XA transaction recovery. If a crash would … have been dropped, as that will already clean them. Bug fixed #1076215 (Laurynas Biveinis). When …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… sure caches were clean. OLTP benchmark As the goal was to compare performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have…_connect_errors = 10 table_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M thread_cache…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
… ./ibdata1 to /data/vadim/mysql/export//ibdata1 >> log scanned up to (3 769009554) …done Copying ./mysql/ibbackup_binlog_marker.ibd is skipped. Copying… %) InnoDB: 12 transaction(s) which must be rolled back or cleaned up InnoDB: in total 107 row operations to undo InnoDB… 96 97 98 99 100 done. When finished quick check mysql> select count(*) from order_line; +———-+ | count(*) | +———-+ | 32093604 | +———-+ 1 row in…
