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/query-cache-thread-states.html
These thread states are associated with the query cache (see Section 8.10.3, “The MySQL Query Cache”). checking privileges on cached query The server is checking whether the user has privileges to access a cached query result. checking query ...
https://dev.mysql.com/doc/refman/5.7/en/show-databases.html
SHOW {DATABASES | SCHEMAS} [LIKE 'pattern' | WHERE expr] SHOW DATABASES lists the databases on the MySQL server host. The LIKE clause, if present, indicates which database names to match. The WHERE clause can be given to select rows using more ...
https://dev.mysql.com/doc/refman/5.7/en/statement-optimization.html
The core logic of a database application is performed through SQL statements, whether issued directly through an interpreter or submitted behind the scenes through an API. The tuning guidelines in this section help to speed up all kinds of MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/sys-format-path.html
Given a path name, returns the modified path name after replacing subpaths that match the values of the following system variables, in order: datadir tmpdir slave_load_tmpdir innodb_data_home_dir innodb_log_group_home_dir innodb_undo_directory ...
https://dev.mysql.com/doc/refman/5.7/en/channels-naming-conventions.html
Each replication channel has a unique name which is a string with a maximum length of 64 characters and is case-insensitive. This section describes how naming conventions are impacted by replication channels. Because channel names are used in ...
https://dev.mysql.com/doc/refman/5.7/en/optimization.html
Sometimes you can be proactive and plan in advance for performance, while other times you might troubleshoot a configuration or code issue after a problem occurs. This chapter explains how to optimize MySQL performance and provides examples.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-session-account-connect-attrs-table.html
Application programs can provide key-value connection attributes to be passed to the server at connect time. For descriptions of common attributes, see Section 25.12.9, “Performance Schema Connection Attribute Tables”. The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-session-connect-attrs-table.html
Application programs can provide key-value connection attributes to be passed to the server at connect time. For descriptions of common attributes, see Section 25.12.9, “Performance Schema Connection Attribute Tables”. To see connection ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-consumers-table.html
If you disable a consumer, the server does not spend time adding event information to it. For detailed information about the effect of enabling different consumers, see Section 25.4.7, “Pre-Filtering by Consumer”.
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-stack.html
row *************************** thread_stack: {"rankdir": "LR","nodesep": "0.10", "stack_created": "2014-02-19 13:39:03", "mysql_version": "5.7.3-m13", "mysql_user": "root@localhost","events": [{"nesting_event_id": "0", "event_id": "10", ... Returns ...