Hello,
If you experience slow logins and have many slow queries which takes up to 15 seconds that looks like this:
"# User@Host: da_roundcube[da_roundcube] @ localhost []
UPDATE session SET vars = ....."
then you need to do these simple steps:
1. convert session table from InnoDB to MySIAM in da_roundcube database and enjoy speed increase by 100 times.
2. If you use cache, then you need to convert cache table to MySIAM too, but first you need to remove foreign key constraint in cache table. (this can easily be done in your phpmyadmin interface by selecting Relation view and then choosing empty field)
These simple changes wiped out slow queries from my server totally, increased speed by 100 times and decreased cpu load spiking to stable and continuous one.
If you experience slow logins and have many slow queries which takes up to 15 seconds that looks like this:
"# User@Host: da_roundcube[da_roundcube] @ localhost []
UPDATE session SET vars = ....."
then you need to do these simple steps:
1. convert session table from InnoDB to MySIAM in da_roundcube database and enjoy speed increase by 100 times.
2. If you use cache, then you need to convert cache table to MySIAM too, but first you need to remove foreign key constraint in cache table. (this can easily be done in your phpmyadmin interface by selecting Relation view and then choosing empty field)
These simple changes wiped out slow queries from my server totally, increased speed by 100 times and decreased cpu load spiking to stable and continuous one.