PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-features-repair-table.html
When used on a corrupted or otherwise damaged table, it is possible for the REPAIR TABLE statement to delete rows that cannot be recovered. However, any such modifications of table data performed by this statement are not replicated, which can ...
https://dev.mysql.com/doc/refman/5.7/en/table-corruption.html
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 'crashed'. If this happens, MySQL writes an entry in the ...
https://dev.mysql.com/doc/refman/5.7/en/index-statistics.html
(This may occur for bulk inserts or deletes, or some ALTER TABLE statements, for example.) If this happens, the statistics are collected using whatever value innodb_stats_method or myisam_stats_method has at the time. Storage engines collect ...For ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-select-all.html
ndb_select_all prints all rows from an NDB table to stdout. Usage ndb_select_all -c connection_string tbl_name -d db_name [> file_name] Options that can be used with ndb_select_all are shown in the following table. --database=dbname, -d dbname Name ...--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-locking.html
In addition, ALTER TABLE statements take metadata locks on the table level. In MySQL 5.7, partition lock pruning eliminates unneeded locks in many cases, and most statements reading from or updating a partitioned MyISAM table cause only the effected ...Effects on DML statements SELECT statements (including those containing unions or joins) lock only those partitions that actually need to be ...
https://dev.mysql.com/doc/refman/5.7/en/commit.html
To disable autocommit mode implicitly for a single series of statements, use the START TRANSACTION statement: START TRANSACTION; SELECT @A:=SUM(salary) FROM table1 WHERE type=1; UPDATE table2 SET summary=@A WHERE type=1; COMMIT; With START ...SET ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html
For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, the auto-update value, or both: An auto-initialized column is set to the current timestamp for inserted rows that specify no value for the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-connection-control-failed-login-attempts-table.html
This table provides information about the current number of consecutive failed connection attempts per account (user/host combination). Notes The CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS plugin must be activated for this table to be available, and ...CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS has these columns: USERHOST The user/host combination indicating an account that has failed connection attempts, in 'user_name'@'host_name' ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-connection-control-table-reference.html
Table 24.9 INFORMATION_SCHEMA Connection Control Tables Table Name Description CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Current number of consecutive failed connection attempts per account .
https://dev.mysql.com/doc/refman/5.7/en/information-schema-firewall-table-reference.html
Table 24.10 INFORMATION_SCHEMA Firewall Tables Table Name Description MYSQL_FIREWALL_USERS Firewall in-memory data for account profiles MYSQL_FIREWALL_WHITELIST Firewall in-memory data for account profile allowlists .