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/windows-pluggable-authentication.html
With this plugin-loading method, the option must be given each time the server starts. Alternatively, to load the plugin at runtime, use this statement: INSTALL PLUGIN authentication_windows SONAME 'authentication_windows.dll'; INSTALL PLUGIN loads ... Note Windows pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/windows-upgrading.html
Deselect all but the MySQL server product, unless you intend to upgrade other products at this time, and click Next. If you encounter errors, see Section 2.3.5, “Troubleshooting a Microsoft Windows MySQL Server Installation”. There are two ...
https://dev.mysql.com/doc/refman/5.7/en/charset-table.html
Every table has a table character set and a table collation. The CREATE TABLE and ALTER TABLE statements have optional clauses for specifying the table character set and collation: CREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-directory.html
If a DATA DIRECTORY or INDEX DIRECTORY table option is used in a CREATE TABLE statement on the source server, the table option is also used on the replica. This can cause problems if no corresponding directory exists in the replica host's file ...
https://dev.mysql.com/doc/refman/5.7/en/system-optimization.html
Some system-level factors can affect performance in a major way: If you have enough RAM, you could remove all swap devices. Some operating systems use a swap device in some contexts even if you have free memory. The --external-locking and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-group-members-table.html
ERROR: The member has encountered an error, either during applying transactions or during the recovery phase, and is not participating in the group's transactions. UNREACHABLE: The failure detection process suspects that this member cannot be ...
https://dev.mysql.com/doc/refman/5.7/en/replication-problems.html
If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for messages. Many users have lost time by not doing this soon enough after encountering problems. If you cannot tell from ...If binary logging is not enabled, verify that you are running the source server with the --log-bin ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-backup-recovery.html
For information about point-in-time recovery, recovery from disk failure or corruption, and how InnoDB performs crash recovery, see Section 14.19.2, “InnoDB Recovery”. This section covers topics related to InnoDB backup and recovery. For ...
https://dev.mysql.com/doc/refman/5.7/en/deallocate-prepare.html
Attempting to execute a prepared statement after deallocating it results in an error. {DEALLOCATE | DROP} PREPARE stmt_name To deallocate a prepared statement produced with PREPARE, use a DEALLOCATE PREPARE statement that refers to the prepared ...
https://dev.mysql.com/doc/refman/5.7/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...