Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-plugins.html
For plugins installed with INSTALL PLUGIN, the Name and Library values are also registered in the mysql.plugin system table. row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ...
https://dev.mysql.com/doc/refman/8.4/en/show-status.html
Each invocation of the SHOW STATUS statement uses an internal temporary table and increments the global Created_tmp_tables value. mysql> SHOW STATUS; +--------------------------+------------+ | Variable_name | Value | ...Status variable information ... SHOW [GLOBAL | SESSION] STATUS [LIKE 'pattern' | WHERE expr] SHOW STATUS provides server status information (see Section 7.1.10, “Server Status ...
https://dev.mysql.com/doc/refman/8.4/en/sys-innodb-buffer-stats-by-schema.html
These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema. Warning Querying views that access the INNODB_BUFFER_PAGE table can affect performance. Do not query these views on a production system ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-save.html
It is intended you call ps_setup_reload_saved() later within the same session as ps_setup_save() because the configuration is saved in TEMPORARY tables. If you end your session without invoking ps_setup_save(), the tables and lock disappear ...This ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-show-disabled.html
Displays all currently disabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display disabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display disabled threads. Example ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-trace-statement-digest.html
If you find a statement of interest within the Performance Schema events_statements_summary_by_digest table, specify its DIGEST column MD5 value to this procedure and indicate the polling duration and interval. in_start_fresh BOOLEAN: Whether to ...
https://dev.mysql.com/doc/refman/8.4/en/uninstall-component.html
It requires the DELETE privilege for the mysql.component system table because it removes the row from that table that registers the component. A loader service handles component unloading, which includes removing uninstalled components from the ...A ...
https://dev.mysql.com/doc/refman/8.4/en/use.html
The named database remains the default until the end of the session or another USE statement is issued: USE db1; SELECT COUNT(*) FROM mytable; # selects from db1.mytable USE db2; SELECT COUNT(*) FROM mytable; # selects from db2.mytable The database ... USE db_name The USE statement tells MySQL to use the named database as the default (current) database for subsequent ...
https://dev.mysql.com/doc/refman/8.4/en/user-variables.html
(Exception: A user with access to the Performance Schema user_variables_by_thread table can see all user variables for all sessions.) All variables for a given client session are automatically freed when that client exits. (This is the same ... You ...
https://dev.mysql.com/doc/refman/8.4/en/what-is-mysql.html
A relational database stores data in separate tables rather than putting all the data in one big storeroom. The logical model, with objects such as databases, tables, views, rows, and columns, offers a flexible programming environment. You set up ...