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/replication-snapshot-method.html
For more information, see Section 4.5.4, “mysqldump — A Database Backup Program”. For InnoDB, all tables in all databases are stored in the system tablespace files, unless you have the innodb_file_per_table option enabled. The following files ... If the database on the source contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/5.7/en/functions.html
Rather than showing examples in this format: mysql> SELECT MOD(29,9); +-----------+ | mod(29,9) | +-----------+ | 2 | +-----------+ 1 rows in set (0.00 sec) This format is used instead: mysql> SELECT MOD(29,9); -> 2 . Expressions can be used at ...
https://dev.mysql.com/doc/refman/5.7/en/option-modifiers.html
The --maximum prefix is available for mysqld only and permits a limit to be placed on how large client programs can set session system variables. For example, with --maximum-back_log=200, the server produces this error: Maximum value of 'back_log' ...For example, the mysql client supports a --column-names option that determines whether or not to display a row of column names at the beginning of query ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-locking.html
For example, a SELECT from a partitioned MyISAM table locks only those partitions actually containing rows that satisfy the SELECT statement's WHERE condition are locked. For statements affecting partitioned tables using storage engines such as ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-stages-history-table.html
To set the number of rows per thread explicitly, set the performance_schema_events_stages_history_size system variable at server startup. When the table contains the maximum number of rows for a given thread, the oldest thread row is discarded when ... The events_stages_history table contains the N most recent stage events that have ended per ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-history-table.html
To set the number of rows per thread explicitly, set the performance_schema_events_statements_history_size system variable at server startup. When the table contains the maximum number of rows for a given thread, the oldest thread row is discarded ... The events_statements_history table contains the N most recent statement events that have ended per ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-history-table.html
To set the number of rows per thread explicitly, set the performance_schema_events_transactions_history_size system variable at server startup. When the table contains the maximum number of rows for a given thread, the oldest thread row is discarded ... The events_transactions_history table contains the N most recent transaction events that have ended per ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-history-table.html
To set the number of rows per thread explicitly, set the performance_schema_events_waits_history_size system variable at server startup. When the table contains the maximum number of rows for a given thread, the oldest thread row is discarded when a ... The events_waits_history table contains the N most recent wait events that have ended per ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-effect.html
The second column shows the result of the SELECT using the German DIN-1 rule, which says that U-umlaut sorts with U. The third column shows the result of the SELECT using the German DIN-2 rule, which says that U-umlaut sorts with UE.
https://dev.mysql.com/doc/refman/5.7/en/information-schema-collations-table.html
The COLLATIONS table provides information about collations for each character set. IS_DEFAULT Whether the collation is the default for its character set. CHARACTER_SET_NAME The name of the character set with which the collation is associated.