PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/check-table.html
CHECK TABLE functionality for InnoDB SPATIAL indexes includes an R-tree validity check and a check to ensure that the R-tree row count matches the clustered index. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/checksum-table.html
However, because the hashing function used by CHECKSUM TABLE is not guaranteed to be collision-free, there is a slight chance that two tables which are not identical can produce the same checksum. [QUICK | EXTENDED] CHECKSUM TABLE reports a checksum ...
https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html
The mysql_options() C API function supports a MYSQL_ENABLE_CLEARTEXT_PLUGIN option that enables the plugin on a per-connection basis. A client-side authentication plugin is available that enables clients to send passwords to the server as ...
https://dev.mysql.com/doc/refman/5.7/en/column-indexes.html
The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups for the rows with the corresponding column values. The B-tree data structure lets the index quickly ...
https://dev.mysql.com/doc/refman/5.7/en/commands-out-of-sync.html
If you get Commands out of sync; you can't run this command now in your client code, you are calling client functions in the wrong order. This can happen, for example, if you are using mysql_use_result() and try to execute a new query before you ...
https://dev.mysql.com/doc/refman/5.7/en/comp-err.html
For non-debug builds, this option is non-functional and causes the program to exit with an explanatory message. comp_err creates the errmsg.sys file that is used by mysqld to determine the error messages to display for different error codes. It ...
https://dev.mysql.com/doc/refman/5.7/en/compiling-for-debugging.html
When you configure MySQL for debugging you automatically enable a lot of extra safety check functions that monitor the health of mysqld. If you have some very specific problem, you can always try to debug MySQL. To do this you must configure MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/connection-compression-control.html
For programs that use the MySQL C API, enabling the MYSQL_OPT_COMPRESS option for the mysql_options() function specifies use of compression for the connection to the server. Connections to the server can use compression on the traffic between ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-primary-key.html
You can get information about the number of rows actually inserted or updated with the mysql_info() C API function. Normally, errors occur for data-change statements (such as INSERT or UPDATE) that would violate primary-key, unique-key, or ...
https://dev.mysql.com/doc/refman/5.7/en/counting-rows.html
See Section 12.19.1, “Aggregate Function Descriptions” for information about COUNT(expr) behavior and related optimizations. Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because ...