MySQL Partitioning

[assuncao]

Have anyone here tried to use mysql partitioning with mailwizz? Does it work well? Currently my table list_field_value contains 127 millions of rows. Is there any recommendation about how to gain performance? My MW is getting progressively slower.

 

[twisted1919]

@Erik Figueiredo - Yes, partitioning might help a lot in this case. I advise talking with a database expert though.

 

[frm.mwz]

Have anyone here tried to use mysql partitioning with mailwizz? Does it work well? Currently my table list_field_value contains 127 millions of rows. Is there any recommendation about how to gain performance? My MW is getting progressively slower.

To find suitable partitioning keys, you could sort by key use frequency.