mysql优化 - MySQL的优点和缺点有哪些？

Question

比如在高并发、复制、集群这些方面等等……

Answer 1

The biggest shortcoming of MySQL that I feel is that it is not well designed like JavaScript, so it is a trick for people to use after it is created.

Advantages? Is there any? Does it count as more popular? There are many forks, so if you are not happy with one, can you try another one and try again? Bold text

Update:

@xiaoxin2222

Advantages: Open source, free, and can be customized and enhanced according to the business. This advantage is enough. For Internet companies, it saves countless costs. The right to define yourself still lies with you.

The new version of MySQL is no longer open source or free. Of course, there are many other forks, and Alibaba and Twitter also have their own forks. ——So you see, if you want to "make custom enhancements based on business", you have to modify its source code . PostgreSQL, an old open source database, supports rich custom data types, supports binary extensions, and supports writing stored procedures in multiple languages ​​such as Python.

Answer 2

Advantages: Open source, free, and can be customized and enhanced according to the business. This advantage is enough. For Internet companies, it saves countless costs. The right to define yourself still lies with you.
Disadvantages: Compared with commercial databases, the functions are definitely not that powerful, and you need to configure and enhance them yourself (such as read-write separation, load balancing, multi-host writing, etc.)

Answer 3

The advantage is that it is good at solving some problems that do not exist in other databases

Answer 4

I won’t talk about the advantages.
Let’s talk about the disadvantages

MySQL does not support custom data types
MySQL does not support XML well enough
MySQL does not support stored procedures and triggers well enough

Compared with nosql
In the face of big data, mysql queries seem weak