PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/rename-table.html
You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. If any errors occur during a RENAME TABLE, the statement fails and no changes are made. Regardless of the statement used, if the ...
https://dev.mysql.com/doc/refman/8.0/en/repair-table-optimization.html
However, changing the global key buffer size invalidates the buffer, causing increased disk I/O and slowdown for other sessions. REPAIR TABLE for MyISAM tables is similar to using myisamchk for repair operations, and some of the same performance ...
https://dev.mysql.com/doc/refman/8.0/en/replication-compatibility.html
For example, you can replicate from a source running MySQL 5.6 to a replica running MySQL 5.7, from a source running MySQL 5.7 to a replica running MySQL 8.0, and so on. For example, if you are using a chained or circular replication setup, you ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-errors.html
For nontransactional storage engines such as MyISAM, it is possible to have a statement that only partially updates a table and returns an error code. If a statement produces the same error (identical error code) on both the source and the replica, ...This includes the case that a statement produces an error on the source or the replica, but not ...
https://dev.mysql.com/doc/refman/8.0/en/source-installation-prerequisites.html
Some of these tools are needed no matter whether you use a standard source distribution or a development source tree. (MySQL binaries built on recent versions of Windows can generally be run on older versions.) You can determine the Windows version ...To install MySQL from source, the following system requirements must be satisfied, regardless of installation method: CMake, which is used as the build framework on all ...
https://dev.mysql.com/doc/refman/8.0/en/subqueries.html
All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. is the outer query (or outer statement), and (SELECT column1 FROM t2) is the subquery. We say that the subquery is ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html
Semijoins are not applicable to window function optimization because semijoins apply to subqueries in WHERE and JOIN ... The workaround is to define the window in a WINDOW clause and refer to the window name in the OVER clauses. For faster ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-objects-table.html
For existing rows, only the ENABLED and TIMED columns can be modified, by users with the UPDATE privilege on the table. The order in which matching occurs matters because different matching setup_objects rows can have different ENABLED and TIMED ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-myisam-bulk-data-loading.html
This does not update any indexes and therefore is very fast. If you use locking, connections 2, 3, and 4 probably do not finish before 1 or 5, but the total time should be about 40% faster. INSERT, UPDATE, and DELETE operations are very fast in ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-queries-myisam.html
If you often need to calculate results such as counts based on information from a lot of rows, it may be preferable to introduce a new table and update the counter in real time. Try to avoid complex SELECT queries on MyISAM tables that are updated ...This updates a value for each index part that indicates the average number of rows that have the same ... Some general tips for speeding up queries on MyISAM tables: To help MySQL better ...