mysql information_schemaデータベースの概要:

20091 ワード

1、CHARACTER_SETS  

CREATE TEMPORARY TABLE `CHARACTER_SETS` (
  `CHARACTER_SET_NAME` varchar(32) NOT NULL DEFAULT '',        ,  set names utf8;
  `DEFAULT_COLLATE_NAME` varchar(32) NOT NULL DEFAULT '',       
  `DESCRIPTION` varchar(60) NOT NULL DEFAULT '',       
  `MAXLEN` bigint(3) NOT NULL DEFAULT '0'          ,  utf8 3   
) ENGINE=MEMORY DEFAULT CHARSET=utf8

      mysql      。

2、COLUMNS ,         
CREATE TEMPORARY TABLE `COLUMNS` (
  `TABLE_CATALOG` varchar(512) NOT NULL DEFAULT '',
  `TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',        
  `TABLE_NAME` varchar(64) NOT NULL DEFAULT '',          
  `COLUMN_NAME` varchar(64) NOT NULL DEFAULT '',      
  `ORDINAL_POSITION` bigint(21) unsigned NOT NULL DEFAULT '0',
  `COLUMN_DEFAULT` longtext,
  `IS_NULLABLE` varchar(3) NOT NULL DEFAULT '',           null
  `DATA_TYPE` varchar(64) NOT NULL DEFAULT '',              
  `CHARACTER_MAXIMUM_LENGTH` bigint(21) unsigned DEFAULT NULL,
  `CHARACTER_OCTET_LENGTH` bigint(21) unsigned DEFAULT NULL,
  `NUMERIC_PRECISION` bigint(21) unsigned DEFAULT NULL,
  `NUMERIC_SCALE` bigint(21) unsigned DEFAULT NULL,
  `DATETIME_PRECISION` bigint(21) unsigned DEFAULT NULL,
  `CHARACTER_SET_NAME` varchar(32) DEFAULT NULL,      
  `COLLATION_NAME` varchar(32) DEFAULT NULL,      
  `COLUMN_TYPE` longtext NOT NULL,                       
  `COLUMN_KEY` varchar(3) NOT NULL DEFAULT '',
  `EXTRA` varchar(30) NOT NULL DEFAULT '',
  `PRIVILEGES` varchar(80) NOT NULL DEFAULT '',               ,  select,insert,update
  `COLUMN_COMMENT` varchar(1024) NOT NULL DEFAULT ''          
) ENGINE=MyISAM DEFAULT CHARSET=utf8
                 

3、ENGINES,      
CREATE TEMPORARY TABLE `ENGINES` (
  `ENGINE` varchar(64) NOT NULL DEFAULT '',           
  `SUPPORT` varchar(8) NOT NULL DEFAULT '',            
  `COMMENT` varchar(80) NOT NULL DEFAULT '',      
  `TRANSACTIONS` varchar(3) DEFAULT NULL,              
  `XA` varchar(3) DEFAULT NULL,                        XA     
  `SAVEPOINTS` varchar(3) DEFAULT NULL            
) ENGINE=MEMORY DEFAULT CHARSET=utf8
             

4、GLOBAL_STATUS ,        , show status     。(   session   )
CREATE TEMPORARY TABLE `GLOBAL_STATUS` (
  `VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '',     
  `VARIABLE_VALUE` varchar(2048) DEFAULT NULL           
) ENGINE=MEMORY DEFAULT CHARSET=utf8
              。

5、GLOBAL_VARIABLES ,       (   session   )
CREATE TEMPORARY TABLE `GLOBAL_VARIABLES` (
  `VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '',     
  `VARIABLE_VALUE` varchar(2048) DEFAULT NULL           
) ENGINE=MEMORY DEFAULT CHARSET=utf8
         ,mysql    set global variabe,       

6、PROCESSLIST ,     ,show processlist    
CREATE TEMPORARY TABLE `PROCESSLIST` (
  `ID` bigint(21) unsigned NOT NULL DEFAULT '0',
  `USER` varchar(16) NOT NULL DEFAULT '',         
  `HOST` varchar(64) NOT NULL DEFAULT '',          
  `DB` varchar(64) DEFAULT NULL,                  
  `COMMAND` varchar(16) NOT NULL DEFAULT '',         
  `TIME` int(7) NOT NULL DEFAULT '0',      
  `STATE` varchar(64) DEFAULT NULL,          
  `INFO` longtext,                          
  `TIME_MS` bigint(21) NOT NULL DEFAULT '0',
  `ROWS_SENT` bigint(21) unsigned NOT NULL DEFAULT '0',
  `ROWS_EXAMINED` bigint(21) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8

7、PROFILING ,sql     profile ,       select  ,           
CREATE TEMPORARY TABLE `PROFILING` (
  `QUERY_ID` int(20) NOT NULL DEFAULT '0',
  `SEQ` int(20) NOT NULL DEFAULT '0',
  `STATE` varchar(30) NOT NULL DEFAULT '',
  `DURATION` decimal(9,6) NOT NULL DEFAULT '0.000000',
  `CPU_USER` decimal(9,6) DEFAULT NULL,
  `CPU_SYSTEM` decimal(9,6) DEFAULT NULL,
  `CONTEXT_VOLUNTARY` int(20) DEFAULT NULL,
  `CONTEXT_INVOLUNTARY` int(20) DEFAULT NULL,
  `BLOCK_OPS_IN` int(20) DEFAULT NULL,
  `BLOCK_OPS_OUT` int(20) DEFAULT NULL,
  `MESSAGES_SENT` int(20) DEFAULT NULL,
  `MESSAGES_RECEIVED` int(20) DEFAULT NULL,
  `PAGE_FAULTS_MAJOR` int(20) DEFAULT NULL,
  `PAGE_FAULTS_MINOR` int(20) DEFAULT NULL,
  `SWAPS` int(20) DEFAULT NULL,
  `SOURCE_FUNCTION` varchar(30) DEFAULT NULL,
  `SOURCE_FILE` varchar(20) DEFAULT NULL,
  `SOURCE_LINE` int(20) DEFAULT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8

8、SCHEMA_PRIVILEGES      ,              
CREATE TEMPORARY TABLE `SCHEMA_PRIVILEGES` (
  `GRANTEE` varchar(81) NOT NULL DEFAULT '',     @host
  `TABLE_CATALOG` varchar(512) NOT NULL DEFAULT '',
  `TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',       
  `PRIVILEGE_TYPE` varchar(64) NOT NULL DEFAULT '',     ,  insert
  `IS_GRANTABLE` varchar(3) NOT NULL DEFAULT ''   
) ENGINE=MEMORY DEFAULT CHARSET=utf8

9、SESSION_STATUS,SESSION_VARIABLES,   GLOBAL_STATUS,GLOBAL_VARIABLES, session     

10、STATISTICS ,         。
CREATE TEMPORARY TABLE `STATISTICS` (
  `TABLE_CATALOG` varchar(512) NOT NULL DEFAULT '',
  `TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',       
  `TABLE_NAME` varchar(64) NOT NULL DEFAULT '',          
  `NON_UNIQUE` bigint(1) NOT NULL DEFAULT '0',              ,0   ,1  
  `INDEX_SCHEMA` varchar(64) NOT NULL DEFAULT '',    
  `INDEX_NAME` varchar(64) NOT NULL DEFAULT '',            
  `SEQ_IN_INDEX` bigint(2) NOT NULL DEFAULT '0',
  `COLUMN_NAME` varchar(64) NOT NULL DEFAULT '',      
  `COLLATION` varchar(1) DEFAULT NULL,    
  `CARDINALITY` bigint(21) DEFAULT NULL,
  `SUB_PART` bigint(3) DEFAULT NULL,
  `PACKED` varchar(10) DEFAULT NULL,
  `NULLABLE` varchar(3) NOT NULL DEFAULT '',
  `INDEX_TYPE` varchar(16) NOT NULL DEFAULT '',        ,  BTree
  `COMMENT` varchar(16) DEFAULT NULL,
  `INDEX_COMMENT` varchar(1024) NOT NULL DEFAULT ''
) ENGINE=MEMORY DEFAULT CHARSET=utf8

11、TABLES ,         。
CREATE TEMPORARY TABLE `TABLES` (
  `TABLE_CATALOG` varchar(512) NOT NULL DEFAULT '',
  `TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',          
  `TABLE_NAME` varchar(64) NOT NULL DEFAULT '',      
  `TABLE_TYPE` varchar(64) NOT NULL DEFAULT '',
  `ENGINE` varchar(64) DEFAULT NULL,             
  `VERSION` bigint(21) unsigned DEFAULT NULL,
  `ROW_FORMAT` varchar(20) DEFAULT NULL,
  `TABLE_ROWS` bigint(21) unsigned DEFAULT NULL,
  `AVG_ROW_LENGTH` bigint(21) unsigned DEFAULT NULL,
  `DATA_LENGTH` bigint(21) unsigned DEFAULT NULL,
  `MAX_DATA_LENGTH` bigint(21) unsigned DEFAULT NULL,
  `INDEX_LENGTH` bigint(21) unsigned DEFAULT NULL,
  `DATA_FREE` bigint(21) unsigned DEFAULT NULL,
  `AUTO_INCREMENT` bigint(21) unsigned DEFAULT NULL,
  `CREATE_TIME` datetime DEFAULT NULL,
  `UPDATE_TIME` datetime DEFAULT NULL,
  `CHECK_TIME` datetime DEFAULT NULL,
  `TABLE_COLLATION` varchar(32) DEFAULT NULL,
  `CHECKSUM` bigint(21) unsigned DEFAULT NULL,
  `CREATE_OPTIONS` varchar(255) DEFAULT NULL,
  `TABLE_COMMENT` varchar(2048) NOT NULL DEFAULT ''
) ENGINE=MEMORY DEFAULT CHARSET=utf8


beta , diff , sql , ,