… – http://master_server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log… the option innodb_fake_changes to prevent INSERTs, UPDATEs, and DELETEs from corrupting the data on the standby server. You will…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in … quite handy I also should tell log table implementation in MySQL is well though of in regards to avoiding trouble. For… optimize TRUNCATE ? I guess it should be blocked as normal DELETE statements are blocked. More than that. I found even if…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… amazing MySQL manual, especially the option and …commanual Com_deleteblogpercona.commanual Com_delete_multiblogpercona.commanual Com_doblogpercona….Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… something like this: SELECT * FROM table WHERE deleted = 0 AND group_id IN (62715996, 62716592, 62717660…page_hash_index,btr_search_info_update_slow,btr_search_info_update,btr_cur_search…_select,JOIN::exec,mysql_sel ect,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…because there are many documents about that: http://dev.mysql.com/doc/refman/5.6/en/replication-gtids-concepts… contains a representation of the set of all transactions deleted from the binary log So now, the process … How to restore a slave in a good and slow way The good way is mysqldump again. We …
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…’ ‘Com_create_table’, ’31′ ‘Com_dealloc_sql’, ’0′ ‘Com_delete‘, ’348788′ ‘Com_delete_multi’, ’1′ ‘Com_do’, ’0′ ‘Com_drop_db’, ’0… 10 mysql conf: [mysqld] server-id=5908 port=3309 socket=/tmp/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…
Post: Slow DROP TABLE
June 16, 2009 By 21 Comments
… out there and for example file removals can be painfully slow and cause a lot of random I/O. However, as…. Here is when the slow file removal on the ext3 file system starts to be a pain. Deleting a 10GB file can take a few seconds and if that is a MySQL table, the mutex…
Post: Be careful rotating MySQL logs
December 9, 2007 By 7 Comments
… you enable logging of all queries as “slow queries” using the patch or MySQL 5.1 you can get log file to… is reopened MySQL will be practically unavailable causing unanticipated downtime. The workaround for this problem is very simple – instead of deleting MySQL log file – rename it, call “FLUSH LOGS” which will be instant as it will not involve complex delete operation and…
Post: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
…-rw—- 1 mysql mysql 1073742171 Nov 2 15:15 /var/lib/mysqllogs/db1-bin-log.003229 -rw-rw—- 1 mysql mysql 1073742976 Nov 2… is slow at deleting files (both customers systems ran on ext3, which can be very slow deleting large files), then write operations in MySQL will suffer since that very same mutex is used inside MYSQL_LOG::write…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… enable logging atomically, not just for new connections as in MySQL. This is very helpful for measurement as otherwise we might… you were using the vanilla MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3….0454 0.6% 260 0.0002 1.00 0.00 DELETE poller_output # 20 0x428A588445FE580B 0.0449 0.6% 260 0…
