One role of a MySQL consultant is to review an existing production system. Sometimes you have sufficient time and access, and other times you don’t. If I am given a limited time here is a general list of things I look at.

Review Server architecture, OS, Memory, Disks (including raid and partition type), Network etc
Review [...]