Re: Need help in purging MySql DataBase

[Phillip Ward]

Quote

... the problem for me is server performance. Mysql is keep taking all my server resources and making server slow

Why are you running anything on your MySQL host other than the database server?

Database servers do love to grab all the resources that they can and will make good use of them having done so.
However, anything else trying to run on that machine is going to have a hard time of it.

Consider moving your other processes to another machine; separating your web server from your database server is a Common Sense security precaution these days.

Regards, Phill W.