mysql编译安装提高性能_Mysql编译安装参数优化

最新推荐文章于 2024-07-22 19:34:47 发布

weixin_39986896

最新推荐文章于 2024-07-22 19:34:47 发布

阅读量105

点赞数

文章标签： mysql编译安装提高性能

本文链接：https://blog.csdn.net/weixin_39986896/article/details/113415239

版权

CFLAGS="-O6" CXX=pgcc CXXFLAGS="-O6 -felide-constructors-fno-exceptions -fno-rtti"

64bits:

CFLAGS="-O6 -funroll-loops -Wall -W -mtune=nocona -mcpu=nocona -march=nocona -mfpmath=sse -pipe -fomit-frame-pointer -msse2 -mmmx -m64 -march=x86-64" CXXFLAGS="-O6 -funroll-loops -Wall -W -mtune=nocona -mcpu=nocona -march=nocona -mfpmath=sse -pipe -fomit-frame-pointer -msse2 -mmmx -m64 -march=x86-64" CXX=pgcc CFLAGS="-DDBUG_OFF -O6 -funroll-loops -Wall -W -mtune=nocona -mcpu=nocona -march=nocona -mfpmath=sse -pipe -fomit-frame-pointer -msse2 -mmmx -m64 -march=x86-64" CXXFLAGS="-DDBUG_OFF -O6 -funroll-loops -Wall -W -mtune=nocona -mcpu=nocona -march=nocona -mfpmath=sse -pipe -fomit-frame-pointer -msse2 -mmmx -m64 -march=x86-64 -fno-implicit-templates -fno-exceptions -fno-rtti"

5.0编译参数：

./configure '--prefix=/opt/mysql' '--with-unix-socket-path=/tmp/mysql.sock' '--localstatedir=/opt/mysql/data' '--with-mysqld-user=mysql' '--without-isam' '--without-innodb' '--with-big-tables' '--with-charset=utf8' '--with-extra-charsets=all' '--with-pthread' '--enable-thread-safe-client' '--enable-assembler' '--with-archive-storage-engine' '--with-client-ldflags=-all-static' '--with-readline' '--enable-local-infile'

5.1编译参数：

./configure '--prefix=/opt/mysql' '--with-unix-socket-path=/tmp/mysql.sock' '--localstatedir=/opt/mysql/data' '--with-mysqld-user=mysql' '--without-ndb-debug' '--with-big-tables' '--with-charset=utf8' '--with-extra-charsets=all' '--with-pthread' '--enable-thread-safe-client' '--enable-assembler' '--with-archive-storage-engine' '--with-client-ldflags=-all-static' '--with-readline' '--enable-local-infile'

注意：

在Linux-x86上使用gcc编译而不用帧指针(-fomit-frame-pointeror-fomit-frame-pointer -ffixed-ebp)，可以使mysqld快1-4%。