PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/server-shutdown.html
The server shutdown process takes place as follows: The shutdown process is initiated. For example, a user with the SHUTDOWN privilege can execute a mysqladmin shutdown command. Other operating system-specific shutdown initiation methods are ...
https://dev.mysql.com/doc/refman/9.7/en/server-status-variables.html
The MySQL server maintains many status variables that provide information about its operation. You can view these variables and their values by using the SHOW [GLOBAL | SESSION] STATUS statement (see Section 15.7.7.39, “SHOW STATUS Statement”).
https://dev.mysql.com/doc/refman/9.7/en/set-sql-log-bin.html
SET sql_log_bin = {OFF|ON} The sql_log_bin variable controls whether logging to the binary log is enabled for the current session (assuming that the binary log itself is enabled). To disable or enable binary logging for the current session, set the ...
https://dev.mysql.com/doc/refman/9.7/en/show-replica-status.html
SHOW REPLICA STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica threads. The statement requires the REPLICATION CLIENT privilege (or the deprecated SUPER privilege). When run concurrently ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-reference-systems.html
A spatial reference system (SRS) for spatial data is a coordinate-based system for geographic locations. There are different types of spatial reference systems: A projected SRS is a projection of a globe onto a flat surface; that is, a flat map.
https://dev.mysql.com/doc/refman/9.7/en/srjs-api-prepared-statements.html
The prepared statement API allows supported SQL statements (see SQL Syntax Permitted in Prepared Statements) to be re-executed without incurring the cost of parsing and optimization each time. The question mark or interrogation point (?) is used as ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-examples.html
This section contains examples illustrating a number of different aspects of using JavaScript programs under various circumstances. The following example demonstrates the use of a JavaScript stored function with table column values. Next, we create ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-mysql.html
The following SQL built-in functions can be called directly from the mysql namespace. These are described in the following list, along with their analogous SQL functions: rand() (MySQL RAND()): Returns a random floating-point value v in the range 0 ...
https://dev.mysql.com/doc/refman/9.7/en/storage-engines.html
Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default and most general-purpose storage engine, and Oracle recommends using it for tables except for specialized use cases. (The CREATE ...
https://dev.mysql.com/doc/refman/9.7/en/stored-program-restrictions.html
Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored functions. There are also some restrictions specific to stored functions but not to stored procedures. The restrictions for stored ...