Nov 8, 2018

Things to look for in production problems

Check process of database

Check disk full of the server

Narrow down the problem.

*-slow.log in /var/lib/mysql

Pay attention to max_allowed_packet when exporting and importing data. Typical setting could be --max_allowed_packet=1G