PROSAGA码农传奇-场景模型-MySQL进程占用150-400％的CPU

<div class =“post-text”itemprop =“text”>
  
    每秒速率= RPS根据您的Linux ulimit -a报告考虑的建议。
  
   <pre>
 <code>
 ulimit -n 16384 to raise Open Files limit from 1024 to support your activities.

</code>
 </pre>
  
    为了在Linux关机/重启上持续存在，请查看此网址。
  
  
    <a href="https://glassonionblog.wordpress.com/2013/01/27/increase-ulimit-and-file-descriptors-limit/" rel="nofollow noreferrer">
      https://glassonionblog.wordpress.com/2013/01/27/increase-ulimit-and-file-descriptors-limit/
    </A>
  
  
    由于Linux的版本，您的具体细节可能略有不同。
  
  
    建议您考虑my.cnf [mysqld]部分
  
   <pre>
 <code>
 innodb_lru_scan_depth=100 # from 1024 to reduce CPU busy every second. 93% savings for this one function.
thread_cache_size=32 # from 9 for thread breathing room and growth.
innodb_io_capacity=1800 # from 200 to take advantage of your HDD IOPS capacity
key_cache_age_threshold=7200 # from 300 seconds to reduce key_reads RPS of 16 
query_cache_size=0 # from 1M to conserve RAM - QC is OFF and not used
query_cache_limit=0 # from 1M to conserve RAM - QC is OFF and not used
key_buffer_size=128M # from 8M which had NO free space at the end of your work day

</code>
 </pre>
  
    有关其他建议，请参阅我的个人资料，网络资料以获取联系信息
  
</DIV>