- Difficulty: Easy
- Application: MySQL
Whenever you change the structure of a MySQL database, or remove a
lot of data from it, the files can become fragmented resulting in a loss
of performance, particularly when running queries. Just remember any
time you change the database to run the optimiser:
mysqlcheck -o <databasename>
You may also find it worth your while to defragment your database
tables regularly if you are using VARCHAR fields: these variable-length
columns are particularly prone to fragmentation.
No comments:
Post a Comment