Search Results
https://dev.mysql.com/doc/refman/8.4/en/account-management-statements.html
MySQL account information is stored in the tables of the mysql system schema. This database and the access control system are discussed extensively in Chapter 7, MySQL Server Administration, which you should consult for additional details.
https://dev.mysql.com/doc/refman/8.4/en/ansi-diff-comments.html
To keep this from happening, MySQL requires a whitespace character following the -- for it to be recognized as a start-comment sequence in MySQL Server, so that an expression such as balance--1 is always safe to use. Standard SQL uses the C syntax ...
https://dev.mysql.com/doc/refman/8.4/en/atomic-ddl.html
To ensure that rollback can be performed safely without introducing inconsistencies, file operations such as renaming or removing data files are performed in this final phase. An atomic DDL statement combines the data dictionary updates, storage ...
https://dev.mysql.com/doc/refman/8.4/en/backup-strategy-summary.html
If you have such safe media, this technique can also be good for disk load balancing (which results in a performance improvement). In case of an operating system crash or power failure, InnoDB itself does all the job of recovering data. But to make ...
https://dev.mysql.com/doc/refman/8.4/en/can-not-connect-to-server.html
It is safe to reduce TIME_WAIT greatly on LAN connections because there is little chance of packets arriving at very long delays, as they could through the Internet with its comparatively large distances and latencies. A MySQL client on Unix can ...
https://dev.mysql.com/doc/refman/8.4/en/cannot-create.html
Provided that the write error is to a test file, the error is not serious and can be safely ignored. If you get an error of the following type for some queries, it means that MySQL cannot create a temporary file for the result set in the temporary ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-encrypted-data.html
The following requirements apply: A secure connection is required when cloning remote data to ensure safe transfer of unencrypted tablespace keys over the network. Tablespace keys are decrypted at the donor before transport and re-encrypted at the ...
https://dev.mysql.com/doc/refman/8.4/en/correlated-subqueries.html
The predicate must employ the equality operator = for making the comparison; the null-safe <=> operator is not supported in this context. A correlated subquery is a subquery that contains a reference to a table that also appears in the outer query.
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary.html
MySQL Server incorporates a transactional data dictionary that stores information about database objects. In previous MySQL releases, dictionary data was stored in metadata files, nontransactional tables, and storage engine-specific data ...
https://dev.mysql.com/doc/refman/8.4/en/delete-optimization.html
Truncate operations are not transaction-safe; an error occurs when attempting one in the course of an active transaction or active table lock. The time required to delete individual rows in a MyISAM table is exactly proportional to the number of ...