Search Results
https://dev.mysql.com/doc/refman/8.4/en/error-log-syslog.html
It is possible to have mysqld write the error log to the system log (the Event Log on Windows, and syslog on Unix and Unix-like systems). On Windows, error messages written to the Event Log within the Application log have these characteristics: ...
https://dev.mysql.com/doc/refman/8.4/en/events-configuration.html
Although ON and OFF have numeric equivalents, the value displayed for event_scheduler by SELECT or SHOW VARIABLES is always one of OFF, ON, or DISABLED. This table can be queried to obtain information about scheduled events which have been defined ... 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/8.4/en/events-overview.html
MySQL Events have the following major features and properties: In MySQL, an event is uniquely identified by its name and the schema to which it is assigned. A user may include statements in an event's action which require privileges that the user ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
Do stored procedures have a statement for raising application errors? A.4.13. Do stored procedures have a statement for raising application errors? Yes. If replication or binary logging in general (for the purpose of point-in-time recovery) is ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create-connection.html
This user must have been created on the remote server, and must have suitable privileges to perform the required actions (SELECT, INSERT, UPDATE, and so forth) on the remote table. The name of the local and the remote table do not have to match. To ...
https://dev.mysql.com/doc/refman/8.4/en/fips-mode.html
This means you have the following options, depending on system and MySQL configuration: Use a system that has OpenSSL 3.0 and the required FIPS object module. If your platform does not include FIPS, you have two options: Migrate to a platform which ... MySQL supports FIPS mode when a supported OpenSSL library and FIPS Object Module are available on the host ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search.html
MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION } MySQL has support for full-text indexing and searching: A ...
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
If not, verify that you do not have a full disk and that the disk is not in very heavy use. However, to reopen the table, it must wait until all other threads have closed the table in question. However, to reopen the table, it must wait until all ...
https://dev.mysql.com/doc/refman/8.4/en/getting-information.html
You have previously seen SHOW DATABASES, which lists the databases managed by the server. To find out which database is currently selected, use the DATABASE() function: mysql> SELECT DATABASE(); +------------+ | DATABASE() | +------------+ | ...
https://dev.mysql.com/doc/refman/8.4/en/gis-point-property-functions.html
For Point objects that have a geographic spatial reference system (SRS), the longitude and latitude may be obtained using the ST_Longitude() and ST_Latitude() functions, respectively. ST_Latitude() handles its arguments as described in the ... A ...