Home > Database > Mysql Tutorial > body text

What are the shortcomings of mysql?

青灯夜游
Release: 2021-12-27 17:22:28
Original
5302 people have browsed it

Disadvantages of mysql: 1. MySQL does not support custom data types; 2. MySQL does not support XML well enough and cannot directly process XML data; 3. MySQL does not support stored procedures and triggers well enough; 4. It cannot provide any OLAP (real-time analysis system) functions, etc.

What are the shortcomings of mysql?

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

What is MySQL

MySQL was originally an open source relational database management system. The original developer was the Swedish MySQLAB company, which was acquired by Sun Microsystems in 2008. Takeovers. In 2009, Oracle acquired Sun and MySQL became a product of Oracle.

MySQL has become the most popular open source database in the past due to its high performance, low cost, and good reliability, and is therefore widely used in small and medium-sized websites on the Internet. As MySQL continues to mature, it is gradually used in more large-scale websites and applications, such as websites such as Google and Facebook.

Features of MySQL:

1. Fast performance, optimized SQL language

2. Easy to use

3. Multi-threading and reliability

4, multi-user support

5, portability and development source code

6, compliance with international standards and internationalization support

7. Provide APIs for multiple programming languages

The shortcomings of MySQL:

1. MyISAM table format operates with table locking, while InnoDB table format operates with row locking

2. Hot backup cannot be performed during MyISAM table operation. The solution is to change to InnoDB table format

3. MySQL does not support custom data types

4. MySQL supports XML Not good enough to handle XML data directly

5. MySQL’s support for stored procedures and triggers is not good enough

6. Some functions are not fully supported and mature enough

7 , cannot provide any OLAP (real-time analysis system) function

[Related recommendations: mysql video tutorial]

The above is the detailed content of What are the shortcomings of mysql?. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact [email protected]
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!