https://dev.mysql.com/innodb-preload-buffer-pool.html
Because uncompressing pages is a CPU-intensive process, it is more efficient for concurrency to perform the operation in a connection thread rather than in the single thread that performs the buffer pool restore operation. To reduce the warmup ...
https://dev.mysql.com/innodb-redo-log.html
Modifications that did not finish updating the data files before an unexpected shutdown are replayed automatically during initialization, and before the connections are accepted. The redo log is a disk-based data structure used during crash ...
https://dev.mysql.com/insert-on-duplicate.html
If you specify the CLIENT_FOUND_ROWS flag to the mysql_real_connect() C API function when connecting to mysqld, the affected-rows value is 1 (not 0) if an existing row is set to its current values. If you specify an ON DUPLICATE KEY UPDATE clause ...
https://dev.mysql.com/insert.html
If you specify the CLIENT_FOUND_ROWS flag to the mysql_real_connect() C API function when connecting to mysqld, the affected-rows value is 1 (not 0) if an existing row is set to its current values. INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] ...
https://dev.mysql.com/ipv6-system-support.html
Before MySQL Server can accept IPv6 connections, the operating system on your server host must support IPv6. As a simple test to determine whether that is true, try this command: shell> ping6 ::1 16 bytes from ::1, icmp_seq=0 hlim=64 time=0.171 ms ...
https://dev.mysql.com/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/linux-installation-debian.html
Users who want to set a password later can leave the password field blank in the dialogue box and just press OK; in that case, root access to the server is authenticated using the MySQL Socket Peer-Credential Authentication Plugin for connections ...
https://dev.mysql.com/linux-installation-native.html
The libraries are required if you want to provide connectivity from different languages and environments such as Perl, Python and others. Many Linux distributions include a version of the MySQL server, client tools, and development components in ...
https://dev.mysql.com/load-data.html
Using LOCAL is a bit slower than letting the server access the files directly, because the file contents must be sent over the connection by the client to the server. INTO Statement”.) To write data from a table to a file, use SELECT ... To read ...
https://dev.mysql.com/locale-support.html
Any client can examine the value of lc_time_names or set its SESSION value to affect the locale for its own connection. The locale indicated by the lc_time_names system variable controls the language used to display day and month names and ...
