Displaying 2 results from an estimated 2 matches for "slow_query_log".
2015 Nov 30
2
SOT: MariaDB 5.5.x-MariaDB logs are not going to desired .log file
...#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...
2009 Apr 15
3
MySQL On ZFS Performance(fsync) Problem?
...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
#*...