因此,当我的网站看到大量传入流量时,我经常会遇到托管MySQL数据库的服务器的性能问题。
我刚刚在mysqltuner结果中看到了这一点:
Total buffers: 4.1G global + 1.0G per thread (500 max threads)
[!!] Maximum reached memory usage: 188.4G (299.43% of installed RAM)
[!!] Maximum possible memory usage: 2002.3G (3182.59% of installed RAM)
我是如何设法为每个线程预留1G的?更重要的是:我如何