리눅스, 자료실, 성경검색, 추억의게임, 고전게임, 오락실게임, 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,829  

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



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. 645
번호 분류 제목 작성자 등록일 조회수
495 innodb mysql> SHOW WARNINGS; rootman 06-04 12184
494 innodb mysql> SHOW TABLE STATUS\\G; rootman 06-04 7362
493 innodb mysql> SHOW PRIVILEGES\\G; rootman 06-04 4968
492 innodb mysql> SHOW OPEN TABLES; rootman 06-04 5312
491 innodb mysql> SHOW MASTER STATUS; rootman 06-04 5005
490 innodb mysql> SHOW LOGS; rootman 06-04 4914
489 innodb mysql> SHOW INNODB STATUS\\G; rootman 06-04 6422
488 innodb mysql> SHOW ERRORS; rootman 06-04 4962
487 innodb mysql> SHOW TABLE TYPES; rootman 06-04 5016
486 innodb mysql> SHOW ENGINES\\G rootman 06-04 4830
485 RAID [INTEL] LSI ONBOARD rootman 06-02 3737
484 javascript [프린트] 현재페이지를 인쇄할때 출력용지에 아무 내용도 안찍히… rootman 05-20 6043
483 javascript    [프린트] <div>로 지정된 영역만 출력합니다. rootman 05-20 3863
482 javascript [프린트] 버튼 클릭으로 현재페이지 프린트 1 rootman 05-20 5063
481 javascript [프린트] 버튼 클릭으로 현재페이지 프린트 3 rootman 05-20 4843
   11  12  13  14  15  16  17  18  19  20    
AND OR