Guys I really need help with this error:
Software error:
Can't connect to Mysql server. at Modules/DataBase.pm line 28.
I have 4 Dedicated servers. 1 for Main. 3 for file servers. This is my configuration.
Fileserver 1 & 2
fileetag: None
keepalive: Off
keepalivetimeout: 5
maxclients: 1024
maxkeepaliverequests: 300
maxrequestsperchild: 2000
maxspareservers: 10
minspareservers: 5
root_options: ExecCGI, FollowSymLinks, IncludesNOEXEC, Indexes, SymLinksIfOwnerMatch
serverlimit: 1024
serversignature: Off
servertokens: ProductOnly
sslciphersuite: ALL:!ADH:+HIGH:+MEDIUM:-LOW:-SSLv2:-EXP
startservers: 45
timeout: 30
traceenable: On
ExpiresActive On
ExpiresDefault A0
Header set Cache-Control "private, no-cache, no-store, proxy-revalidate, no-transform"
Header set Pragma "no-cache"
Specs for this server:
Total processors: 10
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz
Speed
2001.000 MHz
Cache
15360 KB
32GB Ram, 2x2TB for each file server. - Hard disk is only 60% full on both.
Fileserver 3 is the same but with 8TB space and 8CPU's.
Please can you tell me how to set it up properly? I am willing to pay for assistance.
XFileSharing Pro - Need Help With Software Error.
http://sibsoft.net/forum/mysql-error-t5056.html
Look your MySQL log, incrase to max connection limit on MySQL conf, try search...
Look your MySQL log, incrase to max connection limit on MySQL conf, try search...
-
upmorefiles
- Posts: 23
- Joined: Aug 14, 2012 9:10 am
Okay let me tell you how to Increase MySQL connection limit
Os Linux
First u have to check your mysql version after it here we go:
Log-in to your ssh with root:
For MySQL 3.x:
vi /etc/my.cnf
set-variable = max_connections = 100
100 its a default connections limit
For MySQL 4.x and 5.x:
vi /etc/my.cnf
max_connections = 250
250 its a default connections limit
just change the max_connections = 500 or whatever u want to change !
Restart MySQL once you've made the changes
/etc/init.d/mysql restart
and verify with:
echo "show variables like 'max_connections';" | mysql
still u dont know how to do this let me know i will do that for you !
Os Linux
First u have to check your mysql version after it here we go:
Log-in to your ssh with root:
For MySQL 3.x:
vi /etc/my.cnf
set-variable = max_connections = 100
100 its a default connections limit
For MySQL 4.x and 5.x:
vi /etc/my.cnf
max_connections = 250
250 its a default connections limit
just change the max_connections = 500 or whatever u want to change !
Restart MySQL once you've made the changes
/etc/init.d/mysql restart
and verify with:
echo "show variables like 'max_connections';" | mysql
still u dont know how to do this let me know i will do that for you !
Facebook
Twitter