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

Foreword:

On how to get started with MySQL, there are many students in the background to consult me. Maybe some readers have just begun to learn MySQL, and the articles I posted before are temporarily out of touch with some students. Originally, the purpose of writing technical articles is to record their own work and study, without taking into account the different MySQL technical levels of the readers. This article mainly introduces the learning methods of MySQL technology, which can be referenced by beginners.

Introduction to MySQL

To learn about MySQL databases, we first need to understand what MySQL is, what it does, and develop the iterative process.

MySQL is a relational database management system developed by the Swedish company MySQL AB and currently belongs to the products of Oracle. MySQL is one of the most popular relational database management systems. In the aspect of WEB application, MySQL is one of the best RDBMS (Relational Database Management System) application software.

MySQL is a relational database management system in which relational databases store data in different tables instead of all data in one large warehouse, which increases speed and flexibility.

The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts the dual licensing policy, which is divided into community version and commercial version. Because of its small size, high speed and low total cost of ownership, especially open source, the development of small and medium-sized websites generally choose MySQL as the website database.

-- from Baidu encyclopedia

Easy-to-use open source software has branches, such as Linux, and MySQL is no exception. MySQL now has two large branches, MariaDB and Percona Server. Percona Server pays more attention to enhancing performance, and Percona's XtraBackup and pt-tookit are easy to use without friends, which can make DBA more powerful in managing MySQL.

After MySQL AB was acquired by Sun, the founder released MariaDB,MariaDB to focus more on new features.

About learning MySQL, it is recommended to use MySQL5.7.17 or above. For installation tutorials, please refer to my previous article.

Here is a brief introduction to the related concepts:

Database (database): refers to a set of files on a file system, represented in innoDB as files with the suffix idb. Equivalent to schema.

Instance: a collection of processes / threads and memory on the operating system. If you execute ps-ef | grep mysql on the MySQL server, you can see the MySQL process.

Simply put, the database refers to the file, and the instance refers to the process / thread and memory. When we talk about databases, we often refer to relational database management systems (RDBMS). These concepts should be strictly distinguished in rigorous documents, but in normal communication, there is basically no problem with what we have agreed upon.

Table (table): a table is a matrix of data. A table in a database looks like a simple spreadsheet.

Index: use an index to quickly access specific information in a database table. An index is a structure that sorts the values of one or more columns in a database table. A catalogue similar to a book.

About documentation

When we learn MySQL, we will inevitably encounter some difficulties, especially how to set some parameters. At this point, official documentation is the best tool.

Official document address of version 5.7:

Https://dev.mysql.com/doc/refman/5.7/en/

Cdn.nlark.com/yuque/0/2019/png/119537/1563367843956-8141d671-bde8-4e33-9384-0f48a385002f.png ">

It doesn't matter if I don't quite understand it in English. Google translates the web page and can understand the general meaning. Personally, I think the introduction in the official document is much more reliable than the blog searched on the Internet.

About books

Perhaps some students prefer to read professional books, for those who want to buy books to learn MySQL, here recommend the famous "high-performance MySQL", this book can be called MySQL classic, there is no one of the kind.

Summary:

On how to get started with MySQL, the summary is: first build a good learning environment, understand the relevant architecture and concepts of MySQL, and then practice step by step. Documents and books can help you learn more systematically. I hope this article will be helpful to you, others can also leave messages to share if they have good learning methods.

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.