Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-introduction.html
Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. Key Advantages of InnoDB Its DML operations follow the ACID model, with transactions featuring commit, ... InnoDB is a general-purpose storage engine that balances high reliability and high ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-remote-connections.html
mysql> SELECT CURRENT_USER(), @@bind_address; +-----------------------------------+----------------+ | CURRENT_USER() | @@bind_address | +-----------------------------------+----------------+ | remoteipv6user@2001:db8:0:f101::2 | :: | ... The ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-support.html
IPv6 addresses can be specified in account names in statements such as CREATE USER, GRANT, and REVOKE. For example: mysql> CREATE USER 'bill'@'::1' IDENTIFIED BY 'secret'; mysql> GRANT SELECT ON mydb.* TO 'bill'@'::1'; IPv6 functions enable ...
https://dev.mysql.com/doc/refman/8.4/en/json-validation-functions.html
In this example, we set a user variable @schema to the value of a JSON schema for geographical coordinates, and another one @document to the value of a JSON document containing one such coordinate. In this example, we set a user variable @schema to ... MySQL supports validation of JSON documents against JSON schemas conforming to Draft 4 of the JSON Schema ...
https://dev.mysql.com/doc/refman/8.4/en/ldml-collation-example.html
The collation is designed for a scenario involving a Web application for which users post their names and phone numbers. You can check the variable value as follows, although the path name might be different on your system: mysql> SHOW VARIABLES ...
https://dev.mysql.com/doc/refman/8.4/en/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 14.1, “Built-In Function and Operator Reference” For general ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-mysqld.html
row *************************** Id: 1 User: system user Host: db: Command: Daemon Time: 1 State: Waiting for event from ndbcluster Info: NULL Important To participate in an NDB Cluster, the mysqld process must be started with both the options ...To ...
https://dev.mysql.com/doc/refman/8.4/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 TEMPORARY TABLE or DROP TEMPORARY TABLE statements inside ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/refman/8.4/en/replication-sbr-rbr.html
For most users, the mixed replication format should provide the best combination of data integrity and performance. SELECT, a CREATE statement is generated from the table definition and replicated using statement-based format, while the row ...If, ...
https://dev.mysql.com/doc/refman/8.4/en/sys-processlist.html
tmp_tables The number of internal in-memory temporary tables created by the current statement. tmp_disk_tables The number of internal on-disk temporary tables created by the current statement. The MySQL process list indicates the operations ...