Home  >  Article  >  Database  >  mysql千万级数据库表优化?

mysql千万级数据库表优化?

WBOY
WBOYOriginal
2016-06-07 17:50:571140browse

2.数据项:是否有大字段,那些字段的值是否经常被更新;3.数据查询SQL条件:哪些数据项的列名称经常出现在WHERE、GROUP BY、ORDER BY子句中等;4.数据更新类SQL条件:有多少列经常出现UPDATE或DELETE 的WHERE子句中;

Statement:
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