Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
For example, the following query retrieves index sizes for partitions of table t1: mysql> SELECT SUM(stat_value) pages, index_name, SUM(stat_value)*@@innodb_page_size size FROM mysql.innodb_index_stats WHERE table_name like 't1#P%' AND stat_name = ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...
https://dev.mysql.com/doc/refman/8.4/en/insert-on-duplicate.html
References to columns in other tables, as long as the SELECT does not use GROUP BY. If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row ...
https://dev.mysql.com/doc/refman/8.4/en/installing-source-distribution.html
To install MySQL from a standard source distribution: Verify that your system satisfies the tool requirements listed at Section 2.8.2, “Source Installation Prerequisites”. Obtain a distribution file using the instructions in Section 2.1.3, ...
https://dev.mysql.com/doc/refman/8.4/en/internal-temporary-tables.html
Evaluation of statements that contain an ORDER BY clause and a different GROUP BY clause, or for which the ORDER BY or GROUP BY contains columns from tables other than the first table in the join queue. In some cases, the server creates internal ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-rpm.html
Notes The mysql user is created using the -r and -s /bin/false options of the useradd command, so that it does not have login permissions to your server host (see Creating the mysql User and Group for details). The recommended way to install MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/load-data-local-security.html
If you use LOAD DATA LOCAL in Perl scripts or other programs that read the [client] group from option files, you can add a local-infile option setting to that group. The LOAD DATA statement loads a data file into a table. The statement can load a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-linux-rpm.html
The RPM installer should take care of general configuration issues (such as creating the mysql user and group, if needed) automatically. The RPM installer should take care of general configuration issues (such as creating the mysql user and group, ... This section covers the steps necessary to install the correct executables for each type of NDB Cluster node using RPM packages supplied by ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-windows-binary.html
(You can obtain this name using ECHO %USERNAME% on the command line.) To install and run NDB Cluster executables as Windows services, this user should be a member of the Administrators group. You should also have the MySQL client (mysql.exe) on this ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-log-events.html
An event report reported in the event logs has the following format: datetime [string] severity -- message For example: 09:19:30 2005-07-24 [NDB] INFO -- Node 4 Start phase 4 completed This section discusses all reportable events, ordered by ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-files.html
The files table is empty if no disk data objects have been created in NDB. See Section 25.6.11.1, “NDB Cluster Disk Data Objects”, for more information.