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/index-condition-pushdown-optimization.html
ICP can reduce the number of times the storage engine must access the base table and the number of times the MySQL server must access the storage engine. For InnoDB clustered indexes, the complete record is already read into the InnoDB buffer. The ... Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-virtualization.html
Is MySQL supported on virtualized environments such as Oracle VM, VMWare, Docker, Microsoft Hyper-V, or others? A.18.1. Is MySQL supported on virtualized environments such as Oracle VM, VMWare, Docker, Microsoft Hyper-V, or others? MySQL is ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-qualifiers.html
The qualifier must be specified if there is no default database. For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the ...
https://dev.mysql.com/doc/refman/8.0/en/multifactor-authentication.html
(A warning occurs for statements that otherwise would not be permitted.) authentication_policy values can be defined in an option file or specified using a SET GLOBAL statement: SET GLOBAL authentication_policy='*,*,'; There are several rules that ... Authentication involves one party establishing its identity to the satisfaction of a second ...
https://dev.mysql.com/doc/refman/8.0/en/arithmetic-functions.html
* Multiplication: mysql> SELECT 3*5; -> 15 mysql> SELECT 18014398509481984*18014398509481984.0; -> 324518553658426726783156020576256.0 mysql> SELECT 18014398509481984*18014398509481984; -> out-of-range error The last expression produces an error ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-cluster-tables.html
ndb_sync_excluded_objects: Shows information about NDB database objects for which automatic synchronization has failed due to permanent errors resulting from mismatches which cannot be reconciled without manual intervention; these objects are ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-statements-current-table.html
SOURCE The name of the source file containing the instrumented code that produced the event and the line number in the file at which the instrumentation occurs. CURRENT_SCHEMA The default database for the statement, NULL if there is none. For use ...
https://dev.mysql.com/doc/refman/8.0/en/cannot-initialize-character-set.html
You might see an error like this if you have character set problems: MySQL Connection Failed: Can't initialize character set charset_name This error can have any of the following causes: The character set is a multibyte character set and you have ...In this case, you need to recompile the client by running CMake with the -DDEFAULT_CHARSET=charset_name ...
https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html
With regard to view updatability, the overall goal for views is that if any view is theoretically updatable, it should be updatable in practice. Many theoretically updatable views can be updated now, but limitations still exist. Dump files created ... The maximum number of tables that can be referenced in the definition of a view is ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-primary-key.html
Normally, errors occur for data-change statements (such as INSERT or UPDATE) that would violate primary-key, unique-key, or foreign-key constraints. If you are using a transactional storage engine such as InnoDB, MySQL automatically rolls back the ...If you use it, MySQL ignores primary-key or unique-key violations and continues processing with the next ...