[Neo-users] Incompatible change in database schema

Vincent Pelletier vincent at nexedi.com
Thu Nov 4 18:05:51 CET 2010


Hi.

I just committed an incompatible table schema change, which should speed up 
replication a lot, packing a bit, and should not affect regular usage much.

It has not been tested yet, so the order of magnitude of those gains is not 
known yet.

To move to new schema without risks to existing data, you can run the 
following queries before switching to new code:

CREATE TABLE IF NOT EXISTS obj_short (
  partition SMALLINT UNSIGNED NOT NULL,
  oid BIGINT UNSIGNED NOT NULL,
  serial BIGINT UNSIGNED NOT NULL,
  PRIMARY KEY (partition, oid, serial)
) ENGINE = InnoDB;
INSERT INTO obj_short SLEECT partition, oid, serial FROM obj;

Regards,
-- 
Vincent Pelletier



More information about the Neo-users mailing list