…so if you close connection MySQL can clean them up. Killing connections (or stopping related applications) and …you can do better as you can query temporary tables too: mysql> select sum(data_length+index_length)…to detect memory leaks like valgrind are too slow to run in production. So the best …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… to the amazing MySQL manual, especially the option and variable reference table…_conversionsblogpercona.commanual Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query_log_fileblogpercona…
Post: Finding what Created_tmp_disk_tables with log_slow_filter
September 22, 2008 By 3 Comments
… version of MySQL. The microslow patch adds a very useful feature, the ability to log queries by execution plan. log_slow_filter=name Log only the queries that followed certain execution plan. Multiple… to stop collection. SET GLOBAL log_slow_filter:=”"; Then it was just a question of examining the slow query log and fixing the queries. More…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 116 Comments
…, 1.02 Tasks: 191 total, 1 running, 190 sleeping, 0 stopped, 0 zombie Cpu0 : 0.0% us, 0.3% sy, 0… is my.cnf configuration file [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for… = 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/lib/mysql…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… same as original file system Why snapshot based MySQL backups are great ? There are number of reasons: …6) Copy data to backup. Normally you can skip slow query logs and error log while taking backup. You … you can clone slaves from the slaves without stopping them – you just need to use SHOW SLAVE …
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… error and stopping the Slave SQL thread. Bugs Fixed #813587 / #51196 and #61790 in MySQL (Alexey Kopytov). Uninitialized values in the Slow Query Log patch. Bug Fixed: #794774 (Oleg Tsarev). Querying global_temporary_tables caused…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’ ‘Com_show_warnings’, ’8′ ‘Com_slave_start’, ’0′ ‘Com_slave_stop‘, ’0′ ‘Com_stmt_close’, ’304204263′ ‘Com_stmt_execute’, ’304205150′ ‘Com…=/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-queries.log…
Post: Microslow patch for 5.1.20
July 18, 2007 By 3 Comments
… of course enable slow logging with –slow-query-log parameter. MySQL 5.1 has this nice feature which allows you to redirect query log (it… the plain old-fashioned files. In MySQL 5.1 it’s done by setting –log-slow-queries=slow.log and –log-output=FILE. Also… with SLAVE STOP and SLAVE START commands. The change in functionality is more of a bugfix than anything else. long_query_time…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…your choice. 2) Use full slow query log and mk-query-digest. This method is great …queries MySQL server ran with their times and run mk-query-digest with filter to only check queries from replication thread: mk-query-digest slow… for backups/reporting etc) is to stop the replication for some time and …
Post: Living with backups
November 6, 2008 By 28 Comments
… is being filled with random information additional I/O occur slowing everything down even further. What does it all mean? There… simple copy operation from MySQL data directory will result in a total disaster after MySQL stops responding to the incoming queries quick enough. What… to check MySQL status every second and in case the number of connected threads goes above 50, it sends STOP signal to…
