Re: How to index a 1.5 billion rows

[Vladimir Pivovar]

Please tell me how to create new partitions after every n records into MySQL using the mechanism of partitioning?
I want after inserting each of the 25 millionth account was created a new section (which may have the counter start).
The id field is not present.
There is a field of type datetime (in unixtimestamp), the field offset (0 .. 220 million).
The offset field changes its value from 0 to 300 million when reading a new binary file

At the moment I have a table with the number of records = 2.7 billion from the data I want to smash it in sections to another table. Putting in long hand, but then the data will be inserted automatically on a schedule. Therefore it is necessary to specify the optimum criterion for partitioning automatically.