Shulou(Shulou.com)05/31 Report--

This article mainly explains the "basic concepts and common commands of MySQL". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "the basic concepts and common commands of MySQL".

1 introduction to MySQL

Quote

Mysql was developed by more than 1985 Swedish guys, and then they founded Mysql AB. At that time, they developed mysql to provide data warehouse services for retailers, which is why mysql is good at querying rather than transactions. so they designed a method of using index order to store data, that is, ISAM storage engine algorithm, which later developed into MyISAM storage engine. Mysql has the characteristics of high performance, high reliability and ease of use, so it is mainly suitable for web website system, logging system, data warehouse system, and embedded system.

Composition of 2.Mysql architecture

Quote

The physical composition of mysql: log files, data files, Replication related files, other files

Quote

The system Architecture of mysql server: SQL Layer and Storage Engine Layer

Quote

Mysql comes with tools to introduce mysqladmin commands

# ping command to check whether server can provide sufficient services normally

Mysqladmin-uroot-proot-h localhost ping

# status command to view several status values of the current msyql server

Mysqladmin-uroot-proot-h localhost status

# processlist command to get the current connection thread information

Admin-uroot-proot-h localhost processlist

Introduction of 3.MySQL plug-in Storage engine

Quote

Each table in the MyISAM engine is stored as three physical files named after the table name: tableName.frm,tableName.MYD,tableName.MYI

Three indexes are supported: B-Tree, R-Tree, Full-text (B-Tree, to solve the problem of inefficient like query)

Quote

InnoDB storage engine features: support for transaction security, multi-version reading of data, foreign key support

Thank you for your reading, the above is the content of "basic concepts and common commands of MySQL". After the study of this article, I believe you have a deeper understanding of the basic concepts and common commands of MySQL, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.