Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-accounts-table.html
The accounts table contains a row for each account that has connected to the MySQL server. To set the table size explicitly, set the performance_schema_accounts_size system variable at server startup. For each account, the table counts the current ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-hosts-table.html
The hosts table contains a row for each host from which clients have connected to the MySQL server. To set the table size explicitly, set the performance_schema_hosts_size system variable at server startup. For each host name, the table counts the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-miscellaneous-tables.html
The following sections describe tables that do not fall into the table categories discussed in the preceding sections: component_scheduler_tasks: The current status of each scheduled task. user_defined_functions: Loadable functions registered by a ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variables.html
Performance_schema_session_connect_attrs_longest_seen In addition to the connection attribute size-limit check performed by the Performance Schema against the value of the performance_schema_session_connect_attrs_size system variable, the server ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-users-table.html
The users table contains a row for each user who has connected to the MySQL server. To set the table size explicitly, set the performance_schema_users_size system variable at server startup. For each user name, the table counts the current and ...
https://dev.mysql.com/doc/refman/8.4/en/perl-installation.html
These tests attempt to connect to the local MySQL server using the default user name and password. Note that when you run that command during the DBD::mysql installation to exercise the interface code, the MySQL server must be running or the test ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-storage.html
MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. The shared library must be located in the MySQL server plugin directory, the location of which is ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-mysql-sock.html
The default location for the Unix socket file that the server uses for communication with local clients is /tmp/mysql.sock. You can test whether the new socket location works by attempting to connect to the server with this command: $> mysqladmin ...(For some distribution formats, the directory might be different, such as /var/lib/mysql for RPMs.) On some versions of Unix, anyone can delete files in the /tmp directory or other similar directories used for temporary ...
https://dev.mysql.com/doc/refman/8.4/en/program-options.html
It describes a handy technique that uses such variables to specify the TCP/IP port number and Unix socket file for the server and for client programs. For the server, one exception applies: The mysqld-auto.cnf option file in the data directory is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-replica.html
You can set up the replication channel using CHANGE REPLICATION SOURCE TO, or if the new servers are provisioned using MySQL's clone functionality, this all happens automatically. To configure this feature, the replication channel and the ...