Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema.html
The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. The Performance Schema has these characteristics: The Performance Schema provides a way to inspect internal execution of the server at runtime. An ...It ...
https://dev.mysql.com/doc/refman/9.7/en/show-replicas.html
SHOW REPLICAS should be executed on a server that acts as a replication source. Host: The host name of the replica server, as specified on the replica with the --report-host option. This can differ from the machine name as configured in the ... SHOW ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-multi-source.html
Such a case is shown here: Figure 25.17 NDB Cluster Multi-Source Replication, With MySQL Servers MySQL servers acting as replicas must be run with the system variable log_replica_updates enabled. Note Using the log_replica_updates system variable ...
https://dev.mysql.com/doc/refman/9.7/en/load-xml.html
In other words, the FILE privilege affects only whether the client can read files on the server; it has no bearing on whether the client can read files on the local file system. To write data from a table to an XML file, you can invoke the mysql ...
https://dev.mysql.com/doc/refman/9.7/en/socket-pluggable-authentication.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). The file must be located in the directory named by the plugin_dir system variable. The ...The ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-24.html
Bugs Fixed Upon connecting to the server, Connector/C++ executed a number of SHOW [SESSION] VARIABLES statements to retrieve system variable values. Additionally, Connector/C++ was trying to fetch the value of the max_statement_time system variable, ...Typically, the client would see Lost connection to MySQL server during query (CR_SERVER_LOST) or MySQL server has gone away ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-logs-configuration.html
Server Configuration System Variables Server Configuration Status Variables Server Configuration Command Line Server Configuration System Variables The following are the server telemetry logging system variables: telemetry.log_enabled System ...For ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-tips.html
Input-Line Editing Disabling Interactive History Unicode Support on Windows Displaying Query Results Vertically Using Safe-Updates Mode (--safe-updates) Disabling mysql Auto-Reconnect mysql Client Parser Versus Server Parser Input-Line Editing mysql ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-table-import.html
InnoDB page size is defined by the innodb_page_size variable, which is configured when initializing a MySQL server instance. There are many reasons why you might want to import tables: To run reports on a non-production MySQL server instance to ...
https://dev.mysql.com/doc/refman/9.7/en/statement-caching.html
The max_prepared_stmt_count system variable controls the total number of statements the server caches. The stored_program_cache system variable indicates the approximate number of stored programs the server caches per session. For certain ...(The ...