PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-index-stat.html
Running ndb_index_stat with the --update option causes sampleVersion to be incremented. To force them to be created (or updated if they already exist), invoke ndb_index_stat with the --update option, or execute ANALYZE TABLE on the table in the ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-usage.html
Client applications that access the servers to retrieve and update data, choosing servers according to the purposes assigned them. For example, a client should not send an update to a read-only server. If at some point the management application ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
Even with file-per-table mode with each InnoDB table in a separate .ibd file, change buffering can delay the write to the data file, so the file modification time is different from the time of the last insert, update, or delete. To update cached ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locks-set.html
A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL statement. For locking reads (SELECT with FOR UPDATE or FOR SHARE), UPDATE, and DELETE statements, the locks that ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-in-single-primary-mode.html
Each of the MySQL server instances in a group can run on an independent physical host machine, which is the recommended way to deploy Group Replication. This section explains how to create a replication group with three MySQL Server instances, each ...
https://dev.mysql.com/doc/refman/8.0/en/using-date.html
You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. MySQL also permits a “relaxed” string format when updating and in a WHERE clause that compares a date to a DATE, DATETIME, or TIMESTAMP column. To be ...For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric context and vice ...
https://dev.mysql.com/doc/refman/8.0/en/create-view.html
This same principle applies to options such as ALL, DISTINCT, or SQL_SMALL_RESULT that follow the SELECT keyword, and to clauses such as INTO, FOR UPDATE, FOR SHARE, LOCK IN SHARE MODE, and PROCEDURE. The WITH CHECK OPTION clause can be given to ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-txn.html
As you gain experience using the daemon_memcached plugin, you can consider relaxing durability settings for non-critical classes of data, at the risk of losing some updated values in the event of an outage, or returning data that is slightly ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-background.html
The group can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time. Alternatively, for more advanced users the group can be deployed in multi-primary mode, where all servers can accept ...
https://dev.mysql.com/doc/refman/8.0/en/expired-password-handling.html
For example: ALTER USER 'myuser'@'localhost' PASSWORD EXPIRE; For each connection that uses an account with an expired password, the server either disconnects the client or restricts the client to “sandbox mode,” in which the server permits the ... MySQL provides password-expiration capability, which enables database administrators to require that users reset their ...