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-memcached-intro.html
For example, you can change the port that memcached listens on, reduce the maximum number of simultaneous connections, change the maximum memory size for a key-value pair, or enable debugging messages for the error log. Batch size options default to ... The InnoDB memcached plugin implements memcached as a MySQL plugin daemon that accesses the InnoDB storage engine directly, bypassing the MySQL SQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-tuning.html
In case of an outage, a maximum of 100 records are lost, which may be an acceptable margin of error. Because using InnoDB in combination with memcached involves writing all data to disk, whether immediately or sometime later, raw performance is ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-syntax.html
For integer data types, M indicates the minimum display width. Display width is unrelated to the range of values a type can store, as described in Section 11.1.6, “Numeric Type Attributes”. For floating-point and fixed-point data types, M is ...
https://dev.mysql.com/doc/refman/5.7/en/key-cache-restructuring.html
A key cache can be restructured at any time by updating its parameter values. File system caching is not as efficient as using a key cache, so although queries execute, a slowdown can be anticipated. For example: mysql> SET GLOBAL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benchmarking.html
If a table relies on a feature that is specific to another storage engine, you receive an error. In this case, add the ENGINE=other_engine_name clause to the CREATE TABLE statement to avoid the error. If InnoDB is not the default storage engine, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-installation.html
On the source: [mysqld] rpl_semi_sync_master_enabled=1 rpl_semi_sync_master_timeout=1000 # 1 second On each replica: [mysqld] rpl_semi_sync_slave_enabled=1 . For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE ... Semisynchronous replication is implemented using plugins, so the plugins must be installed into the server to make them ...
https://dev.mysql.com/doc/refman/5.7/en/alter-instance.html
ENCRYPTION operations, and locks are taken to prevent conflicts that could arise from concurrent execution of these statements. ALTER INSTANCE actions are written to the binary log so that they can be executed on replicated servers. ALTER INSTANCE ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-configuration-table.html
Parameters stored in the table can be changed at runtime with the CHANGE MASTER TO statement, as indicated in the column descriptions. DESIRED_DELAY The number of seconds that the replica must lag the source. This table shows the configuration ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-windows-binary.html
For this example, we refer to ndbd.exe as the data node executable, but you can install ndbmtd.exe, the multithreaded version of this program, instead, in exactly the same way. Note As with other Windows programs, NDB Cluster executables are named ...You should also have the MySQL client (mysql.exe) on this ...
https://dev.mysql.com/doc/refman/5.7/en/what-is-crashing.html
If your keyboard is locked up, you may be able to recover by logging in to your machine from another machine and executing kbd_mode -a. If you have examined all other possibilities and concluded that the MySQL server or a MySQL client is causing the ...This can normally be checked by pressing the Caps Lock ...