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/check-table.html
A table is reported as needing a rebuild if it contains old temporal columns in pre-5.6.4 format (TIME, DATETIME, and TIMESTAMP columns without support for fractional seconds precision) and the avoid_temporal_upgrade system variable is disabled. If ...CHECK TABLE is supported for partitioned tables, and you can use ALTER TABLE ...option: { FOR UPGRADE | QUICK | ...
https://dev.mysql.com/doc/refman/8.0/en/update.html
The implicit default value is 0 for numeric types, the empty string ('') for string types, and the “zero” value for date and time types. Each matching row is updated once, even if it matches the conditions multiple times. Only the partitions (or ... UPDATE is a DML statement that modifies rows in a ...Each value can be given as an expression, or the ...
https://dev.mysql.com/doc/refman/8.0/en/using-systemd.html
Instances then are managed by normal systemd commands, such as: systemctl start mysqld@replica01 systemctl start mysqld@replica02 To enable instances to run at boot time, do this: systemctl enable mysqld@replica01 systemctl enable mysqld@replica02 ...The following discussion covers these topics: Overview of systemd Configuring systemd for MySQL Configuring Multiple MySQL Instances Using systemd Migrating from mysqld_safe to systemd Note On platforms for which systemd support for MySQL is installed, scripts such as mysqld_safe and the System V initialization script are unnecessary and are not ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
8.0.18 WEEK() Return the week number WEEKDAY() Return the weekday index WEEKOFYEAR() Return the calendar week of the date (1-53) WEIGHT_STRING() Return the weight string for a string XOR Logical XOR YEAR() Return the year YEARWEEK() Return the year ... The following table lists each built-in (native) function and operator and provides a short description of each ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-internals.html
The expire_time_column value is related to the way memcached hashes requests to different servers and caches data in memory. Specify 0 for flags, cas_column, and expire_time_column if they are unused. InnoDB API functions access the InnoDB tables ...
https://dev.mysql.com/doc/refman/8.0/en/index-hints.html
Thus, you should expect USE INDEX, FORCE INDEX, and IGNORE INDEX to be deprecated in a future release of MySQL, and at some time thereafter to be removed altogether. These index-level optimizer hints are supported with both single-table and ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-aws-plugin.html
This is simpler and has no side effects, but is not suitable for installations that require minimal server downtime with as few restarts as possible. The keyring_aws keyring plugin communicates with the Amazon Web Services Key Management Service ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-usage.html
These statements are subject to rewriting: As of MySQL 8.0.12: SELECT, INSERT, REPLACE, UPDATE, and DELETE. When the plugin reads each rule from the rules table, it computes a normalized (statement digest) form from the pattern and a digest hash ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
Although these functions are not deterministic, they are treated as safe for purposes of logging and replication: CONNECTION_ID(), CURDATE(), CURRENT_DATE(), CURRENT_TIME(), CURRENT_TIMESTAMP(), CURTIME(), LAST_INSERT_ID(), LOCALTIME(), ...These ...
https://dev.mysql.com/doc/refman/8.0/en/connection-access.html
When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on these conditions: Your identity and whether you can verify it by supplying the proper credentials. Otherwise, the server accepts the connection, ...