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/symbolic-links-to-tables.html
For files used by tables for other storage engines, you may get strange problems if you try to use symbolic links. For InnoDB tables, use the alternative technique explained in Section 14.6.1.2, “Creating Tables Externally” instead. Do not ...
https://dev.mysql.com/doc/refman/5.7/en/channels-startup-options.html
--slave_net-timeout=N This value is set per channel, so that each channel waits for N seconds to check for a broken connection. --max-relay-log-size=size Maximum size of the individual relay log file for each channel; after reaching this limit, the ... This section describes startup options which are impacted by the addition of replication ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-lock-waits-table.html
row *************************** requesting_trx_id: 3396 requested_lock_id: 3396:91:3:2 blocking_trx_id: 3395 blocking_lock_id: 3395:91:3:2 Notes Use this table to help diagnose performance problems that occur during times of heavy concurrent load.
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf16.html
Because MySQL must allow for the worst case (that one character requires four bytes) the maximum length of a utf16 column or index is only half of the maximum length for a ucs2 column or index. The utf16 character set is the ucs2 character set with ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-pre-filtering.html
Modifications to any of these tables affect monitoring immediately, with some exceptions: Modifications to some instruments in the setup_instruments table are effective only at server startup; changing them at runtime has no effect. That might be ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-referential-constraints-table.html
The REFERENTIAL_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. UNIQUE_CONSTRAINT_CATALOG The name ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-storage-common-layer.html
A MySQL pluggable storage engine is the component in the MySQL database server that is responsible for performing the actual data I/O operations for a database as well as enabling and enforcing certain feature sets that target a specific ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-monitoring.html
row *************************** CHANNEL_NAME: source_1 GROUP_NAME: SOURCE_UUID: 046e41f8-a223-11e4-a975-0811960cc264 THREAD_ID: 24 SERVICE_STATE: ON COUNT_RECEIVED_HEARTBEATS: 0 LAST_HEARTBEAT_TIMESTAMP: 0000-00-00 00:00:00 RECEIVED_TRANSACTION_SET: ... To monitor the status of replication channels the following options exist: Using the replication Performance Schema ...
https://dev.mysql.com/doc/refman/5.7/en/insert-optimization.html
You can use the following methods to speed up inserts: If you are inserting many rows from the same client at the same time, use INSERT statements with multiple VALUES lists to insert several rows at a time. This is considerably faster (many times ... To optimize insert speed, combine many small operations into a single large ...
https://dev.mysql.com/doc/refman/5.7/en/windows-installation.html
This requirement changed over time: MySQL 5.7.37 and below requires the Microsoft Visual C++ 2013 Redistributable Package, MySQL 5.7.38 and 5.7.39 require both, and only the Microsoft Visual C++ 2019 Redistributable Package is required as of MySQL ... Important MySQL Community 5.7 Server requires the Microsoft Visual C++ 2019 Redistributable Package to run on Windows ...