PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/roles.html
You should keep in mind that this distinction is not immutable; a user with appropriate privileges can lock or unlock roles or (other) users after they have been created. The following list summarizes role-management capabilities provided by MySQL: ...Like user accounts, roles can have privileges granted to and revoked from ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-subpartitions.html
Consider the following CREATE TABLE statement: CREATE TABLE ts (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) SUBPARTITION BY HASH( TO_DAYS(purchased) ) SUBPARTITIONS 2 ( PARTITION p0 VALUES LESS THAN (1990), PARTITION p1 VALUES LESS ... Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-api-statistics.html
This reflects the creation of the hidden primary key that is a feature of all tables using the NDB storage engine. Such actions include starting and closing (or aborting) transactions; primary key and unique key operations; table, range, and pruned ... A number of types of statistical counters relating to actions performed by or affecting Ndb objects are ...
https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
mysql> SELECT 38.8, CAST(38.8 AS CHAR); -> 38.8, '38.8' mysql> SELECT 38.8, CONCAT(38.8); -> 38.8, '38.8' See later in this section for information about the character set of implicit number-to-string conversions, and for modified rules that apply ...A single-row subquery from a table or tables is not considered a ... When an operator is used with operands of ...
https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
With an innodb_force_recovery value of 3 or less you can DROP or CREATE tables. To investigate database page corruption, you might dump your tables from the database with SELECT ... In such cases, you can use the innodb_force_recovery option to ...
https://dev.mysql.com/doc/refman/8.0/en/host-cache.html
The Performance Schema host_cache table exposes the contents of the host cache so that it can be examined using SELECT statements. It does not use the cache for TCP connections established using a loopback interface address (for example, 127.0.0.1 ... The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-consistent-read.html
This exception causes the following anomaly: If you update some rows in a table, a SELECT sees the latest version of the updated rows, but it might also see older versions of any rows. If other sessions simultaneously update the same table, the ...
https://dev.mysql.com/doc/refman/8.0/en/load-data-local-security.html
Dump loading utility util.loadDump() Import dump files created using MySQL Shell's instance, schema, or table dump utility into a MySQL HeatWave Service DB System or a MySQL Server instance. The LOAD DATA statement loads a data file into a table.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-pre-filtering.html
Modifications to any of these tables affect monitoring immediately, with the exception that modifications to the setup_actors table affect only foreground threads created subsequent to the modification, not existing threads. Pre-filtering can be ...
https://dev.mysql.com/doc/refman/8.0/en/show-replica-status.html
This is similar to the information available from the SHOW REPLICA STATUS statement, but represented in table form. The relay log file name (Relay_Log_File) is set according to the relay_log_recovery setting, either a new file that was created at ...