Andrey, it is not a bug. Monty wanted to avoid some changes in 3.23 and decided to do 'delete from a' with individual row deletes if InnoDB is defined. In 4.0 you should use TRUNCATE TABLE to empty a table, and it works fast for all table types.
Regards, Heikki http://www.innodb.com/ibman.html >Hi! >I run now mysql 3.23.42 >If I run mysqld without --skip-innodb >Then query "delete from a;" run so slow (but the table is MYISAM!!!) >Why? Is it a bug or no? > >> check the command line option -d (or --no-data) >> >> > -----Original Message----- >> > From: Barry McClure [mailto:barry [EMAIL PROTECTED]] >> > Sent: Wednesday, October 03, 2001 1:45 AM >> > To: [EMAIL PROTECTED] >> > Subject: --How to dump only table structure with MySQLDump? >> > >> > >> > I would like to extract the DDL for the database so I can re-run >> > it elsewhere. >> > MySQLDump can do that, but it also exports the data. Is there a >> > way for it >> > to just export the Create Table statements? >> > >> > TIA >> > >> > Barry >> > >> > --------------------------------------------------------------------- >> > Before posting, please check: >> > http://www.mysql.com/manual.php (the manual) >> > http://lists.mysql.com/ (the list archive) >> > >> > To request this thread, e-mail <[EMAIL PROTECTED]> >> > To unsubscribe, e-mail >> > <[EMAIL PROTECTED]> >> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> > >> > >> >> --------------------------------------------------------------------- >> Before posting, please check: >> http://www.mysql.com/manual.php (the manual) >> http://lists.mysql.com/ (the list archive) >> >> To request this thread, e-mail <[EMAIL PROTECTED]> >> To unsubscribe, e-mail <[EMAIL PROTECTED]> >> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> >> > > Best regards. > > Andrey Kotrekhov [EMAIL PROTECTED] > ISP Alkar Teleport > ???. +380 562 34-00-44 > > >--------------------------------------------------------------------------- ----- > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
