On Mon, 11 Jun 2007, Dave Shariff Yadallee - System Administrator a.k.a. The
Root of the Problem wrote:
REcently my mysql server has been overload with a lot
of connections; in fact losing the mysql.user table and
one whole database.
Define losing. You lost access, or the tables got corrupted?
How can this be prevented?
If your load is so high that the whole system is grinding to a halt, that
indicates one or more of the following:
1) Your database isn't configured properly.
1.1) This may mean you have to allocate more memory to it in my.conf, but
more likely,
1.2) you either have a poorly designed query somewhere in the calling
code, or most likely
1.3) a missing index on a frequently used table
2) Your server isn't up to the job
Have you enabled logging of slow queries in my.conf to see what queries
are taking a lot of time to execute?
What table type are you using? Is your data access mainly reads, mainly
writes, or a combination of both? If it's both, you may benefit from using
InnoDB tables instead of MyISAM, assuming this isn't what you are doing
already.
The first thing to find is what queries are taking up a lot of resources
and making sure they are running fully indexed, and/or possibly changing
the data structure to better suit the query requirements.
Gordan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]