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/multiple-windows-command-line-servers.html
For example, the C:\my-opts1.cnf file might be written like this: [mysqld] datadir = C:/mydata1 port = 3307 enable-named-pipe socket = mypipe1 Modify C:\my-opts2.cnf similarly for use by the second server. To start multiple servers this way, you can ... The procedure for starting a single MySQL server manually from the command line is described in Section 2.3.4.6, “Starting MySQL from the Windows Command ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-enterprise-security.html
For more information, see Section 17.13, “InnoDB Data-at-Rest Encryption”, Section 19.3.2, “Encrypting Binary Log Files and Relay Log Files”, and Encrypting Audit Log Files. These functions enable masking existing data using several methods ... MySQL Enterprise Edition provides plugins that implement security features using external services: MySQL Enterprise Edition includes an authentication plugin that enables MySQL Server to use LDAP (Lightweight Directory Access Protocol) to authenticate MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/show-engine.html
The statement has these variants: SHOW ENGINE INNODB STATUS SHOW ENGINE INNODB MUTEX SHOW ENGINE PERFORMANCE_SCHEMA STATUS SHOW ENGINE INNODB STATUS displays extensive information from the standard InnoDB Monitor about the state of the InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/environment-variables.html
Options on the command line take precedence over values specified in option files and environment variables, and values in option files take precedence over values in environment variables. In many cases, it is preferable to use an option file ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html
If validate_password rejects the new password, it reports an error indicating the minimum number of characters that must differ. If the file is named as a relative path, it is interpreted relative to the server data directory. For the dictionary ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-unix-servers.html
-DMYSQL_TCP_PORT=port_number \ -DMYSQL_UNIX_ADDR=file_name \ -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-8.0.44 Here, port_number and file_name must be different from the default TCP/IP port number and Unix socket file path name, and the ...Compiling in ... Note The discussion here uses mysqld_safe to launch multiple instances of ...For MySQL installation using an RPM ...
https://dev.mysql.com/doc/refman/8.0/en/memory-use.html
The InnoDB buffer pool is a memory area that holds cached InnoDB data for tables, indexes, and other auxiliary buffers. For each MyISAM table the server opens, the index file is opened once; the data file is opened once for each concurrently running ...For efficiency of cache management, the buffer pool is implemented as a linked list of pages; data that is rarely used is aged out of the cache, using a variation of the LRU ...
https://dev.mysql.com/doc/refman/8.0/en/solaris-installation.html
If you do not have GNU tar on your system, install it with the following command: pkg install archiver/gnu-tar You should mount any file systems on which you intend to store InnoDB files with the forcedirectio option. (By default mounting is done ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-reference-systems.html
For computations on multiple geometry values, all values must have the same SRID or an error occurs. SRID 0 is the default SRID for spatial data in MySQL. MySQL maintains information about available spatial reference systems for spatial data in the ... A spatial reference system (SRS) for spatial data is a coordinate-based system for geographic ...Earth is a bit shorter in its North-South axis than its East-West ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-diskpagebuffer.html
The diskpagebuffer table provides statistics about disk page buffer usage by NDB Cluster Disk Data tables. The diskpagebuffer table contains the following columns: node_id The data node ID block_instance Block instance pages_written Number of pages ...Together with the block name, this number can be used to look up a given instance in the threadblocks ...row *************************** node_id: 1 thr_no: 1 block_name: PGMAN thread_name: rep pages_written: 0 pages_written_lcp: 0 pages_read: 1 log_waits: 0 ...