《MYSQL教程mysql下修改engine引擎的方法》要点: 本文介绍了MYSQL教程mysql下修改engine引擎的方法,希望对您有用。如果有疑问,可以联系我们。
修改my.ini,在[mysqld]下加上
??? default-storage-engine=INNODB?MYSQL教程
其中红色字体部分是要指定的引擎名称.MYSQL教程
用sql语句修改已经建成表的引擎:MYSQL教程
alter table tableName type=InnoDB MYSQL教程
下面贴出我的my.ini文件供参考(http://www.my400800.cn):MYSQL教程
[mysqld] basedir=C:Program FilesVertrigoServMysql datadir=C:Program FilesVertrigoServMysqldata port =3306 key_buffer =64M max_allowed_packet =1M table_cache =128 sort_buffer_size =512K net_buffer_length =8K read_buffer_size =256K read_rnd_buffer_size =512K myisam_sort_buffer_size =68M default-storage-engine=INNODB
[mysqldump] quick max_allowed_packet =116M
[mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates
[isamchk] key_buffer =20M sort_buffer_size =20M read_buffer =62M write_buffer =62M
[myisamchk] key_buffer =20M sort_buffer_size =20M read_buffer =62M write_buffer =62M
[mysqlhotcopy] interactive-timeoutMYSQL教程 (编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|