PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html
SELECT statements, these rules apply regarding acceptable forms of SELECT query expressions that you can refer to in an ON DUPLICATE KEY UPDATE clause: References to columns from queries on a single table, which may be a derived table. References to ... If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row ...
https://dev.mysql.com/doc/refman/5.7/en/known-issues.html
With statement-based binary logging, the source server writes the executed queries to the binary log. If and only if the preceding queries have no ORDER BY clause guaranteeing a deterministic order. The easiest way to avoid this problem is to add an ... This section lists known issues in recent versions of ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-innodb-mutex-waits-performance-schema.html
$> ./mysqlslap --auto-generate-sql --concurrency=100 --iterations=10 --number-of-queries=1000 --number-char-cols=6 --number-int-cols=6; Query the wait event data. In this example, wait event data is queried from the ... A mutex is a synchronization ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-column-indexes.html
MySQL can use multiple-column indexes for queries that test all the columns in the index, or queries that test just the first column, the first two columns, the first three columns, and so on. If you specify the columns in the right order in the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-operations.html
MySQL NDB Cluster 7.5 and 7.6 support online table schema changes using ALTER TABLE ... NDB Cluster handles COPY and INPLACE as described in the next few paragraphs. For ALGORITHM=COPY, the mysqld NDB Cluster handler performs the following actions: ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-tables.html
It can be used to detect malformed queries sent by clients. Statement events occur at a high level of the event hierarchy. Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within ...
https://dev.mysql.com/doc/refman/5.7/en/sys-table-exists.html
Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, TEMPORARY is returned. Parameters in_db VARCHAR(64): The name of the database in which to ...
https://dev.mysql.com/doc/refman/5.7/en/user-variables.html
You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one statement to another. User variables are written as @var_name, where the variable name var_name ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
Table 6.32 audit_log_policy_value Values Value Corresponding audit_log_policy Value 0 or "::none" NONE 1 or "::logins" LOGINS 2 or "::all" ALL 3 or "::queries" QUERIES The "::xxx" values are symbolic pseudo-constants that may be given instead of the ...For information about using JSON data in MySQL, see Section 11.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/5.7/en/crashing.html
Normally, this is one of the last queries in the log file just before the server restarts. Run the command mysqladmin -i 5 status or mysqladmin -i 5 -r status in a separate window to produce statistics while running other queries. Each MySQL ...