linux下安装mysql

Linux下mysql使用源码包安装配置

 

1、  创建文件夹

a)         mkdir -p /opt/modules/ /opt/modules/src

2、  添加数据库用户

a)         adduser mysql

3、  将源码包解压copy到/opt/modules/src/mysql

4、  进入文件夹

a)         cd /opt/modules/src/mysql

5、  使用优化编译

a)         export CFLAGS="-O6 -march=pentium -fomit-frame-pointer"

b)        export CXX=gcc

c)         export CXXFLAGS="-O6 -march=pentium -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti"

d)        ./configure --prefix=/opt/modules/mysql --enable-assembler  --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-debug --with-mysqld-user=mysql --with-big-tables

6、  编译和安装

a)         Make

b)        Make install

7、  拷贝配置文件

a)         cp support-files/my-huge.cnf /etc/my.cnf

8、  修改/etc/my.cnf 文件，修改或增加如下内容

a)        [mysqld]

b)        port            = 3306

c)         socket          = /tmp/mysql.sock

d)        skip-locking

e)         key_buffer = 384M

f)         max_allowed_packet = 3M

g)        read_buffer_size = 20M

h)        myisam_sort_buffer_size = 128M

i)          query_cache_size = 64M

j)         # Try number of CPU's*2 for thread_concurrency

k)        thread_concurrency = 8

l)          set-variable=back_log=1024

m)      set-variable=interactive_timeout=7200

n)        set-variable=wait_timeout=7200

o)        set-variable=key_buffer_size=16773120

p)        set-variable=max_connections=2048

q)        set-variable=record_buffer=16773120

r)         set-variable=sort_buffer=16773120

s)         set-variable=table_cache=512

t)         set-variable=thread_cache_size=80

u)        set-variable=max_connect_errors=2048

v)        set-variable=log_slow_queries=ON

w)       set-variable=delay_key_write=ON

x)        set-variable=join_buffer_size=16773120

y)        log=/var/log/mysqld.log

9、  增加默认编码集

a)         default-character-set=utf8

10、              安装初始化数据库

a)         cd /opt/modules/mysql/

b)        ./bin/mysql_install_db --user=mysql

11、              设置属性

a)         chgrp -R mysql var

12、              拷贝启动脚本到/opt/sbin

a)         cp /opt/modules/mysql/share/mysql/mysql.server /opt/sbin/mysql.server

13、              创建mysql日志，并且修改文件属性

a)         touch /var/log/mysqld.log

b)        chown mysql:mysql /var/log/mysqld.log

14、              启动服务器

a)         /opt/sbin/mysql.server start|restart|stop