MySQL data type

InnoDB table

. frm: Table structure

. IBD: Table space (data and index)

SHOW ENGINES

SHOW TABLE STATUS

How the program language connects to the database:

Dynamic SQL: Establishing a connection to a database service by function or method

Embedded SQL:

Jdbc,odbc

Client: MySQL, mysqladmin, mysqldump mysqlimport Mysqlcheck

Servers: mysqld, Mysqld_safe, Mysqld_multi

My.cnf

/ETC/MY.CNF--->/etc/mysql/my.cnf---> $MYSQL _home/my.cnf--->--default-extra-file=/path/to/somefile--- > ~/.my.cnf

#mysqld--help--verbose

DataDir =/mydata/data

Hostname.err error Log

1. Previous service not closed

2. Initialization of data failed

3. Data Directory Location error

4. Data Directory Permissions issues

33 min

This article is from the "Stones" blog, make sure to keep this source http://liangge.blog.51cto.com/7154562/1896056

MySQL data type