search for: slow_query_log

...#wait_timeout=28800 #interactive_timeout = 28800 max_allowed_packet=512M #General Query Log general_log_file = /var/log/mysql/mysql_query.log general_log = 1 #Error Log log_error = /var/log/mysql/mysql_error.log #Slow Query Log slow_query_log = 1 slow_query_log_file = /var/log/mysql/mysql_slow.log long_query_time = 2 log-queries-not-using-indexes collation-server = utf8_general_ci init-connect='SET NAMES utf8' character-set-server = utf8 # this is only for embedded server [e...

...ock table_cache = 1024 thread_cache_size = 512 thread_concurrency = 8 query_cache_type=0 #memory table max size tmp_table_size = 128M #******************************* Logs related settings *************************** log-error=/usr/local/mysql/log/error3.log long_query_time = 1 log_long_format slow_query_log=/usr/local/mysql/log/slow-query3.log binlog_cache_size = 2M max_binlog_size = 512M log-bin=/data/mysqldata3/binlog/mysql-bin sync_binlog=1 #log warnings log_warnings #******************************* Replication related settings ********************** #master server-id = 3 binlog_format=mixed #*...