PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-mutex-instances-table.html
The setup_instruments table lists the name of the instrumentation point, with the prefix wait/synch/mutex/. The mutex_instances table lists all the mutexes seen by the Performance Schema while the server executes. A mutex is a synchronization ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-prepared-statements-instances-table.html
For a prepared statement created by a stored program, these columns point to the stored program. The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary protocol. This is accessed ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-setup-instruments-table.html
At this point, the real statement type is unknown, the type will be refined after SQL parsing. The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM ...
https://dev.mysql.com/doc/refman/9.7/en/plugin-loading.html
However, removing options for a plugin from the my.cnf file may not be sufficient to uninstall it if at some point INSTALL PLUGIN has also been used. Server plugins must be loaded into the server before they can be used. It is also possible to ...
https://dev.mysql.com/doc/refman/9.7/en/privilege-changes.html
The in-memory tables become effective for access control at that point. If the mysqld server is started without the --skip-grant-tables option, it reads all grant table contents into memory during its startup sequence. If you modify the grant ...
https://dev.mysql.com/doc/refman/9.7/en/problems-with-null.html
For example, if you insert NULL into an integer or floating-point column that has the AUTO_INCREMENT attribute, the next number in the sequence is inserted. The concept of the NULL value is a common source of confusion for newcomers to SQL, who ...
https://dev.mysql.com/doc/refman/9.7/en/query-attributes.html
Attributes exist until statement execution ends, at which point the attribute set is cleared. The most visible part of an SQL statement is the text of the statement. Clients can also define query attributes that apply to the next statement sent to ...
https://dev.mysql.com/doc/refman/9.7/en/rename-table.html
Foreign key constraint names that point to the renamed table are automatically updated unless there is a conflict, in which case the statement fails with an error. RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ... You must ...
https://dev.mysql.com/doc/refman/9.7/en/replica-io-thread-states.html
At that point, the thread considers the connection to be broken and makes an attempt to reconnect. The following list shows the most common states you see in the State column for a replication I/O (receiver) thread on a replica server. This state ...
https://dev.mysql.com/doc/refman/9.7/en/replica-logs-status.html
Then you can use a CHANGE REPLICATION SOURCE TO statement with the SOURCE_LOG_FILE and SOURCE_LOG_POS options to tell the replica to re-read the binary logs from the source from that point (provided that the required binary logs still exist on the ... A replica server creates two replication metadata repositories, the connection metadata repository and the applier metadata ...