Search Results
https://dev.mysql.com/doc/refman/8.4/en/error-log-components.html
For a loadable component, the description specifies the URN to use if explicitly loading or unloading the component with the INSTALL COMPONENT and UNINSTALL COMPONENT statements. This section describes the characteristics of individual error log ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-rotation.html
If you flush the error log using a FLUSH ERROR LOGS or FLUSH LOGS statement, or a mysqladmin flush-logs command, the server closes and reopens any error log file to which it is writing. To rename an error log file, do so manually before flushing.
https://dev.mysql.com/doc/refman/8.4/en/error-log-syslog.html
On Windows, error messages written to the Event Log within the Application log have these characteristics: Entries marked as Error, Warning, and Note are written to the Event Log, but not messages such as information statements from individual ...
https://dev.mysql.com/doc/refman/8.4/en/error-message-language.html
For example, if the server is using the fr_FR locale for error messages, a client can execute this statement to receive error messages in English: SET lc_messages = 'en_US'; . By default, mysqld produces error messages in English, but they can be ...
https://dev.mysql.com/doc/refman/8.4/en/event-scheduler.html
Section 27.4.3, “Event Syntax”, discusses the SQL statements for creating, altering, and dropping MySQL Events. The MySQL Event Scheduler manages the scheduling and execution of events, that is, tasks that run according to a schedule. The ...
https://dev.mysql.com/doc/refman/8.4/en/except.html
query_expression_body EXCEPT [ALL | DISTINCT] query_expression_body [EXCEPT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” EXCEPT limits the result ...
https://dev.mysql.com/doc/refman/8.4/en/fips-mode.html
Enabling FIPS Mode in MySQL To determine whether MySQL is running on a system with FIPS mode enabled, check the value of the ssl_fips_mode server system variable using an SQL statement such as SHOW VARIABLES LIKE '%fips%' or SELECT @@ssl_fips_mode.
https://dev.mysql.com/doc/refman/8.4/en/gis-data-formats.html
For example, the following statements both use ST_X() to extract the X-coordinate from a Point object. Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-modifiers.html
MySQL supports an additional, alternative syntax for this modifier, as shown in Section 15.2.13, “SELECT Statement”. The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-changing-group-mode.html
While the action runs, you can check its progress by issuing the following SELECT statement: SELECT event_name, work_completed, work_estimated FROM performance_schema.events_stages_current WHERE event_name LIKE "%stage/group_rpl%"; ... This section ...