PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/account-activity-auditing.html
When a client connects successfully, the server authenticates the client to a particular row in this table. Its value is constructed from the User and Host columns of the user table row for the account. However, this value does not necessarily ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-transactional-storage.html
Data dictionary tables are created in a single InnoDB tablespace named mysql.ibd, which resides in the MySQL data directory. The data dictionary schema stores dictionary data in transactional (InnoDB) tables. Data dictionary tables are located in ...
https://dev.mysql.com/doc/refman/8.0/en/events-configuration.html
Starting the MySQL server with the --skip-grant-tables option causes event_scheduler to be set to DISABLED, overriding any other value set either on the command line or in the my.cnf or my.ini file (Bug #26807). For SQL statements used to create, ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-installation.html
The available scripts differ in the file name used to refer to the script: win_install_firewall.sql linux_install_firewall.sql The installation script creates stored procedures in the default database, mysql. MySQL Enterprise Firewall installation ...
https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html
The default return type of IF() (which may matter when it is stored into a temporary table) is calculated as follows: If expr2 or expr3 produce a string, the result is a string. The second syntax returns the result for the first condition that is ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-functional-dependence.html
The following discussion provides several examples of the ways in which MySQL detects functional dependencies. The examples use this notation: {X} -> {Y} Understand this as “X uniquely determines Y,” which also means that Y is functionally ...
https://dev.mysql.com/doc/refman/8.0/en/key-space.html
In MyISAM tables, you can also prefix compress numbers by specifying the PACK_KEYS=1 table option when you create the table. This is for the worst case when all keys are inserted in sorted order and the table doesn't have any compressed keys. You ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-failover.html
This means that the ndb_apply_status table contains information for the replica on this host as well as for any other host which acts as a replica of the replication source server running on this host. Using the information obtained from the query ... In the event that the primary Cluster replication process fails, it is possible to switch over to the secondary replication ...
https://dev.mysql.com/doc/refman/8.0/en/out-of-range-and-overflow.html
In strict mode, these statements fail, and some or all the values are not inserted or changed, depending on whether the table is a transactional table and other factors. If no restrictive modes are enabled, MySQL clips the value to the appropriate ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-startup-configuration.html
It is possible that a plugin installed later may create the instrument, at which time the name is recognized and configured. Consumer names in the setup_consumers table use underscores, but for consumers set at startup, dashes and underscores within ... To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to ...