PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/macos-installation-launchd.html
macOS uses launch daemons to automatically start, stop, and manage processes and applications such as MySQL. The md5 checksum of a file containing the above snippet is d925f05f6d1b6ee5ce5451b596d6baed. To enable the launchd service, you can either: ...
https://dev.mysql.com/doc/refman/8.0/en/macos-installation-pkg.html
It is named according to the version of MySQL you have downloaded. 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 installation, be sure ...
https://dev.mysql.com/doc/refman/8.0/en/macos-installation-prefpane.html
Note The MySQL preference pane only starts and stops MySQL installation installed from the MySQL package installation that have been installed in the default location. The MySQL Installation Package includes a MySQL preference pane that enables you ...
https://dev.mysql.com/doc/refman/8.0/en/macos-installation.html
The user you use to perform the installation must have administrator privileges. For a list of macOS versions that the MySQL server supports, see https://www.mysql.com/support/supportedplatforms/database.html. MySQL for macOS is available in a ...
https://dev.mysql.com/doc/refman/8.0/en/making-trace-files.html
To do this, you must have a mysqld that has been compiled with debugging support. If the mysqld server does not start or it crashes easily, you can try to create a trace file to find the problem. If the version number ends with -debug, it is ...
https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html
MOD() also works on values that have a fractional part and returns the exact remainder after division: mysql> SELECT MOD(34.5,3); -> 1.5 MOD(N,0) returns NULL. ABS(X) Returns the absolute value of X, or NULL if X is NULL. An implication of this is ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-optimization-tips.html
If you have data that does not conform well to a rows-and-columns table structure, you can pack and store data into a BLOB column. This section lists a number of miscellaneous tips for improving query processing speed: If your application makes ...
https://dev.mysql.com/doc/refman/8.0/en/monitor-innodb-mutex-waits-performance-schema.html
A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to a common resource. When two or more threads executing in the server need to access the same resource, the threads compete ...
https://dev.mysql.com/doc/refman/8.0/en/monitor-mysql-memory-use.html
Memory instruments have names in the form of memory/code_area/instrument_name, where code_area is a value such as sql or innodb, and instrument_name is the instrument detail. The following example demonstrates how to use Performance Schema and sys ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-key-caches.html
Any attempt to do this is ignored: mysql> SET GLOBAL key_buffer_size = 0; mysql> SHOW VARIABLES LIKE 'key_buffer_size'; +-----------------+---------+ | Variable_name | Value | +-----------------+---------+ | key_buffer_size | 8384512 | ... Note As ...