[OSM-dev] Slow Osmosis

Andreas Kalsch 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 
better ;)

Joachim Zobel schrieb:

"There is another approach. ALTER all InnoDb tables to 
MyISAM, run

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
> questionable."

More information about the dev mailing list