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/storage-engine-setting.html
For example, in a replication setup, perhaps your source server uses InnoDB tables for maximum safety, but the replica servers use other storage engines for speed at the expense of durability or concurrency. To prevent confusing, unintended behavior ... When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage ...
https://dev.mysql.com/doc/refman/8.0/en/string-literals.html
The following lines are equivalent: 'a string' 'a' ' ' 'string' If the ANSI_QUOTES SQL mode is enabled, string literals can be quoted only within single quotation marks because a string quoted within double quotation marks is interpreted as an ... A ...
https://dev.mysql.com/doc/refman/8.0/en/sys-innodb-lock-waits.html
blocking_lock_mode The mode of the lock that is blocking the waiting lock. 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 ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-trx-info.html
Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and ...
https://dev.mysql.com/doc/refman/8.0/en/time.html
For more restrictive treatment of invalid TIME values, enable strict SQL mode to cause errors to occur. MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). The hours part may be so large ...
https://dev.mysql.com/doc/refman/8.0/en/year.html
If strict SQL mode is not enabled, MySQL converts invalid YEAR values to 0000. In strict SQL mode, attempting to insert an invalid YEAR value produces an error. The YEAR type is a 1-byte type used to represent year values. It can be declared as ...
https://dev.mysql.com/doc/refman/8.0/en/compilation-problems.html
This mode causes compiler warnings to become errors, so disabling it may enable compilation to proceed. For information about acquiring or updating tools, see the system requirements in Section 2.8, “Installing MySQL from Source”. If you do ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
To require an encrypted connection, a client need specify only the --ssl-mode=REQUIRED option; the connection attempt fails if a secure connection cannot be established. CREATE USER permits these resource_option values: MAX_QUERIES_PER_HOUR count, ... CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ...
https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-more-topics.html
Warning Any software updates or installations users perform to the Docker container (including those for MySQL components) may conflict with the optimized MySQL installation created by the Docker image. "Mounts": [ { "Type": "volume", "Name": ...A ...
https://dev.mysql.com/doc/refman/8.0/en/document-store-interfaces.html
You can use MySQL Shell to prototype applications, execute queries and update data. To work with MySQL as a document store, you use dedicated components and a choice of clients that support communicating with the MySQL server to develop document ...