MySQL database cleanup

knopr
knopr used Ask the Experts™
on
Hi, I got a question to solve a php website / database issue. Having no knowlegde of MySQL databases, I have to cleanup a database because it has become too large. This website uses a forum, phpBB software.

The problem is probably simple, the database has had no maintenance,but I need to knw which action to take (without knowlegde of MySQL) to clean the database up without causing problems or losiing information.

In the web admin folder I see an overview of tables and in particular 3 tables take a lot of space:

phpbb_posts
phpbb_wordmatch
phpbb_wordlist

See attached screenshot. What action can I take best?

Thanks,

Richard Screenshot MySQL Admin
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Gopinathan cSenior php developer

Commented:
you can delete the older post in phbb admin area not in database. i fyou delete older datas in phbb admin automatically you wll get the database reduced space

Author

Commented:
The prblem is that I cannot tell what 's old or what can bve deleten, nor can my contact person. So we look for some possibility that doesn't lose content, like rebuilding an index, getting rid of log files or something. You comment suggest to delete old files, but that could concern info that maybe should not be deleted.

Commented:
I understood that from your question;
you web site is slow and you want to do something on your database to fix the problem right?
if it is so, firstly you must review your queries which pulls data from database, you must make your queries simpler and not working hadrly on the database.
After that query review, if you can't take enough performance, I offer you to search about "sql index" by indexinq some of table you may have faster performance on your db.
Commented:
The problem was disk space as a result of a lot of spam, but I solved it already. Thanks anyway.

Author

Commented:
.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial