0 Members and 1 Guest are viewing this topic.
A. Kloxo-MR: 7.0.0.b-2015053102 - Web: hiawatha-9.13.0-f.6.mr.el6.x86_64 - PHP: php54s-5.4.41-1.ius.el6 (fpm mode)B. Plateform: - OS: CentOS release 6.6 (Final) x86_64 - Hostname: bns.bachngocsach.netC. Services: 1. MySQL: MariaDB-server-10.0.19-1.el6.x86_64 2. PHP: - Branch: php53u-5.3.29-1.ius.el6.x86_64 3. Httpd: httpd-2.2.29-2.mr.el6.x86_64 - PHP Type: php-fpm_event 4. Lighttpd: --uninstalled-- 5. Hiawatha: --unused-- 6. Nginx: --uninstalled-- 7. Cache: varnish-3.0.7-1.el6.x86_64 8. Dns: bind-9.9.5-1.el6.x86_64 9. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.x86_64 - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.x86_64
Add 'max-connections=100' under '[mysqld]' in /etc/my.cnf.d/server.cnf
[mysqld]max_connections = 400max_user_connections=200performance_schema=ondefault-storage-engine=myisamskip-innodb#OpenVZ AIO bug fix..................................
In most situation, 100 is enough.
[root@bns ~]# service mysql restart ERROR! MySQL server PID file could not be found!Starting MySQL SUCCESS!
Don't panic. Try 'pkill -9 mysql; sh /script/restart-mysql -y'.
[root@bns ~]# pkill -9 mysql; sh /script/restart-mysql -y ERROR! MySQL server PID file could not be found!Starting MySQL. SUCCESS!-------------------------------------------------------------------- For help, type '/script/restart-mysql [--help|-h]'
Page created in 0.044 seconds with 18 queries.