MySQL DBA刚入职时如何快速拥抱新的环境(三)
以及它们的状态
㈦ 第七部分
# Query cache ################################################
query_cache_type | ON
Size | 0.0
Usage | 0%
HitToInsertRatio | 0%
--这部分是关于查询缓存基本情况
㈧ 第八部分
# Schema #####################################################
Would you like to mysqldump -d the schema and analyze it y/n y
There are 6 databases. Would you like to dump all, or just one
Type the name of the database, or press Enter to dump all of them.
Database Tables Views SPs Trigs Funcs FKs Partn
cdio 61 65
jiradb 130 6
mysql 22
test
Database InnoDB MyISAM
cdio 61
jiradb 130
mysql 22
test
Database BTREE
cdio 193
jiradb 274
mysql 31
c t
h i
a m
r e
s
t
a
m
p
Database === ===
cdio 114 155
jiradb 1 346
mysql 8 3
test
--这部分便是 mysqldump --no-data 跑出来的数据
--第一个小部分指明每个库有多少张表、视图、存储过程、触发器、函数、外键约束等
--第二个小部分指明每个库有多少张表使用了不同的存储引擎
--第三个小部分指明每个库有多少索引类型
--第四个小部分指明每个库数据类型的分布情况、可能比较难看、因为列是竖着放、比如第一列是char
㈨ 第九部分
# Noteworthy Technologies ####################################
Full Text Indexing | No
Geospatial Types | No
Foreign Keys | Yes
Partitioning | No
InnoDB Compression | No
SSL | No
Explicit LOCK TABLES | No
Delayed Insert | No
XA Transactions | No
NDB Cluster | No
Prepared Statements | No
Prepared statement count | 0
--这部分显示了一些关键技术是否被用上、如：全文索引、XA等
(十)第十部分
# InnoDB #####################################################
Version | 1.1.8
Buffer Pool Size | 128.0M
Buffer Pool Fill | 10%
Buffer Pool Dirty | 0%
File Per Table | ON
Page Size | 16k
Log File Size | 2 * 5.0M = 10.0M
Log Buffer Size | 8M
Flush Method |
Flush Log At Commit | 1
XA Support | ON
Checksums | ON
Doublewrite | ON
R/W I/O Threads | 4 4
I/O Capacity | 200
Thread Concurrency | 0
Concurrency Tickets | 500
Commit Concurrency | 0
Txn Isolation Level | REPEATABLE-READ
Adaptive Flushing | ON
Adaptive Checkpoint |
Checkpoint Age | 0
InnoDB Queue | 0 queries inside InnoDB, 0 queries in queue
Oldest Transaction | 0 Seconds
History List Len | 1899
Read Views | 1
Undo Log Entries | 0 transactions, 0 total undo, 0 max undo
Pending I/O Reads | 0 buf pool reads, 0 normal AIO, 0 ibuf AIO, 0 preads
Pending I/O Writes | 0 buf pool (0 LRU, 0 flush list, 0 page); 0 AIO, 0 sync, 0 log IO (0 log, 0 chkp); 0 pwrites
Pending I/O Flushes | 0 buf pool, 0 log
Transaction States | 16xnot started
--这部分显示了InnoDB 的基本配置
--Buffer Pool Fill和Buffer Pool Dirty是近视值
(11)第11部分
# MyISAM ##############