PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-limitations.html
DDL operations take longer due to writing to storage, undo logs, and redo logs instead of .frm files. This section describes temporary limitations introduced with the MySQL data dictionary. Manual creation of database directories under the data ...
https://dev.mysql.com/doc/refman/8.0/en/deallocate-prepare.html
If too many prepared statements are created and not deallocated by either the DEALLOCATE PREPARE statement or the end of the session, you might encounter the upper limit enforced by the max_prepared_stmt_count system variable. {DEALLOCATE | DROP} ...
https://dev.mysql.com/doc/refman/8.0/en/debugging-client.html
If you have problems with your own client code, you should attempt to connect to the server and run your query using a client that is known to work. To be able to debug a MySQL client with the integrated debug package, you should configure MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/deleting-from-related-tables.html
If the total length of the DELETE statement for related_table is more than the default value of the max_allowed_packet system variable, you should split it into smaller parts and execute multiple DELETE statements. You probably get the fastest ...
https://dev.mysql.com/doc/refman/8.0/en/downgrading.html
In-place means starting and running a new MySQL server binary on an existing MySQL data directory that was created by a different MySQL server version. Downgrading from MySQL 8.0 to MySQL 5.7 is not supported. In-place downgrades are supported from ...
https://dev.mysql.com/doc/refman/8.0/en/drop-logfile-group.html
Currently, the only permitted values for engine_name are NDB and NDBCLUSTER. DROP LOGFILE GROUP logfile_group ENGINE [=] engine_name This statement drops the log file group named logfile_group. The log file group must already exist or an error ...
https://dev.mysql.com/doc/refman/8.0/en/drop-spatial-reference-system.html
Reserved ranges are [0, 32767] (reserved by EPSG), [60,000,000, 69,999,999] (reserved by EPSG), and [2,000,000,000, 2,147,483,647] (reserved by MySQL). DROP SPATIAL REFERENCE SYSTEM [IF EXISTS] srid srid: 32-bit unsigned integer This statement ...
https://dev.mysql.com/doc/refman/8.0/en/events-syntax.html
MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. The definition of an existing event can be changed by means of the ALTER EVENT statement. When a scheduled event is no ...
https://dev.mysql.com/doc/refman/8.0/en/extended-show.html
Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of INFORMATION_SCHEMA itself. Several SHOW statements accept a WHERE clause that provides more ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-virtualization.html
The usual ones are related to performance, performance degradations, slowness, or unpredictability of disk, I/O, network, and memory. Is MySQL supported on virtualized environments such as Oracle VM, VMWare, Docker, Microsoft Hyper-V, or others? ...