Search Results
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-rpm.html
The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM packages provided by Oracle. There are two sources for obtaining them, for the Community Edition of MySQL: From the MySQL software repositories: The MySQL Yum ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-launchd.html
The ProgramArguments section defines the command line options that are passed into the program, which is the mysqld binary in this case. macOS uses launch daemons to automatically start, stop, and manage processes and applications such as MySQL.
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-notes.html
Data: Because the MySQL package installer installs the MySQL contents into a version and platform specific directory, you can use this to upgrade and migrate your database between versions. You should keep the following issues and notes in mind: ...
https://dev.mysql.com/doc/refman/8.4/en/merge-table-advantages.html
For example, you can put data from different months into separate tables, compress some of them with myisampack, and then create a MERGE table to use them as one. MERGE tables can help you solve the following problems: Easily manage a set of log ...
https://dev.mysql.com/doc/refman/8.4/en/mrr-optimization.html
The accessed rows are packed into packages and sent back to the central node. Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-data-directories.html
You can unpack such a distribution into a temporary location, then copy it data directory to where you are setting up the new instance. Each MySQL Instance on a machine should have its own data directory. There are different methods of setting up a ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-server-clients.html
Start the client with --protocol=TCP to connect using TCP/IP, --protocol=SOCKET to connect using a Unix socket file, --protocol=PIPE to connect using a named pipe, or --protocol=MEMORY to connect using shared memory. For TCP/IP connections, you may ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-tables.html
The pet table keeps track of which pets you have. If you want to record other information about them, such as events in their lives like visits to the vet or when litters are born, you need another table. What should this table look like? It needs ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-key-cache.html
That is, it reads from the cache or writes into it rather than reading from or writing to disk. To minimize disk I/O, the MyISAM storage engine exploits a strategy that is used by many database management systems. It employs a cache mechanism to ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-maintenance-schedule.html
Alternatively, if you can stop the mysqld server for a while, change location into the data directory and use this command while the server is stopped: $> myisamchk -r -s --sort-index --myisam_sort_buffer_size=16M */*.MYI . It is a good idea to ...