How many MySQL connections can server handle before gettting fucked?
Avg server 2 ghz , 1 gig of ram running Freebsd
Avg server 2 ghz , 1 gig of ram running Freebsd
-
-
7
Amen -
hmm dont you set that up?
Comment
-
yeah but I was curious as to whether there is a thresholdOriginally posted by hyper
hmm dont you set that up?Comment
-
Ask your tech support. They'll increase the amount of connections that they know will be ok.
Comment
-
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)Originally posted by juicylinks
yeah but I was curious as to whether there is a threshold
AmenComment
-
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."Comment
-
You should be able to easily do 500-600 on that setup.Comment
-
Hard Question.
MySQL sucks up RAM like a baby on a mothers tit.Comment
-
Agreed, the number would be somewhere around there.Originally posted by fletcher
You should be able to easily do 500-600 on that setup.Comment
-
MySQL is one of our lowest running processes, you need to optimizeOriginally posted by fsfaz
Hard Question.
MySQL sucks up RAM like a baby on a mothers tit.
Comment
-
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.Originally posted by juicylinks
yeah but I was curious as to whether there is a threshold
ICQ: 282814268Comment
-
ALOT. But there shouldn't be that many unless you are using persistent connections, which are gay.I'm waiting for the Mr Fushion Fleshlight so I can wank my way back to the future!Comment
-
43590485739357 connectionsNeed WebHosting ? Email me for some great deals [email protected]Comment
-
depends on what you gonna do in the mysql.
the 100 means 100 users at the same time.Don't let greediness blur your vision | You gotta let some shit slide
icq - 441-456-888Comment
-
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).Comment
-
Optimize & cache.Comment
-
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.Comment
-
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 couldn't possibly know what I'm talking about, I'm completely, absolutely and definitively out of my fucking mind.Comment
-
i think you should be able to set it at 1024 without any problems.Tanguy 0x7a69 inc. Programmer/President/CEO
http://www.0x7a69.com
A Leader in Programming since 1996
PHP, Ruby on Rails, MySQL, PCI DSS, and any Technical ConsultingComment
Comment