不断变化的数据的最佳存储引擎 [英] Best storage engine for constantly changing data

问题描述

我当前有一个使用MyISAM存储引擎的130个MySQL表的应用程序.每个表每秒都有多个查询，包括选择/插入/更新/删除查询，因此数据和索引在不断变化.

I currently have an application that is using 130 MySQL table all with MyISAM storage engine. Every table has multiple queries every second including select/insert/update/delete queries so the data and the indexes are constantly changing.

我面临的问题是硬盘驱动器无法应对，MySQL进行如此多的读/写操作的等待时间长达6+秒.

The problem I am facing is that the hard drive is unable to cope, with waiting times up to 6+ seconds for I/O access with so many read/writes being done by MySQL.

我当时正在考虑只更改为1个表并使其基于内存.我从来没有用过内存表来处理这么多的查询，所以我想知道是否有人可以给我有关是否做正确的事情的反馈?

I was thinking of changing to just 1 table and making it memory based. I've never used a memory table for something with so many queries though, so I am wondering if anyone can give me any feedback on whether it would be the right thing to do?

推荐答案

我现在已更改为MEMORY表，并且一切都变得更好.实际上，我现在在服务器上有多余的备用资源，可以进一步扩展操作.

I've now changed to a MEMORY table and everything is much better. In fact I now have extra spare resources on the server allowing for further expansion of operations.

这篇关于不断变化的数据的最佳存储引擎的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！