June 20, 2013

Post: Quickly finding unused indexes (and estimating their size)

… into your working index_analysis schema. Merging stats from several servers In the …I simply created a view of a UNION DISTINCT of those two tables: mysql> create view used_indexes as…mysql> alter table mytable ENGINE=Innodb; However, this blocks and on a large table can take quite some time. All

Post: Distributed Set Processing with Shard-Query

view over a union of all the already joined and aggregated data from all …SQL, but right now only MySQL storage nodes are supported. Amdahl…computation over ICE, InnoDB, Vectorwise and other databases, all at the same …airport_id` * storage node result set merge optimization enabled: ON DUPLICATE KEY …