The longevity of SSDs is largely determined by the amount of bytes written by insert, update and delete operations. What is the best way to accurately determine how much data is being written by MariaDB 5.5 on a daily basis so that I can use this to estimate the possible longevity of SSDs if used in a heavy write database environment?
Current setup is that all tables are InnoDB. Can I use
Uptime to determine a rough idea of bytes written per day, or is there a better way of doing it?