|
MySQL takes a lots of load
I have mysqld running on a small server. Sometimes it happens to take a lots of load (about 90% and up, I saw that in `top`). I have some perl scripts that use databases, but nothing more than simple SELECT and INSERT statements at rate of 5-10 statements per second for all scripts total. If I restart mysqld the load drops down to normal. One of my databases is about 15MB big, could that be a problem? Right at the moment it starts using the db, load increases.
Maybe it takes a lot of time for SELECT statements to search through the whole DB? Or the large file troubles the system memory?
I need that db and it can't be smaller.
My MySQL config is the default one (huh, which one of the my-*.cnf files is it?)
Does anyone has an idea of whats going on?
|
