PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html
$> mysqld --innodb-buffer-pool-size=8G --innodb-buffer-pool-instances=16 mysql> SELECT @@innodb_buffer_pool_size/1024/1024/1024; +------------------------------------------+ | @@innodb_buffer_pool_size/1024/1024/1024 | ... You can configure InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-example.html
* * In your $HOME/.my.cnf file, you probably want to put: [test2_libmysqld_SERVER] language = /path/to/source/of/mysql/sql/share/english * You could, of course, modify argc and argv before passing * them to this function. * * If you link this client ... These two example programs should work without any changes on a Linux or FreeBSD ...
https://dev.mysql.com/doc/refman/5.7/en/loading-tables.html
See Section 6.1.6, “Security Considerations for LOAD DATA LOCAL”, for information on how to change this. Suppose that Diane gets a new hamster named “Puffball.” You could add a new record using an INSERT statement like this: mysql> INSERT ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-start.html
Note This is a limit per thread! delay_key_write=ALL Don't flush key buffers between writes for any MyISAM table. Note If you do this, you should not access MyISAM tables from another program (such as from another MySQL server or with myisamchk) ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-multiple-nodes.html
A LOCK TABLES statement or GET_LOCK() call works only for the SQL node on which the lock is issued; no other SQL node in the cluster “sees” this lock. This is true for a lock issued by any statement that locks tables as part of its operations.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-host-cache-table.html
The Performance Schema must be enabled or this table is empty. This information enables the server to avoid caching bad or missing host names during temporary DNS failures, which would negatively affect clients forever. For the rationale why this ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-pre-filtering.html
An instrument disabled in this table produces no events regardless of the contents of the other production-related setup tables. An instrument enabled in this table is permitted to produce events, subject to the contents of the other tables. This ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-memory.html
To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that notifies replicas that the table must be emptied by writing a DELETE or (from MySQL 5.7.32) TRUNCATE TABLE statement ... When a replication source server shuts down and restarts, its MEMORY tables become ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-concepts.html
This section explains these concepts and is essential reading before attempting to modify the replication mode of an online server. This means it is possible to have a replication topology that has servers using both anonymous and GTID transactions.
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-disable-gtids.html
This section describes how to disable GTID transactions on servers that are already online. This procedure does not require taking the server offline and is suited to use in production. You cannot disable GTID transactions online on any single ...