PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/precision-math-examples.html
The floating-point calculation introduces small errors: +--------+------------------+ | d | f | +--------+------------------+ | 1.0000 | 0.99999999999991 | +--------+------------------+ Example 2. In strict mode, inserting a value that is out of ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions-mbr.html
If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. For functions that take multiple geometry arguments, if those arguments are not in the same SRS, an ER_GIS_DIFFERENT_SRIDS error occurs. If ...
https://dev.mysql.com/doc/refman/8.0/en/set-password.html
For accounts that use a plugin that performs authentication against a credentials system that is external to MySQL, password management must be handled externally against that system as well. The clause must be given if password changes for the ...
https://dev.mysql.com/doc/refman/8.0/en/rename-user.html
(That is, the statement fails if renaming an account would cause a stored object to become orphaned.) To perform the operation anyway, you must have the SET_USER_ID privilege; in this case, the statement succeeds with a warning rather than failing ...To use RENAME USER, you must have the global CREATE USER privilege, or the UPDATE privilege for the mysql system ...
https://dev.mysql.com/doc/refman/8.0/en/set-transaction.html
To set the global isolation level at server startup, use the --transaction-isolation=level option on the command line or in an option file. Each characteristic value sets the transaction isolation level or access mode. The access mode specifies ...
https://dev.mysql.com/doc/refman/8.0/en/server-shutdown.html
If the server tries to create a shutdown thread and cannot (for example, if memory is exhausted), it issues a diagnostic message that appears in the error log: Error: Can't create thread to kill server The server stops accepting new connections. To ... The server shutdown process takes place as follows: The shutdown process is ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-oci-marketplace-deploy.html
Important When the deployment is complete, and the MySQL server is started, you must connect to the compute instance and retrieve the default root password which was written to the MySQL log file. To deploy MySQL EE on Oracle Cloud Infrastructure, ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-startup-configuration.html
To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to occur. For example, use these lines in the server my.cnf file: [mysqld] performance_schema=ON If the server is unable to allocate any internal ...To enable or disable it explicitly, start the server with the performance_schema variable set to an appropriate ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-check-options.html
myisamchk supports the following options for table checking operations: --check, -c Command-Line Format --check Check the table for errors. Normally, myisamchk or myisamchk --medium-check should be able to determine whether there are any errors in ...This is the default operation if you specify no option that selects an operation type ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-list.html
As with the other partitioning examples, we assume that the default_storage_engine is InnoDB.) Suppose that there are 20 video stores distributed among 4 franchises as shown in the following table. You can cause this type of error to be ignored by ...As in partitioning by RANGE, each partition must be explicitly ... List ...