← Back to team overview

maria-discuss team mailing list archive

Re: Performace issue with insert

 

what mariadb and mysql version?

2016-01-27 17:05 GMT-02:00 Tom Worster <fsb@xxxxxxxxxx>:

> Hi wh,
>
> If a table has any indexes then inset time increases with the number of
> records in the table. Even with only one index, the difference between
> inserting when the table is nearly empty and when it has many millions of
> records can be dramatic.
>
> If you have some understanding of how conventional indexes work then this
> effect can become fairly easy to imagine.
>
> Tom
>
> On 1/27/16, 5:27 AM, "Maria-discuss on behalf of walter harms"
> <maria-discuss-bounces+fsb=thefsb.org@xxxxxxxxxxxxxxxxxxx on behalf of
> wharms@xxxxxx> wrote:
>
> >Hello list,
> >i have a strange problem with inserts.
> >The tables is large (time series data) and has a
> >lot of partitions, engine is IMMODB.
> >We have notice that the write performance decreases with
> >time, start of the month good, end of the month bad.
> >
> >The same behavier is the lasted version of mariadb.
> >But when i replace mariadb with mysql the problems vanishes
> >(so its not a hardware issue). I suspect that it is a caching
> >problem but a comparison of the configs did not give a hint.
> >Anyone an idea what may cause the effect ?
> >
> >
> >re,
> > wh
> >
> >_______________________________________________
> >Mailing list: https://launchpad.net/~maria-discuss
> >Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> >Unsubscribe : https://launchpad.net/~maria-discuss
> >More help   : https://help.launchpad.net/ListHelp
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>



-- 
Roberto Spadim
SPAEmpresarial - Software ERP
Eng. Automação e Controle

Follow ups

References