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/starting-server.html
If the server is unable to access the data directory it starts or read the grant tables in the mysql database, it writes a message to its error log. Such problems can occur if you neglected to create the grant tables by initializing the data ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-metadata.html
To obtain metadata about stored routines: Query the ROUTINES table of the INFORMATION_SCHEMA database. Use the SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION statements to see routine definitions. Use the SHOW PROCEDURE STATUS and SHOW FUNCTION ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-databases.html
Suppose that you have a database db1 under the MySQL data directory, and then make a symlink db2 that points to db1: $> cd /path/to/datadir $> ln -s db1 db2 The result is that, for any table tbl_a in db1, there also appears to be a table tbl_a in ...
https://dev.mysql.com/doc/refman/5.7/en/sys-create-synonym-db.html
Given a schema name, this procedure creates a synonym schema containing views that refer to all the tables and views in the original schema. This can be used, for example, to create a shorter name by which to refer to a schema with a long name ...
https://dev.mysql.com/doc/refman/5.7/en/sys-extract-schema-from-file-name.html
For this reason, it does not work with partitions or tables defined using their own DATA_DIRECTORY table option. Given a file path name, returns the path component that represents the schema name. This function assumes that the file name lies ...
https://dev.mysql.com/doc/refman/5.7/en/sys-format-statement.html
This function is useful for formatting possibly lengthy statements retrieved from Performance Schema tables to a known fixed maximum length. Configuration Options format_statement() operation can be modified using the following configuration options ... Given a string (normally representing an SQL statement), reduces it to the length given by the statement_truncate_len configuration option, and returns the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-statement-latency.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. full_scans The total number of full table scans by statements for the host.
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-statement-type.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. full_scans The total number of full table scans by occurrences of the ...
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. These views summarize statement activity, file I/O, and connections, grouped ...
https://dev.mysql.com/doc/refman/5.7/en/sys-innodb-lock-waits.html
These views summarize the InnoDB locks that transactions are waiting for. The innodb_lock_waits and x$innodb_lock_waits views have these columns: wait_started The time at which the lock wait started. wait_age How long the lock has been waited for, ...