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/partitioning-limitations.html
This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. For a list of ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-stages-current-table.html
For example, the events_stages_history and events_stages_history_long tables are collections of the most recent stage events that have ended, up to a maximum number of rows per thread and globally across all threads, respectively. Instrument names ...The table stores one row per thread showing the current status of the thread's most recent monitored stage event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-naming.html
Memory instruments have names of the form memory/code_area/instrument_name where code_area is a value such as sql or myisam, and instrument_name is the instrument detail. Stage Instrument Elements Stage instruments have names of the form ... An ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-memory-summary-tables.html
CURRENT_COUNT_USED The aggregated number of currently allocated blocks that have not been freed yet. CURRENT_NUMBER_OF_BYTES_USED The aggregated size of currently allocated memory blocks that have not been freed yet. The memory summary tables have ...Operation counts help to understand or tune the overall pressure the server is putting on the memory allocator, which has an impact on ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-processlist-table.html
If you have the PROCESS privilege, you can see all threads, even those belonging to other users. Otherwise (without the PROCESS privilege), nonanonymous users have access to information about their own threads but not threads for other users, and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-group-member-stats-table.html
Once the transactions have been checked for conflicts, if they pass the check, they are queued to be applied as well. COUNT_TRANSACTIONS_CHECKED The number of transactions that have been checked for conflicts. COUNT_CONFLICTS_DETECTED The number of ...The replication_group_member_stats table has these columns: CHANNEL_NAME Name of the Group Replication channel VIEW_ID Current view identifier for this ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-monitoring.html
Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be loaded. Other mutexes have an instance per connection, or per page in various caches and data buffers, so the ...Performance_schema_xxx_instances_lost indicates how many instances of object type xxx could not be ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-characteristics.html
Some of the setup tables have columns that can be modified to affect Performance Schema operation; some also permit rows to be inserted or deleted. That might be useful, for example, after you have made a runtime configuration change. Privileges are ... The name of the performance_schema database is lowercase, as are the names of tables within ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-tp-thread-group-stats-table.html
PRIO_KICKUPS The number of statements that have been moved from low-priority queue to high-priority queue based on the value of the thread_pool_prio_kickup_timer system variable. STALLED_QUERIES_EXECUTED The number of statements that have become ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-storage-common-layer.html
A major benefit of using specific storage engines is that you are only delivered the features needed for a particular application, and therefore you have less system overhead in the database, with the end result being more efficient and higher ... A ...