Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-keyring-keys-table.html
MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. Key metadata includes key IDs, key owners, and backend key IDs. The keyring_keys table does not expose ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-mutex-instances-table.html
The mutex_instances table lists all the mutexes seen by the Performance Schema while the server executes. A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to some common ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-replication-connection-status-table.html
GROUP_NAME If this server is a member of a group, shows the name of the group the server belongs to. This table shows the current status of the I/O thread that handles the replica's connection to the source, information on the last transaction ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-thread-filtering.html
The threads table contains a row for each server thread. The threads table also indicates for each server thread whether to perform historical event logging. Each row contains information about a thread and indicates whether monitoring is enabled ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-thread-pool-tables.html
Thus, the MySQL server holds the mutex of the thread group while producing the snapshot. But it does not hold mutexes on all thread groups at the same time, to prevent a statement against tp_thread_state from blocking the entire MySQL server. The ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-tp-thread-state-table.html
EXEC_COUNT: The accumulated number of queries (statements) passed to the server for execution. ACCUMULATED_EXEC_TIME: The wall clock time spent processing queries by the server. The tp_thread_state table has one row per thread created by the thread ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-transaction-summary-tables.html
Transaction event collection occurs for all non-aborted transactions initiated by the server, including empty transactions. However, presuming that only one isolation level would be used per server, aggregation by isolation level is not provided.
https://dev.mysql.com/doc/refman/9.7/en/permission-optimization.html
For example, if you do not grant any table-level or column-level privileges, the server need not ever check the contents of the tables_priv and columns_priv tables. Similarly, if you place no resource limits on any accounts, the server does not have ... The more complex your privilege setup, the more overhead applies to all SQL ...
https://dev.mysql.com/doc/refman/9.7/en/point-in-time-recovery.html
Typically, this type of recovery is performed after restoring a full backup that brings the server to its state as of the time the backup was made. (The full backup can be made in several ways, such as those listed in Section 9.2, “Database Backup ... Point-in-time recovery refers to recovery of data changes up to a given point in ...
https://dev.mysql.com/doc/refman/9.7/en/populating-spatial-columns.html
In a C program, you can escape a binary value using mysql_real_escape_string_quote() and include the result in a query string that is sent to the server. After you have created spatial columns, you can populate them with spatial data. Values should ...