How many MySQL connections can server handle? - GoFuckYourself.com

Juicy D. Links · 12-15-2003, 07:30 PM

How many MySQL connections can server handle before gettting fucked?

Avg server 2 ghz , 1 gig of ram running Freebsd

- Jesus Christ - · 12-15-2003, 07:31 PM

hyper · 12-15-2003, 07:31 PM

hmm dont you set that up?

Juicy D. Links · 12-15-2003, 07:32 PM

Quote:

Originally posted by hyper
hmm dont you set that up?

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

Turboface · 12-15-2003, 07:33 PM

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

- Jesus Christ - · 12-15-2003, 07:35 PM

Quote:

Originally posted by juicylinks

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

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)

hyper · 12-15-2003, 07:41 PM

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."

fletcher · 12-15-2003, 07:43 PM

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

fsfaz · 12-15-2003, 07:45 PM

Hard Question.

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

nathan_f · 12-15-2003, 07:51 PM

Quote:

Originally posted by fletcher
You should be able to easily do 500-600 on that setup.

Agreed, the number would be somewhere around there.

JSA Matt · 12-15-2003, 07:57 PM

Quote:

Originally posted by fsfaz
Hard Question.

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

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

sweet7 · 12-15-2003, 08:15 PM

Quote:

Originally posted by juicylinks

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

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.

Eve · 12-15-2003, 08:15 PM

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

sandman! · 12-15-2003, 08:17 PM

43590485739357 connections

grumpy · 12-15-2003, 08:18 PM

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

fuzebox · 12-15-2003, 09:59 PM

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).

Mr.Fiction · 12-15-2003, 10:01 PM

Optimize & cache.

arial · 12-15-2003, 10:02 PM

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.

dnsmonster · 12-15-2003, 10:11 PM

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.

myneid · 12-15-2003, 11:54 PM

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

12-15-2003, 07:30 PM	#1
Juicy D. Links So Fucking Banned Industry Role: Join Date: Apr 2001 Location: N.Y. -Long Island -- Posts: 122,992	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

12-15-2003, 07:31 PM	#2
- Jesus Christ - Confirmed User Industry Role: Join Date: Mar 2003 Location: ::::::::::::: :::::::::::\|\|::::::::::: :::::::::::\|\|::::::::::: :::::::::::\|\|::::::::::: :::::::::::\|\|::::::::::: :::::::::::\|\|::::::::::: ::::::\|\|\|\|\|\|\|\|\|\|\|\|:::::: :::::::::::\|\|::::::::::: :::::::::::\|\|::::::::::: :::::::::::::::::::::::: Posts: 7,197	7 __________________ Amen

12-15-2003, 07:31 PM	#3
hyper Confirmed User Join Date: Mar 2002 Location: Mass Ass Posts: 5,294	hmm dont you set that up? __________________

12-15-2003, 07:33 PM	#5
Turboface Back in Black Industry Role: Join Date: Mar 2002 Posts: 9,976	Ask your tech support. They'll increase the amount of connections that they know will be ok. __________________ Search Engine Optimization Services for Adult Sites

12-15-2003, 07:41 PM	#7
hyper Confirmed User Join Date: Mar 2002 Location: Mass Ass Posts: 5,294	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." __________________

12-15-2003, 07:43 PM	#8
fletcher Confirmed User Join Date: Jan 2003 Location: Austin, TX Posts: 698	You should be able to easily do 500-600 on that setup. __________________   [email protected] ICQ: 6411138

12-15-2003, 07:45 PM	#9
fsfaz Confirmed User Join Date: Apr 2003 Location: Hollyweird, CA Posts: 747	Hard Question. MySQL sucks up RAM like a baby on a mothers tit.

12-15-2003, 08:15 PM	#13
Eve Confirmed User Industry Role: Join Date: Dec 2002 Location: Phoenix, Arizona Posts: 805	ALOT. But there shouldn't be that many unless you are using persistent connections, which are gay.

12-15-2003, 08:17 PM	#14
sandman! Icq: 14420613 Industry Role: Join Date: Mar 2001 Location: chicago Posts: 15,432	43590485739357 connections __________________ Need WebHosting ? Email me for some great deals [email protected]

12-15-2003, 08:18 PM	#15
grumpy Too lazy to set a custom title Join Date: Jan 2002 Location: Holland Posts: 9,870	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-888

12-15-2003, 09:59 PM	#16
fuzebox making it rain Industry Role: Join Date: Oct 2003 Location: seattle Posts: 22,114	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).

12-15-2003, 10:01 PM	#17
Mr.Fiction Confirmed User Join Date: Feb 2002 Location: Free Speech Land Posts: 9,484	Optimize & cache.

12-15-2003, 10:02 PM	#18
arial Confirmed User Join Date: Jul 2002 Location: Bay Area Posts: 4,012	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.

12-15-2003, 10:11 PM	#19
dnsmonster Confirmed User Join Date: Jul 2002 Location: A warm place. Posts: 634	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.

12-15-2003, 11:54 PM	#20
myneid Confirmed User Industry Role: Join Date: Jan 2003 Location: Los Angeles Posts: 736	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 Consulting