Celestial
07-04-2011, 09:28 PM
My MySQL server is currently set to all default settings:
Key buffer size: Default
Maximum packet size: Default
Sort buffer size: Default
Network buffer size: Default
MyISAM sort buffer size: Default
Tables to cache: Default
Maximum number of connections: Default
The website has around 5,500 members online at once at it's daily peak, many of which using automated software for whatever reason, causing the database to give this error at random times:
"Can't connect to MySQL server on '0.0.0.0' (99)"
[Example IP]
I assume this is a problem with the handling of the cache and users so I was just wondering, based on the statistics, what the best settings for the MySQL database should be?
If it's some other problem I overlooked, then a resolution to that would be very appreciated too.
Key buffer size: Default
Maximum packet size: Default
Sort buffer size: Default
Network buffer size: Default
MyISAM sort buffer size: Default
Tables to cache: Default
Maximum number of connections: Default
The website has around 5,500 members online at once at it's daily peak, many of which using automated software for whatever reason, causing the database to give this error at random times:
"Can't connect to MySQL server on '0.0.0.0' (99)"
[Example IP]
I assume this is a problem with the handling of the cache and users so I was just wondering, based on the statistics, what the best settings for the MySQL database should be?
If it's some other problem I overlooked, then a resolution to that would be very appreciated too.