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

The purpose of this article is to share with you about the shortcomings of mysql. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

The shortcomings of mysql: 1, MySQL does not support custom data types; 2, MySQL does not support XML well enough to deal with XML data directly; 3, MySQL does not support stored procedures and triggers well enough; 4, it can not provide any OLAP (real-time analysis system) functions.

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 developed by Sweden's MySQLAB, which was acquired by Sun in 2008. In 2009, Oracle Oracle acquired Sun, 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 Google and Facebook.

Characteristics of MySQL:

1. Fast performance and optimized SQL language

2. Easy to use

3. Multithreading and reliability

4. Multi-user support

5. Portability and development source code

6. Compliance with international standards and international support

7. Provide API for multiple programming languages

Shortcomings of MySQL:

1. MyISAM table format is locked when operating, while InnoDB table format is row locked.

2. MyISAM table cannot be hot backed up during operation. The solution is to change it to InnoDB table format.

3. MySQL does not support custom data types.

4. MySQL does not support XML well enough to deal with XML data directly.

5. MySQL does not support stored procedures and triggers well enough.

6. Some functions are not well supported and mature.

7. Can not provide any OLAP (real-time analysis system) function

Thank you for reading! This is the end of the article on "what is the deficiency of mysql". I hope the above content can be helpful to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

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.