Re: Replication advise

2008-05-16 Thread Rob Wultsch
On Fri, May 16, 2008 at 6:44 AM, Ben Clewett <[EMAIL PROTECTED]> wrote: > Looking at EXPLAIN PARTITIONS I have noticed that these SQL statement > correctly select the partition: > > SELECT WHERE t = > SELECT WHERE t IN > > But these select all partition tables: > > SELECT WHERE t > > SELECT WHE

Replication advise

2008-05-16 Thread Ben Clewett
Dear MySql, Hope somebody might give some advise about replication! On 5.1.24, I have something simple like: CREATE TABLE big_f_er ( id BIGINT UNSINGED NOT NULL AUTO_INCREMENT, t TIMESTAMP NULL NOT NULL, PRIMARY KEY (id, t), KEY (t) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 PARTITION BY RA