PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/events-privileges.html
If you inspect the MySQL error log (hostname.err), you can see that the event is executing, but the action it is attempting to perform fails: 2013-09-24T12:41:31.261992Z 25 [ERROR] Event Scheduler: [jon@ghidora][cookbook.e_store_ts] INSERT command ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/8.0/en/federated-description.html
A FEDERATED table consists of two elements: A remote server with a database table, which in turn consists of the table definition (stored in the MySQL data dictionary) and the associated table. To read a result set, it uses mysql_store_result() and ... When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the associated ...
https://dev.mysql.com/doc/refman/8.0/en/floating-point-types.html
Here, (M,D) means than values can be stored with up to M digits in total, of which D digits may be after the decimal point. Because floating-point values are approximate and not stored as exact values, attempts to treat them as exact in comparisons ... The FLOAT and DOUBLE types represent approximate numeric data ...
https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html
Note The syntax of the CASE operator described here differs slightly from that of the SQL CASE statement described in Section 15.6.5.1, “CASE Statement”, for use inside stored programs. The default return type of IF() (which may matter when it ...The second syntax returns the result for the first condition that is ...
https://dev.mysql.com/doc/refman/8.0/en/general-tablespaces.html
Similar to the system tablespace, truncating or dropping tables stored in a general tablespace creates free space internally in the general tablespace .ibd data file which can only be used for new InnoDB data. Similar to the system tablespace, ... A ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-mapping.html
These files may be stored in the database directory, or the information may be stored in a separate file. There is a correspondence between database and table identifiers and names in the file system. For the basic structure, MySQL represents each ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablestats-table.html
This information is derived from in-memory data structures rather than data stored on disk. CLUST_INDEX_SIZE The number of pages on disk that store the clustered index, which holds the InnoDB table data in primary key order. OTHER_INDEX_SIZE The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
This is the total number of bytes of data that can be stored in the table, given the data pointer size used. For NDB tables, DATA_LENGTH includes data stored in main memory only; the MAX_DATA_LENGTH and DATA_FREE columns apply to Disk Data. The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-flushing.html
When table data is stored on a traditional HDD storage device, flushing neighbor pages in one operation reduces I/O overhead (primarily for disk seek operations) compared to flushing individual pages at different times. For table data stored on SSD, ... InnoDB performs certain tasks in the background, including flushing of dirty pages from the buffer ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-per-table-tablespaces.html
A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system in a single data file. Truncating or dropping a table stored in a shared tablespace creates free space within the shared tablespace ...