Assuming a production OLTP system with predominantly InnoDB tables
- What are the common symptoms of a mistuned/misconfigured system?
- What configuration parameters do you most commonly change from their defaults?
- How do you spot potential bottlenecks before there is a problem?
- How do you recognize and troubleshoot active problems?
Any anecdotes detailing specific
status variables and diagnostics would be appreciated.