MySQL Problems

How to Optimize a Database in Mysql

In case you remove a lot of data from the tables OR change the database structure, a de-fragmentation/optimizing of the database is necessary to avoid performance loss, especially while running queries. To avoid performance loss, optimize the database.

Virtualese offers Netherlands VPS with  high performance MySQL servers.

SSH to your server and execute:

mysqlcheck -o <databasename>

Where, -o stands for optimize which is similar to defragmentation. You should look to defragment the tables regularly when using VARCHAR fields since these columns get fragmented too often.