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/performance-schema-transaction-tables.html
The setup_timers table contains a row with a NAME value of transaction that indicates the unit for transaction event timing. The cost of transaction instrumentation can be reduced various ways, such as enabling or disabling transaction ...These ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-monitoring.html
When the server cannot create a mutex instrument, these results occur: No row for the instrument is inserted into the setup_instruments table. However, the content of the tables in the performance_schema database misses events. For example, ...Names ...Other mutexes have an instance per connection, or per page in various caches and data buffers, so the number of instances varies over ...
https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html
Windows users, please note that FAT and VFAT (FAT32) are not considered suitable for production use with MySQL. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL ...For up-to-date information operating system file size limits, refer to the documentation specific to your operating ...
https://dev.mysql.com/doc/refman/5.7/en/handler.html
The HANDLER interface is a more natural way to look at data when working with applications that provide an interactive user interface to the database. (See Section 14.21, “InnoDB memcached Plugin” for an alternative way to adapt applications ...
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/multiple-key-caches.html
For example: mysql> SET GLOBAL keycache1.key_buffer_size=128*1024; To destroy a key cache, set its size to zero: mysql> SET GLOBAL keycache1.key_buffer_size=0; You cannot destroy the default key cache. Shared access to the key cache improves ...To ...
https://dev.mysql.com/doc/refman/5.7/en/windows-troubleshooting.html
The following examples show other common error messages you might encounter when installing MySQL and starting the server for the first time: If the MySQL server cannot find the mysql privileges database or other critical files, it displays these ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-connection-configuration-table.html
(CHANGE MASTER TO option: MASTER_PORT) USER The user name of the account used to connect to the replication source server. (CHANGE MASTER TO option: MASTER_USER) NETWORK_INTERFACE The network interface that the replica is bound to, if any. This ...
https://dev.mysql.com/doc/refman/5.7/en/show-events.html
In its simplest form, SHOW EVENTS lists all of the events in the current schema: mysql> SELECT CURRENT_USER(), SCHEMA(); +----------------+----------+ | CURRENT_USER() | SCHEMA() | +----------------+----------+ | jon@ghidora | myschema | ...row ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-select-all.html
--ndb-connectstring Command-Line Format --ndb-connectstring=connection_string Type String Default Value [none] Set connect string for connecting to ndb_mgmd. --ndb-nodeid Command-Line Format --ndb-nodeid=# Type Integer Default Value [none] Set node ...--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 ...