MySQL 经常连接不上，应该怎么优化

63490794

MySQL 经常连接不上，每次重启MySQL才可以，/etc/my.cnf 应该怎么优化

服务器配置：

CPU：intel xeon E5-2420（两个）
内存：16G （4*4）
硬盘：600GB SAS （3个 300GB  RAID 5）

MySQL 8.0.20

licess

配置文件都是自动优化过了的
看一下mysql日志和系统日志中mysql停止工作时间的日志

63490794

licess 发表于 2021-3-9 20:19
配置文件都是自动优化过了的
看一下mysql日志和系统日志中mysql停止工作时间的日志 ...

mysqli::real_connect(): (08004/1040): Too many connections

max_connections=1000
还需要加大码？

63490794

1. [client]
   
2. #password   = your_password
   
3. port        = 3306
   
4. socket      = /tmp/mysql.sock
   
5. 
   
6. [mysqld]
   
7. port        = 3306
   
8. socket      = /tmp/mysql.sock
   
9. datadir = /home/mysql
   
10. skip-external-locking
    
11. key_buffer_size = 256M
    
12. max_allowed_packet = 1M
    
13. table_open_cache = 1024
    
14. sort_buffer_size = 4M
    
15. net_buffer_length = 8K
    
16. read_buffer_size = 4M
    
17. read_rnd_buffer_size = 512K
    
18. myisam_sort_buffer_size = 64M
    
19. thread_cache_size = 128
    
20. tmp_table_size = 128M
    
21. performance_schema_max_table_instances = 6000
    
22. 
    
23. explicit_defaults_for_timestamp = true
    
24. #skip-networking
    
25. max_connections = 1000
    
26. max_connect_errors = 100
    
27. open_files_limit = 65535
    
28. default_authentication_plugin = mysql_native_password
    
29. 
    
30. wait_timeout = 60
    
31. interactive_timeout = 60
    
32. 
    
33. log-bin=mysql-bin
    
34. binlog_format=mixed
    
35. server-id   = 1
    
36. binlog_expire_logs_seconds = 864000
    
37. early-plugin-load = ""
    
38. 
    
39. default_storage_engine = InnoDB
    
40. innodb_file_per_table = 1
    
41. innodb_data_home_dir = /home/mysql
    
42. innodb_data_file_path = ibdata1:10M:autoextend
    
43. innodb_log_group_home_dir = /home/mysql
    
44. innodb_buffer_pool_size = 1024M
    
45. innodb_log_file_size = 256M
    
46. innodb_log_buffer_size = 8M
    
47. innodb_flush_log_at_trx_commit = 1
    
48. innodb_lock_wait_timeout = 50
    
49. 
    
50. sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
    
51. 
    
52. [mysqldump]
    
53. quick
    
54. max_allowed_packet = 16M
    
55. 
    
56. [mysql]
    
57. no-auto-rehash
    
58. 
    
59. [myisamchk]
    
60. key_buffer_size = 256M
    
61. sort_buffer_size = 4M
    
62. read_buffer_size = 4M
    
63. write_buffer_size = 2M
    
64. 
    
65. [mysqlhotcopy]
    
66. interactive-timeout
    
67. 
    
68. [mysqld_safe]
    
69. malloc-lib=/usr/lib/libjemalloc.so
    

复制代码

licess

可以增大试试，日志里什么内容？

sunny123456

licess 发表于 2021-3-11 12:38
可以增大试试，日志里什么内容？

mysql远程连接慢，就是使用工具连接Mysql比较慢，有什么优化方案吗？？？？？