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/sys-metrics.html
The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the global_status table For InnoDB metrics: The NAME column of the INNODB_METRICS table For other metrics: A view-provided ... This view summarizes MySQL server metrics to show variable names, values, types, and whether they are ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-cache-table.html
Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index; for example test/articles. Before querying it, set the value of the ... The ...The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-disk-io.html
Because the doublewrite buffer setting is global, doublewrite buffering is also disabled for data files residing on non-Fusion-io hardware. InnoDB uses asynchronous disk I/O where possible, by creating a number of threads to handle I/O operations, ...In random read-ahead, if InnoDB notices that some area in a tablespace seems to be in the process of being fully read into the buffer pool, it posts the remaining reads to the I/O ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-optimization-tips.html
This section lists a number of miscellaneous tips for improving query processing speed: If your application makes several database requests to perform related updates, combining the statements into a stored routine can help performance. In this ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions.html
For information on using replication in a backup environment, including notes on the setup, backup procedure, and files to back up, see Section 16.3.1, “Using Replication for Backups”. For performance or data distribution reasons, you may want ... Replication can be used in many different environments for a range of ...Using replication as a scale-out solution requires ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-queries-myisam.html
An update of the following form is very fast: UPDATE tbl_name SET count_col=count_col+1 WHERE key_col=constant; This is very important when you use MySQL storage engines such as MyISAM that has only table-level locking (multiple readers with single ... Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk --analyze on a table after it has been loaded with ...
https://dev.mysql.com/doc/refman/5.7/en/check-table.html
CHECK TABLE Output Checking Version Compatibility Checking Data Consistency CHECK TABLE Usage Notes for InnoDB Tables CHECK TABLE Usage Notes for MyISAM Tables CHECK TABLE Output CHECK TABLE returns a result set with the columns shown in the ...The ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-restrictions.html
The exception is that for Unicode, the utf8 character set can be used, but not the ucs2 character set. Full-text searches are supported for InnoDB and MyISAM tables only. Although FULLTEXT indexes on ucs2 columns cannot be used, you can perform IN ...Ideographic languages such as Chinese and Japanese do not have word ...
https://dev.mysql.com/doc/refman/5.7/en/gone-away.html
If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by setting the server's max_allowed_packet variable, which has a default value of 4MB. More information on setting the packet size is ...The most common reason for the MySQL server has gone away error is that the server timed out and closed the ...
https://dev.mysql.com/doc/refman/5.7/en/installing-development-tree.html
Prerequisites for Installing from Development Source Setting Up a MySQL Git Repository Prerequisites for Installing from Development Source To install MySQL from a development source tree, your system must satisfy the tool requirements listed at ...