开发者

Best Linux filesystem for MySQL with a 100% SELECT workload

开发者 https://www.devze.com 2022-12-28 02:05 出处:网络
I have a MySQL database that contains millions of rows per table and there are 9 开发者_运维百科tables in total. The database is fully populated, and all I am doing is reads i.e., there are no INSERTs

I have a MySQL database that contains millions of rows per table and there are 9 开发者_运维百科tables in total. The database is fully populated, and all I am doing is reads i.e., there are no INSERTs or UPDATEs. Data is stored in MyISAM tables.

Given this scenario, which linux file system would work best? Currently, I have xfs. But, I read somewhere that xfs has horrible read performance. Is that true? Should I shift the database to an ext3 file system?

Thanks


What about a RAM disk?


it's not about the FS but it can improve your SELECTs. did you evaluated the mysql table partitioning ?

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号