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/dynamic-format.html
Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table option. You can use OPTIMIZE TABLE or myisamchk -r to ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-create-select.html
SELECT statement to make any changes in tables other than the table that is created by the statement. Some older versions of MySQL permitted these statements to do so; this means that, when using replication between a MySQL 5.6 or later replica and ...To prevent this from happening, you should use row-based replication, rewrite the offending statement before running it on the source, or upgrade the source to MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/blackhole-storage-engine.html
When you create a BLACKHOLE table, the server creates a table format file in the database directory. The file begins with the table name and has an .frm extension. That is, you can include index declarations in the table definition. Inserts into a ... The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-crash-recovery.html
If your tables become corrupted frequently, you should try to find the reason why. For an explanation of how MyISAM tables can become corrupted, see Section 15.2.4, “MyISAM Table Problems”. If you run mysqld with external locking disabled (which ... This section describes how to check for and deal with data corruption in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-consumer-configurations.html
The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. The setup_consumers table contains the following hierarchy of values: global_instrumentation thread_instrumentation events_waits_current ...The ...
https://dev.mysql.com/doc/refman/5.7/en/programs-overview.html
mysql_install_db This program initializes the MySQL data directory, creates the mysql database and initializes its grant tables with default privileges, and sets up the InnoDB system tablespace. mysql_tzinfo_to_sql This program loads the time zone ...Later sections provide a more detailed description of each one, with the exception of NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
Parameters in_action ENUM('snapshot', 'overall', 'delta', 'create_tmp', 'create_table', 'save', 'cleanup'): The action to take. The default is to make a snapshot of the current content of the Performance Schema events_statements_summary_by_digest ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
Here is a simple example that associates a trigger with a table, to activate for INSERT operations. The trigger acts as an accumulator, summing the values inserted into one of the columns of the table. In this case, the trigger activates before each ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.20, “CREATE TRIGGER Statement”, and Section 13.1.31, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/5.7/en/static-format.html
Static-format tables have these characteristics: CHAR and VARCHAR columns are space-padded to the specified column width, although the column type is not altered. It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, ...
https://dev.mysql.com/doc/refman/5.7/en/ndb-restore-to-different-version.html
In such cases, it is necessary to alter any tables using utf8mb4_ai_ci so that they use a character set supported in the older version prior to performing the backup. Due to changes in how the MySQL Server and NDB handle table metadata, tables ...