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/debugging-server.html
If mysqld starts to eat up CPU or memory or if it “hangs,” you can use mysqladmin processlist status to find out if someone is executing a query that takes a long time. If you are using some functionality that is very new in MySQL, you can try ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-key-types.html
MySQL Keyring supports keys of different types (encryption algorithms) and lengths: The available key types depend on which keyring plugin is installed. The permitted key lengths are subject to multiple factors: General keyring loadable-function ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-load-data.html
LOAD DATA is considered unsafe for statement-based logging (see Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”). When binlog_format=MIXED is set, the statement is logged in row-based format. When ...
https://dev.mysql.com/doc/refman/5.7/en/selecting-rows.html
As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, particularly when it becomes large. Instead, you're usually more interested in answering a particular question, in ...
https://dev.mysql.com/doc/refman/5.7/en/windows-testing.html
In this case, start mysqld with the skip_name_resolve system variable enabled and use only localhost and IP addresses in the Host column of the MySQL grant tables. (Be sure that an account exists that specifies an IP address or you may not be able ...
https://dev.mysql.com/doc/refman/5.7/en/windows-installation-layout.html
include Include (header) files lib Libraries share Miscellaneous support files, including error messages, character set files, sample configuration files, SQL for database installation . For MySQL 5.7 on Windows, the default installation directory ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-and-plugins.html
Time spent executing the code while the plugin was loaded was still spent even if the plugin is unloaded later. Removing a plugin with UNINSTALL PLUGIN does not affect information already collected for code in that plugin. The associated event ...
https://dev.mysql.com/doc/refman/5.7/en/channels-naming-conventions.html
Each replication channel has a unique name which is a string with a maximum length of 64 characters and is case-insensitive. This section describes how naming conventions are impacted by replication channels. Because channel names are used in ...
https://dev.mysql.com/doc/refman/5.7/en/alter-server.html
ALTER SERVER server_name OPTIONS (option [, option] ...) Alters the server information for server_name, adjusting any of the options permitted in the CREATE SERVER statement. For example, to update the USER option: ALTER SERVER s OPTIONS (USER ...
https://dev.mysql.com/doc/refman/5.7/en/backup-strategy-summary.html
In case of an operating system crash or power failure, InnoDB itself does all the job of recovering data. But to make sure that you can sleep well, observe the following guidelines: Always run the MySQL server with the --log-bin option, or even ...