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/prepare.html
A parameter which is an operand of a temporal operator has type DATETIME if the operator returns a DATETIME, TIME if the operator returns a TIME, and DATE if the operator returns a DATE. Exceptions: The derived type is TIME and the actual type is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-performance.html
Use this clause if the primary concern is finishing the DDL operation in the shortest amount of time possible, and concurrent query and DML access is not necessary. row *************************** Id: 5 User: root Host: localhost db: test Command: ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-oci-component.html
The encryption endpoint is vault specific and Oracle Cloud Infrastructure assigns it at vault-creation time. The key management endpoint is vault specific and Oracle Cloud Infrastructure assigns it at vault-creation time. The vaults endpoint is ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-failover.html
This is necessary for restoring a replica that is immediately available as a candidate to become a new source on failover or switchover. This method is simple and effective, but requires the replica to read the binary log from the source; it can ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-setup.html
The flags, cas_column, and expire_time_column fields of the innodb_memcache.containers table are typically not significant in applications using the daemon_memcached plugin. Because the memcached daemon is tightly integrated with the MySQL server to ... This section describes how to set up the daemon_memcached plugin on a MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-shm-definition.html
For optimum performance, you can define a spin time for the SHM transporter (ShmSpinTime parameter); this affects both the data node receiver thread and the poll owner (receive thread or user thread) in NDB. Communications between NDB cluster nodes ...The shared memory (SHM) transporter is distinguished by the fact that signals are transmitted by writing in memory rather than on a ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
To update invisible columns for UPDATE statements, name them and assign a value, just as for visible columns. As an illustration of when invisible columns may be useful, suppose that an application uses SELECT * queries to access a table, and must ...An invisible column is normally hidden to queries, but can be accessed if explicitly ...
https://dev.mysql.com/doc/refman/8.0/en/charset-applications.html
For applications that store data using the default MySQL character set and collation (utf8mb4, utf8mb4_0900_ai_ci), no special configuration should be needed. Specify character settings at configuration time, if you build MySQL from source. If most ...If applications require data storage using a different character set or collation, you can configure character set information several ways: Specify character settings per ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-standard-monitor.html
Status This section shows the timestamp, the monitor name, and the number of seconds that per-second averages are based on. The number of seconds is the elapsed time between the current time and the last time InnoDB Monitor output was printed. The ...Enabling either monitor for periodic output turns on the same output stream, but the stream includes extra information if the Lock Monitor is ...
https://dev.mysql.com/doc/refman/8.0/en/connection-interfaces.html
Linux or Solaris should be able to support at least 500 to 1000 simultaneous connections routinely and as many as 10,000 connections if you have many gigabytes of RAM available and the workload from each is low or the response time target ...Network ... This section describes aspects of how the MySQL server manages client ...