Not the answer you need?
Register and ask your own question!

Haswell optimized binary

nmmmnmmm Current User Role Novice

Soon I will have new Haswell server.

Is there a Haswell optimized binary of Percona Server 8.0 or I should compile myself?

Tagged:

Answers

  • matthewbmatthewb Senior [email protected] Percona Staff Role

    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.

  • nmmmnmmm Current User Role Novice

    Thanks.

    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.

  • matthewbmatthewb Senior [email protected] Percona Staff Role

    I think haswell specific instructions will speed up MySQL.

    Do you have any specifics here? What specific instructions?

    I will post update once we do some tests.

    Please do. MySQL 8 uses the standard glibc and some aspects of BoostLib. Any gains that MySQL might have would come from there.

  • nmmmnmmm Current User Role Novice

    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.

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.