mysql 安装

[root@suibian mysql]# yum -y install ncurses-devel
[root@suibian mysql]# useradd mysql
[root@suibian mysql]# tar xvf mysql-5.1.58.tar.gz

[root@suibian mysql]# cd mysql-5.1.58

[root@suibian mysql-5.1.58]#

./configure --prefix=/usr/local/mysql --localstatedir=/data/mysqldata --with-extra-charsets=complex --with-big-tables --with-mysqld-
ldflags=-all-static --with-client-ldflags=-all-static --without-debug --with-plugins=all --with-readline --with-ssl --with-embedded-
server --enable-local-infile

[root@suibian mysql-5.1.58]# make && make install

[root@suibian mysql-5.1.58]# cp my.cnf /etc/

[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
open_files_limit = 10240
back_log = 600
max_connections = 5000
max_connect_errors = 6000
table_cache = 614
external-locking = FALSE
max_allowed_packet = 32M
sort_buffer_size = 1M
join_buffer_size = 1M
thread_cache_size = 300
query_cache_size = 512M
query_cache_limit = 2M
query_cache_min_res_unit = 2k
thread_stack = 192K
tmp_table_size = 246M
max_heap_table_size = 246M
long_query_time = 3
binlog_cache_size = 4M
max_binlog_cache_size = 8M
max_binlog_size = 1G
expire_logs_days = 30
key_buffer_size = 256M
read_buffer_size = 1M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1
myisam_recover
interactive_timeout = 120
wait_timeout = 86400
skip-name-resolve
loose_handlersocket_port = 9998
loose_handlersocket_port_wr = 9999
loose_handlersocket_threads = 16
loose_handlersocket_threads_wr = 1
open_files_limit = 65535
lower_case_table_names=1
log-bin=mysql-bin
binlog_format=mixed
server-id = 1
innodb_data_home_dir = /usr/local/mysql/var
innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 512M
innodb_data_file_path = ibdata1:256M:autoextend
innodb_file_io_threads = 4
innodb_thread_concurrency = 8
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 16M
innodb_log_file_size = 128M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120
innodb_file_per_table = 0
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash

[root@suibian mysql-5.1.58]# cd /usr/local/mysql

[root@suibian mysql]# chown -R mysql .
[root@suibian mysql]# chgrp -R mysql .

[root@suibian mysql]# /usr/local/mysql/bin/mysql_install_db --user=mysql

[root@suibian mysql]# chown -R root .

[root@suibian mysql]# chown -R mysql var/

[root@suibian mysql]# cp /root/mysql-5.1.58/support-files/mysql.server /etc/init.d/mysqld

[root@suibian mysql]# chmod 755 /etc/init.d/mysqld
[root@suibian mysql]# service mysqld restart
[root@suibian mysql]# chkconfig --level 345 mysqld on
[root@suibian mysql]# echo "PATH=/usr/local/mysql/bin:$PATH" >> /etc/profile
[root@suibian mysql]# echo "export PATH" >> /etc/profile
[root@suibian mysql]# source /etc/profile