MYSQL Partitioning : What is and HOW To ?
eduguru 3 Comments fname VARCHAR(30), hired DATE NOT NULL DEFAULT '1970-01-01', How to mysql partition, job_code INT, learn mysql, lname VARCHAR(30), MySQL, mysql partition, MYSQL Partitioning : What is and HOW To ?, PARTITION p1 VALUES LESS THAN (1996), PARTITION p2 VALUES LESS THAN (2001), PARTITION p3 VALUES LESS THAN MAXVALUE ); This allows to speed up e.g.: Dropping old data by simple: ALTER TABLE employees DROP PARTITION p0; Database can speed up a query like this: SELECT COUNT(*) F, separated DATE NOT NULL DEFAULT '9999-12-31', store_id INT ) PARTITION BY RANGE ( YEAR(separated) ) ( PARTITION p0 VALUES LESS THAN (1991), The idea behind partitioning isn't to use multiple servers but to use multiple tables instead of one table. You can divide a table into many tables so that you can have old data in one sub table and n, What is mysql partition, you define how the data is partitioned. Simple example from the MySQL Documentation: CREATE TABLE employees ( id INT NOT NULL
The idea behind partitioning isn’t to use multiple servers but to use multiple tables instead of one table. You can
Read more