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/audit-log-filter-definitions.html
The preceding definition can be written like this: { "filter": { "class": [ { "name": [ "connection", "general", "table_access" ] } ] } } Logging Specific Event Subclasses To select specific event subclasses, use an event item containing a name item ...For information about using JSON data in MySQL, see Section 11.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/5.7/en/memory-use.html
The InnoDB buffer pool is a memory area that holds cached InnoDB data for tables, indexes, and other auxiliary buffers. For each MyISAM table the server opens, the index file is opened once; the data file is opened once for each concurrently running ... MySQL allocates buffers and caches to improve performance of database ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-quick-start.html
If this engine is available (which you should already have checked earlier), you should see it listed with a SUPPORT value of YES in the output from the Information Schema ENGINES table or the SHOW ENGINES statement: mysql> SELECT * FROM ... This ...
https://dev.mysql.com/doc/refman/5.7/en/temporary-table-problems.html
Use ALTER TABLE instead: ALTER TABLE old_name RENAME new_name; You cannot refer to a TEMPORARY table more than once in the same query. Temporary tables created with CREATE TEMPORARY TABLE have the following limitations: TEMPORARY tables are ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html
It is permitted to mix VIRTUAL and STORED columns within a table. A function is deterministic if, given the same data in tables, multiple invocations produce the same result, independently of the connected user. A generated column definition can ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-table-maintenance.html
This section discusses how to use myisamchk to check or repair MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). For general myisamchk background, see Section 4.6.3, “myisamchk — MyISAM Table-Maintenance ...
https://dev.mysql.com/doc/refman/5.7/en/show-open-tables.html
SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open in the table cache. The FROM clause, if present, restricts the tables shown to those present in the db_name ...The WHERE clause can be given to select rows using more general conditions, as discussed in Section 24.8, “Extensions to SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-handling-nulls.html
DROP PARTITION, see Section 13.1.8, “ALTER TABLE Statement”.) NULL is also treated in this way for partitioning expressions that use SQL functions. If you insert a row into a table partitioned by RANGE such that the column value used to ...
https://dev.mysql.com/doc/refman/5.7/en/cost-model.html
These estimates are stored in the server_cost and engine_cost tables in the mysql system database and are configurable at any time. The intent of these tables is to make it possible to easily adjust the cost estimates that the optimizer uses when it ... To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
To use a row format other than DYNAMIC, configure innodb_default_row_format, or specify the ROW_FORMAT option explicitly in a CREATE TABLE or ALTER TABLE statement. Design your tables to minimize their space on the disk. Smaller tables normally ...