PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/starting-server-troubleshooting.html
If you are going to use storage engines that support transactional tables (InnoDB, NDB), be sure that you have them configured the way you want before starting the server. If you are using InnoDB tables, see Section 17.8, “InnoDB Configuration” ... This section provides troubleshooting suggestions for problems starting the ...
https://dev.mysql.com/doc/refman/8.0/en/starting-server.html
If the server is unable to access the data directory it starts or read the grant tables in the mysql schema, it writes a message to its error log. Such problems can occur if you neglected to create the grant tables by initializing the data directory ... This section describes how start the server on Unix and Unix-like ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/en/sys-innodb-lock-waits.html
locked_table_partition The name of the locked partition, if any; NULL otherwise. locked_table_subpartition The name of the locked subpartition, if any; NULL otherwise. These views summarize the InnoDB locks that transactions are waiting for. The ...