|
InnoDB made MyIsam DELETE's slow: msg#01114db.mysql.general
Hello, Our problem is that the speed of DELETE's became very slow after installing InnoDB. For MyISAM, the table data file is just truncated to 0 after DELETE FROM table; isn't it? But it seems that system scans the whole table - and file is not truncating. We have MySQL 3.23.48 running on FreeBSD 4.4 with LinuxThreads installed. May be it's because of LinuxThreads? Thank you, Dino --------------------------------------------------------------------- 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 <mysql-thread113363@xxxxxxxxxxxxxxx> To unsubscribe, e-mail <mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php |
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | RE: Increasing number of open_files -- no takers on this one?: 01114, Sam Taylor |
|---|---|
| Next by Date: | Re: RecordCount: 01114, Ramiro Varandas Jr. |
| Previous by Thread: | Fwd: Re: Foreign keyi: 01114, Elby Vaz |
| Next by Thread: | Re: InnoDB made MyIsam DELETE's slow: 01114, Dan Nelson |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
| News | FAQ | advertise |