FutureQuest.net Services Support Our Data Center Community About Contact
Support Center » Knowledgebase » Database is slow after making changes?
 Database is slow after making changes?
Article Question:

I did a large delete in one of my databases and now the database is slow. Did it get corrupted?

Answer:

The ANALYZE TABLE and CHECK TABLE commands are ways to check your tables for various types of corruption.

Whenever you delete a large amount of data in your database, to reclaim the space and defragment the data file, you should use the OPTIMIZE TABLE command. It is also recommended to do this as a matter of routine maintenance. Incorporating it into your backup routine is suggested.

For further information on these commands, please see the MySQL documentation at:
http://dev.mysql.com/doc/refman/5.0/en/table-maintenance-sql.html

Database management tasks such as this can also be done with applications like phpMyAdmin. For direct assistance, you can find the project page for phpMyAdmin at:
http://sourceforge.net/projects/phpmyadmin/

Assistance in this area may also be found within the FutureQuest Community Forums:
http://www.AOTA.net/Forums/

Article Details
Article ID: 555

 Back
 Log in [Lost Password] 
E-mail:
Password:
Remember Me:
 
 Search
 Article Options
 Print Article
 PDF Version
 E-mail Article
 Add to Favorites
Home | Register | Submit a Ticket | Knowledgebase | News | Downloads
Language:

Help Desk Software by Kayako eSupport v3.70.01