linux二进制文件构建mysql_linux中mysql 5.5二进制文件安装详解

vi /etc/my.cnf

[mysqladmin]

socket =/var/run/mysqld/mysqld.sock

[client]

port = 3306

socket =/var/run/mysqld/mysqld.sock

[mysqld]

port = 3306

socket = /var/run/mysqld/mysqld.sock

user = mysql

pid-file = /var/run/mysqld/mysqld.pid

basedir = /opt/mysql/product/5.5

datadir = /opt/mysql/mysqldata

skip-external-locking = 1

interactive_timeout = 1200

wait_timeout = 1200

character-set-server = utf8

back_log = 500

default_time_zone = '+08:00'

max_connections = 1000

max_connect_errors = 1000

connect_timeout = 300

table_open_cache = 100

max_allowed_packet = 16M

binlog_cache_size = 8M

max_heap_table_size = 64M

sort_buffer_size = 8M

join_buffer_size = 8M

thread_cache_size = 32

thread_concurrency = 16

query_cache_size = 0M

default-storage-engine = INNODB

thread_stack = 192K

transaction_isolation = READ-COMMITTED

tmp_table_size = 64M

log-bin =/opt/mysql/mysqllog/mysqlbin

log-error=/opt/mysql/mysqllog/mysqld.err

expire_logs_days = 7

binlog_format = ROW

max_binlog_size = 300M

slow_query_log = 1

slow_query_log_file =/opt/mysql/mysqllog/mysqld-slow

long_query_time = 10

tmpdir = /tmp

server-id = 1

key_buffer_size = 8M

read_buffer_size = 1M

read_rnd_buffer_size = 1M

bulk_insert_buffer_size = 1M

myisam_sort_buffer_size = 128K

innodb_additional_mem_pool_size = 16M

innodb_buffer_pool_size = 2G

innodb_data_file_path = ibdata1:1024M:autoextend

innodb_autoextend_increment = 64

innodb_file_per_table = 1

innodb_data_home_dir = /opt/mysql/mysqldata

innodb_file_io_threads = 4

innodb_thread_concurrency = 16

innodb_flush_log_at_trx_commit = 2

innodb_log_buffer_size = 8M

innodb_log_file_size = 512M

innodb_log_files_in_group = 3

innodb_max_dirty_pages_pct = 40

innodb_lock_wait_timeout = 120

innodb_locks_unsafe_for_binlog = 1

innodb_autoinc_lock_mode = 2

skip-name-resolve

lower_case_table_names=1

[mysqldump]

quick

max_allowed_packet = 16M

[mysql]

auto-rehash

[myisamchk]

key_buffer_size = 512M

sort_buffer_size = 512M

read_buffer = 8M

write_buffer = 8M

[mysqlhotcopy]

interactive-timeout

[mysqld_safe]

open-files-limit = 8192