PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-actors-table.html
The setup_actors table has these indexes: Primary key on (HOST, USER, ROLE) TRUNCATE TABLE is permitted for the setup_actors table. The setup_actors table contains information that determines whether to enable monitoring and historical event ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-consumers-table.html
The setup_consumers table has these indexes: Primary key on (NAME) TRUNCATE TABLE is not permitted for the setup_consumers table. For detailed information about the effect of enabling different consumers, see Section 29.4.7, “Pre-Filtering by ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-instruments-table.html
This affects primarily mutexes, conditions, and rwlocks in the server, although there may be other instruments for which this is true. The setup_instruments table has these indexes: Primary key on (NAME) TRUNCATE TABLE is not permitted for the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-threads-table.html
The setup_threads table has these indexes: Primary key on (NAME) TRUNCATE TABLE is not permitted for the setup_threads table. It exposes thread class names and attributes: mysql> SELECT * FROM performance_schema.setup_threads\G ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-socket-instances-table.html
The socket_instances table has these indexes: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (THREAD_ID) Index on (SOCKET_ID) Index on (IP, PORT) TRUNCATE TABLE is not permitted for the socket_instances table. The socket_instances table provides a ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-histogram-summary-tables.html
The statement histogram summary tables have these indexes: events_statements_histogram_by_digest: Unique index on (SCHEMA_NAME, DIGEST, BUCKET_NUMBER) events_statements_histogram_global: Primary key on (BUCKET_NUMBER) TRUNCATE TABLE is permitted for ... The Performance Schema maintains statement event summary tables that contain information about minimum, maximum, and average statement latency (see Section 29.12.20.3, “Statement Summary ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-handles-table.html
The table_handles table has these indexes: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME) Index on (OWNER_THREAD_ID, OWNER_EVENT_ID) TRUNCATE TABLE is not permitted for the table_handles table. The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-user-defined-functions-table.html
The user_defined_functions table has these indexes: Primary key on (UDF_NAME) TRUNCATE TABLE is not permitted for the user_defined_functions table. The user_defined_functions table contains a row for each loadable function registered automatically ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-user-variable-tables.html
The user_variables_by_thread table has these indexes: Primary key on (THREAD_ID, VARIABLE_NAME) TRUNCATE TABLE is not permitted for the user_variables_by_thread table. The Performance Schema provides a user_variables_by_thread table that exposes ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-users-table.html
The users table has these indexes: Primary key on (USER) . The users table contains a row for each user who has connected to the MySQL server. For each user name, the table counts the current and total number of connections. To set the table size ...