Search Results
https://dev.mysql.com/doc/refman/8.4/en/host-cache.html
To disable DNS host name lookups, start the server with the skip_name_resolve system variable enabled. To disallow TCP/IP connections entirely, start the server with the skip_networking system variable enabled. Unblock with 'mysqladmin flush-hosts' ...The server uses the host cache for several purposes: By caching the results of IP-to-host name lookups, the server avoids doing a Domain Name System (DNS) lookup for each client ...
https://dev.mysql.com/doc/refman/8.4/en/create-user.html
If count is 0 (the default), the server determines the number of simultaneous connections for the account from the global value of the max_user_connections system variable. When the read_only system variable is enabled, CREATE USER additionally ...
https://dev.mysql.com/doc/refman/8.4/en/connection-control-plugin-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). Connection Delay Configuration Connection Failure Assessment Connection Failure Monitoring ...
https://dev.mysql.com/doc/refman/8.4/en/connection-interfaces.html
To control and monitor how the server manages threads that handle client connections, several system and status variables are relevant. (See Section 7.1.8, “Server System Variables”, and Section 7.1.10, “Server Status Variables”.) The ...If ... This section describes aspects of how the MySQL server manages client ...On ...
https://dev.mysql.com/doc/refman/8.4/en/programs-overview.html
mysqld_multi A server startup script that can start or stop multiple servers installed on the system. Oracle Corporation also provides the MySQL Workbench GUI tool, which is used to administer MySQL servers and databases, to create, execute, and ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-audit-plugins.html
The general plugin descriptor also refers to simple_status and system_variables, structures that expose several status and system variables. system_variables is an array of system variable elements, each of which is defined using a MYSQL_THDVAR_xxx ... This section describes how to write a server-side audit plugin, using the example plugin found in the plugin/audit_null directory of MySQL source ...Note Other examples of ...
https://dev.mysql.com/doc/refman/8.4/en/automatic-start.html
On Linux systems that support systemd, you can use it to control the server. On systems that use System V-style run directories (that is, /etc/init.d and run-level specific directories), invoke mysql.server. systemd, the mysqld_safe and mysql.server ... This section discusses methods for starting and stopping the MySQL ...On Windows, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-init-startup-configuration.html
(The MySQL server changes its current working directory to the data directory when it begins executing.) Alternatively, you can specify an absolute path for system tablespace data files. You can define a different number of redo log files and ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-metrics-table.html
SET GLOBAL innodb_monitor_reset_all = [counter-name|module_name|pattern|all]; Counters and counter modules can also be enabled at startup using the MySQL server configuration file. For example, to enable the log module, metadata_table_handles_opened ... The INNODB_METRICS table provides information about InnoDB performance and resource-related ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-connection-parameters.html
server TCP/IP Server localhost The host name of the MySQL server. port Port 3306 The TCP/IP port to use if server is not localhost. password Password - The password for the user account on server. socket - - The Unix socket file or Windows named ...