My brother and i share a dedicated linux server, with Plesk CP. On this server we have 4 MYSQL databases, plus my sound files for my music site. our ASP is hosted elsewhere. For the last few days the server has been going down, and simultaneously, none of the sites can connect to the server. Usually the error is this
Microsoft OLE DB Provider for ODBC Drivers error '80004005' [MySQL][ODBC 3.51 Driver]Lost connection to MySQL server at 'reading initial communication packet', system error: 0
but we also get this error on some occasions :-
[MySQL][ODBC 3.51 Driver]Host 'server213-171-218-93.livedns.org.uk' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
i have ran a flush-hosts and this will help for a little while, but within a few hours the sites will be down again
we have 4 sites running, and when one is down, they will all be down. I can still access the control panel, and when i look at the MYSQL engine, it is still running, and i can browse the tables etc.
i have checked the number of concurrent connections for all the databases and it is never above 10 or so.
i have not been messing with any of the scripts of the sites for a long time, so i am at a loss as what is causing it to crash. we have had this server for a few years, and it has been fine until now.
i did notice that the query stats seemed quite high, as we only get about 500 hits a day to all 4 sites combined. here is a copy and paste of the stats:-
Query statistics: Since its startup, 34,358 queries have been sent to the server. (this was in 6 hours since it was rebooted)
i thought we may have been hacked, so changed all passwords, but that didnt help
anyone have any ideas what else i should look into?