Page 1 of 1
CPU usage of MySQL
Posted: Tue Aug 23, 2005 8:23 am
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?
Posted: Tue Aug 23, 2005 9:49 am
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.
Posted: Tue Aug 23, 2005 7:12 pm
by innosys
i am getting the same problem this week and i don't know what to do ?
Posted: Tue Aug 23, 2005 7:14 pm
by innosys
could it be a virus effect Mysql
Posted: Tue Aug 23, 2005 11:53 pm
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.
logs/cache
Posted: Wed Aug 24, 2005 2:31 am
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??