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-maintenance.html
If you have deleted a large number of rows from a partition or if you have made many changes to a partitioned table with variable-length rows (that is, having VARCHAR, BLOB, or TEXT columns), you can use ALTER TABLE ... A number of table and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-connection-tables.html
The users and hosts tables have a USER and HOST column, respectively, to track connections per user name and host name. It has these effects: Rows are removed for accounts, hosts, or users that have no current connections (rows with ... When a ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-statements-current-table.html
For example, the events_statements_history and events_statements_history_long tables are collections of the most recent statement events that have ended, up to a maximum number of rows per thread and globally across all threads, respectively. The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-waits-current-table.html
For example, the events_waits_history and events_waits_history_long tables are collections of the most recent wait events that have ended, up to a maximum number of rows per thread and globally across all threads, respectively. Instrument names may ...The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-quick-start.html
The history tables contain the same kind of rows as the current-events table but have more rows and show what the server has been doing “recently” rather than “currently.” The events_waits_history and events_waits_history_long tables contain ... This section briefly introduces the Performance Schema with examples that show how to use ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-tables.html
At this time, there are no active replication threads, so the THREAD_ID columns are NULL and the SERVICE_STATE columns have a value of OFF. Threads that are idle or active have a SERVICE_STATE value of ON. After STOP REPLICA, the THREAD_ID columns ...This is similar to the information available from the SHOW REPLICA STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW REPLICA STATUS output is useful for visual inspection, but not so much for programmatic ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-socket-instances-table.html
row *************************** EVENT_NAME: wait/io/socket/sql/server_tcpip_socket OBJECT_INSTANCE_BEGIN: 4316699040 THREAD_ID: 1 SOCKET_ID: 14 IP: 0.0.0.0 PORT: 50603 STATE: ACTIVE Socket instruments have names of the form ... The socket_instances ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-histogram-summary-tables.html
Each statement histogram summary table has these summary columns containing aggregated values: BUCKET_TIMER_LOW, BUCKET_TIMER_HIGH A bucket counts statements that have a latency, in picoseconds, measured between BUCKET_TIMER_LOW and ... The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-variable-tables.html
It includes the session variables for its session, as well as the values of global variables that have no session counterpart. For example: SELECT EVENT_NAME, COUNT_STAR FROM performance_schema.events_statements_summary_global_by_event_name WHERE ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-system-variable-tables.html
It includes the session variables for its session, as well as the values of global variables that have no session counterpart. The global_variables and session_variables tables have these columns: VARIABLE_NAME The system variable name. The ... The ...