CPU usage of MySQL

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
AGISB
Forum Contributor
Posts: 422
Joined: Fri Jul 09, 2004 1:23 am

CPU usage of MySQL

Post by AGISB »

I got a problem with MySQL running for a couple of days. After a while the CPU usage gets higher and higher. If I stop MySQl and restart it is back to normal for a while. Any Ideas how to avoid this?
AbyssUnderground
Forum Newbie
Posts: 3
Joined: Tue Aug 23, 2005 9:38 am

Post by AbyssUnderground »

Im no whizz at this but you could try making a .bat file (if running windows like me) and get it to run every 24 hours to close mysql and start it again.

I do the same with my webserver to rotate the logs once a week.
innosys
Forum Newbie
Posts: 7
Joined: Mon Aug 22, 2005 9:47 am

Post by innosys »

i am getting the same problem this week and i don't know what to do ?
innosys
Forum Newbie
Posts: 7
Joined: Mon Aug 22, 2005 9:47 am

Post by innosys »

could it be a virus effect Mysql
AGISB
Forum Contributor
Posts: 422
Joined: Fri Jul 09, 2004 1:23 am

Post by AGISB »

I am running on FreeBSD and MySQL is only on localhost. Virus should not be a problem.

Sure I will restart MySQL for now but that does not fix the problem.
User avatar
AnarKy
Forum Contributor
Posts: 119
Joined: Tue Nov 02, 2004 1:49 am
Location: South Africa

logs/cache

Post by AnarKy »

Perhaps it's a cache that is becoming too full or
system logs that are growing too large?

Perhaps clearing them periodically might make a huge difference??
Post Reply