MySQL database cleanup
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
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
Last Comment
Gopinathan c
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
ASKER
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.
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.
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.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
.
Visual Basic Classic
Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.
165K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
