PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-change-buffer.html
During this time, disk I/O is increased, which can cause a significant slowdown for disk-bound queries. The change buffer is a special data structure that caches changes to secondary index pages when those pages are not in the buffer pool. The ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-other-options.html
This improves join performance by enabling the join optimizer to better choose the order in which to join the tables and which indexes it should use. --block-search=offset, -b offset Command-Line Format --block-search=offset Type Numeric Find the ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-features-to-trace.html
They are: Greedy search: With an N-table join, this could explore factorial(N) plans. These switches are listed here: greedy_search: Greedy search is not traced. dynamic_range: Only the first call to the range optimizer on this JOIN_TAB::SQL_SELECT ... Some features in the optimizer can be invoked many times during statement optimization and execution, and thus can make the trace grow beyond ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-reference.html
Slave_rows_last_search_algorithm_used: Search algorithm most recently used by this replica to locate rows for row-based replication (index, table, or hash scan). gtid_executed_compression_period: Compress gtid_executed table each time this many ...
https://dev.mysql.com/doc/refman/5.7/en/string-comparison-functions.html
To search for \, specify it as \\\\; this is because the backslashes are stripped once by the parser and again when the pattern match is made, leaving a single backslash to be matched against. (Unless the NO_BACKSLASH_ESCAPES SQL mode is enabled, in ... Table 12.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the resulting string is also a binary ...
https://dev.mysql.com/doc/refman/5.7/en/alter-event.html
This example changes the SQL statement executed by myevent to one that deletes all records from mytable; it also changes the schedule for the event such that it executes once, one day after this ALTER EVENT statement is run. This includes any ...
https://dev.mysql.com/doc/refman/5.7/en/backup-policy.html
This backup operation acquires a global read lock on all tables at the beginning of the dump (using FLUSH TABLES WITH READ LOCK). As soon as this lock has been acquired, the binary log coordinates are read and the lock is released. While the server ...A full backup (a snapshot of the data at a point in time) can be done in MySQL with several ...
https://dev.mysql.com/doc/refman/5.7/en/command-line-options.html
In this Manual, we use dashes in option names, except where underscores are significant. An exception to this rule is the option for specifying your MySQL password. This option can be given in long form as --password=pass_val or as --password. This ... Program options specified on the command line follow these rules: Options are given after the command ...
https://dev.mysql.com/doc/refman/5.7/en/installing-mysql-shell-linux-quick.html
This is an example of the subrepository's default entry in the file (the baseurl entry in your file might look different, depending on your Linux distribution): [mysql-tools-preview] name=MySQL Tools Preview ...To do so, you need to remove your old ... Note Installation packages for MySQL Shell are available only for a limited number of Linux distributions, and only for 64-bit ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-windows-command-line-servers.html
The procedure for starting a single MySQL server manually from the command line is described in Section 2.3.4.6, “Starting MySQL from the Windows Command Line”. To start multiple servers this way, you can specify the appropriate options on the ...It is more convenient to place the options in an option file, but it is necessary to make sure that each server gets its own set of ...