Basic concepts and common commands of MySQL
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!
