mysql分区

Question

对数据库优化方面不是太熟悉，最近一直在学。
mysql的分库、分表技术很多公司都已经在用了。mysql的分区出来好像也有很长一段时间了，想问下，分区技术用的多不多，相比分库分表来说，有什么优势？

Answer 1

To put it simply, partitioning is to split the data of a table into N blocks, and each block stores different data. Then read the content in the specified block according to the rules.
For example, SQLselect * from table where column=? reads the data in the specified block based on column. When the amount of data is large, partitioning can speed up the process. that's all.