Embedded server with the archive storage engine

2006-10-22 Thread imre
Hi, Is it possible to use the embedded server with the archive storage engine (version 5.0.24a)? I tried to build it on windows with VS2005, and encountered a few problems. After I managed to build it, I had an assertion failure in a file close operation. I built libmysqld in the following way

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
; 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

2005-10-19 Thread Mihail Manolov
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 Lis

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

ARCHIVE storage engine and INSERT DELAY in MySQL 4.1

2005-10-19 Thread Mihail Manolov
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

Archive storage engine

2004-11-16 Thread Garrett Kajmowicz
When would a person want to use the archive storage engine? Would it suitable for output an audit log to? What happens if I insert into such a table in the middle of a transaction? Thanks for the info. - Garrett -- MySQL General Mailing List For list archives: http://lists.mysql.com