… find more optimization candidates. So “tail -f mysql-slow.log | mysql_slow_log_filter -T 0.5 -R 1000″ will look at… to generate you query log and get back to unpatched version. It is best if you generate this log for all your queries… of time and then get back to logging only very slow queries. Once you have created full log – parse it and check queries…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
….8 tmpdir=/home/mysqld/mdmp/tmp slow_query_log=mdmp_slow_queries.log # binary logging and replication binlog_cache_size=1M binlog_format…=1 general_log = ON max_heap_table_size=128M event_scheduler=ON query_cache_limit = 10M open_files_limit = 8088 back_log=128…=1 general_log = ON max_heap_table_size=128M event_scheduler=ON query_cache_limit = 10M open_files_limit = 8088 back_log=128…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
…DROP statement at position 336797160: mysql> show binary logs; +——————+———–+ | Log_name | File_size | +——————+———–+ … | mysql-bin.000022 | 336797725 | | …consistent data and still have my salaries table back. Because leaving a production server with active …
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… | | INNODB_LOG_FILE_SIZE | 5242880 | 50331648 | | BASEDIR | /mnt/nfs/dist/5.5.30 | /mnt/nfs/dist/5.6.10 | | BACK_LOG | 50 | 80…/dist/5.6.10/lib/plugin/ | | SYNC_RELAY_LOG | 0 | 10000 | | GENERAL_LOG_FILE | /mnt/data/sandboxes/msb_5_5_30/data… a lot better on MySQL 5.6 with default configuration back_log Minor increase 50 to 80 does not make much difference…
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
…. I’ll explain the math below. Second – is MySQL parameter back_log which has default value of just 50. You may want… as 3000 connections come in. Under such conditions the default back_log of 50 is enough just for 17 milliseconds, and if…. I would suggest sizing your tcp_max_syn_backlog and back_log value to be enough for at least 2 seconds worth…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…privilegesblogpercona.commanual back_logblogpercona….log_binblogpercona.commanual log_binblogpercona.commanual log_bin_indexblogpercona.commanual log_bin_trust_function_creatorsblogpercona.commanual log_errorblogpercona.commanual log_isamblogpercona.commanual log_outputblogpercona.commanual log…
Post: Get Me Some Query Logs!
November 22, 2012 By 14 Comments
… collected in the logs. After it finishes sleeping, or if you interrupt the script, the script restores log configuration back to the values they started with. $ full-slow-log [ -v ] [ -s seconds ] [ -c config… verbose output: $ full-slow-log -v Discovering slow_query_log=1 Discovering slow_query_log_file=mysql-slow.log Discovering long_query_time=60…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… down recovery. During startup after crash Innodb scans log files to find log records which only have been applied in memory and… is close to be proportional to size of log files, so expect 1GB logs to take twice time to apply compared to… phase – after log file are applied and database is in “physically consistent” state, Innodb will need to roll back certain transactions which…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… we made something smaller it was because of long experience backed up by testing that showed smaller was a better choice… and try the settings for any OLTP workloads they have. back_log is calculated based on max_connections. You’re right that… ability to write less information in the binary log when using row-based logging. Both of those are good and I recommend…
Post: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
… lock up at random times and then it would go back to normal in just a few seconds. This was MySQL… created and, if expire_logs_days is not zeroish, log files older than expire_logs_days are removed. &LOCK_log mutex is held for the duration of the binary log removal and…
