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/intersect.html
query_expression_body INTERSECT [ALL | DISTINCT] query_expression_body [INTERSECT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” INTERSECT limits the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-consumer-configurations.html
The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. The setup_consumers table contains the following hierarchy of values: global_instrumentation thread_instrumentation events_waits_current ...The ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-statistics.html
The table is persistent so that column statistics need not be created each time the server starts. This histogram type is created when the number of distinct values in the column is less than or equal to the number of buckets specified in the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-memcached.html
You might create additional secondary indexes on tables that are frequently used to generate reports using SQL. If you store several different classes of information using memcached, consider setting up a separate InnoDB table for each type of data.
https://dev.mysql.com/doc/refman/8.0/en/connection-access.html
The server performs identity and credentials checking using columns in the user table, accepting the connection only if these conditions are satisfied: The client host name and user name match the Host and User columns in some user table row. When ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-restrictions.html
If a source used STATEMENT format and a replica used ROW format, the replica would be unable to handle the transaction correctly, therefore the CREATE TABLE ... When binlog_format is set to STATEMENT, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE ...When using GTIDs, updates to tables using nontransactional storage engines such as MyISAM cannot be made in the same statement or transaction as updates to tables using transactional storage engines such as ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks-handling.html
Another way to serialize transactions is to create an auxiliary “semaphore” table that contains just a single row. When modifying multiple tables within a transaction, or different sets of rows in the same table, do those operations in a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-txn.html
This option is less appropriate when accessing the same tables through both memcached and SQL, because it blocks CREATE INDEX statements on the tables, which could be important for running reporting queries. Although the default behavior does not ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-auto-increment.html
The instructions just given are subject to the limitations of CREATE TABLE ... If a table definition includes any of those characteristics, create t2 using a CREATE TABLE statement that is identical to the one used to create t1, but with the ...(Bug ... Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated correctly using statement-based ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlimport.html
Here is a sample session that demonstrates use of mysqlimport: $> mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test $> ed a 100 Max Sydow 101 Count Dracula . Invoke mysqlimport like this: mysqlimport [options] db_name textfile1 [textfile2 ... The mysqlimport client provides a command-line interface to the LOAD DATA SQL ...