How to limit connection MySQL

[hoangsang]

How to limit about 200 connection MySQL?
Thanks!

Code: [Select]

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.net
C. 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

[MRatWork]

Add 'max-connections=100' under '[mysqld]' in /etc/my.cnf.d/server.cnf

[hoangsang]

Add 'max-connections=100' under '[mysqld]' in /etc/my.cnf.d/server.cnf

I'm edited:

Code: [Select]

[mysqld]
max_connections = 400
max_user_connections=200
performance_schema=on
default-storage-engine=myisam
skip-innodb
#OpenVZ AIO bug fix
..................................
OK?

[MRatWork]

In most situation, 100 is enough.

[hoangsang]

In most situation, 100 is enough.

Thanks!
But i'm restart MySQL show error??

Code: [Select]

[root@bns ~]# service mysql restart
 ERROR! MySQL server PID file could not be found!
Starting MySQL SUCCESS!



[MRatWork]

Don't panic. Try 'pkill -9 mysql; sh /script/restart-mysql -y'.

[hoangsang]

Don't panic. Try 'pkill -9 mysql; sh /script/restart-mysql -y'.

Show mess:

Code: [Select]

[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]'



[MRatWork]

Check your mysql with 'service mysql status'. In most situation, avoid above message.