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/mysql-cluster-limitations.html
In the sections that follow, we discuss known limitations in current releases of NDB Cluster as compared with the features available when using the MyISAM and InnoDB storage engines. You can report any discrepancies that you encounter to the MySQL ...Any problem which we do not plan to fix in NDB Cluster 8.0, is added to the ...See Section 25.2.7.11, “Previous NDB Cluster Issues Resolved in NDB Cluster 8.0” ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-myisam.html
The MyISAM storage engine performs best with read-mostly data or with low-concurrency operations, because table locks limit the ability to perform simultaneous updates. In MySQL, InnoDB is the default storage engine rather than MyISAM.
https://dev.mysql.com/doc/refman/8.0/en/primary-key-optimization.html
With the InnoDB storage engine, the table data is physically organized to do ultra-fast lookups and sorts based on the primary key column or columns. The primary key for a table represents the column or set of columns that you use in your most ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
You should be aware that while this makes the output easier to read, it also renders the JSON invalid, causing JSON functions to raise an error. If the value of explain_format is JSON, EXPLAIN ANALYZE returns an error unless FORMAT=TREE is specified ...In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a ... {EXPLAIN | DESCRIBE | DESC} tbl_name [col_name | wild] {EXPLAIN | DESCRIBE | DESC} [explain_type] {explainable_stmt | ...
https://dev.mysql.com/doc/refman/8.0/en/gis-wkt-functions.html
If the options argument is invalid, an error occurs to indicate why. For geographic SRS geometry arguments, if any argument has a longitude or latitude that is out of range, an error occurs: If a longitude value is not in the range (−180, 180], an ... These functions take as arguments a Well-Known Text (WKT) representation and, optionally, a spatial reference system identifier ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transaction-inconsistencies.html
If the error is in a mixed transaction, that transaction is half-applied. When using a multithreaded replica, workers which have not received an error complete their queues, so it may take time to stop all threads. This ensures it never leaves gaps ... Inconsistencies in the sequence of transactions that have been executed from the relay log can occur depending on your replication ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-recover.html
Details of the error and the last applied transaction are recorded in the Performance Schema replication_applier_status_by_worker table. Follow this procedure to recover from the error: Identify the replicated event that caused the error and verify ... If a privilege check against the PRIVILEGE_CHECKS_USER account fails, the transaction is not executed and replication stops for the ...
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/access-control.html
MySQL enables the creation of accounts that permit client users to connect to the server and access data managed by the server. The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to ...
https://dev.mysql.com/doc/refman/8.0/en/account-management-statements.html
This database and the access control system are discussed extensively in Chapter 7, MySQL Server Administration, which you should consult for additional details. MySQL account information is stored in the tables of the mysql system schema.