Search Results
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-rpm.html
The full names for the RPMs have the following syntax: packagename-version-distribution-arch.rpm The distribution and arch values indicate the Linux distribution and the processor type for which the package was built. Notes The mysql user is created ... The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM packages provided by ...
https://dev.mysql.com/doc/refman/8.4/en/load-data-local-security.html
To avoid LOAD DATA issues, clients should avoid using LOCAL unless proper client-side precautions have been taken. Clients that make no explicit arrangements therefore have LOCAL capability disabled or enabled according to the ENABLED_LOCAL_INFILE ... The LOAD DATA statement loads a data file into a ...
https://dev.mysql.com/doc/refman/8.4/en/locale-support.html
Locale names have language and region subtags listed by IANA (http://www.iana.org/assignments/language-subtag-registry) such as 'ja_JP' or 'pt_BR'. The default value is 'en_US' regardless of your system's locale setting, but you can set the value at ... The locale indicated by the lc_time_names system variable controls the language used to display day and month names and ...
https://dev.mysql.com/doc/refman/8.4/en/log-destinations.html
(This assumes that the general query log itself is enabled.) Log Table Benefits and Characteristics The use of tables for log output offers the following benefits: Log entries have a standard format. For users who have access to the .CSV files that ... MySQL Server provides flexible control over the destination of output written to the general query log and the slow query log, if those logs are ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-column-indexes.html
For example, if you have a three-column index on (col1, col2, col3), you have indexed search capabilities on (col1), (col1, col2), and (col1, col2, col3). MySQL can create composite indexes (that is, indexes on multiple columns). For certain data ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-data-directories.html
Each MySQL Instance on a machine should have its own data directory. Warning Normally, you should never have two servers that update data in the same databases. If (despite this warning) you run multiple servers using the same data directory and ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-servers.html
In addition to using different data directories, several other options must have different values for each server instance: --port=port_num --port controls the port number for TCP/IP connections. If you have multiple MySQL installations in different ... In some cases, you might want to run multiple instances of MySQL on a single ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-maintenance-schedule.html
For example, whenever the machine has done a restart in the middle of an update, you usually need to check each table that could have been affected before it is used further. To start with, execute myisamchk -s each night on all tables that have ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-repair.html
Note that when you do mysqladmin shutdown on a remote server, the mysqld server is still available for a while after mysqladmin returns, until all statement-processing has stopped and all index changes have been flushed to disk. Stage 1: Checking ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk.html
myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. You can also use the CHECK TABLE and ...