Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-connections-pages-database-processes.html
Current Statement The statement the thread is executing, or NULL if it is not executing any statement. Full Scan The number of full table scans performed by the current statement. Last Statement The last statement executed by the thread, if there is ...Important This report retrieves data from the processlist view of the sys ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-processes-category.html
Full Scan Did the currently running SQL statement for this process cause a full table scan? YES/NO. Last Statement The previous SQL statement ran by this process, if no SQL statement is currently running. Last Statement Latency Latency of the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-qanal-using-performance-schema.html
Query Analyzer data is automatically collected and displayed by monitoring MySQL Server 5.6.14 or greater, using the Performance Schema Statement Digests feature (Performance Schema Statement Digests and Sampling) added in MySQL 5.6. Note It is not ...Note The maximum space available for digest computation is 1024 bytes by default; queries exceeding this length are ...
https://dev.mysql.com/doc/refman/8.4/en/locking-functions.html
For example, suppose that you execute these statements: SELECT GET_LOCK('lock1',10); SELECT GET_LOCK('lock2',10); SELECT RELEASE_LOCK('lock2'); SELECT RELEASE_LOCK('lock1'); The second GET_LOCK() acquires a second lock and both RELEASE_LOCK() calls ...While held by one session, other sessions cannot obtain a lock of the same ...
https://dev.mysql.com/doc/refman/8.4/en/partial-revokes.html
Using Partial Revokes Partial Revokes Versus Explicit Schema Grants Disabling Partial Revokes Partial Revokes and Replication Note For brevity, CREATE USER statements shown here do not include passwords. As mentioned previously, partial revokes of ... It is possible to grant privileges that apply globally if the partial_revokes system variable is ...
https://dev.mysql.com/doc/refman/8.4/en/query-log.html
The server writes information to this log when clients connect or disconnect, and it logs each SQL statement received from clients. mysqld writes statements to the query log in the order that it receives them, which might differ from the order in ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-functions.html
(See Section 19.2.1, “Replication Formats”.) USER() and CURRENT_USER() are automatically replicated using row-based replication when using MIXED mode, and generate a warning in STATEMENT mode. For this reason, if you select from the replica's ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
Resource Group Elements These capabilities provide the SQL interface for resource group management in MySQL: SQL statements enable creating, altering, and dropping resource groups, and enable assigning threads to resource groups. Resource group ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-session-track-get-first.html
The characteristics tracker data string may be empty, or it may contain one or more SQL statements, each terminated by a semicolon: If no characteristics apply, the string is empty. (For isolation level and access mode, these defaults are given by ... int mysql_session_track_get_first(MYSQL *mysql, enum enum_session_state_type type, const char **data, size_t *length) Description MySQL implements a session tracker mechanism whereby the server returns information about session state changes to ...
https://dev.mysql.com/doc/connectors/en/connector-python-coding.html
This is especially important for columns that make up the primary key for an InnoDB table, because those column values are duplicated within each secondary index. For example, input values might contain quotation marks, semicolons, % and _ wildcard ... The following guidelines cover aspects of developing MySQL applications that might not be immediately obvious to developers coming from a Python background: For security, do not hardcode the values needed to connect and log into the database in your main ...