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/information-schema-innodb-ft-default-stopword-table.html
This is not used if you override the default stopword processing with either the innodb_ft_server_stopword_table or the innodb_ft_user_stopword_table system variable. Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-adaptive-hash.html
Based on the observed pattern of searches, a hash index is built using a prefix of the index key. The adaptive hash index enables InnoDB to perform more like an in-memory database on systems with appropriate combinations of workload and sufficient ...
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 ...