lto:bcantw...@firescope.com]
Sent: Wednesday, June 02, 2010 12:30 PM
To: mysql@lists.mysql.com
Subject: Fancy partitioning scheme
Perhaps someone has already accomplished this:
I have a simple table with 3 columns:
mytable(
myid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
myunixtime INT(11) NOT NU
Perhaps someone has already accomplished this:
I have a simple table with 3 columns:
mytable(
myid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
myunixtime INT(11) NOT NULL DEFAULT 0,
myvalue BIGINT(20) UNSIGNED NOT NULL DEFAULT 0
)
It is collecting millions of rows.
The myunixtime column is a un
