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/structured-system-variables.html
These rules may assume greater significance if some other type of structured variable is created in the future. (You could also have written --default.key_buffer_size=256K.) In addition, the server creates a second key cache named extra_cache that ... A structured variable differs from a regular system variable in two respects: Its value is a structure with components that specify server parameters considered to be closely ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-temp-tables.html
memory_tmp_tables The total number of internal in-memory temporary tables created by occurrences of the statement. disk_tmp_tables The total number of internal on-disk temporary tables created by occurrences of the statement. These views list ...
https://dev.mysql.com/doc/refman/5.7/en/table-locking.html
Workarounds for Locking Performance Issues The following items describe some ways to avoid or reduce contention caused by table locking: Consider switching the table to the InnoDB storage engine, either using CREATE TABLE ... You might have to ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-before-you-begin.html
If your MySQL installation contains a large amount of data that might take a long time to convert after an in-place upgrade, it may be useful to create a test instance for assessing the conversions that are required and the work involved to perform ...The backup should include the mysql system database, which contains the MySQL system ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-troubleshooting.html
If you have created a loadable function with a given name and upgrade MySQL to a version that implements a new built-in function with the same name, the loadable function becomes inaccessible. To correct this, use DROP FUNCTION to drop the loadable ... If problems occur, such as that the new mysqld server does not start, verify that you do not have an old my.cnf file from your previous ...
https://dev.mysql.com/doc/refman/5.7/en/using-mysqldump.html
This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and INSERT statements to load data into tables. The output can be saved in a file and reloaded later using mysql to recreate the ... This section describes how to use mysqldump to produce dump files, and how to reload dump ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-reference.html
The following functions permit the server's list of version tokens to be created, changed, removed, and inspected. If a token does not exist, it is created with the given value. The following discussion serves as a reference to these Version Tokens ...
https://dev.mysql.com/doc/refman/5.7/en/workbench.html
MySQL Workbench provides five main areas of functionality: SQL Development: Enables you to create and manage connections to database servers. Data Modeling: Enables you to create models of your database schema graphically, reverse and forward ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-status-variables.html
If the bind has failed, or if the skip_networking option has been used, the value shows UNDEFINED. Mysqlx_errors_unknown_message_type The number of unknown message types that have been received. Mysqlx_notice_other_sent The number of other types of ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
mysql> SELECT TO_DAYS(950501); -> 728779 mysql> SELECT TO_DAYS('2007-10-07'); -> 733321 TO_DAYS() is not intended for use with values that precede the advent of the Gregorian calendar (1582), because it does not take into account the days that were ... This section describes the functions that can be used to manipulate temporal ...