mysql 一个表修改了引擎的操作

gir

遇到的问题：
mysql消耗完内存。
show full process list;mysql进程locked了.

修改步骤：
1. 改配置　
2. 导出sql
3. 重启数据库
4. 导入sql

将表修改成innodb：
my.cnf 添加：
innodb_file_per_table
innodb_log_group_home_dir = /usr/local/mysql/data
innodb_log_arch_dir = /usr/local/mysql/data
innodb_buffer_pool_size = 2G
innodb_additional_mem_pool_size = 32M
innodb_log_file_size = 128M
innodb_log_buffer_size = 12M
innodb_flush_log_at_trx_commit = 0
innodb_lock_wait_timeout = 240
innodb_thread_concurrency=8

数据库起不来：


先删除：


[iyunv@twin0134 mysql]# rm ib_logfile[01] -fv
removed `ib_logfile0'
removed `ib_logfile1'
/usr/local/mysql/bin/mysqld_safe --user=mysql &
ok


130925 07:10:31  mysqld started
130925  7:10:31 [Warning] Asked for 196608 thread stack, but got 126976
130925  7:10:31  InnoDB: Log file /usr/local/mysql/data/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /usr/local/mysql/data/ib_logfile0 size to 128 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100
130925  7:10:37  InnoDB: Log file /usr/local/mysql/data/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /usr/local/mysql/data/ib_logfile1 size to 128 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100
130925  7:10:40  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
130925  7:10:40  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 8 3558903820.
InnoDB: Doing recovery: scanned up to log sequence number 8 3558903820
130925  7:10:40  InnoDB: Flushing modified pages from the buffer pool...
130925  7:10:41  InnoDB: Started; log sequence number 8 3558903820
/usr/local/mysql/bin/mysqld: ready for connections.
Version: '4.1.7-standard-log'  socket: '/tmp/mysql.sock'  port: 3306  Official MySQL-standard binary

plantegg

V　幸福已经离我远去了.在你走的同时也把我的幸福全部带走了　〃

xiaoxue85

他连他的父母都那样对待，你还指望他怎样对你