Soon I will have new Haswell server.
Is there a Haswell optimized binary of Percona Server 8.0 or I should compile myself?
AFAIK, Percona does not provide CPU-specific builds. We provide generic x86_64 builds that work on any x86_64 processor. If you think there is something specific to be gained with Haswell processors, you will need to compile yourself.
I think haswell specific instructions will speed up MySQL.
Because of SSE and AVX I think it would be a waste if you run generic build on haswell and up.
Question is how much, the improvement will be...
I will post update once we do some tests.
Do you have any specifics here? What specific instructions?
Please do. MySQL 8 uses the standard glibc and some aspects of BoostLib. Any gains that MySQL might have would come from there.
I don't think generic build do "vectorizations" and "stuff" like that. However if the compiler knows it can use haswell (or another architecture that supports it), it might emit necessary instructions.
Check for vmulps instructions. You do not need to be able to read assembly - I can not,
but these instructions allow several multiplications in single CPU cycle. And definitely "haswell" and "buldozer" versions will be 3-4x faster from generic one. However, this is example made to demonstrate. In real life difference will be not so big.
MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.