The number of MySQL storage engines provide great flexibility for database users, administrators and developers. At the same time, engines add an extra level of complexity when it comes to troubleshooting issues. Before choosing the right troubleshooting tool, you need to answer the following questions (and often others):
- What part of the server is responsible for my issue?
- Was a lock set at the server or engine level?
- Is a standard or engine-specific tool better?
- Where are the engine-specific options?
- How to know if an engine-specific command exists?
My next webinar, Introduction to troubleshooting storage engines, will discuss these questions and how to find the right answers across all storage engines in a general sense.
You will also learn:
- How to troubleshoot issues caused by simple storage engines such as MyISAM or Memory
- Why Federated is deprecated, and what issues affected that engine
- How Blackhole can affect replication
. . . and more.
Note: We will hold a separate webinar specifically for InnoDB.