<强> 强>
<强> 强>
# yum install ncurses-devel libaio-devel - y
# ls -lh cmake-2.8.8.tar。广州
# cd cmake-2.8.8
#。/配置
# gmake ,,, gmake 安装
# yum install cmake - y
<强> 强>
# useradd -s /sbin/nologin -M mysql
<强> 强>
http://mirrors.sohu.com/
<强> 强> <强> 强>
# tar xf mysql-5.5.49.tar。广州
cmake 只-DCMAKE_INSTALL_PREFIX=/应用程序/mysql-5.5.49 \ -DMYSQL_DATADIR=/应用程序/mysql-5.5.49/data \ -DMYSQL_UNIX_ADDR=/应用程序/mysql-5.5.49/tmp/mysql.sock \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci \ -DEXTRA_CHARSETS=gbk, gb2312, use utf8, ascii \ -DENABLED_LOCAL_INFILE=提醒\ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_FEDERATED_STORAGE_ENGINE=1 \ -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \ -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \ -DWITHOUT_PARTITION_STORAGE_ENGINE=1 \ -DWITH_FAST_MUTEXES=1 \ -DWITH_ZLIB=bundled \ -DENABLED_LOCAL_INFILE=1 \ -DWITH_READLINE=1 \ -DWITH_EMBEDDED_SERVER=1 \ -DWITH_DEBUG=0
# make ,,, make 安装
# ln -s /应用程序/mysql-5.5.49/,/应用程序/mysql
<强>数据库配置文件强>
# mkdir -p /数据/3306/数据
# vim/数据/3306/my . cnf中所做
[客户] port ,,,,,,,,,=, 3306 socket ,,,,,,,,=,/数据/3306/mysql.sock (mysql) no-auto-rehash (mysqld) user ,,,=mysql port ,,=3306 socket =/数据/3306/mysql.sock basedir =,/应用程序/mysql datadir =/数据/3306/数据 open_files_limit ,=, 1024 back_log =600 max_connections =800 max_connect_errors =3000 table_cache =614 external-locking =FALSE max_allowed_packet =8米 sort_buffer_size =1米 join_buffer_size =1米 thread_cache_size =100 时间=thread_concurrency 2 query_cache_size =2 m query_cache_limit =1米 query_cache_min_res_unit =2 k # default_table_type =InnoDB thread_stack =192 k # transaction_isolation =读取提交 tmp_table_size =2 m max_heap_table_size =2 m long_query_time =1 # log_long_format # log-error =/数据/3306/error.log # log-slow-queries =/数据/3306/slow.log pid-file =/数据/3306/mysql.pid log-bin =/数据/3306/mysql-bin relay-log =/数据/3306/relay-bin relay-log-info-file =/数据/3306/relay-log.info binlog_cache_size =1米 max_binlog_cache_size =1米 max_binlog_size =2 m expire_logs_days =7 key_buffer_size =16米 read_buffer_size =1米 read_rnd_buffer_size =1米 bulk_insert_buffer_size =1米 # myisam_sort_buffer_size =1米 # myisam_max_sort_file_size =10 g # myisam_max_extra_sort_file_size =10 g # myisam_repair_threads =1 # myisam_recover lower_case_table_names =1 skip-name-resolve slave-skip-errors =1032、1062 replicate-ignore-db=mysql server-id =1 innodb_additional_mem_pool_size =, 4 m innodb_buffer_pool_size =32米 时间=innodb_data_file_path ibdata1:128M: autoextend 时间=innodb_file_io_threads 4 innodb_thread_concurrency =8 时间=innodb_flush_log_at_trx_commit 2 innodb_log_buffer_size =2 m innodb_log_file_size =, 4 m 时间=innodb_log_files_in_group 3 innodb_max_dirty_pages_pct =90 innodb_lock_wait_timeout =120 innodb_file_per_table =0 (, mysqldump) 快速 max_allowed_packet =2 m (mysqld_safe) 日志错误=/数据/3306/mysql_3306.err pid文件=/数据/3306/mysqld。pidmysql编译安装及其它