PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html
if the user ID of the owner of the .frm, .MYD, or .MYI file is different from the user ID of the mysqld process, OPTIMIZE TABLE generates a "cannot change ownership of the file" error unless mysqld is started by the root user. The table and indexes ...OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-options.html
--keyring-migration-user=user_name Command-Line Format --keyring-migration-user=user_name Type String The user name of the MySQL account used for connecting to the running server that is currently using one of the key migration keystores. MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-configuration.html
Setting the GLOBAL query_cache_type value determines query cache behavior for all clients that connect after the change is made. Individual clients can control cache behavior for their own connection by setting the SESSION query_cache_type value.
https://dev.mysql.com/doc/refman/5.7/en/select.html
[WITH ROLLUP]] [HAVING where_condition] [ORDER BY {col_name | expr | position} [ASC | DESC], ...] [LIMIT {[offset,] row_count | row_count OFFSET offset}] [PROCEDURE procedure_name(argument_list)] [into_option] [FOR UPDATE | LOCK IN SHARE MODE] ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
It is not true for names of columns, constraints, databases, partitions, statements prepared with PREPARE, tables, triggers, users, and user-defined variables. If you plan to set the lower_case_table_names system variable to 1 on Unix, you must ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
If a ROW_FORMAT option is not defined explicitly in the table definition or ROW_FORMAT=DEFAULT is used, the innodb_default_row_format setting must be the same on the source and destination instances. A convenient way to accomplish this is to add ...
https://dev.mysql.com/doc/refman/5.7/en/assignment-operators.html
Within a SET statement, = is treated as an assignment operator that causes the user variable on the left hand side of the operator to take on the value to its right. Causes the user variable on the left hand side of the operator to take on the value ... Table 12.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assignment ...The value on the right hand side ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-filtering.html
Pre-filtering is done by the Performance Schema and has a global effect that applies to all users. Post-filtering is performed on a per-user basis because individual users select which of the available events are of interest. Reasons to use ...The ... Events are processed in a producer/consumer fashion: Instrumented code is the source for events and produces events to be ...| wait/synch/mutex/sql/LOCK_global_read_lock | YES | YES | | ...
https://dev.mysql.com/doc/refman/5.7/en/nested-join-optimization.html
In other words, we cannot ignore parentheses for the inner table expressions of outer join operations. Parentheses for the other operand (operand for the outer table) can be ignored. In the second query, it is formed with an inner join operation. In ...The following discussion refers to the join syntax described in Section 13.2.9.2, “JOIN ...
https://dev.mysql.com/doc/refman/5.7/en/resignal.html
The last (stacked) diagnostics area, which has the condition areas that were set up before the handler took control. SET is not an exception, it clears, performs the operation, and produces a result of “success.” The diagnostics area stack now ...RESIGNAL may change some or all information before passing it ...RESIGNAL also can make some procedures shorter if a given handler can handle part of a ...