development:database:mysql:partition
Differences
This shows you the differences between two versions of the page.
| development:database:mysql:partition [2024/08/06 06:59] – created - external edit 127.0.0.1 | development:database:mysql:partition [2024/08/06 08:58] (current) – 113.190.232.2 | ||
|---|---|---|---|
| Line 3: | Line 3: | ||
| Table > 2G cần đánh partition, mỗi partition tầm 100K - 2M rows, Select chỉ rõ Partition, dùng local index | Table > 2G cần đánh partition, mỗi partition tầm 100K - 2M rows, Select chỉ rõ Partition, dùng local index | ||
| - | <code> | + | <file sql> |
| SELECT | SELECT | ||
| PLUGIN_NAME as Name, | PLUGIN_NAME as Name, | ||
| Line 249: | Line 249: | ||
| INSERT INTO transactions_1 SELECT * FROM transactions; | INSERT INTO transactions_1 SELECT * FROM transactions; | ||
| - | </code> | + | </file> |
development/database/mysql/partition.1722927590.txt.gz · Last modified: 2024/08/06 06:59 by 127.0.0.1