Search Results
https://dev.mysql.com/doc/refman/9.7/en/error-log-destination-configuration.html
After the server interprets the default error log destination options, it sets the log_error system variable to indicate the default destination, which affects where several log sink components write error messages. If the default error log ...The ... This section describes which server options configure the default error log destination, which can be the console or a named ...
https://dev.mysql.com/doc/refman/9.7/en/compatibility.html
Selecting SQL Modes The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system variable. MySQL Server was originally designed to work with ...MySQL ... This section describes how MySQL relates to the ANSI/ISO SQL ...
https://dev.mysql.com/doc/refman/9.7/en/query-log.html
When the general query log is enabled, the server writes output to any destinations specified by the log_output system variable. To specify the log destination, use the log_output system variable (as described in Section 7.4.1, “Selecting General ...The server writes information to this log when clients connect or disconnect, and it logs each SQL statement received from ...
https://dev.mysql.com/doc/refman/9.7/en/unix-signal-response.html
On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the process. This section describes how the MySQL server and client programs respond to signals. Server ...Some command interpreters associate certain key sequences with signals, such as Control+C to send a SIGINT ...
https://dev.mysql.com/doc/refman/9.7/en/clone-plugin-monitoring.html
There is one clone system object in a MySQL server instance. For more information, refer to the discussion about Com_xxx statement counter variables in Section 7.1.10, “Server Status Variables”. You can monitor the status and progress of a ...
https://dev.mysql.com/doc/refman/9.7/en/events-configuration.html
The global event_scheduler system variable determines whether the Event Scheduler is enabled and running on the server. (In this situation the event_scheduler system variable does not change from ON to OFF. It is also possible to use 0 for OFF, and ... Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually refer to this ...
https://dev.mysql.com/doc/refman/9.7/en/data-dictionary-schema.html
MySQL system tables still exist in MySQL 9.7 and can be viewed by issuing a SHOW TABLES statement on the mysql system database. Generally, the difference between MySQL data dictionary tables and system tables is that data dictionary tables contain ... Data dictionary tables are protected and may only be accessed in debug builds of ...
https://dev.mysql.com/doc/refman/9.7/en/information-functions.html
See the description of the version system variable in Section 7.1.8, “Server System Variables”. mysql> SELECT CONNECTION_ID(); -> 23786 Warning Changing the session value of the pseudo_thread_id system variable changes the value returned by the ...The intended use is from within the mysql client, which reports query execution times: mysql> SELECT BENCHMARK(1000000,AES_ENCRYPT('hello','goodbye')); +---------------------------------------------------+ | BENCHMARK(1000000,AES_ENCRYPT('hello','goodbye')) | +---------------------------------------------------+ | 0 | +---------------------------------------------------+ 1 row in set (4.74 sec) The time reported is elapsed time on the client end, not CPU time on the server ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-config.html
This consists of system variables that cannot be changed at run time; thus, there is no corresponding section of the cluster configuration file for them. You can filter the results by section (DB, SYSTEM, or CONNECTIONS) using one of the options ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-methods-standard.html
Note The skip_networking MySQL system variable affects the TCP/IP connection method. This connection method enables MySQL Workbench to connect to MySQL Server using TCP/IP. Parameters Tab The parameters for standard TCP/IP connections are: ...In ...