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/mysql-cluster-install-shutdown-restart.html
On the SQL node host (198.51.100.20), execute the following command: C:\> SC START mysql In a production setting, it is usually not desirable to shut down the cluster completely. To shut down the cluster, enter the following command in a shell on ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-timeout.html
The total retry count can be seen in the output of SHOW STATUS; see Section 5.1.9, “Server Status Variables”.
https://dev.mysql.com/doc/refman/5.7/en/row-subqueries.html
An error occurs if the subquery produces multiple rows because a row subquery can return at most one row. Thus, the following query fails with a syntax error: SELECT * FROM t1 WHERE ROW(1) = (SELECT column1 FROM t2) Row constructors are legal in ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-truncate-table-reclaim-space.html
To reclaim operating system disk space when truncating an InnoDB table, the table must be stored in its own .ibd file. For a table to be stored in its own .ibd file, innodb_file_per_table must enabled when the table is created. Additionally, there ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-float.html
Floating-point numbers sometimes cause confusion because they are approximate and not stored as exact values. The following example uses DOUBLE to demonstrate how calculations that are done using floating-point operations are subject to ...A ...
https://dev.mysql.com/doc/refman/5.7/en/declare-condition.html
DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ... CONDITION statement declares a named error condition, associating a name with a condition that needs ...The ...
https://dev.mysql.com/doc/refman/5.7/en/sorting-rows.html
You may have noticed in the preceding examples that the result rows are displayed in no particular order. It is often easier to examine query output when the rows are sorted in some meaningful way. This means that the order is undefined for columns ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-stages.html
total_latency The total wait time of timed occurrences of the stage event for the host. avg_latency The average wait time per timed occurrence of the stage event for the host. By default, rows are sorted by host and descending total latency. The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-stages.html
total_latency The total wait time of timed occurrences of the stage event for the user. avg_latency The average wait time per timed occurrence of the stage event for the user. By default, rows are sorted by user and descending total stage latency.
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
Examples: SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(time_col))) FROM tbl_name; SELECT FROM_DAYS(SUM(TO_DAYS(date_col))) FROM tbl_name; Functions such as SUM() or AVG() that expect a numeric argument cast the argument to a number if necessary. Multiple ...