Some article said the Mysql after partition in addition to the primary key index, don't need to add other index

If partition data is much, wouldn't it be slower

CodePudding user response:

Partition is to large files into small files, similar to open a big TXT file you open slowly, and then put large files into multiple small TXT, you open every quickly, but the table partitioning need to query request, try to get the query results in a partition, or query will be more slowly,

CodePudding user response:

Don't listen to theory to actual needs, but now that the partitions, as far as possible use partition, reduce query all partitions are true,