到底懂不懂系统

mysql_install_db --defaults-file=/etc/my.cnf --user=mysql

使用该命令初始化必须保证my.cnf中的目录创建

还要配置属主
chown -R mysql.mysql /data/mysql

chown -R mysql.mysql /data/mysql_backup

# The following options will be passed to all MySQL clients
[client]
#password       = your_password
port            = 3306
socket          = /data/mysql/database/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port            = 3306
socket          = /data/mysql/database/mysql.sock
datadir         = /data/mysql/database/
pid-file        = /data/mysql/database/mysql.pid

skip-locking
key_buffer_size = 2048M
max_allowed_packet = 2M
table_open_cache = 512
sort_buffer_size = 8M
read_rnd_buffer_size = 4M

query_cache_size = 1M
query_cache_type = 1

# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 16
thread_cache_size = 8
innodb_file_per_table

read_buffer_size = 4M
myisam_sort_buffer_size = 4M
myisam_recover
myisam_repair_threads=4

server-id = 1
log-bin=/data/mysql_backup/binlogs/database
max_binlog_size = 512M
expire_logs_days = 3
long_query_time = 2 
log-slow-queries = slow.log 
log-queries-not-using-indexes
event_scheduler=1
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /data/mysql/database/
innodb_data_file_path = ibdata1:20M;ibdata2:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 10000M
innodb_additional_mem_pool_size = 4M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 8M
innodb_log_buffer_size = 4M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

##
#interactive_timeout=6048000

wait_timeout=315360000
interactive_timeout=31536000
connect_timeout=60
max_connect_errors=100000000
max_connections=50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer_size = 128M
write_buffer_size = 128M

[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer_size = 128M
write_buffer_size = 128M

[mysqlhotcopy]
interactive-timeout

初始化好， mysql -uroot -p   应该无需密码

然后看>show engines

mysql> show engines;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine     | Support | Comment                                                        | Transactions | XA   | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |
| MRG_MYISAM | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
| BLACKHOLE  | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
| CSV        | YES     | CSV storage engine                                             | NO           | NO   | NO         |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
| FEDERATED  | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |
| ARCHIVE    | YES     | Archive storage engine                                         | NO           | NO   | NO         |
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance         | NO           | NO   | NO         |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
8 rows in set (0.00 sec)