maria-discuss team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxxx>]

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