large .arn file filling up whole hard drive
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
Subject
Views
Written By
Posted
large .arn file filling up whole hard drive
4223
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.