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

This article mainly explains "what are the main points of MySQL basic knowledge". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "what are the key points of MySQL basic knowledge"?

1. MySQL is the Cramp S architecture.

2. Mysqld is its daemon

3. Architecturally, it can be divided into storage layer, process layer and memory layer, which is similar to Oracle system.

Storage tier: data files on file system

Process layer: a dynamic program that exists to access data

Memory layer: space allocated to MySQL in machine memory to speed up data query, such as buffer cache, etc.

4. Common commands or programs: divided into client programs and non-client programs, non-client programs do not need to use clients to connect to MySQL

4-1 client program

Mysql query to view the results

Mysqladmin Management Server

Mysqlcheck checks the integrity of the table

Mysqldump logical backup

Mysqlimport Import data File

Mysqlshow displays database and table information

Mysqlslap mimics client load

Database Management with mysql workbench Graphics

4-2 non-client programs (directly access data files without using a client connection)

Innochecksum checks tablespace files offline

Mysqlaccess check access privileges

Mysqldumpslow Summary slow query

Mysqlbinlog binary log file

At this point, I believe you have a deeper understanding of "what are the key points of MySQL basic knowledge?" you might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.