Mysql-Learning -6-20170511-mysql engine and character set

mysql-Learning-6-20170515

Understanding the objects of a database

Engine=innodb;

Performance_schema

INFORMATION_SCHEMA read-only dictionary library

Compare common engines, from strong to weak:

Innodb tokudb Memory myrocks sphinexse

1pb=1024t
1eb=1024pb

Acid

The atomicity of a

C Conformance

I isolation

D Persistence

MVCC Multi-version control

Transaction control

Concurrent Systems

Multi-version Processing

Log system

Share a Btree project to understand B+tree more:

Https://github.com/yangez/btree-js

Blob and text columns are not supported, not varchar

Data type

Documentstore

Status or \s can query the character set

Show CharSet;

char (N) denotes a character 10 letters,

Char (Ten) gbk:10 letters, 10 Chinese, implementation length: 20

Rules:

VarChar <=255-overload 1byte varchar >255-overload 2byte varchar GBK 10 letters, 10 Chinese, 20+1 varcha R (x) UTF8 10 letters, 10 Chinese, 30+1 GBK 256 letters, 256 Chinese 256*2+2 UTF8256 letters, 256 Chinese 256*3+2

CHAR (30) Save UTF8 characters:

CHAR (30) Save GBK Character: 30 15 30

Mysql-Learning -6-20170511-mysql engine and character set