← Back to team overview

maria-discuss team mailing list archive

Re: unexpected index growth


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?


Follow ups