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-table-exists.html
Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, TEMPORARY is returned. Parameters in_db VARCHAR(64): The name of the database in which to ...
https://dev.mysql.com/doc/refman/5.7/en/user-variables.html
You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one statement to another. User variables are written as @var_name, where the variable name var_name ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
Table 6.32 audit_log_policy_value Values Value Corresponding audit_log_policy Value 0 or "::none" NONE 1 or "::logins" LOGINS 2 or "::all" ALL 3 or "::queries" QUERIES The "::xxx" values are symbolic pseudo-constants that may be given instead of the ...For information about using JSON data in MySQL, see Section 11.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/5.7/en/crashing.html
Normally, this is one of the last queries in the log file just before the server restarts. Run the command mysqladmin -i 5 status or mysqladmin -i 5 -r status in a separate window to produce statistics while running other queries. Each MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-cjk.html
This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) issues. What problems should I be aware of when working with the Big5 ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html
The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given query.
https://dev.mysql.com/doc/refman/5.7/en/innodb-standard-monitor.html
Contention can be due to heavy parallelism of queries or problems in operating system thread scheduling. You can calculate from these numbers how many data file I/O operations your queries currently are doing. The Lock Monitor is the same as the ...
https://dev.mysql.com/doc/refman/5.7/en/internal-temporary-tables.html
Tables created for subquery or semijoin materialization (see Section 8.2.2, “Optimizing Subqueries, Derived Tables, and View References”). For queries that use the SQL_SMALL_RESULT modifier, MySQL uses an in-memory temporary table, unless the ...
https://dev.mysql.com/doc/refman/5.7/en/log-file-maintenance.html
As described in Section 5.4, “MySQL Server Logs”, MySQL Server can create several different log files to help you see what activity is taking place. However, you must clean up these files regularly to ensure that the logs do not take up too ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
Despite the in-memory processing for MEMORY tables, they are not necessarily faster than InnoDB tables on a busy server, for general-purpose queries, or under a read/write workload. User-Created and Temporary Tables MEMORY table contents are stored ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...