大佬教程收集整理的这篇文章主要介绍了linux – MySQL在小型网站上的高CPU使用率,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
这是服务器规格
中央处理器
hw.machine: amd64 hw.model: Intel(R) Xeon(R) cpu X3330 @ 2.66GHz hw.ncpu: 4 hw.machine_arch: amd64
HHD转移信息
Seek times: Full stroke: 250 iter in 1.507837 sec = 6.031 msec Half stroke: 250 iter in 1.461401 sec = 5.846 msec Quarter stroke: 500 iter in 5.829283 sec = 11.659 msec Short forWARD: 400 iter in 2.668680 sec = 6.672 msec Short BACkWARD: 400 iter in 3.261849 sec = 8.155 msec Seq outer: 2048 iter in 0.247219 sec = 0.121 msec Seq inner: 2048 iter in 0.246036 sec = 0.120 msec Transfer rates: outside: 102400 kbytes in 1.207812 sec = 84781 kbytes/sec middle: 102400 kbytes in 1.342168 sec = 76294 kbytes/sec inside: 102400 kbytes in 1.893578 sec = 54078 kbytes/sec I/O command overhead: time to read 10MB block 0.131751 sec = 0.006 msec/sector time to read 20480 sectors 2.170542 sec = 0.106 msec/sector calculated command overhead = 0.100 msec/sector
顶部(在@L_262_18@高的时刻)
@H_137_26@mem: 1518M Active,1396M Inact,732M Wired,50M Cache,435M Buf,239M Free 4949 MysqL 27 52 0 2236M 1434M uwait 3 180:02 66.26% MysqLd @H_315_18@my.cnf中[MysqLd] sql_mode=NO_ENGINE_SUBSTITUTION skip-external-locking max_connections=5000 max_connect_errors=1500 ft_min_word_len = 2 myisam_sorT_Buffer_size = 64M # Log slow queries slow_query_log = 1 slow_query_log_file = /var/log/slow-queries.log long_query_time = 1 key_buffer = 384M max_allowed_packet = 32M thread_stack = 128K thread_cache_size = 128 thread_concurrency = 16 wait_timeout = 2000 interactive_timeout = 10000 join_buffer_size = 1M sorT_Buffer_size = 2M read_buffer_size = 1M read_rnd_buffer_size = 2M query_cache_size = 268435456 query_cache_type=1 query_cache_limit=1048576
我不知道出了什么问题.
以上是大佬教程为你收集整理的linux – MySQL在小型网站上的高CPU使用率全部内容,希望文章能够帮你解决linux – MySQL在小型网站上的高CPU使用率所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。