在Percona XtraDB集群的所有三个节点中,我都看到了大量的二进制日志文件的突然增加:
-rw-rw---- 1 mysql mysql 1,1G 19 oct. 16:11 binlog-32.000001
-rw-rw---- 1 mysql mysql 1,1G 19 oct. 16:36 binlog-32.000002
-rw-rw---- 1 mysql mysql 1,1G 19 oct. 16:48 binlog-32.000003
-rw-rw---- 1 mysql mysql 1,1G 19 oct. 16:59 binlog-32.000004
因此,当我的网站看到大量传入流量时,我经常会遇到托管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的?更重要的是:我如何
当服务器A运行连接到两个独立的mysqldb服务器B和C的node.js应用程序时,服务器A报告的错误如下:
Error: ER_CANT_CREATE_THREAD: Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
at Handshake.Sequence._packetToError (/home/abc/workspace/node_modules