* Compile MySQLD into static mode to compile MYSQLD without shared libraries to improve performance. Add the following options to the following options to compile mysqld into static mode:%> ./ configure -with-mysqld-ldflags = -all-static [- Other Configuration Options] Configuration Example
The following configuration commands are often used to improve the performance of MySQL:
%> Cflags = "- O6 -MPENTIUMPRO -FOMIT-FRAME-POINTER" CXX = GCC CXXFLAGS = "- O6 -MPENTIUMPRO -FOMITORS-FNO-POINTER -FELIDE-Constructor -fno-Exceptions -fno-RTTI" ./configure - Prefix = / usr / local --enable-assembler --with-mysqld-ldflags = -ll-static --disable-shared another configuration list (actual path, modify according to your own situation) cflags = "- O3 - mpentiumpro "CXX = gcc CXXFLAGS =" - O3 -mpentiumpro -felide-constructors -fno-exceptions -fno-rtti "./configure --prefix = / usr / local / mysql --enable-assembler --with-mysqld-ldflags = -All-static --disable-shared --with-extra-charset = complex
make make install --- Install the Databasescripts / mysql_install_db-- Set the environmentchown -R root / usr / local / mysqlchown -R mysql / usr / local / mysql / varchgrp -R mysql / usr / local / mysqlcp support-files / my -Medium.cnf /etc/my.cnf - Start the server / usr / local / mysql / bin / safe_mysqld --user = mysql & - set the root passwd / usr / local / mysql / bin / mysqladmin -u root -p password 'new-password' / usr / local / mysql / bin / mysqladmin -u root -h *** -p password 'new-password' * compiles mysql to use --with - charset = GBK parameters, so MySQL will directly support Chinese findings and sort.
