11 Mar
2013
11 Mar
'13
12:31 p.m.
Hi, Said! On Mar 06, Said Ramirez wrote:
We have noticed a very strange index growth with one of our tables. The data in the table is currently ~ 42GB and has been growing at a rate of about 1 GB per day for the week. Inserts/Updates on the tables are done with statements like:
insert into foo ( ...) on duplicate key update ...
We have a job which updates about 1/3 of the table 12 times a day. We running Mariadb version 5.5.27-MariaDB-log
Just a guess, perhaps you have long-running transactions that prevent old row versions from being purged? Regards, Sergei