… is not – FLUSH TABLES WITH READ LOCK may take quite a while to complete on systems with long queries. Problems with data… while to complete if you have long running queries. The catch here is FLUSH TABLES WITH READ LOCK actually waits for all…. Normally you can skip slow query logs and error log while taking backup. You also can skip most of binary logs – however if some of…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… well it can bring the server down. You can have slow query log enabled and review it occasionally, but doing it offline means… tables and indexes can be cleaned with the corresponding FLUSH command (e.g. FLUSH INDEX_STATISTICS). All that can be fed into… new commands with our msl patch, which introduces the advanced query logging, would give the administrator powerful tool to almost effortlessly catch…
Comment: Get Me Some Query Logs!
December 31, 2012 By 14 Comments
… and MariaDB. – Gentler log redirection, without doing FLUSH LOGS. – New “-f file” option to specify the location of the redirected slow-query log. I’ll write some documentation soon too. JohnShep, I believe the problem you described is that your slow-query log is…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
… #master-port = 3306 #innodb_flush_log_at_trx_commit=0 sync_binlog=0 slave-skip-errors = 1062 back_log = 75 # skip-innodb max…_timeout = 120 innodb_use_sys_malloc = 0 long_query_time = 8 #log-slow-queries = /var/log/mysql-slow-query.log # Default to using old password format for compatibility…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
… = 64M thread_cache_size = 8 query_cache_size = 32M log_queries_not_using_indexes = On log_slow_queries=/var/lib/mysql/log-slow-queries.log innodb_data_home_dir = /var…=100M set-variable = innodb_additional_mem_pool_size=10M innodb_flush_log_at_trx_commit=1 #skip-innodb skip-name-resolve # Try…
Post: Be careful rotating MySQL logs
December 9, 2007 By 7 Comments
If you enable logging of all queries as “slow queries” using the patch or MySQL 5.1 you can get log file to grow huge. Same may happen with general log… problem is very simple – instead of deleting MySQL log file – rename it, call “FLUSH LOGS” which will be instant as it will not…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
….2.10 | | INNODB_BUFFER_POOL_INSTANCES | 1 | 8 | | QUERY_CACHE_SIZE | 0 | 1048576 | | SLOW_QUERY_LOG_FILE | /mnt/data/sandboxes/msb_5_5_30… in MySQL 5.6 Welcome to much faster information_schema queries! innodb_log_file_size – default has been increased from 5MB to… to provide some level of guaranty independently on file system flush policy. This probably will not impact most of workloads. secure…
Comment: 5.0.77 / 5.0.82 -build16 Percona binaries
June 19, 2009 By 4 Comments
… @@ OPT_PROFILING_USE_GETRUSAGE, OPT_SLOW_LOG, OPT_SLOW_QUERY_LOG_FILE, + OPT_USERSTAT_RUNNING, OPT_USE_GLOBAL_LONG_QUERY_TIME, OPT_INNODB_ROLLBACK_ON_TIMEOUT….h.rej srv0srv.h.rej: *************** *** 145,150 **** extern ulint srv_flush_neighbor_pages; extern uint srv_read_ahead; extern ulint srv…
Post: Announcing Percona Server for MySQL 5.5.30-30.1
March 7, 2013 By Leave a Comment
…flushing. Bug fixed #1117067 (Laurynas Biveinis). Percona Server would do unnecessary slow log stats accounting even with the slow log disabled. Bug fixed #1123915 (Alexey Kopytov). Optimization cleanup to avoid calls related to extended slow query log…
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
… InnoDB durability (innodb_flush_log_at_trx_commit) disable binary logging if it’s not useful look at the write queries that may cause… full slow query logging (with long_query_time = 0) for some time during peak load. Then you can use pt-query-digest to analyze the queries and have a report of the queries that are causing the most…
