[OSM-dev] Slow Osmosis
andreaskalsch at gmx.de
Wed Dec 3 15:47:49 GMT 2008
OK, I will create the tables as InnoDB tables directly, this is surely
Joachim Zobel schrieb:
"There is another approach. ALTER all InnoDb tables to
osmosis and then ALTER them back to InnoDb.
It seems that the INSERT approach scales badly to large InnoDb tables."
> "Be aware that an ALTER TABLE on MySQL (at least with InnoDb) always
> copies the table into the new strucure. If you do an ALTER TABLE ...
> ENGINE=InnoDb this is unavoidable. All other ALTER TABLE statements are
More information about the dev