On Mar 10, 2008, at 15:43, Mark Smith wrote: > AFAIK this trick doesn't work on InnoDB, since they use a flat > tablespace TRUNCATE just maps to DELETE FROM anyway. It does if you use the (recommended) innodb_file_per_table configuration... - ask -- http://www.askbjoernhansen.com/