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

This article mainly explains "what are the characteristics of mysql database". 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 "what are the characteristics of mysql database".

Mysql database was originally an open source relational database management system, originally developed by Sweden's MySQL AB, which was acquired by Shenyang Microsystems in 2008, and MySQL became a product of Oracle when Oracle acquired Shenyang Microsystems in 2009.

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

What is the mysql database?

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 (officially pronounced as / ma relational database management system / "MyS-Qmurl", but is also often read as / ma relational database management system / "My Sequel") was originally an open source relational database management system, originally developed by Sweden's MySQL AB, which was acquired by Shenyang Microsystems (Sun Microsystems) in 2008. In 2009, Oracle acquired Shenyang Microsystems, and MySQL became a product of Oracle.

MySQL has become the most popular open source database in the past because of its high performance, low cost and good reliability, so it is widely used in small and medium-sized websites on Internet. As MySQL continues to mature, it is also gradually used in more large-scale websites and applications, such as Wikipedia, Google and Facebook. The "M" in the very popular open source software combination LAMP refers to MySQL.

But after it was acquired by Oracle, Oracle sharply increased the price of MySQL's commercial version, and Oracle no longer supported the development of OpenSolaris, another free software project. As a result, the free software community was worried about whether Oracle would continue to support the MySQL community version (the only free version of MySQL). MySQL founder Michael Vidnius set up a branch plan MariaDB based on MySQL. However, some open source software that used to use MySQL gradually turned to MariaDB or other databases. Wikipedia, for example, officially announced in 2013 that it would migrate from MySQL to MariaDB database [6].

MySQL's license is now divided into free community version and paid standard version, enterprise version, etc. [7]. Generally speaking, if you release MySQL in a non-open source project, or need technical support for MySQL from Oracle, or use some enterprise version tools or plug-ins of MySQL, or modify the MySQL source code as closed-source software, you need to buy a commercial version. If you just install and use MySQL, or even modify and use MySQL, whether for a fee or not, or if the software does not include MySQL, users of the software install MySQL; themselves, or MySQL is included in open source software products that use the GPL protocol, these situations may use the community version of MySQL.

Mysql characteristics

Written in C and C++, and tested with a variety of compilers to ensure the portability of the source code.

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

Provides API for a variety of programming languages. These programming languages include C, C++, C #, VB.NET, Delphi, Eiffel, Java, Perl, PHP, Python, Ruby and Tcl.

Support multithreading, make full use of CPU resources, support multi-users.

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

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

Provide multi-language support, common codes such as Chinese GB 2312, BIG5, Japanese Shift JIS can be used as data table names and data column names.

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

Provides management tools for managing, checking, and digitizing database operations.

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

Thank you for your reading, these are the contents of "what are the characteristics of mysql database?" after the study of this article, I believe you have a deeper understanding of the characteristics of mysql database, 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!

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.