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

 
[innodb] mysql> SHOW TABLE STATUS\\G;
 작성자 : rootman
Date : 2009-06-04 19:20  |  Hit : 7,034  
mysql> SHOW TABLE STATUS\\G;
*************************** 1. row ***************************
Name: columns_priv
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 227994731135631359
Index_length: 1024
Data_free: 0
Auto_increment: NULL
Create_time: 2009-06-04 00:32:28
Update_time: 2009-06-04 00:32:28
Check_time: NULL
Collation: utf8_bin
Checksum: NULL
Create_options:
Comment: Column privileges
*************************** 2. row ***************************
Name: db
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 2
Avg_row_length: 438
Data_length: 876
Max_data_length: 123286039799267327
Index_length: 4096
Data_free: 0
Auto_increment: NULL
Create_time: 2009-06-04 00:32:28
Update_time: 2009-06-04 00:32:28
Check_time: 2009-06-04 00:32:28
Collation: utf8_bin
Checksum: NULL
Create_options:
Comment: Database privileges
*************************** 3. row ***************************
Name: func
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 162974011515469823
Index_length: 1024
Data_free: 0
Auto_increment: NULL
Create_time: 2009-06-04 00:32:28
Update_time: 2009-06-04 00:32:28
Check_time: NULL
Collation: utf8_bin
Checksum: NULL
Create_options:
Comment: User defined functions
*************************** 4. row ***************************
Name: help_category
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 36
Avg_row_length: 581
Data_length: 20916
Max_data_length: 163536961468891135
Index_length: 3072
Data_free: 0
Auto_increment: NULL
Create_time: 2009-06-04 00:32:28
Update_time: 2009-06-04 00:32:28
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: help categories
*************************** 5. row ***************************
Name: help_keyword
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 395
Avg_row_length: 197
Data_length: 77815
Max_data_length: 55450570411999231
Index_length: 14336
Data_free: 0
Auto_increment: NULL
Create_time: 2009-06-04 00:32:28
Update_time: 2009-06-04 00:32:28
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: help keywords
*************************** 6. row ***************************
Name: help_relation
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 809
Avg_row_length: 9
Data_length: 7281
Max_data_length: 2533274790395903
Index_length: 15360
Data_free: 0
Auto_increment: NULL
Create_time: 2009-06-04 00:32:28
Update_time: 2009-06-04 00:32:28
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: keyword-topic relation
*************************** 7. row ***************************
Name: help_topic
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 466
Avg_row_length: 715
Data_length: 333276
Max_data_length: 281474976710655
Index_length: 17408
Data_free: 0
Auto_increment: NULL
Create_time: 2009-06-04 00:32:28
Update_time: 2009-06-04 00:32:28
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: help topics
*************************** 8. row ***************************
Name: host
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 109775240917155839
Index_length: 1024
Data_free: 0
Auto_increment: NULL
Create_time: 2009-06-04 00:32:28
Update_time: 2009-06-04 00:32:28
Check_time: NULL
Collation: utf8_bin
Checksum: NULL
Create_options:
Comment: Host privileges; Merged with database privileges
*************************** 9. row ***************************
Name: proc
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 281474976710655
Index_length: 1024
Data_free: 0
Auto_increment: NULL
Create_time: 2009-06-04 00:32:28
Update_time: 2009-06-04 00:32:28
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Stored Procedures
*************************** 10. row ***************************
Name: procs_priv
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 239253730204057599
Index_length: 1024
Data_free: 0
Auto_increment: NULL
Create_time: 2009-06-04 00:32:28
Update_time: 2009-06-04 00:32:28
Check_time: NULL
Collation: utf8_bin
Checksum: NULL
Create_options:
Comment: Procedure privileges
*************************** 11. row ***************************
Name: tables_priv
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 239535205180768255
Index_length: 1024
Data_free: 0
Auto_increment: NULL
Create_time: 2009-06-04 00:32:28
Update_time: 2009-06-04 00:32:28
Check_time: NULL
Collation: utf8_bin
Checksum: NULL
Create_options:
Comment: Table privileges
*************************** 12. row ***************************
Name: time_zone
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 1970324836974591
Index_length: 1024
Data_free: 0
Auto_increment: 1
Create_time: 2009-06-04 00:32:28
Update_time: 2009-06-04 00:32:28
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Time zones
*************************** 13. row ***************************
Name: time_zone_leap_second
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 3659174697238527
Index_length: 1024
Data_free: 0
Auto_increment: NULL
Create_time: 2009-06-04 00:32:28
Update_time: 2009-06-04 00:32:28
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Leap seconds information for time zones
*************************** 14. row ***************************
Name: time_zone_name
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 55450570411999231
Index_length: 1024
Data_free: 0
Auto_increment: NULL
Create_time: 2009-06-04 00:32:28
Update_time: 2009-06-04 00:32:28
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Time zone names
*************************** 15. row ***************************
Name: time_zone_transition
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 4785074604081151
Index_length: 1024
Data_free: 0
Auto_increment: NULL
Create_time: 2009-06-04 00:32:28
Update_time: 2009-06-04 00:32:28
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Time zone transitions
*************************** 16. row ***************************
Name: time_zone_transition_type
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 10696049115004927
Index_length: 1024
Data_free: 0
Auto_increment: NULL
Create_time: 2009-06-04 00:32:28
Update_time: 2009-06-04 00:32:28
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment: Time zone transition types
*************************** 17. row ***************************
Name: user
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 3
Avg_row_length: 50
Data_length: 152
Max_data_length: 281474976710655
Index_length: 2048
Data_free: 0
Auto_increment: NULL
Create_time: 2009-06-04 00:32:28
Update_time: 2009-06-04 00:32:28
Check_time: NULL
Collation: utf8_bin
Checksum: NULL
Create_options:
Comment: Users and global privileges
17 rows in set (0.00 sec)

ERROR:
No query specified


mysql> SHOW TABLE STATUS like 'user' \\G;
*************************** 1. row ***************************
Name: user
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 3
Avg_row_length: 50
Data_length: 152
Max_data_length: 281474976710655
Index_length: 2048
Data_free: 0
Auto_increment: NULL
Create_time: 2009-06-04 00:32:28
Update_time: 2009-06-04 00:32:28
Check_time: NULL
Collation: utf8_bin
Checksum: NULL
Create_options:
Comment: Users and global privileges
1 row in set (0.00 sec)

ERROR:
No query specified

 
 

Total. 645
번호 분류 제목 작성자 등록일 조회수
495 innodb mysql> SHOW WARNINGS; rootman 06-04 11836
494 innodb mysql> SHOW TABLE STATUS\\G; rootman 06-04 7035
493 innodb mysql> SHOW PRIVILEGES\\G; rootman 06-04 4822
492 innodb mysql> SHOW OPEN TABLES; rootman 06-04 5193
491 innodb mysql> SHOW MASTER STATUS; rootman 06-04 4877
490 innodb mysql> SHOW LOGS; rootman 06-04 4776
489 innodb mysql> SHOW INNODB STATUS\\G; rootman 06-04 6270
488 innodb mysql> SHOW ERRORS; rootman 06-04 4836
487 innodb mysql> SHOW TABLE TYPES; rootman 06-04 4878
486 innodb mysql> SHOW ENGINES\\G rootman 06-04 4687
485 RAID [INTEL] LSI ONBOARD rootman 06-02 3625
484 javascript [프린트] 현재페이지를 인쇄할때 출력용지에 아무 내용도 안찍히… rootman 05-20 5886
483 javascript    [프린트] <div>로 지정된 영역만 출력합니다. rootman 05-20 3741
482 javascript [프린트] 버튼 클릭으로 현재페이지 프린트 1 rootman 05-20 4937
481 javascript [프린트] 버튼 클릭으로 현재페이지 프린트 3 rootman 05-20 4708
   11  12  13  14  15  16  17  18  19  20    
AND OR