Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-scaleout.html
Start by creating a wrapper library or module that implements the following functions: safe_writer_connect() safe_reader_connect() safe_reader_statement() safe_writer_statement() safe_ in each function name means that the function takes care of ...
https://dev.mysql.com/doc/refman/8.4/en/replication-threads-monitor-worker.html
A multithreaded replica's coordinator thread also prints statistics to the replica's error log on a regular basis if the verbosity setting is set to display informational messages. The message lists the following statistics for the relevant ... On a ...
https://dev.mysql.com/doc/refman/8.4/en/reset-persist.html
If the variable is not present in the file, an error occurs. RESET PERSIST [[IF EXISTS] system_var_name] RESET PERSIST removes persisted global system variable settings from the mysqld-auto.cnf option file in the data directory. Removing a ...
https://dev.mysql.com/doc/refman/8.4/en/row-subqueries.html
An error occurs if the subquery produces multiple rows because a row subquery can return at most one row. Thus, the following query fails with a syntax error: SELECT * FROM t1 WHERE ROW(1) = (SELECT column1 FROM t2) Row constructors are legal in ...
https://dev.mysql.com/doc/refman/8.4/en/se-csv-repair.html
The CSV storage engine supports the CHECK TABLE and REPAIR TABLE statements to verify and, if possible, repair a damaged CSV table. When running the CHECK TABLE statement, the CSV file is checked for validity by looking for the correct field ...
https://dev.mysql.com/doc/refman/8.4/en/selinux-troubleshooting.html
$> systemctl start mysql.service Job for mysqld.service failed because the control process exited with error code. If you configure the MySQL Server to use a non-default port, such as port 3307, and do not update the policy to reflect the change, ...
https://dev.mysql.com/doc/refman/8.4/en/server-logs.html
MySQL Server has several logs that can help you find out what activity is taking place. The following log-specific sections provide information about the server options that enable logging. By default, the server writes files for all enabled logs ...
https://dev.mysql.com/doc/refman/8.4/en/server-shutdown.html
If the server tries to create a shutdown thread and cannot (for example, if memory is exhausted), it issues a diagnostic message that appears in the error log: Error: Can't create thread to kill server The server stops accepting new connections.
https://dev.mysql.com/doc/refman/8.4/en/set-role.html
The server writes warnings to its error log for default roles that cannot be activated, but the client receives no warnings. If a user executes SET ROLE DEFAULT during a session, an error occurs if any default role cannot be activated (for example, ... SET ROLE { DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.4/en/set.html
Duplicate values in the definition cause a warning, or an error if strict SQL mode is enabled. A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is ...