Re: ARCHIVE storage engine and INSERT DELAY in MySQL 4.1

2005-10-21 Thread Gleb Paharenko
Privet! It works in 5.0.13. But for a pity not in 4.1.14. I've reported a bug, you may want to add your comments at: http://bugs.mysql.com/bug.php?id=14153 [EMAIL PROTECTED] mysql-debug-5.0.13-rc-linux-i686-glibc23]$ lmysql Welcome to the MySQL monitor. Commands end with ; or \g. You

Re: ARCHIVE storage engine and INSERT DELAY in MySQL 4.1

2005-10-20 Thread Jeff Smelser
On Wednesday 19 October 2005 04:34 pm, Mihail Manolov wrote: > It's the way our code is written, and I just changed the table type and > began getting this error. We have lots of data to insert into this > table, therefore the optimal option is to use DELAYED and insert them in > blocks. > > Not s

Re: ARCHIVE storage engine and INSERT DELAY in MySQL 4.1

2005-10-19 Thread Mihail Manolov
Jeff Smelser wrote: I would highly suspect this is a bug.. I would submit one.. unless someone else knows better.. Not real sure why you really need delayed, archive is suppose to be much faster on inserts then even myisam. Jeff Thanks Jeff! It's the way our code is written, and I just

Re: ARCHIVE storage engine and INSERT DELAY in MySQL 4.1

2005-10-19 Thread Mihail Manolov
Jeff Smelser wrote: On Wednesday 19 October 2005 01:18 pm, Mihail Manolov wrote: Apparently ARCHIVE tables do not support INSERT DELAYED. Why? In documentation (http://dev.mysql.com/doc/refman/4.1/en/archive-storage-engine.html) it says that it should be possible. Example of the error that I