If you are concerned by performance degradation caused by Spectre and Meltdown patches it might be a good idea to do a few checks that will boost back your MySQL performance:
- Check if your instance’s CPU are running with full power:
if the output is
You may benefit from setting CPU speed to performance mode
for i in /sys/devices/system/cpu/cpu*/cpufreq/scaling_governor ; do echo performance
Please refer to https://wiki.debian.org/HowTo/CpuFrequencyScaling and https://www.kernel.org/doc/Documentation/cpu-freq/governors.txt for more details.
- Check if your MySQL instances are configured properly. Buffer pool should …[Read more]