Home > Database > Mysql Tutorial > mysql大数据表处理问题_MySQL

mysql大数据表处理问题_MySQL

WBOY
Release: 2016-06-01 13:14:14
Original
1103 people have browsed it

一台server上的mysql中有个表A非常大,增长非常快,而且读写很频繁,表A的读写会影响到整个数据库的性能。也用了cache。此外一般都用什么方案来解决这个问题? 

所想到的:

1、表A纵向拆到不同的server上;

2、表A必须也进行横向切换,因为一台是server总会装不下的。

3、MongoDB等来做表A的db?

求建议。

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template