Search Results
https://dev.mysql.com/doc/refman/8.4/en/shutdown.html
Another way to stop the server is to send it a SIGTERM signal, which can be done by root or the account that owns the server process. SHUTDOWN provides an SQL-level interface to the same functionality available using the mysqladmin shutdown command.
https://dev.mysql.com/doc/refman/8.4/en/sys-latest-file-io.html
The latest_file_io and x$latest_file_io views have these columns: thread For foreground threads, the account associated with the thread (and port number for TCP/IP connections). These views summarize file I/O activity, grouped by file and thread.
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-is-consumer-enabled.html
This function accounts for the consumer hierarchy, so a consumer is not considered enabled unless all consumers on which depends are also enabled. Returns YES or NO to indicate whether a given Performance Schema consumer is enabled, or NULL if the ...
https://dev.mysql.com/doc/refman/8.4/en/table-cache.html
Also take into account that the MyISAM storage engine needs two file descriptors for each unique open table. When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-options-system-variables.html
For modifications to this variable, if the new value is smaller than the current number of connections, the new limit is taken into account only for new connections. To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line ...
https://dev.mysql.com/doc/ndb-operator/8.4/en/crd-ndbclusterstatus.html
generatedRootPasswordSecretName (string): This is the name of the secret generated by the operator, used as the MySQL server root account password. processedGeneration (integer): Holds the latest generation of the Ndb resource whose specs have been ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-rpd-nodes-table.html
If a query starts and finishes in the four seconds between refreshes, the memory used by the query is not accounted for in the reported value. The rpd_nodes table has these columns: ID A unique identifier for the MySQL AI Engine (AI engine).
https://dev.mysql.com/doc/relnotes/mysql-router/9.5/en/news-9-1-0.html
(Bug #36935988) Bootstrapping against a MySQL account that used the mysql_native_password authentication plugin with MySQL Router 9.0 from a standalone (zip or tar.gz) package would exit with an error indicating that the plugin was not available.
https://dev.mysql.com/doc/workbench/en/wb-basic-modeling.html
On the MySQL Model screen, double-click the Add Diagram icon (shown in the following figure). Figure 9.29 Adding an EER Diagram From an EER diagram page you can graphically design a database.
https://dev.mysql.com/doc/workbench/en/wb-database-diff-report.html
This facility enables you to create a report detailing the differences between your MySQL Workbench model, and a live database or script. Choose Database, Compare Schemas from the main menu to run the Compare and Report Differences in Catalogs ...