Performance Schema Table Descriptions Tables in the performance_schema database can be grouped as follows: • Setup tables. These tables are used to configure and display monitoring characteristics. • Current events table. The events_waits_cu...
Performing DML and DDL Statements on the Underlying InnoDB Table You can access the InnoDB table (by default, test.demo_test) through the standard SQL interfaces. However, there are some restrictions: • When query a table through SQL that is also...
Physical Characteristics of MEMORY Tables The MEMORY storage engine associates each table with one disk file, which stores the table definition (not the data). The file name begins with the table name and has an extension of .frm. MEMORY tables have the following characteristics: • Space for MEM...
Potential hosts file issues. A common problem when trying to use host names for Cluster nodes arises because of the way in which some operating systems (including some Linux distributions) set up the system's own host name in the /etc/hosts during installation. Consider two machines with the host...
Pre Filtering by Thread The threads table contains a row for each server thread. Each row contains information about a thread and indicates whether monitoring is enabled for it. For the Performance Schema to monitor a thread, these things mu...
Preventing execution of unsupported statements. In order to prevent execution of statements that would cause GTID-based replication to fail, all servers must be started with the --enforcegtid- consistency [2056] option when enabling GTIDs. This causes statements of any of the types discussed prev...
Problems from Tables Not Being Closed Properly Each MyISAM index file (.MYI file) has a counter in the header that can be used to check whether a table has been closed properly. If you get the following warning from CHECK TABLE or myisamchk, it m...
Quick Test Setup of MySQL Cluster To familiarize you with the basics, we will describe the simplest possible configuration for a functional MySQL Cluster. After this, you should be able to design your desired setup from the information provided in the other relevant sections of this chapter. Fir...
RBL nontransactional tables, and stopped slaves. When using row-based logging, if the slave server is stopped while a slave thread is updating a nontransactional table, the slave database may reaches an inconsistent state. For this reason, it is recommended that you use a transactional storage en...
RBL, RBR, and temporary tables. As noted in Section 16.4.1.22, “Replication and Temporary Tables”, temporary tables are not replicated when using row-based format. When mixed format is in effect, “safe” statements involving temporary tables are logged using statement-based format. For more inform...
