List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:October 19 2005 10:37pm
Subject:Re: ARCHIVE storage engine and INSERT DELAY in MySQL 4.1
View as plain text  
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


[gleb@blend mysql-debug-5.0.13-rc-linux-i686-glibc23]$ lmysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10 to server version: 5.0.13-rc-debug-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table ar(a int) engine=archive;
Query OK, 0 rows affected (0.02 sec)

mysql> insert delayed into ar set a=1;
Query OK, 1 row affected (0.01 sec)



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 am getting:
> 
> INSERT DELAYED INTO audit_log VALUES
> ('db','user','549220','address_id','757812','5214');
> 
> ERROR 1031 (HY000): Table storage engine for 'audit_log' doesn't have
> this option
> 
> 
> Mihail
> 
> 
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
ARCHIVE storage engine and INSERT DELAY in MySQL 4.1Mihail Manolov19 Oct
  • Re: ARCHIVE storage engine and INSERT DELAY in MySQL 4.1Gleb Paharenko21 Oct
Re: ARCHIVE storage engine and INSERT DELAY in MySQL 4.1Mihail Manolov19 Oct
Re: ARCHIVE storage engine and INSERT DELAY in MySQL 4.1Mihail Manolov19 Oct
  • Re: ARCHIVE storage engine and INSERT DELAY in MySQL 4.1Jeff Smelser20 Oct