mysql下修改engine引擎的方法
- WBOYOriginal
- 2016-06-07 18:05:24885browse
修改mysql的引擎为INNODB，可以使用外键，事务等功能，性能高。
修改my.ini，在[mysqld]下加上
其中红色字体部分是要指定的引擎名称。
用sql语句修改已经建成表的引擎：
下面贴出我的my.ini文件供参考()：
[mysqld]
basedir=C:\Program Files\VertrigoServ\Mysql\
datadir=C:\Program Files\VertrigoServ\Mysql\data\
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
[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-timeout
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：关于MYSQL 远程登录的授权方法 命令Next article：MYSQL随机抽取查询 MySQL Order By Rand()效率问题