"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@bfs.de> 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp