Search Results
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-launchd.html
Figure 2.6 MySQL Preference Pane: Location The Instances page includes an option to start or stop MySQL, and Initialize Database recreates the data/ directory. The default plist definition is written with less sophisticated use cases in mind. macOS ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-pkg.html
The initial wizard introduction screen references the MySQL server version to install. The package is located inside a disk image (.dmg) file that you first need to mount by double-clicking its icon in the Finder. Note Before proceeding with the ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-prefpane.html
The Instances page includes an option to start or stop MySQL, and Initialize Database recreates the data/ directory. The MySQL Installation Package includes a MySQL preference pane that enables you to start, stop, and control automated startup ...
https://dev.mysql.com/doc/refman/8.4/en/memory-use.html
The table_open_cache system variable defines the initial table cache size; see Section 10.4.3.1, “How MySQL Opens and Closes Tables”. The table_definition_cache system variable defines the number of table definitions that can be stored in the ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-alter-table-performance-schema.html
The estimated work after completion of the initial stage is 1213. You can monitor ALTER TABLE progress for InnoDB tables using Performance Schema. There are seven stage events that represent different phases of ALTER TABLE. Each stage event reports ...
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. There are different methods of setting up a data directory for a new instance: Create a new data directory. Warning Normally, you should never have two servers that update data in ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-tables.html
Given these considerations, the CREATE TABLE statement for the event table might look like this: mysql> CREATE TABLE event (name VARCHAR(20), date DATE, type VARCHAR(15), remark VARCHAR(255)); As with the pet table, it is easiest to load the initial ... The pet table keeps track of which pets you ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-unix-servers.html
Note The discussion here uses mysqld_safe to launch multiple instances of MySQL. For MySQL installation using an RPM distribution, server startup and shutdown is managed by systemd on several Linux platforms. On these platforms, mysqld_safe is not ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-table-info.html
“Record” and “row” are synonymous, as are “field” and “column.” The initial part of the table description contains these values: MyISAM file Name of the MyISAM (index) file. To obtain a description of a MyISAM table or statistics ...
https://dev.mysql.com/doc/refman/8.4/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row. MySQL uses mmap() ...