Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-memory-summary-tables.html
Operation counts help to understand or tune the overall pressure the server is putting on the memory allocator, which has an impact on performance. Allocating a single byte one million times is not the same as allocating one million bytes a single ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-metadata-locks-table.html
MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency; see Section 10.11.4, “Metadata Locking”. Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-quick-start.html
For example, use these lines in the server my.cnf file: [mysqld] performance_schema=ON When the server starts, it sees performance_schema and attempts to initialize the Performance Schema. This section briefly introduces the Performance Schema with ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-stage-tables.html
The Performance Schema instruments stages, which are steps during the statement-execution process, such as parsing a statement, opening a table, or performing a filesort operation. Stages correspond to the thread states displayed by SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-tables.html
Statement events occur at a high level of the event hierarchy. Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction events. These tables store statement events: ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-handles-table.html
The Performance Schema exposes table lock information through the table_handles table to show the table locks currently in effect for each opened table handle. This information shows which table handles the server has open, how they are locked, and ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-tables.html
Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction events. These tables store transaction events: events_transactions_current: The current transaction event for each ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-wait-tables.html
The Performance Schema instruments waits, which are events that take time. Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction events. These tables store wait events: ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-mysql-sock.html
For example, put the following lines in /etc/my.cnf: [mysqld] socket=/path/to/socket [client] socket=/path/to/socket See Section 6.2.2.2, “Using Option Files”. The default location for the Unix socket file that the server uses for communication ...
https://dev.mysql.com/doc/refman/8.4/en/proxy-users.html
The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking purposes. This enables the external user to be a proxy for the second user; that is, to assume the ...