At the beginning of this year we lunched a lot of massive data deletions (millions of rows per week) in our production database. Also, there is an automatic integration of new data (insert/updates) of 10 to 25 .CSV files per day with a global/average size of
We noticed that reading performance on data even with full using of index became too slow. We have about
122GB of daya with
60GB of RAM and I configured
48GB for the
Innodb buffer pool (please check details in images).
Is the deletion affect buffer pool performance ? What is the best/fast way to resolve that issue ?
Thank you for your help.
It is not indexes (the use is about 90% - 100%) but the bad way the app is using the db model made is too bad.