Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-objects-table.html
The setup_objects table controls whether the Performance Schema monitors particular objects. This table has a maximum size of 100 rows by default. To change the table size, modify the performance_schema_setup_objects_size system variable at server ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-tables.html
These setup tables are available: setup_actors: How to initialize monitoring for new foreground threads setup_consumers: The destinations to which event information can be sent and stored setup_instruments: The classes of instrumented objects for ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-startup-configuration.html
For example, use these lines in the server my.cnf file: [mysqld] performance_schema=ON If the server is unable to allocate any internal buffer during Performance Schema initialization, the Performance Schema disables itself and sets ... To use the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variables.html
Statements differing only after that many initial bytes are indistinguishable in the column. The Performance Schema automatically sizes the values of several of its parameters at server startup if they are not set explicitly. Performance Schema ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-reference.html
The following table summarizes all available Performance Schema tables. For greater detail, see the individual table descriptions. Table 29.1 Performance Schema Tables Table Name Description accounts Connection statistics per client account ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-timing.html
The timer baseline (“time zero”) occurs at Performance Schema initialization during server startup. Events are collected by means of instrumentation added to the server source code. Instruments time events, which is how the Performance Schema ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-summary-tables.html
Transaction event collection occurs for all non-aborted transactions initiated by the server, including empty transactions. The Performance Schema maintains tables for collecting current and recent transaction events, and aggregates that ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-variables-info-table.html
The default is the time at which the server initialized global system variables during startup. The variables_info table shows, for each system variable, the source from which it was most recently set, and its range of values. VARIABLE_SOURCE The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema.html
When there is a choice between performing processing during event collection initially or during event retrieval later, priority is given to making collection faster. The MySQL Performance Schema is a feature for monitoring MySQL Server execution ...
https://dev.mysql.com/doc/refman/8.4/en/proxy-users.html
The initial root account created during MySQL installation has the PROXY ... 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 ...