…Slow Query Log – Especially after the changes to log all queries slow query log may be growing too rapidly to follow, so we implemented slow query log filter (based on parse_mysql_slow_log…can change long_query_time without restarting server so it is easy to get sample of all queries for some period …
Post: Enabling/Disabling query log without server restart in MySQL 5.0
September 13, 2007 By 13 Comments
… in MySQL on profuction server for various debugging needs. Unfortunately you can’t switch it on and off without restarting server until MySQL 5.0. What can you do in MySQL 5.0 and below ? Use… all queries logged as slow queries (with times) and as you can change long-query-time online you can effectively enable and disable debug logging live…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…MySQL configuration ? OS Configuration or Hardware configuration or could have anyone changed it without … pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but …regularly with mk-query-digest (Percona Server marks Slave Thread in slow query log so it…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… file system Why snapshot based MySQL backups are great ? There are …slow query logs and error log while taking backup. You also can skip most of binary logs …log_pos=401934686; 12) Run SLAVE START to restart replication. With slightly modified process you can clone slaves from the slaves without…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
…panic and what thought to be slow down with version upgrade is … such as both systems after restart or even better both systems fully…query-digest to compare workloads on servers. Best if you can analyze full query logs…without side load. Setting up 2 MySQL Servers side by side (for example with MySQL…
Post: Percona Server 5.1.47-rel11.0
June 21, 2010 By 13 Comments
…slow_query_log option to use microsecond precision for the slow query log‘s timestamps (issue #358412). Added the –use_global_log_slow_control option to control slow-query logging globally without restarting…DEBUG #569156 CentOS 5: mysql-server conflicts with MySQL-server #589639 Recovery process …
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…write on every node without needing to worry about … network traffic would really slow down transactions. You may …log entries 1 MySQL thread id 3972, OS thread handle 0x7fddb84e0700, query…mysql> commit; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction node1 mysql…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…restart MySQL. You can obviously choose the most convenient time, there is no rush. The restart…log_slow_filter. log-slow-queries[=name] Log slow queries to this log file. Defaults logging to hostname-slow.log file. Must be enabled to activate other slow log…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…query-time=5 log-slow-queries=/apps/log/slow-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query… this option without enabling named pipes…master.info and restart the slaver server…log_group_home_dir = /usr/local/mysql/data/ #innodb_log_arch_dir = /usr/local/mysql…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
…, but we use the random query generator for generating our …code seemed very, very slow I just like the …EXECUTE_IF(“crash_commit_after_log“, DBUG_SUICIDE();); DBUG_EXECUTE…crashed and restarted: $ ./kewpie.py –suite=innodbCrash –basedir=mysql-5…. tests have been passing without incident, but I also…
