Shulou(Shulou.com)06/01 Report--

1. Check the engine provided by mysql.

MariaDB [(none)] > show engines +- -- + | Engine | Support | Comment | Transactions | XA | Savepoints | +- -+ | CSV | YES | CSV storage engine | | NO | | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | | MEMORY | YES | Hash based | Stored in memory Useful for temporary tables | NO | | BLACKHOLE | YES | / dev/null storage engine (anything you write to it disappears) | NO | | MyISAM | YES | MyISAM storage engine | NO | | NO | NO | | InnoDB | DEFAULT | Percona-XtraDB | Supports transactions, row-level locking And foreign keys | YES | | ARCHIVE | YES | Archive storage engine | NO | | FEDERATED | YES | FederatedX pluggable storage engine | YES | NO | YES | | PERFORMANCE_SCHEMA | YES | Performance Schema | NO | | Aria | YES | Crash-safe tables with MyISAM heritage | NO | +-| -+ -+-+ 10 rows in set (0.00 sec)

2. Check the default engine of mysql.

MariaDB [(none)] > show variables like'% storage_engine%' +-+-+ | Variable_name | Value | +-+-+ | default_storage_engine | InnoDB | | storage_engine | InnoDB | + -+-+ 2 rows in set (0.00 sec)

3. View the engine of a table.

MariaDB [(none)] > show create table table name

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.