Join the community today
Become a Member

MariaDB MariaDB Profile-Guided Optimization?

Discussion in 'MariaDB & General MySQL news & discussions' started by tininho, Nov 5, 2019.

  1. tininho

    tininho Premium Member Premium Member

    40
    4
    8
    May 22, 2019
    Ratings:
    +17
    Local Time:
    9:38 PM
    • Optimistic Optimistic x 1
  2. eva2000

    eva2000 Administrator Staff Member

    42,078
    9,497
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,613
    Local Time:
    5:38 AM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Yeah I have built MariaDB custom RPMs with Intel cpu optimisations via GCC compiler and not even needing Intel compiler - which can be up to 50% faster than generic MariaDB RPM builds. But haven't tried Profile Guided Optimizations with MariaDB before. I wouldn't be surprised PGO trained MariaDB MySQL would be faster just like Centmin Mod's PHP 7+ PGO trained PHP-FPM binaries. Might try it out for my own curiosity but wouldn't be something I'd add to publicly available Centmin Mod as it's something I wouldn't be willing to provide support for (for free). I only add to Centmin Mod what I am willing to support :)

    But MariaDB MySQL is about data integrity and stability so usually best to use official MariaDB RPMs for bug fixes and security.
     
    • Informative Informative x 1
  3. eva2000

    eva2000 Administrator Staff Member

    42,078
    9,497
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,613
    Local Time:
    5:38 AM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    and 40% better single-threaded performance in MariaDB