PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-mgm-definition.html
(NDB 7.5.0) This refers to the Id set for one of the computers defined in a [computer] section of the config.ini file. Normally, the management server should be configured as an arbitrator by setting its ArbitrationRank to 1 (the default for ... The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-shm-definition.html
For optimum performance, you can define a spin time for the SHM transporter (ShmSpinTime parameter); this affects both the data node receiver thread and the poll owner (receive thread or user thread) in NDB. You can enable a shared memory connection ...The shared-memory transporter (SHM) can improve performance by negating up to 20% of the overhead required by a TCP connection when running an API node (usually an SQL node) and a data node together on the same ...
https://dev.mysql.com/doc/refman/5.7/en/using-systemd.html
In other cases, the error log directory must be writable or the error log must be present and writable for the user running the mysqld process. Arrange for systemd to set environment variables for the MySQL server process. For example: [Service] ...
https://dev.mysql.com/doc/refman/5.7/en/controlling-query-plan-evaluation.html
A more flexible method for query optimization enables the user to control how exhaustive the optimizer is in its search for an optimal query evaluation plan. If you are unsure of what a reasonable value is for optimizer_search_depth, this variable ... The task of the query optimizer is to find an optimal plan for executing an SQL ...The general idea is that the fewer plans ...
https://dev.mysql.com/doc/refman/5.7/en/perl-installation.html
These tests attempt to connect to the local MySQL server using the default user name and password. (The default user name is your login name on Unix, and ODBC on Windows. The default password is “no password.”) If you cannot connect to the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-isolation-levels.html
A user can change the isolation level for a single session or for all subsequent connections with the SET TRANSACTION statement. Isolation is the I in the acronym ACID; the isolation level is the setting that fine-tunes the balance between ...InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/disk-issues.html
You can also set the parameters for the file system that the database uses: If you do not need to know when files were last accessed (which is not really useful on a database server), you can mount your file systems with the -o noatime option. For ... This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-drop-table.html
--database, -d Command-Line Format --database=name Type String Default Value TEST_DB Name of the database in which the table resides. --ndb-connectstring Command-Line Format --ndb-connectstring=connection_string Type String Default Value [none] Set ...--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving ...
https://dev.mysql.com/doc/refman/5.7/en/native-pluggable-authentication.html
This section describes mysql_native_password, which implements authentication against the mysql.user system table using the native password hashing method. MySQL includes two plugins that implement native authentication; that is, authentication ...
https://dev.mysql.com/doc/refman/5.7/en/temporary-files.html
For the first one found to be set, MySQL uses it and does not check those remaining. If the MySQL server is acting as a replica, you can set the slave_load_tmpdir system variable to specify a separate directory for holding temporary files when ...If ... On Unix, MySQL uses the value of the TMPDIR environment variable as the path name of the directory in which to store temporary ...