PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/events-syntax.html
MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. An event can be dropped by any user having the EVENT privilege for the database on which the event is defined. The ...
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
If so, create an appropriate index and check the query with EXPLAIN again. Plan isn't ready yet (JSON property: none) This value occurs with EXPLAIN FOR CONNECTION when the optimizer has not finished creating the execution plan for the statement ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tables-table.html
Names of databases and user tables are in the same case as they were originally defined, possibly influenced by the lower_case_table_names setting. The number reported includes three hidden columns that are created by InnoDB (DB_ROW_ID, DB_TRX_ID, ... The INNODB_SYS_TABLES table provides metadata about InnoDB tables, equivalent to the information from the SYS_TABLES table in the InnoDB data ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-analyze-table-complexity.html
To set the number of pages sampled for an individual table, use the STATS_SAMPLE_PAGES option with CREATE TABLE or ALTER TABLE. For the nonunique indexes, the primary key columns (a,b) are counted in addition to the user defined columns. ANALYZE ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
If you have no indexes suitable for your statement and MySQL must scan the entire table to process the statement, every row of the table becomes locked, which in turn blocks all inserts by other users to the table. It is important to create good ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-isolation-levels.html
A user can change the isolation level for a single session or for all subsequent connections with the SET TRANSACTION statement. This is because a non-locking SELECT statement presents the state of the database from a read-view which consists of ...
https://dev.mysql.com/doc/refman/5.7/en/json-utility-functions.html
In the case where it is string, the function returns the amount of storage space in the JSON binary representation that is created by parsing the string as JSON and converting it to binary. This section documents utility functions that act on JSON ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-error-reporter.html
ndb_error_reporter creates an archive from data node and management node log files that can be used to help diagnose bugs or other problems with a cluster. Optionally, you can supply the name of a user that is able to access the cluster's data ...
https://dev.mysql.com/doc/refman/5.7/en/query-log.html
The server creates the file in the data directory unless an absolute path name is given to specify a different directory. To rename the file and create a new one, use the following commands: $> mv host_name.log host_name-old.log $> mysqladmin ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
Only statements that can be logged using GTID safe statements can be logged when enforce_gtid_consistency is set to ON, so the operations listed here cannot be used with this option: CREATE TABLE ... SELECT statements CREATE TEMPORARY TABLE or DROP ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...