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/date-and-time-functions.html
mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET'); -> '2004-01-01 13:00:00' mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','+10:00'); -> '2004-01-01 22:00:00' Note To use named time zones such as 'MET' or 'Europe/Amsterdam', the ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/5.7/en/example-storage-engine.html
When you create an EXAMPLE table, the server creates a table format file in the database directory. The file begins with the table name and has an .frm extension. mysql> CREATE TABLE test (i INT) ENGINE = EXAMPLE; Query OK, 0 rows affected (0.78 ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-information-schema.html
Can I add to or otherwise modify the tables found in the INFORMATION_SCHEMA database? A.7.1. Where can I find documentation for the MySQL INFORMATION_SCHEMA database? See Chapter 24, INFORMATION_SCHEMA Tables. What is the difference between the ...
https://dev.mysql.com/doc/refman/5.7/en/foreign-key-optimization.html
If a table has many columns, and you query many different combinations of columns, it might be efficient to split the less-frequently used data into separate tables with a few columns each, and relate them back to the main table by duplicating the ...Depending on how the data is distributed, the queries might perform less I/O and take up less cache memory because the relevant columns are packed together on ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html
InnoDB tables require a FULLTEXT index on all columns of the MATCH() expression to perform boolean queries. The stopword list applies, controlled by innodb_ft_enable_stopword, innodb_ft_server_stopword_table, and innodb_ft_user_stopword_table for ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-index-types.html
Each InnoDB table has a special index called the clustered index that stores row data. When you define a PRIMARY KEY on a table, InnoDB uses it as the clustered index. If you do not define a PRIMARY KEY for a table, InnoDB uses the first UNIQUE ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-innodb_cmp.html
The INNODB_CMP and INNODB_CMP_RESET tables provide status information about operations related to compressed tables, which are described in Section 14.9, “InnoDB Table and Page Compression”. These two tables have identical contents, but reading ...For example, if you archive the output of INNODB_CMP_RESET every 60 minutes, you see the statistics for each hourly ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-purge-configuration.html
If DML action is concentrated on a single table, purge operations for the table are performed by a single purge thread. If DML action is concentrated on a few tables, keep the innodb_purge_threads setting low so that the threads do not contend with ... InnoDB does not physically remove a row from the database immediately when you delete it with an SQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-recovery.html
In some cases of database corruption, it is enough to dump, drop, and re-create one or a few corrupt tables. You can use the CHECK TABLE statement to check whether a table is corrupt, although CHECK TABLE naturally cannot detect every possible kind ...To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html
The default file name is keyring_encrypted, located in a directory that is platform specific and depends on the value of the INSTALL_LAYOUT CMake option, as shown in the following table. The password value cannot be displayed at runtime with SHOW ...