리눅스, 자료실, 성경검색, 추억의게임, 고전게임, 오락실게임, rootman, http://www.rootman.co.kr
* 35.175.120.174 *
| Home | Profile | Linux | 자료실 | zabbix | Mysql 5.6 | 갤러리 | 성경검색 | 해피니스 | 자유게시판 | 게시물검색 | L | O | R |    

 
[innodb] mysql> SHOW ENGINES\\G
 작성자 : rootman
Date : 2009-06-04 18:47  |  Hit : 4,830  

현재 서버의 스토리지 엔진을 보여준다.



mysql> SHOW ENGINES\\G
*************************** 1. row ***************************
Engine: MyISAM
Support: YES
Comment: Default engine as of MySQL 3.23 with great performance
*************************** 2. row ***************************
Engine: MEMORY
Support: YES
Comment: Hash based, stored in memory, useful for temporary tables
*************************** 3. row ***************************
Engine: InnoDB
Support: DEFAULT
Comment: Supports transactions, row-level locking, and foreign keys
*************************** 4. row ***************************
Engine: BerkeleyDB
Support: YES
Comment: Supports transactions and page-level locking
*************************** 5. row ***************************
Engine: BLACKHOLE
Support: NO
Comment: /dev/null storage engine (anything you write to it disappears)
*************************** 6. row ***************************
Engine: EXAMPLE
Support: NO
Comment: Example storage engine
*************************** 7. row ***************************
Engine: ARCHIVE
Support: NO
Comment: Archive storage engine
*************************** 8. row ***************************
Engine: CSV
Support: NO
Comment: CSV storage engine
*************************** 9. row ***************************
Engine: ndbcluster
Support: NO
Comment: Clustered, fault-tolerant, memory-based tables
*************************** 10. row ***************************
Engine: FEDERATED
Support: NO
Comment: Federated MySQL storage engine
*************************** 11. row ***************************
Engine: MRG_MYISAM
Support: YES
Comment: Collection of identical MyISAM tables
*************************** 12. row ***************************
Engine: ISAM
Support: NO
Comment: Obsolete storage engine
12 rows in set (0.00 sec)



 
 

Total. 10
번호 분류 제목 작성자 등록일 조회수
10 innodb mysql> SHOW WARNINGS; rootman 06-04 12184
9 innodb mysql> SHOW TABLE STATUS\\G; rootman 06-04 7362
8 innodb mysql> SHOW PRIVILEGES\\G; rootman 06-04 4969
7 innodb mysql> SHOW OPEN TABLES; rootman 06-04 5313
6 innodb mysql> SHOW MASTER STATUS; rootman 06-04 5006
5 innodb mysql> SHOW LOGS; rootman 06-04 4915
4 innodb mysql> SHOW INNODB STATUS\\G; rootman 06-04 6422
3 innodb mysql> SHOW ERRORS; rootman 06-04 4963
2 innodb mysql> SHOW TABLE TYPES; rootman 06-04 5016
1 innodb mysql> SHOW ENGINES\\G rootman 06-04 4831
AND OR