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...
Hello. Where can I find mysql log?ufkabakan wrote:http://sibsoft.net/forum/mysql-error-t5056.html
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