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/optimizing-innodb-many-tables.html
If you have configured non-persistent optimizer statistics (a non-default configuration), InnoDB computes index cardinality values for a table the first time that table is accessed after startup, instead of storing such values in the table. This ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk.html
Possible causes include but are not limited to file system errors. The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for ...
https://dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html
Such statements produce a warning in the error log when using statement-based mode and are written to the binary log using the row-based format when using MIXED mode. If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would ...
https://dev.mysql.com/doc/refman/5.7/en/geometry-well-formedness-validity.html
Spatial import functions that parse WKT or WKB values raise an error for attempts to create a geometry that is not syntactically well-formed. Spatial computations may detect some cases of invalid geometries and raise an error, but they may also ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-general.html
Does MySQL have a NOW() function with fractions of seconds? Yes, see Section 11.2.7, “Fractional Seconds in Time Values”. Does MySQL have a NOW() function with fractions of seconds? A.1.7. If an exactly identical query is made (which often ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
The error message looks like this: InnoDB: Error: table test/parent already exists in InnoDB internal InnoDB: data dictionary. You can drop the orphan table by following the instructions given in the error message. [ERROR] InnoDB: The error means ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-config-file.html
Configuring NDB Cluster requires working with two files: my.cnf: Specifies options for all NDB Cluster executables. This file, with which you should be familiar with from previous work with MySQL, must be accessible by each executable running in ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-decimal-characteristics.html
This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits Storage format Storage requirements The nonstandard MySQL extension to the upper range ...D is the number of digits to the right of the decimal point (the ...
https://dev.mysql.com/doc/refman/5.7/en/out-of-memory.html
Is it reasonable that it should return so many rows? If not, correct the query and try again. This causes it to use the mysql_use_result() C API function to retrieve the result set, which places less of a load on the client (but more on the server).
https://dev.mysql.com/doc/refman/5.7/en/precision-math-examples.html
Consider the following stored procedure, which adds .0001 to a variable 1,000 times. The floating-point calculation introduces small errors: +--------+------------------+ | d | f | +--------+------------------+ | 1.0000 | 0.99999999999991 | ... This ...