… can have a really large log file generated. Another thing that we normally do is set the variable log_slow_verbosity to ‘full’, this variable is available in Percona Server and allows us to log all the… you were using the vanilla MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:02…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… to the log table, query times and lock times are truncated to to integers: sql/log.cc, Log_to_csv_event_handler::log_slow(): 610…,Close stmt,Reset stmt,Set option,Fetch,Daemon,Error’), CONCAT(‘# administrator command: ‘, sql_text), sql_text), ‘;’ ) AS `# slow-log` FROM `mysql`.`slow_log`; GO echo “#” I…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
… get valuable information: SET GLOBAL slow_query_log=1; SET GLOBAL long_query_time=0; With long_query_time we are logging all queries that… the slow query log to the DEV server we can replay the load: percona-playback –mysql-host=127.0.0.1 –mysql-user=root –mysql-schema=my_db –query-log-file=slow.log Executed 429467 queries Spent…
Post: Microslow patch for 5.1.20
July 18, 2007 By 3 Comments
… you to redirect query log (it’s actually called general log now) and slow log to CSV tables mysql.general_log and mysql.slow_log respectively. The patch will… output for your logs to the plain old-fashioned files. In MySQL 5.1 it’s done by setting –log-slow-queries=slow.log and –log-output=FILE… you to log queries executed by the slave thread. This can be achieved by running MySQL with startup time parameter –log-slow-slave-statements…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… makes it better to disable them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my…_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 innodb_data_home_dir = /data/mysql/var innodb_data_file_path = ibdata1:10000M:autoextend innodb_file_per_table innodb_log_group_home_dir = /log/mysql/var/ innodb…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
…logged into slow log, however the new version is loaded with a set of cool new features. CONNECTION IDENTIFIER Each slow log… 1113 LOGGING OF THE REPLICATED STATEMENTS Normally MySQL will not write into slow log any… behavior with the new parameter –log-slow-slave-statements. THE DETAILED INFORMATION…
Post: Profiling MySQL stored routines
January 19, 2009 By 4 Comments
…, feels [like] almost summer! | +———————————————————-+ 1 row in set (0.00 sec) host # tail /var/log/mysql/mysql-slow.log # Time: 090115 2:25:28 # User@Host… show you how this works: mysql> set profiling=1; Query OK, 0 rows affected (0.00 sec) mysql> SELECT whatstheweatherlike(3); +———————————————————–+ | whatstheweatherlike(3…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
… disks). Software It was used MySQL 5.0.75-percona-b11 on CentOS release 4.7 MySQL setting There were two cases considered CPU- and IO-bound. Each case had three options: logging turned off; logging queries which… are two conclusions can be made: It is safe to log slow queries with execution time bigger than a second without worry…
Post: Poor man's query logging
November 7, 2008 By 5 Comments
…of additional information. The other is slow log enabled by –log-slow-queries parameter (MySQL 5.1 requires also –slow-query-log), which was designed to store…when no longer necessary (though actually slow log can be disabled by simply setting long_query_time MySQL variable vale high enough). So …
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
… MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in…in the log file. If you used to do tail -100 log-slow.log and now change it to SELECT * FROM slow_log …feature would be the function which returns as as SET list of tables which query is using. This …
