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/locking-functions.html
The OBJECT_TYPE column says USER LEVEL LOCK and the OBJECT_NAME column indicates the lock name. When this happens, the server chooses a caller and terminates its lock-acquisition request with an ER_USER_LOCK_DEADLOCK error. A warning is logged if ...
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/sys-processlist.html
The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. db The default database for the thread, or NULL if there is none. They provide more complete information than the SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/select-optimization.html
Scalability means that your application can handle more simultaneous users, larger requests, and so on without experiencing a big drop in performance. Queries, in the form of SELECT statements, perform all the lookup operations in the database. NDB ...
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/optimizing-innodb-configuration-variables.html
Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that experience spikes of high activity. Because the InnoDB storage engine performs many of its ...See ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-windows-command-line-servers.html
To shut down the servers, connect to each using the appropriate port number: C:\> C:\mysql\bin\mysqladmin --port=3307 --host=127.0.0.1 --user=root --password shutdown C:\> C:\mysql\bin\mysqladmin --port=3308 --host=127.0.0.1 --user=root --password ...Enable such connections by starting the server with the shared_memory system variable enabled and specify a unique shared-memory name for each server by setting the shared_memory_base_name system ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-general-info.html
Instead, users of NDB Cluster binaries from Oracle should upgrade to the most recent binary release of NDB Cluster for supported platforms—these include RPMs that should work with most Linux distributions. NDB Cluster users who build from source ...While many standard MySQL schemas and applications can work using NDB Cluster, it is also true that unmodified applications and database schemas may be slightly incompatible or have suboptimal performance when run using NDB Cluster (see Section 21.2.7, “Known Limitations of NDB ...