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

Editor to share with you what kind of database mysql is, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Mysql is a relational database management system, which is developed by MySQL AB Company of Sweden and belongs to Oracle products. MySQL software adopts double authorization policy, which is divided into community version and commercial version. Because of its small size, high speed and low total cost of ownership, the development of small and medium-sized websites generally chooses MySQL as the website database.

This article operating environment: Windows7 system, mysql8.0 version, Dell G3 computer.

MySQL is the most popular relational database management system, and MySQL is one of the best RDBMS (Relational Database Management System: relational database management system) applications in WEB applications.

MySQL is a relational database management system developed by the Swedish company MySQL AB and 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.

System characteristics

1. MySQL is written in C and C++, and tested with a variety of compilers to ensure the portability of the source code.

2. Support AIX, FreeBSD, HP-UX, Linux, Mac OS, NovellNetware, OpenBSD, OS/2 Wrap, Solaris, Windows and other operating systems.

3. API is provided for many programming languages. These programming languages include C, C++, Python, Java, Perl, PHP, Eiffel, Ruby,.NET and Tcl.

4. Support multithreading and make full use of CPU resources.

5. The optimized SQL query algorithm can effectively improve the query speed.

6. It can be used not only as a separate application in the client server network environment, but also as a library and embedded in other software.

7. Provide multi-language support. Common codes such as GB 2312 and BIG5 in Chinese and Shift_JIS in Japanese can be used as data table names and data column names.

8. Provide a variety of database connections such as TCP/IP, ODBC and JDBC.

9. Provide management tools for managing, checking, and optimizing database operations.

10. Support large databases. It can handle large databases with tens of millions of records.

11. Multiple storage engines are supported.

12.MySQL is open source, so you don't have to pay extra.

13.MySQL uses the standard SQL data language form.

14.MySQL has good support for PHP, and PHP is a popular Web development language.

15.MySQL can be customized, using the GPL protocol, you can modify the source code to develop your own MySQL system.

16. Online DDL/ change capabilities, data architecture support for dynamic applications and developer flexibility (5.6 new)

17. Copy the global transaction identity to support self-healing clustering (added in 5.6)

18. Replication crash-free slaves to improve availability (add 5.6)

19. Copy multithreaded slaves to improve performance (added in 5.6)

20.3x faster performance (5.7 [3] New)

21. New optimizer (5.7 added)

twenty-two。 Native JSON support (5.7new)

23. Multi-source replication (5.7 New)

Spatial expansion of 24.GIS [4] (5.7New)

The above is all the contents of the article "what kind of database mysql is". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.