vps交流
当前位置：嘟嘟社区 > bbs > 正文

win相比linux的MYSQL，为什么CPU一直100%

2022-08-31 分类：bbs

WP 程序，同一个网站，放在WIN和linxu里，同样配置的，WIN 2008 mysql占用CPU 100%, LINUX debian mysql占用大约40%-70%
具体配置KS-LE E5-1650v2/32G/2x4TB
mysql 5.6.5

linux的mysql配置文件内容

  1. [client]
  2. #password        = your_password
  3. port                = 3306
  4. socket                = /tmp/mysql.sock
  6. [mysqld]
  7. binlog_cache_size = 2560K
  8. thread_stack = 5120K
  9. join_buffer_size = 8192K
  10. query_cache_type = 1
  11. max_heap_table_size = 1024M
  12. port                = 3306
  13. socket                = /tmp/mysql.sock
  14. datadir = /www/server/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 = 1024
  22. sort_buffer_size = 1024K
  23. net_buffer_length = 4K
  24. read_buffer_size = 1024K
  25. read_rnd_buffer_size = 8048K
  26. myisam_sort_buffer_size = 128M
  27. thread_cache_size = 2560
  28. query_cache_size = 1024M
  29. tmp_table_size = 1024M
  30. sql-mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
  32. explicit_defaults_for_timestamp = true
  33. #skip-name-resolve
  34. max_connections = 500
  35. max_connect_errors = 100
  36. open_files_limit = 65535
  38. log-bin=mysql-bin
  39. binlog_format=mixed
  40. server-id = 1
  41. expire_logs_days = 10
  42. slow_query_log=1
  43. slow-query-log-file=/www/server/data/mysql-slow.log
  44. long_query_time=3
  45. #log_queries_not_using_indexes=on
  48. innodb_data_home_dir = /www/server/data
  49. innodb_data_file_path = ibdata1:10M:autoextend
  50. innodb_log_group_home_dir = /www/server/data
  51. innodb_buffer_pool_size = 1024M
  52. innodb_log_file_size = 1024M
  53. innodb_log_buffer_size = 1024M
  54. innodb_flush_log_at_trx_commit = 1
  55. innodb_lock_wait_timeout = 50
  56. innodb_max_dirty_pages_pct = 90
  57. innodb_read_io_threads = 8
  58. innodb_write_io_threads = 8
  60. [mysqldump]
  61. quick
  62. max_allowed_packet = 500M
  64. [mysql]
  65. no-auto-rehash
  67. [myisamchk]
  68. key_buffer_size = 512M
  69. sort_buffer_size = 8M
  70. read_buffer = 2M
  71. write_buffer = 2M
  73. [mysqlhotcopy]
  74. interactive-timeout

复制代码

WIN的mysql配置文件

  2. [client]
  3. default-character-set=utf8
  5. [mysqld]
  6. character_set_server=utf8
  7. port=3306
  8. basedir  ="C:websoftmysql-5.6.15"
  9. datadir  ="C:websoftmysql-5.6.15data"
  10. tmpdir   ="C:websoftmysql-5.6.15data"
  11. socket   ="C:websoftmysql-5.6.15datamysql.sock"
  12. log-error="C:websoftmysql-5.6.15datamysql_error.log"
  13. log-bin=mysql-bin
  14. binlog_format=mixed
  15. server_id = 1
  16. slow_query_log = ON
  17. slow-query-log-file = "C:websoftmysql-5.6.15datamysql-slow.log"
  18. long_query_time = 3
  20. #skip-locking
  21. max_connections = 5000
  22. table_open_cache = 1024
  23. query_cache_size = 1024M
  24. tmp_table_size = 1024M
  25. thread_cache_size = 2560
  26. binlog_cache_size = 2560K
  27. thread_stack = 5120K
  28. read_buffer_size = 1024K
  29. query_cache_type = 1
  30. max_heap_table_size = 1024M
  31. key_buffer_size = 1024M
  32. expire_logs_days = 10
  34. innodb_data_home_dir="C:websoftmysql-5.6.15data"
  35. innodb_flush_log_at_trx_commit =1
  36. innodb_log_buffer_size = 1024M
  37. innodb_buffer_pool_size = 1024M
  38. innodb_log_file_size=1024M
  39. innodb_thread_concurrency=16
  40. innodb-autoextend-increment=1000
  41. join_buffer_size = 8192K
  42. sort_buffer_size = 1024K
  43. read_rnd_buffer_size = 8048K
  44. max_allowed_packet = 320M
  45. explicit_defaults_for_timestamp=true
  46. sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  48. #sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

复制代码
标签：