与其他DBMS相比，MySQL消耗的资源明显多吗？ [英] Does MySQL consume significantly more resouces compared to other DBMS?

问题描述

越来越多的趋势是从mysql转移到NOSQL，SQLite等等。我已经阅读了很多博客和文章，比较mysql的速度和其他类型的DBMS。但是，我相信速度不是mysql的问题，因为它是真的很快;但问题是与资源使用更多的连接。这是常见的面临极端的服务器负载由于mysql慢查询。例如，Oracle对mysql的一个优点是具有较少的与内存泄漏相关的问题。

1. 与其他数据库（例如SQLite，非关系数据库，键/值数据库）相比，显着更多资源（CPU和内存）。

如果是的话，明显是指不为大型数据库使用mysql的主要原因。 （到1），与Mysql相比，可以估计类似系统的更好的资源使用情况。

注意：考虑一个简单的系统，因为不需要mysql的高级功能。只需比较简单查询的性能。

解决方案

CPU和内存从来不是原因，因为它们便宜。问题是I / O速度。 NoSQL数据库用于写密集型应用程序以及需要无架构数据库的应用程序中（因为在MySQL中更改表模式会涉及重写表，这可能非常慢）。因此，一些折衷是优化磁盘操作，这通常导致消耗更多的CPU，内存或磁盘空间。

另一个原因可能是悲观vs乐观锁。这是另一个主题。

但是，由于问题是真的mysql消耗比其他数据库更多的资源（CPU和内存）是< > NO ，进一步讨论它是毫无意义的：）

There is a growing tendency for shifting from mysql to NOSQL, SQLite, etc. I have read many blogs and articles comparing the speed of mysql with other types of DBMS. However, I believe that speed is not a problem with mysql, as it is really fast; but the problem is more connected with resource usage. It is common to face extreme server load due to mysql slow queries. For instance, an advantage of Oracle over mysql is to have less problem associated with memory leaks.

1. Is it true that mysql consumes significantly more resources (CPU and memory) comparing with other databases such as SQLite, Non-relational databases, key/value databases. By significantly I mean is it the main reason for not using mysql for large databases (to save server costs).

2. If YES (to 1), what can be an estimate of better resource usage of a similar system like SQLite comparing with Mysql.

Note: Consider a simple system as advanced features of mysql is not needed. Just comparing the performance for simple queries.

解决方案

CPU and Memory never are the reason, as they are cheap. The problem is with the I/O speed. NoSQL databases are used in write-intensive applications, as well as in applications which need schema-less database (because changing the table schema in MySQL involves rewriting the table, which may be extremely slow). So some trade-offs are made to optimize the disk operations, which often lead to consuming more CPU, memory or disk space.

Another reason could be pessimistic vs optimistic locks. Which is another topic.

But since the answer to the question "Is it true that mysql consumes significantly more resources (CPU and memory) comparing with other databases" is NO, it is pointless to discuss it further :)

这篇关于与其他DBMS相比，MySQL消耗的资源明显多吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！