{"id":373,"date":"2011-04-07T11:34:08","date_gmt":"2011-04-07T11:34:08","guid":{"rendered":"http:\/\/10sa.com\/sql_stories\/?p=373"},"modified":"2014-08-21T09:13:08","modified_gmt":"2014-08-21T09:13:08","slug":"mysql-source-instalation-5-5","status":"publish","type":"post","link":"http:\/\/10sa.com\/sql_stories\/?p=373","title":{"rendered":"MySQL source installation 5.5"},"content":{"rendered":"

I usually install all my database servers from source. This gives me control over server available options and allows me to disable any unwanted options. I am not dependent on OS, too.
\nTypically I used following combination:<\/p>\n

CFLAGS=\"-O3\" CXX=gcc CXXFLAGS=\"-O3 -felide-constructors \\\r\n-fno-exceptions -fno-rtti\" .\/configure \\\r\n--prefix=\/usr\/local\/services\/mysql \\\r\n--with-mysqld-ldflags=-all-static \\\r\n--enable-assembler \\\r\n--with-big-tables \\\r\n--with-tcp-port=3306 \\\r\n--with-unix-socket-path=\/tmp\/mysql.sock \\\r\n--without-debug \\\r\n--without-docs \\\r\n--without-geometry \\\r\n--without-man \\\r\n--with-charset=latin2 \\\r\n--with-extra-charsets=utf8 \\\r\n--with-collation=latin2_general_ci \\\r\n--with-plugins=partition,blackhole,innodb \\<\/pre>\n
From MySQL 5.5 configure was replaced with cmake… and installation and gains are not so obvious.
\nI use CentOS release 5.5 (Final). Before you start to compile, you have to install:<\/p>\n
CentOS release 5.5 (Final)<\/p>\n
yum install gcc-c++\r\nyum install ncurses-devel\r\nyum install bison.x86_64\r\nyum install cmake (CentOS release 6.3)\r\n# or install from source cmake.org<\/pre>\n
You have to compile cmake (cmake.org<\/a>)<\/p>\n
Debian 6.0 (Squeeze)<\/p>\n
aptitude install g++\r\naptitude install make\r\naptitude install ncurses-dev\r\naptitude install bison++\r\naptitude install cmake<\/pre>\n
There is a very helpful site on mysql: Autotools_to_CMake_Transition_Guide<\/a><\/p>\n
My new recipe is:<\/p>\n
cmake . \\\r\n-DCMAKE_C_FLAGS=\"-O3 -m64\" \\\r\n-DCMAKE_CXX_FLAGS=\"-m64 -O3 -felide-constructors -fno-exceptions -fno-rtti\" \\\r\n-DCMAKE_BUILD_TYPE=RelWithDebInfo \\\r\n-DCMAKE_INSTALL_PREFIX=\/usr\/local\/services\/mysql \\\r\n-DSYSCONFDIR=\/usr\/local\/services\/mysql \\\r\n-DWITH_INNOBASE_STORAGE_ENGINE=1 \\\r\n-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \\\r\n-DWITH_PARTITION_STORAGE_ENGINE=1 \\\r\n-DWITH_FEDERATED_STORAGE_ENGINE=1 \\\r\n-DDEFAULT_CHARSET=latin2 \\\r\n-DWITH_EXTRA_CHARSETS=utf8 \\\r\n-DDEFAULT_COLLATION=latin2_general_ci \\\r\n-DWITH_DEBUG=0 \\\r\n-DENABLE_DEBUG_SYNC=0 \\\r\n-DWITH_FAST_MUTEXES=0 \\<\/pre>\n
I did not find any replacement for the following:
\n–with-mysqld-ldflags=-all-static
\n–enable-assembler
\n–with-big-tables
\n–without-docs
\n–without-geometry
\n–without-man<\/p>\n
I was curious about option -DWITH_FAST_MUTEXES, however, I did not find any sources which would encourage me to turn it on:<\/p>\n