In this chapter, we will discuss the basic techniques that can be used to find problems in the MariaDB server and in SQL statements. The following are some of the basic tools and techniques used:
Error conditions
The diagnostics area
The error log
The general query log
Maintaining logs
The
SQL_ERROR_LOG
pluginDebugging of stored programs