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/sys-host-summary.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. statement_latency The total wait time of timed statements for the host.
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
For example, you cannot have two events in the same database with the names anEvent and AnEvent. (See also Bug #16522.) Each execution of the statements contained in the body of an event takes place in a new connection; thus, these statements have ...The restrictions for stored procedures also apply to the DO clause of Event Scheduler event ...Some of the restrictions ...
https://dev.mysql.com/doc/refman/5.7/en/error-message-elements.html
As just illustrated, the client may display the error message so the user can take corrective measures. Error Message Sources Error Message Elements Error Message Sources Error messages can originate on the server side or the client side: On the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-change-buffer.html
The purge operation can write disk blocks for a series of index values more efficiently than if each value were written to disk immediately. During this time, disk I/O is increased, which can cause a significant slowdown for disk-bound queries. The ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-server-clients.html
"mysql_read_default_file=/usr/local/mysql/data/my.cnf"; $dbh = DBI->connect($dsn, $user, $password); See Section 27.9, “MySQL Perl API”. On Unix, set the MYSQL_UNIX_PORT and MYSQL_TCP_PORT environment variables to point to the Unix socket file ...For TCP/IP connections, you may also need to specify --host and --port ...Start the client with --protocol=TCP to connect using TCP/IP, --protocol=SOCKET to connect using a Unix socket file, --protocol=PIPE to ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. The permitted qualifiers for object ...This statement creates a table using the qualified name db1.t1: CREATE TABLE db1.t1 (i INT); Because db1.t1 includes a database qualifier db1, the statement creates t1 in the database named db1, regardless of the default ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-installation.html
This section covers hardware and software requirements; networking issues; installation of NDB Cluster; basic configuration issues; starting, stopping, and restarting the cluster; loading of a sample database; and performing queries. A common ...The ...
https://dev.mysql.com/doc/refman/5.7/en/general-tablespaces.html
As with file-per-table tablespaces, the ability to place data files outside of the MySQL data directory allows you to manage performance of critical tables separately, setup RAID or DRBD for specific tables, or bind tables to particular disks, for ...The server keeps tablespace metadata in memory for the lifetime of a ... A general tablespace is ...
https://dev.mysql.com/doc/refman/5.7/en/locking-service.html
This is distinct from, for example, locks acquired with the GET_LOCK() function, which have an OBJECT_TYPE of USER LEVEL LOCK. Thus, for a statement such as the following, where service_get_write_locks() is called once per row of the result set, ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mixed.html
The following system variables, when used with session scope (only), do not cause the logging format to switch: auto_increment_increment auto_increment_offset character_set_client character_set_connection character_set_database character_set_server ...(Bug #12092, Bug #30244) When USER(), CURRENT_USER(), or CURRENT_USER is ... When running in MIXED logging format, the server automatically switches from statement-based to row-based logging ...