Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-processlist.html
Note An alternative implementation for SHOW PROCESSLIST is available based on the Performance Schema processlist table, which, unlike the default SHOW PROCESSLIST implementation, does not require a mutex and has better performance characteristics.
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-thread-trx-info.html
The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and events_statements_history tables. The value should match the THREAD_ID column from some ... Returns a JSON object containing information about a given ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-auto-increment-columns.html
This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values and the usage ratio (ratio of used to possible values). Tables in these schemas are excluded ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-redundant-indexes.html
The schema_redundant_indexes view has these columns: table_schema The schema that contains the table. The x$schema_flattened_keys view has these columns: table_schema The schema that contains the table. The schema_redundant_indexes view displays ...
https://dev.mysql.com/doc/refman/8.4/en/update-optimization.html
Performing multiple updates together is much quicker than doing one at a time if you lock the table. For a MyISAM table that uses dynamic row format, updating a row to a longer total length may split the row. If you do this often, it is very ... An ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-usage.html
For example, if a table contains a TIMESTAMP column named ts, standard SQL permits PARTITION BY ts but not PARTITION BY HOUR(ts), whereas MySQL permits both. However, whereas an aggregate operation groups query rows into a single result row, a ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-connection-compression.html
The following table compares the characteristics of the different compression algorithms and shows their assigned priorities. Instead, its default is to permit all algorithms shown in Table 22.1, “X Protocol Compression Algorithm ... X Plugin ...
https://dev.mysql.com/doc/c-api/8.4/en/getting-unique-id.html
If you insert a record into a table that contains an AUTO_INCREMENT column, you can obtain the value stored into that column by calling the mysql_insert_id() function. You can check from your C applications whether a value was stored in an ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-options.html
Options for information such as SSL certificate and key files are used to establish an encrypted connection if such connections are available, but do not enforce any requirement that the connection obtained be encrypted. The Performance Schema ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-refresh.html
This function flushes tables or caches, or resets replication server information. int mysql_refresh(MYSQL *mysql, unsigned int options) Description Note mysql_refresh() is deprecated and is subject to removal in a future version of MySQL. The ...