色天使久久综合网天天,欧美激情精品久久久久久久,久久无码一区二区三区少妇

查看mysql中表的存儲引擎類型的方法：1、使用【show table status from 數(shù)據(jù)庫庫名 where name=’表名’】；2、查看mysql服務(wù)器是否啟用InnoDB存儲引擎。

如何查看mysql中表的存儲引擎類型

查看mysql中表的存儲引擎類型的方法：

1.show table status from 數(shù)據(jù)庫庫名 where name=’表名’,例：

mysql&gt;?SHOW?TABLE?STATUS?from?mytest?where?Name='test'; +------------+--------+---------+------------+------+----------------+-------------+(省略部分結(jié)果) |?Name?|?Engine?|?Version?|?Row_format?|?Rows?|?Avg_row_length?|?Data_length?|(省略部分結(jié)果) +------------+--------+---------+------------+------+----------------+-------------+(省略部分結(jié)果) |?test?|?MyISAM?|??????10?|?Fixed??????|????0?|??????????????0?|???????????0?|(省略部分結(jié)果) +------------+--------+---------+------------+------+----------------+-------------+(省略部分結(jié)果) 1?row?in?set?(0.02?sec) mysql&gt;

看到Engine對應(yīng)的值是MyISAM

2.mysqlshow -u 數(shù)據(jù)庫登錄賬號用戶名 -p’數(shù)據(jù)庫登錄賬號密碼’ –status 數(shù)據(jù)庫庫名表名

mysqlshow??-uroot?-p'mypassword'???--status?mytest?test Database:mytest??Wildcard:?test +------------+--------+---------+------------+------+----------------+-------------+(省略部分結(jié)果) |?Name?|?Engine?|?Version?|?Row_format?|?Rows?|?Avg_row_length?|?Data_length?|(省略部分結(jié)果) +------------+--------+---------+------------+------+----------------+-------------+(省略部分結(jié)果) |?test?|?MyISAM?|??????10?|?Fixed??????|????0?|??????????????0?|???????????0?|(省略部分結(jié)果) +------------+--------+---------+------------+------+----------------+-------------+(省略部分結(jié)果)

可以看到Engine對應(yīng)的值是MyISAM

3.show create table 表名

這種方法有時(shí)候是不準(zhǔn)確的，例：

服務(wù)器配置沒有啟用InnoDB存儲引擎，在創(chuàng)建表的時(shí)候設(shè)置的是InnoDB存儲引擎，創(chuàng)建表時(shí)的命令：

mysql&gt;?create?database?mytest; Query?OK,?1?row?affected?(0.02?sec) mysql&gt;?use?mytest; Database?changed mysql&gt;?CREATE?TABLE?test?( -&gt;?id?INT(11)?default?NULL?auto_increment, -&gt;?s?char(60)?default?NULL, -&gt;?PRIMARY?KEY?(id) -&gt;?)?ENGINE=InnoDB; Query?OK,?0?rows?affected,?2?warnings?(0.06?sec) mysql&gt;

此時(shí)使用上面的方法1和2查看會看到test表使用的引擎是MyISAM，但是使用3查看會看到如上的結(jié)果。而實(shí)際上test表使用的存儲引擎是MyISAM的。

4.查看mysql服務(wù)器是否啟用InnoDB存儲引擎：

返回結(jié)果是：? “InnoDB”? ?對應(yīng)的? “Support”等于 “NO”? ，表示未啟用? InnoDB? 存儲引擎。

mysql&gt;?SHOW??ENGINES; +------------+---------+----------------------------------------------------------+(省略部分結(jié)果) |?Engine?????|?Support?|?Comment??????????????????????????????????????????????????|(省略部分結(jié)果) +------------+---------+----------------------------------------------------------+(省略部分結(jié)果) |?InnoDB?????|?NO??????|?Supports?transactions,?row-level?locking,?and?foreign?keys|(省略部分結(jié)果) |?MRG_MYISAM?|?YES?????|?Collection?of?identical?MyISAM?tables??????????????????|(省略部分結(jié)果) |?BLACKHOLE??|?YES?????|?/dev/null?storage?engine?(anything?you?write?to?it?disa(省略部分結(jié)果) |?CSV????????|?YES?????|?CSV?storage?engine???????????????????????????????????????|(省略部分結(jié)果) |?MEMORY?????|?YES?????|?Hash?based,?stored?in?memory,?useful?for?temporary?tables|(省略部分結(jié)果) |?FEDERATED??|?NO??????|?Federated?MySQL?storage?engine???????????????????????????|(省略部分結(jié)果) |?ARCHIVE????|?YES?????|?Archive?storage?engine???????????????????????????????????|(省略部分結(jié)果) |?MyISAM?????|?DEFAULT?|?Default?engine?as?of?MySQL?3.23?with?great?performance|(省略部分結(jié)果) +------------+---------+----------------------------------------------------------+(省略部分結(jié)果) 8?rows?in?set?(0.00?sec) mysql&gt;