maria-discuss team mailing list archive
Mailing list archive
Re: unexpected index growth
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?