How many MySQL connections can server handle?
 

How many MySQL connections can server handle before gettting fucked?

Avg server 2 ghz , 1 gig of ram running Freebsd

7

hmm dont you set that up?

yeah but I was curious as to whether there is a threshold

Ask your tech support. They'll increase the amount of connections that they know will be ok.

:winkwink:

nope.... But it could start to slow the sytem down and If your ram is full, data will start going in and out of your swap. (Thats bad)

found this

From the manual - "If you need more connections than the default (100), then you
should restart mysqld with a bigger value for the max_connections variable."

"The maximum number of connects MySQL is depending on how good the thread library is
on a given platform. Linux or Solaris should be able to support 500-1000 simultaneous
connections, depending on how much RAM you have and what your clients are doing."

You should be able to easily do 500-600 on that setup.

Hard Question.

MySQL sucks up RAM like a baby on a mothers tit.

Agreed, the number would be somewhere around there.

MySQL is one of our lowest running processes, you need to optimize :)

there usually is a threshold set by the admin and when that threshold is met you won't be able to create any more connections to your DB. :Graucho

ALOT. But there shouldn't be that many unless you are using persistent connections, which are gay.

43590485739357 connections

depends on what you gonna do in the mysql.
the 100 means 100 users at the same time.

Like everyone else says, depends what you're doing, and how intensive the queries are.

MySQL is going to be happier with more ram, so that's the main consideration in building a DB server. The disk setup will also make a big difference in performance (you didn't mention how that was setup).

Optimize & cache.

I've tested mine with over 2 million in one day. I have a dual xeon processed server (4ghz total), 1GB ram, red hat, all the works.

MySQL comes with benchmark scripts that should tell you exactly that. As someone mentioned, counting connections, unless they are persistent, makes little sense. A real benchmark is how many queries in can do per second.

i think you should be able to set it at 1024 without any problems.