哪种MySQL数据库引擎更适合存储会话和会话数据:MyISAM或InnoDB? [英] Which MySQL database engine is better for storing sessions and session data: MyISAM or InnoDB?

问题描述

一个非常简单的问题.

Pretty straightforward question.

出于某些原因，我将InnoDB用于其他所有功能.对于高流量"表，它对MyISAM的性能有影响吗?

I use InnoDB for everything else, for a couple of reasons. Is it a performance hit over MyISAM for a 'high-traffic' table?

推荐答案

由于您所看到的读写流量相当均匀，因此InnoDB是更好的选择. MyISAM在每次写入时的全表锁定可能是谋杀. MyISAM在90％以上的读取或90％以上的写入情况下表现更好.

Since you're looking at a pretty even mix of read/write traffic, InnoDB is the better choice. MyISAM's full-table locks on every write would probably be murder. MyISAM fairs better with 90%+ read or 90%+ write situations.

我相信高性能MySQL

这篇关于哪种MySQL数据库引擎更适合存储会话和会话数据:MyISAM或InnoDB?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！