mysql - calculate traffic for tmp tables I'm thinking of placing tmpdir to SSD - to increase speed of working with sorting data in tmp tables on disk. Our base creates a lot temporary tables on disk during sorting, merging, joining an so on. So, placing tmpdir to SSD is good idea, or it will die with our heavy load within 2 or 3 monthes? 

I simply want to get to calculate "traffic", being written by DB to tmpdir during some period of time (hour, day, etc), and using this value calculate "average" life of SSD. 

How can I do this?
Kingston SSD SH103S3/240G 
mysql-5.6 (900+ tables, 140Gb size of database) Debian-9
You can go 2 ways: logical and physical calculation.

PERFORMANCE_SCHEMA database has detailed io information about tables and file io. You may need to enable the right monitor metrics to get what you want.

For a physical path, there are multiple tools available. Separate your tmp dir on a different device (a temporary disk, a separate petition or if you cannot do anything else, a loop back device) and you can get detailed stats with some of the many standard Linux utilities or any of the higher level monitoring tools like Prometheus.