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/migrating-from-year2.html
YEAR(2) column definitions for new tables produce warnings or errors: Before MySQL 5.7.5, YEAR(2) column definitions for new tables are converted (with an ER_INVALID_YEAR_COLUMN_LENGTH warning) to 4-digit YEAR columns: mysql> CREATE TABLE t1 (y ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html
Table 15.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather than in the storage engine.) Yes Cluster database support No Clustered indexes No Compressed data Yes ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html
Some statements require a lot of execution time on the source, but result in just a few rows being modified. It is possible to change the logging format to STATEMENT, but doing so at runtime leads very rapidly to errors because InnoDB can no longer ...The logging format also can be switched at runtime, although note that there are a number of situations in which you cannot do this, as discussed later in this ...
https://dev.mysql.com/doc/refman/5.7/en/mysqladmin.html
--connect-timeout=value Command-Line Format --connect-timeout=value Type Numeric Default Value 43200 The maximum number of seconds before connection timeout. --shutdown-timeout=value Command-Line Format --shutdown-timeout=seconds Type Numeric ...You ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-stats-table.html
This number is incremented when a statement starts executing, not when it finishes. QUERIES_QUEUED The number of statements received that were queued for execution. This does not count statements that the thread group was able to begin executing ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-logging-configuration.html
The timestamp value is similar to a Unix timestamp, with the last 7 digits representing the fractional second part. The timestamp value is similar to a Unix timestamp, with the last 7 digits representing the fractional second part. When renaming ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. The index value of the empty string error value is 0. Value Index NULL NULL '' 0 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-config-example.html
You may also specify these parameters on the command line when invoking the executables. You may also use a separate [mysql_cluster] section in the cluster my.cnf file for settings to be read and used by all executables: # cluster-specific settings ... To support NDB Cluster, you must to update my.cnf as shown in the following ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-configuration-variables.html
Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that experience spikes of high activity. Preventing one-time operations such as table scans from interfering ...Because the InnoDB storage engine performs many of its optimizations automatically, many performance-tuning tasks involve monitoring to ensure that the database is performing well, and changing configuration options when performance ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
For example, the SUM_LOCK_TIME and SUM_ERRORS columns in statement summary tables are the aggregates of the LOCK_TIME and ERRORS columns in events_statements_current table. The prepared_statements_instances table has these additional summary ...(The ... The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary ...