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/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/multiple-tables.html
Given these considerations, the CREATE TABLE statement for the event table might look like this: mysql> CREATE TABLE event (name VARCHAR(20), date DATE, type VARCHAR(15), remark VARCHAR(255)); As with the pet table, it is easiest to load the initial ... The pet table keeps track of which pets you ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldumpslow.html
The MySQL slow query log contains information about queries that take a long time to execute (see Section 7.4.5, “The Slow Query Log”). mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow ...
https://dev.mysql.com/doc/refman/8.0/en/sys-io-global-by-wait-by-bytes.html
These views summarize global I/O consumers to display amount of I/O and time waiting for I/O, grouped by event. By default, rows are sorted by descending total I/O (bytes read and written). The io_global_by_wait_by_bytes and ...avg_read The average ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-statement-type.html
These views summarize information about statements executed, grouped by host and statement type. By default, rows are sorted by host and descending total latency. The host_summary_by_statement_type and x$host_summary_by_statement_type views have ...