Shulou(Shulou.com)06/02 Report--

How to analyze the mysql database? in view of this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

What is the database?

Database is a kind of software for managing data. The management of data is reflected in two aspects, the first is to describe the data, that is, how a piece of data is represented, and the second is to organize the data, that is, how to manage a lot of data.

The main purpose of the database is to add, delete, modify and query the data.

Second, the classification of the database?

Database is mainly divided into relational database and sub-relational database.

Data requirements for relational databases non-relational databases uniform data specifications do not require data specifications to unify the organization of formal tables, documents / key-value pairs of data

Put the same kind of data into one table

Each row in the table is a record

Each record contains many columns, which are required to have the same type and meaning.

Each record is a document, and the attributes and fields in each document do not require the same advantages. Data verification is stricter and less strict, but it is more efficient and more suitable for today's distributed systems. Typical representative of Oracle,MySQL,SQL ServerMangoDB,Redis,HBase III. The difference between database and data structure

Data structure: it is an abstract discipline, which studies the logical structure and physical structure of data and the relationship between them, defines the appropriate operation for this structure, and designs the corresponding algorithm.

Database: is a more specific kind of software, in the implementation of this software uses a lot of data structures.

A lot of software needs to use the data structure to add, delete, change and search, and the database is just one of the application scenarios.

Fourth, the introduction of MySQL database 4.1 the composition of MySQL database

MySQL database is a "client-server" program, the client initiates the request actively, the data sent by the client is called request, the server passively accepts the request, and the data returned by the server is called response. The client and the server communicate through the network.

When you install the MySQL database, you can install the client and server on the same host, or you can install them on different hosts. In practice, the same server can provide services for multiple clients.

The MySQL client is a very simple program that is only used to interact with users. (database programming refers to the implementation of a client, which has nothing to do with the server.) the MySQL server is the ontology of the database, and the MySQL database stores data on the server.

Mainstream MySQL version: MySQL5 series, MySQL8 series.

4.2 introduction of MySQL server

The MySQL server contains several databases, each of which is a logical collection of data tables (putting associated tables together).

Servers: containing multiple databases

Databases: containing multiple tables

Table: contains multiple rows, each of which is a record

Row: contains multiple columns, each column is a field

4.3 data storage location of the MySQL database

Many databases store data in external memory, such as MySQL, Oracle, etc., and a small number of databases store data in memory, such as Redis.

MySQL stores the data on the hard disk. The reasons are as follows:

First of all, understand the difference between memory and hard disk:

The memory has less space and the hard disk has more space; the memory is more expensive than the hard disk; if the power is off, the data on the memory will be lost and the data on the hard disk will not be lost.

Database data storage requirements: large capacity, because of the large amount of data; expect to have a lower cost; expect that the data will not be lost after the power off, can be persistent storage; hard disk compared with memory, fully meet these requirements, so choose the hard disk to store data.

If you store a large amount of data, you can choose to use the following methods:

Add a few more hard drives to ①

② uses multiple machines to store, MySQL's sub-library sub-table.

First of all, the classification of databases is introduced, which is divided into two types: structured database and unstructured database. Secondly, it introduces the composition of MySQL database, that is, MySQL is composed of client and server, and the server is the main body of MySQL. Finally, it is introduced that the MySQL server stores data on the hard disk because of its large capacity, low cost and persistent storage.

The answer to the question on how to analyze the mysql database is shared here. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

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.