Re: ARCHIVE storage engine and INSERT DELAY in MySQL 4.1
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. 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ARCHIVE storage engine and INSERT DELAY in MySQL 4.1
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 sure why they say that ARCHIVE storage engine is a new feature in 5.0? I had to take a double take, as I thought it was.. That could be why its not working 100%, as its actually a feature of 5.0. However, I am guessing that this point.. Jeff pgpv8zNukrx9v.pgp Description: PGP signature
Re: ARCHIVE storage engine and INSERT DELAY in MySQL 4.1
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 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 sure why they say that ARCHIVE storage engine is a new feature in 5.0? Mihail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ARCHIVE storage engine and INSERT DELAY in MySQL 4.1
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ARCHIVE storage engine and INSERT DELAY in MySQL 4.1
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 -- Mihail Manolov Government Liquidation, LLC Special Projects Leader 202 558 6227 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]