【已完成】mysql配置文件设置后仍然不写入慢日志

生产机mysql配置如下

1. [client]
   
2. #password        = your_password
   
3. port                = 3306
   
4. socket                = /tmp/mysql.sock
   
5. 
   
6. [mysqld]
   
7. binlog_cache_size = 256K
   
8. thread_stack = 512K
   
9. join_buffer_size = 8192K
   
10. max_heap_table_size = 2048M
    
11. #innodb_force_recovery=6
    
12. port                = 3306
    
13. socket                = /tmp/mysql.sock
    
14. datadir = /data/www/data
    
15. default_storage_engine = InnoDB
    
16. performance_schema_max_table_instances = 400
    
17. table_definition_cache = 400
    
18. skip-external-locking
    
19. key_buffer_size = 1024M
    
20. max_allowed_packet = 100G
    
21. table_open_cache = 2048
    
22. sort_buffer_size = 4096K
    
23. net_buffer_length = 4K
    
24. read_buffer_size = 4096K
    
25. read_rnd_buffer_size = 2048K
    
26. myisam_sort_buffer_size = 128M
    
27. thread_cache_size = 256
    
28. tmp_table_size = 2048M
    
29. default_authentication_plugin = mysql_native_password
    
30. lower_case_table_names = 1
    
31. sql-mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
    
32. 
    
33. explicit_defaults_for_timestamp = true
    
34. #skip-name-resolve
    
35. max_connections = 1024
    
36. max_connect_errors = 100
    
37. open_files_limit = 65535
    
38. 
    
39. log-bin=mysql-bin
    
40. binlog_format=mixed
    
41. server-id = 1
    
42. binlog_expire_logs_seconds = 600000
    
43. slow_query_log=1
    
44. slow-query-log-file=/data/www/data/mysql-slow.log
    
45. long_query_time=3
    
46. #log_queries_not_using_indexes=on
    
47. early-plugin-load = ""
    
48. 
    
49. innodb_data_home_dir = /data/www/data
    
50. innodb_data_file_path = ibdata1:10M:autoextend
    
51. innodb_log_group_home_dir = /data/www/data
    
52. innodb_buffer_pool_size = 4096M
    
53. innodb_log_file_size = 1024M
    
54. innodb_log_buffer_size = 8M
    
55. innodb_flush_log_at_trx_commit = 1
    
56. innodb_lock_wait_timeout = 50
    
57. innodb_max_dirty_pages_pct = 90
    
58. innodb_read_io_threads = 12
    
59. innodb_write_io_threads = 12
    
60. 
    
61. local-infile = 1
    
62. secure_file_priv = ""
    
63. [mysqldump]
    
64. quick
    
65. max_allowed_packet = 500M
    
66. 
    
67. [mysql]
    
68. no-auto-rehash
    
69. 
    
70. [myisamchk]
    
71. key_buffer_size = 512M
    
72. sort_buffer_size = 8M
    
73. read_buffer = 2M
    
74. write_buffer = 2M
    
75. 
    
76. [mysqlhotcopy]
    
77. interactive-timeout

复制代码

在堡塔后台mysql面板慢日志可以正常看到几条慢日志，
但是/www/server/data/mysql-slow.log 从9月多一直没有更新。mysql和服务器上周末重启了也没区别。


在测试机上试了，slow log相关的配置相同，测试机可以正常写入/www/server/data/mysql-slow.log。

1. /data/www/data/mysql-slow.log

复制代码

路劲正确吗，目录权限正确吗？MySQL日志是否出现报错？
要mysql/755的上级目录权限，mysql/660的文件权限就可以了

堡塔安全赤井秀一 发表于 2021-10-27 11:44
路劲正确吗，目录权限正确吗？MySQL日志是否出现报错？
要mysql/755的上级目录权限，mysql/660的文件权限 ...

没问题了，是我路径搞错了，感谢！