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/shutdown.html
Another way to stop the server is to send it a SIGTERM signal, which can be done by root or the account that owns the server process. SHUTDOWN provides an SQL-level interface to the same functionality available using the mysqladmin shutdown command ...
https://dev.mysql.com/doc/refman/5.7/en/sys-latest-file-io.html
The latest_file_io and x$latest_file_io views have these columns: thread For foreground threads, the account associated with the thread (and port number for TCP/IP connections). These views summarize file I/O activity, grouped by file and thread.
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-is-consumer-enabled.html
(Prior to MySQL 5.7.28, the function returns NULL if the argument is not a valid consumer name.) This function accounts for the consumer hierarchy, so a consumer is not considered enabled unless all consumers on which depends are also enabled.
https://dev.mysql.com/doc/refman/5.7/en/table-cache.html
Also take into account that the MyISAM storage engine needs two file descriptors for each unique open table. When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: ...
https://dev.mysql.com/doc/refman/5.7/en/union.html
If the data types of corresponding SELECT columns do not match, the types and lengths of the columns in the UNION result take into account the values retrieved by all the SELECT statements. [UNION [ALL | DISTINCT] SELECT ...] UNION combines the ...
https://dev.mysql.com/doc/refman/5.7/en/windows-initialize-data-directory.html
If you installed MySQL using the noinstall package, you may need to initialize the data directory: Windows distributions prior to MySQL 5.7.7 include a data directory with a set of preinitialized accounts in the mysql database. As of 5.7.7, Windows ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-options-system-variables.html
For modifications to this variable, if the new value is smaller than the current number of connections, the new limit is taken into account only for new connections. To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line ...
https://dev.mysql.com/doc/refman/5.7/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... HANDLER statement specifies a handler that deals ...
https://dev.mysql.com/doc/refman/5.7/en/drop-database.html
The DROP DATABASE statement removes from the given database directory those files and directories that MySQL itself may create during normal operation: All files with the following extensions: .BAK .DAT .HSH .MRG .MYD .MYI .TRG .TRN .cfg .db .frm ...
https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html
To start with an AUTO_INCREMENT value other than 1, set that value with CREATE TABLE or ALTER TABLE, like this: mysql> ALTER TABLE tbl AUTO_INCREMENT = 100; InnoDB Notes For information about AUTO_INCREMENT usage specific to InnoDB, see Section ...