Re: Archive Engine Question

2013-09-19 Thread Tim Callaghan
If you are looking for great compression another option is TokuDB. It supports quicklz, zlib, and lzma compression. On Wed, Sep 18, 2013 at 2:30 AM, Manuel Arostegui wrote: > 2013/9/17 Wayne Leutwyler > > > Hello List, > > > > I have a customer who is wanting to use the Archive Engine. I have

Re: Archive Engine Question

2013-09-17 Thread Manuel Arostegui
2013/9/17 Wayne Leutwyler > Hello List, > > I have a customer who is wanting to use the Archive Engine. I have no > experience with this engine, other than what I am been reading. Why would I > want to use Archive over InnoDB. They are only going to be placing audit > information in the table.

Re: Archive Engine Question

2013-09-17 Thread Wayne Leutwyler
Yea, the more I think about it the more it makes good sense. Are there any special my.cnf setting we should be looking at. We currently have our systems tuned for InnoDB as our primary engine. Thanks for the feedback Keith. On Sep 17, 2013, at 11:34 AM, Keith Murphy wrote: > From here: > >

Re: Archive Engine Question

2013-09-17 Thread Keith Murphy
>From here: http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html The ARCHIVE engine supports INSERT and SELECT , but not DELETE

Re: archive engine potential bug

2007-09-11 Thread Rob
also when it hits a dupl. and i skip the record, and continue slave it hits another duplicate entry almost instantly, when i then drop the table on the slave, and recreate it manually and set it to myisam at that time, the slave continues without a problem. On Tue, 2007-09-11 at 16:42 +0200, WiNK

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

Re: archive data

2003-11-20 Thread Paride De Gasperis
Copy database directory in another location (ex. /db/data). This path must contains your databases directories... /db --- /data --- /mysql --- data file... --- data file... --- data file... --- data file... --- /test --- /YourDB1 ---

RE: Archive on remote Machine.

2003-02-19 Thread Chris Faust
You could just ftp them wherever you want for storage. I made a simple script where I took the provided "mysqlhotcopy" script, added it and used it every day as a cron to make a copy of all my databases, then run through a check of each one then tar them all up and ftp them to a remote server. It

Re: Archive on remote Machine.

2003-02-19 Thread Charles Lewis
If you have ssh installed on your target machine couldn't you do the following? mysqldump | scp @:. KH Chiu wrote: It will then be a networking problem. As far as I know, you may need a networking file system like NFS or Samba. You should mount your remote machine as a network drive. Then

Re: Archive on remote Machine.

2003-02-19 Thread KH Chiu
It will then be a networking problem. As far as I know, you may need a networking file system like NFS or Samba. You should mount your remote machine as a network drive. Then you can use mysqldump to make a backup but redirect the output to the network drive. There may be other methods. In fact

Re: Archive on remote Machine.

2003-02-18 Thread KH Chiu
You may try the following command mysqldump -u -p samp_db | mysql -h samp_db -u -p Please also note that samp_db must be exist on your remote machine. Of course, you should sub. samp_db with your to be achieve database name. Regards, > Hi, > I use Select * into outfile "filepath" from

re: Archive on remote Machine.

2003-02-18 Thread Victoria Reznichenko
On Tuesday 18 February 2003 12:51, Ahmed S K Anis wrote: > I use Select * into outfile "filepath" from table to archive the > database. > Is there any way to archive this into a different machine. (Not current > machine) > > Yes Mapping to new machine and then giving path is an option. Any oth

Re: Archive and retrieval in MySQL

2003-01-13 Thread Stefan Hinz, iConnect \(Berlin\)
Ahmed, > 1. How can i trigger a database archive when a certain data base limit > is reached in a table. > Ex: when 1,00,000 records is reached, archive to file and clean table. You will have to wait for MySQL 5.0. This version will have SQL triggers. > 2. How can i restore multiple files into d

RE: Archive of this mysql list

2002-10-03 Thread Sqlcoders.com Programming Dept
Ahem, have a look at the bottom of any post to the list: Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) :) HTH, William. > -Original Message- > From: Chris Becker [mailto:[EMAIL PROTECTED]] > Sent:

RE: Archive of this mysql list

2002-10-03 Thread Andrew Braithwaite
Yep, It's here http://www.mysql.com/documentation/searchlists.html Cheers, Andrew Sql,query -Original Message- From: Chris Becker [mailto:[EMAIL PROTECTED]] Sent: Friday, 04 October 2002 00:43 To: [EMAIL PROTECTED] Subject: Archive of this mysql list >Is there an archive of

Re: Archive

2001-02-28 Thread Gerald L. Clark
kentj wrote: > > Is there an archive for this mailing list? > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this

Re: Archive?

2001-02-18 Thread Jeremy D. Zawodny
On Sun, Feb 18, 2001 at 12:41:01AM -0500, Michael Fischer wrote: > > Hello, > > is there a browseable archive for this list? > > I would as soon look it over, if it exists, before > posting what may be an FAQ. Are you looking for something other than the archive which is mentioned in the foote

Re: archive of old mails in lists?

2001-01-17 Thread Tobias Talltorp
To: "Richard Ellerbrock" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 18, 2001 2:32 AM Subject: Re: archive of old mails in lists? > Actually it doesn't give the exact URL and it is a little hard to find from > the home p

Re: archive of old mails in lists?

2001-01-17 Thread Rolf Hopkins
e - From: "Richard Ellerbrock" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, January 17, 2001 22:06 Subject: Re: archive of old mails in lists? > Read the footer of EVERY message sent to the mysql list Including this one. >

Re: archive of old mails in lists?

2001-01-17 Thread Richard Ellerbrock
Read the footer of EVERY message sent to the mysql list Including this one. -- Richard Ellerbrock [EMAIL PROTECTED] >>> "Tomas Mas-Esteve (ECE)" <[EMAIL PROTECTED]> 2001/01/17 03:51:45 >>> Hello, is a archive where all the mails sent to mysql list are stored? if yes, where is the archive and