Search Results
https://dev.mysql.com/doc/refman/8.4/en/backup-strategy-example.html
You should include such options as necessary to enable client programs to connect to the MySQL server. InnoDB: Apply batch completed InnoDB: Started mysqld: ready for connections For the cases of file system crashes or hardware problems, we can ...
https://dev.mysql.com/doc/refman/8.4/en/backup-types.html
Online backup methods have these characteristics: The backup is less intrusive to other clients, which can connect to the MySQL server during the backup and may be able to access data depending on what operations they need to perform. This section ...
https://dev.mysql.com/doc/refman/8.4/en/bug-reports.html
If you have a problem with Connector/ODBC (MyODBC), please try to generate a trace file and send it with your report. If your question is related to the privilege system, please include the output of mysqladmin reload, and all the error messages you ... Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at ...
https://dev.mysql.com/doc/refman/8.4/en/cast-functions.html
If you omit CHARACTER SET charset_name, the character set and collation of the result are defined by the character_set_connection and collation_connection system variables that determine the default connection character set and collation (see ...
https://dev.mysql.com/doc/refman/8.4/en/charset-syntax.html
For example, to use the latin1 Unicode character set, issue this statement after connecting to the server: SET NAMES 'latin1'; For more information about character set-related issues in client/server communication, see Section 12.4, “Connection ...
https://dev.mysql.com/doc/refman/8.4/en/charset.html
MySQL includes character set support that enables you to store data using a variety of character sets and perform comparisons according to a variety of collations. The default MySQL server character set and collation are utf8mb4 and ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-monitoring.html
To check the state of a cloning operation: Connect to the recipient MySQL server instance. You can monitor the status and progress of a cloning operation on the recipient MySQL server instance using the clone_status and clone_progress Performance ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-object-cache.html
The object limit is set to the value of max_connections, which has a default value of 151. The stored_program_cache option sets a soft upper limit for the number of cached stored procedures or functions per connection, and the limit is checked each ... The dictionary object cache is a shared global cache that stores previously accessed data dictionary objects in memory to enable object reuse and minimize disk ...
https://dev.mysql.com/doc/refman/8.4/en/datetime.html
(This does not occur for other types such as DATETIME.) By default, the current time zone for each connection is the server's time. This section describes their characteristics, how they are similar, and how they differ. MySQL recognizes DATE, ...
https://dev.mysql.com/doc/refman/8.4/en/error-access-denied.html
Often the problem is related to the MySQL accounts that the server permits client programs to use when connecting. See Section 8.2, “Access Control and Account Management”, and Section 8.2.22, “Troubleshooting Problems Connecting to MySQL”.