Results 1 to 7 of 7
Thread: maximum mysql connection
-
07-18-2003, 06:10 AM #1Junior Guru
- Join Date
- Jun 2003
- Posts
- 186
maximum mysql connection
hi guyz
can u people tell me how to increase maximum mysql connection on the server?
on my server right now may sites show too many mysql connections
can you tell me the command which to run in root which will increase the maximum amount of mysql connection
also tell me how to see the current amount of mysql connections so i can increase accordingly thanks
-
07-18-2003, 06:31 AM #2Web Hosting Master
- Join Date
- Nov 2001
- Posts
- 5,383
pico /etc/my.cnf
Assuming your running version 4
[mysqld]
set-variable = max_connections=1000
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
If your not
[mysqld]
set-variable = max_connections=1000Clustered Hosting With Continuous Data Protection (CDP)
http://www.solidinternet.com
8 Years of hosting excellence!
-
07-18-2003, 06:45 AM #3Junior Guru Wannabe
- Join Date
- May 2003
- Posts
- 90
What would be a good setting (ie won't cause 80% load) for my server?
I've got a
P4 2.6, 512MB DDR.
And what about for a:
Dual Xeon 2.0, 1GB DDR
Anyway for unlimited connections?
Cheers
Jack
-
07-18-2003, 06:45 AM #4Web Hosting Master
- Join Date
- Nov 2001
- Posts
- 5,383
It depends on what version your running. Goto www.vbulletin.com/forum/ for tips on mysql tweaking.
Clustered Hosting With Continuous Data Protection (CDP)
http://www.solidinternet.com
8 Years of hosting excellence!
-
07-18-2003, 06:51 AM #5Junior Guru Wannabe
- Join Date
- May 2003
- Posts
- 90
Woah, what a l337 forum!! Cheers!!
-
07-18-2003, 06:52 AM #6Junior Guru
- Join Date
- Jun 2003
- Posts
- 186
thx it worked
i have set it to 750
it was 500 before
-
07-18-2003, 06:56 AM #7Web Hosting Master
- Join Date
- Nov 2001
- Posts
- 5,383
http://www.vbulletin.com/forum/forumdisplay.php?f=14
Remember to restart mysqlClustered Hosting With Continuous Data Protection (CDP)
http://www.solidinternet.com
8 Years of hosting excellence!