Original: MySQL Partitioning technology
There are two main types of optimizations for massive data:
the way of large table splitting table; optimization of SQL statements Partitioning Technology:similar to horizontal segmentation, but it is a horizontal table at the logical level, which is still a table for the application One, Range mode1. Create a partitioned table can be seen under/usr/local/mysql/var/test/to generate so many files (26) 2. Create an unpartitioned tableyou can see the generated 3 files under/usr/local/mysql/var/test/. 3. Establish Load_part_tab storage 4. Add 800W datause commands under/usr/local/mysql/var/test/: watch-n1 ls-lh Dynamically view dynamic changes in each partition of the inserted datause the top order to see the CPU and memory usage 5, in the non-partitioned table also insert so much data 6. Test SQL Performance To view the number of rows affected
Create an index test SQL Performance again Add non-indexed field query
MySQL Partitioning technology