maria-discuss team mailing list archive

[Peter Laursen <peter_laursen@xxxxxxxxxx>]

"We have notice that the write performance decreases with
time, start of the month good, end of the month bad."

Do you happen to partition BY MONTH? if so it looks like the more the
latest partition grows the slower it becomes.I am no expert in this but I
think you should post the CREATE TABLE for this table. You should also tell
the exact MariaDB and MySQL versions you have tried ("SELECT version();").

-- Peter
-- not a MariaDB person

On Wed, Jan 27, 2016 at 11:27 AM, walter harms <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
>