Home / server / Questions / 60454
In Process
Omry
Asked: 2009-08-30 23:50:11 +0800 CST

MySQL : limit the number of clients served concurrently

  • 772

  1. I am experiencing a problem where the server runs out of memory in specific scenarios. one solution I am thinking about is to limit the number of clients served concurrently, but have the extra clients wait for a free slot instead of having them get a "too many connections error". is this possible?

  2. how do I calculate maximum memory usage per open mysql connection?

mysql

2 Answers

  1. take a look in my.cnf (should be somewhere in /etc or /etc/mysql, depending on your distro); there you have several options for fine tuning, like

    • max_connections
    • max_connect_errors
    • max_delayed_threads
    • max_user_connections

    and some query cache options

    • 3

  2. How much memory is the database using? How much is installed? What OS are you running MySQL on?

    • 0