Search Results
https://dev.mysql.com/doc/refman/8.4/en/load-xml.html
The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and >). LOAD XML acts as the complement of running the mysql client in XML output mode (that is, starting the ...
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/lock-order-tool.html
Some system variables exist in pairs, such as lock_order_debug_loop and lock_order_trace_loop. The MySQL server is a multithreaded application that uses numerous internal locking and lock-related primitives, such as mutexes, rwlocks (including ...
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
For example, if the statement fails part way through and rolls back, locks acquired up to the point of failure still exist. MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable ...
https://dev.mysql.com/doc/refman/8.4/en/log-destinations.html
You can atomically rename a log table (to perform log rotation, for example) using the following strategy: USE mysql; DROP TABLE IF EXISTS general_log2; CREATE TABLE general_log2 LIKE general_log; RENAME TABLE general_log TO general_log_backup, ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-launchd.html
$> cd /Library/LaunchDaemons $> sudo launchctl load -F com.oracle.oss.mysql.mysqld.plist To configure MySQL to automatically start at bootup, you can: $> sudo launchctl load -w com.oracle.oss.mysql.mysqld.plist Note The upgrade process replaces your ... macOS uses launch daemons to automatically start, stop, and manage processes and applications such as ...
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
Note A known issue exists where indexes on the same columns must be in identical order, in both the MERGE table and the underlying MyISAM table. The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-functions.html
ANY_VALUE() is also useful if functional dependence exists between columns but MySQL cannot determine it. The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ...
https://dev.mysql.com/doc/refman/8.4/en/multibyte-characters.html
The existing character sets provide the best documentation and examples to show how these functions are implemented. If you want to add support for a new character set named MYSET that includes multibyte characters, you must use multibyte character ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-servers.html
You might want to test a new MySQL release while leaving an existing production setup undisturbed. In some cases, you might want to run multiple instances of MySQL on a single machine. Or you might want to give different users access to different ...