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/show-master-status.html
row *************************** File: source-bin.000002 Position: 1307 Binlog_Do_DB: test Binlog_Ignore_DB: manual, mysql Executed_Gtid_Set: 3E11FA47-71CA-11E1-9E33-C80AA9429562:1-5 1 row in set (0.00 sec) When global transaction IDs are in use, ...
https://dev.mysql.com/doc/refman/5.7/en/connection-control-plugin-variables.html
connection_control_max_connection_delay Command-Line Format --connection-control-max-connection-delay=# Introduced 5.7.17 System Variable connection_control_max_connection_delay Scope Global Dynamic Yes Type Integer Default Value 2147483647 Minimum ...Connection Control Plugin Status Variables If the CONNECTION_CONTROL plugin is installed, it exposes this status variable: Connection_control_delay_generated The number of times the server added a delay to its response to a failed connection ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-options.html
To specify an option file for a C program, use the --defaults-file option as one of the elements of the second argument of the mysql_library_init() function. Any options that may be given with the mysqld server daemon, may be used with an embedded ...
https://dev.mysql.com/doc/refman/5.7/en/start-slave.html
SQL_THREAD starts the replication applier thread, which reads events from the relay log and executes them. You must check the replica's error log for error messages generated by the replication threads, or check that they are running satisfactorily ... START SLAVE [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ...
https://dev.mysql.com/doc/refman/5.7/en/table-corruption.html
If you get a lot of these errors, without mysqld having died unexpectedly just before, then something is wrong and needs to be investigated further. When the server detects MyISAM table corruption, it writes additional information to the error log, ... If you have started mysqld with the myisam_recover_options system variable set, MySQL automatically checks and tries to repair MyISAM tables if they are marked as 'not closed properly' or ...
https://dev.mysql.com/doc/refman/5.7/en/silent-column-changes.html
In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, to attributes associated with a data type, or to an index specification. All changes are ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html
If an attempted runtime assignment to keyring_encrypted_file_data results in an error, the variable value remains unchanged. If an attempted runtime assignment to keyring_file_data results in an error, the variable value remains unchanged. If an ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-range-list.html
To drop the partition named p2, execute the following command: mysql> ALTER TABLE tr DROP PARTITION p2; Query OK, 0 rows affected (0.03 sec) Note The NDBCLUSTER storage engine does not support ALTER TABLE ... You can see that this is the case by ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-selection.html
As you can see from the result when the SELECT is run a second time, there remains a row in the table matching the WHERE condition, but residing in a different partition (p2). MySQL 5.7 supports explicit selection of partitions and subpartitions ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk.html
Possible causes include but are not limited to file system errors. The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for ...