innodb_open_files=200
innodb_print_all_deadlocks=1
innodb_purge_threads=4
innodb_read_ahead_threshold=0
innodb_read_io_threads=8
innodb_rollback_on_timeout=0
innodb_sort_buffer_size=2M
innodb_spin_wait_delay=6
innodb_stats_on_metadata=0
innodb_strict_mode=1
innodb_sync_array_size=256
innodb_sync_spin_loops=30
innodb_thread_concurrency=64
innodb_use_native_aio=0
innodb_write_io_threads=8
innodb_support_xa=1
[mysqld_safe]
datadir=/u01/my3306/data/
八、执行MySQL安装脚本
./scripts/mysql_install_db? --defaults-file=/u01/my3306/my.cnf? --user=mysql --datadir=/u01/my3306/data
? ?
说明:defaults-file表示指定默认的配置文件,如果不指定,系统默认的优先级是先使用/etc/my.cnf作为mysql的配置文件,那之前make的那些参数就白设置了.
九、启动mysql
mysqld_safe --defaults-file=/u01/app/mysql/data/mysql3306/my.cnf --user=mysql &
十、登录MySQL
mysql -h127.0.0.1 -uroot -P3306
--------------------------------------分割线 --------------------------------------
--------------------------------------分割线 --------------------------------------