set-variable = max_connections=1024
set-variable = interactive_timeout = 300
set-variable = wait_timeout = 30
set-variable = slow_query_log = 1
set-variable = expire_logs_days = 7
set-variable = interactive_timeout = 300
set-variable = wait_timeout = 30
set-variable = slow_query_log = 1
set-variable = expire_logs_days = 7
解决方案 »
- 存储过程中,运行出现Column count doesn't match value count at row 1问题。麻烦大大帮忙解决
- mysql主主同步,数据丢失问题
- key id_2(id)是什么意思?
- <<<<<<<<<<<<<<求一个sql语句>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
- 关于大量数据更新的性能
- 存储过程问题,高分在线急求,解决马上给分,不给是小狗
- 关于几个close()的区别
- 请教Mysql高手,在Mysql5的Text数据类型问题
- mysql_proxy同步延迟的问题
- SQL统计在线时长 怎么解
- 一个关联表更新和性能问题
- mysql>show databases没反应
max_connections=1024
interactive_timeout=300
wait_timeout=30
expire_logs_days=7[/code]slow_query_log 好象没有
Config File Format expire_logs_days
Option Sets Variable Yes, expire_logs_days
Variable Name expire_logs_days
Variable Scope Global
Dynamic Variable Yes
Value Set Type numeric
Default 0
Range 0-99
The number of days for automatic binary log removal. The default is 0, which means “no automatic removal.” Possible removals happen at startup and at binary log rotation.
slow_launch_time Command Line Format --slow_launch_time=#
Config File Format slow_launch_time
Option Sets Variable Yes, slow_launch_time
Variable Name slow_launch_time
Variable Scope Global
Dynamic Variable Yes
Value Set Type numeric
Default 2
If creating a thread takes longer than this many seconds, the server increments the Slow_launch_threads status variable.