linux mysql 安装innodb_linux 下mysql 重新配置innodb过程

1)停止mysql服务

[root@mysql ~]# service mysqld stop

2)修改mysql的配置文件

[root@mysql ~]# vi

/etc/my.cnf

3)删除datedir文件夹下的包含ib_logfile1和ibdata的文件

4)在根目录下建立mysqldata文件夹

5)启动使设置生效

my.cnf修改内容如下

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

user=mysql

# Default to using old password format for compatibility with mysql

3.x

# clients (those using the mysqlclient10 compatibility

package).

old_passwords=1

# Disabling symbolic-links is recommended to prevent assorted

security risks;

# to do so, uncomment this line:

# symbolic-links=0

default-storage-engine=InnoDB

set-variable= transaction-isolation=READ-COMMITTED

innodb_data_home_dir =

innodb_data_file_path

=/mysqldata/ibdata1:2000M;/mysqldata/ibdata2:2000M:autoextend

innodb_buffer_pool_size=1G

innodb_additional_mem_pool_size=20M

innodb_log_file_size=256M

innodb_log_buffer_size=8M

innodb_flush_log_at_trx_commit=1

innodb_lock_wait_timeout=50

innodb_thread_concurrency=5

[mysqld_safe]

log-error=/var/log/mysqld.log

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