Answer the question
In order to leave comments, you need to log in
Why does Innodb slow down for a while after moving to a new VPS?
I transfer databases from one vps to another, use mysqldump and then upload it via mysql. Databases from 400MB to 25GB. Everything flies on old vps, but when I transfer the base to a new vps, then the brakes begin with a processor load of 100%. I have this effect for about 10 hours, then the base starts working at a normal speed and does not load more than usual.
I have an assumption that while the brakes are on, innodb is building indexes. But having searched for information on how to update the indexes in innodb, I did not find anything because it is said in innodb that they are always up to date.
What could be the problem?
Answer the question
In order to leave comments, you need to log in
For all tables, you need to execute and the brakes will disappear.
ANALYZE TABLE table_name;
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question