Re: ARCHIVE storage engine and INSERT DELAY in MySQL 4.1

[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 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
> 
> 
> do show create table audit_log, and post, plz.
> 
> Jeff

There you go:

CREATE TABLE `audit_log` (
   `db_host` varchar(64) NOT NULL default '',
   `table_name` varchar(255) NOT NULL default '',
   `record_id` int(11) NOT NULL default '0',
   `field_name` varchar(255) NOT NULL default '',
   `field_value` varchar(255) NOT NULL default '',
   `user` varchar(255) NOT NULL default ''
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1


Mihail