MySQL Forums
Forum List  »  Archive Storage Engine

large .arn file filling up whole hard drive
Posted by: Florian Enzinger
Date: January 28, 2015 07:28AM

Hello,

I recently ran into an issue whit an archive table of about 1gb. When I try to get data from this table a large .arn file with up to 800gb is created on the server, using almost all space available.
This happens running mysql5.5.4 on ubuntu. I also have the same setup on another server (mysql5.0.38 on ubuntu) where I don't have this issue (thoug the archive there is ~8gb). On mysql5.0.38 there is no .arn but a .arm file that has only 19kb.

This is what the table looks like:

CREATE TABLE `importsuccess` (
`backup_id` int(10) unsigned NOT NULL,
`serial` varchar(36) NOT NULL,
`identifier` varchar(14) NOT NULL,
`sn_id` int(10) unsigned NOT NULL,
`sn` longtext NOT NULL,
`parsetime` bigint(20) unsigned NOT NULL DEFAULT '0',
`ts_import` datetime NOT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=utf8 PACK_KEYS=0;

Thanks for any help,
Flo

Options: ReplyQuote


Subject
Views
Written By
Posted
large .arn file filling up whole hard drive
3359
January 28, 2015 07:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.