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/replication-rbr-safe-unsafe.html
When activated, this causes such warnings not to be written to the error log; instead, for each 50 warnings of this type, a note The last warning was repeated N times in last S seconds is written to the error log. Formerly, if a large number of such ...This continues as long as the 50 most recent such warnings were issued in 50 seconds or less; once the rate has decreased below this threshold, the warnings are once again logged ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-files-using-openssl.html
A typical error in this case is: ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1) Important If a client connecting to a MySQL server instance uses an SSL certificate with the extendedKeyUsage extension (an X.509 v3 ... This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and ...
https://dev.mysql.com/doc/refman/5.7/en/out-of-range-and-overflow.html
When a floating-point or fixed-point column is assigned a value that exceeds the range implied by the specified (or default) precision and scale, MySQL stores the value representing the corresponding endpoint of that range. If strict SQL mode is ...
https://dev.mysql.com/doc/refman/5.7/en/structured-system-variables.html
(You could also have written --default.key_buffer_size=256K.) In addition, the server creates a second key cache named extra_cache that has a size of 128KB, with the size of block buffers for caching table index blocks set to 2048 bytes. The ... A ...
https://dev.mysql.com/doc/refman/5.7/en/windows-start-service.html
You should now be able to invoke any MySQL executable program by typing its name at the DOS prompt from any directory on the system, without having to supply the path. If mysqld does not start, check the error log to see whether the server wrote any ... On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and ...
https://dev.mysql.com/doc/refman/5.7/en/index-statistics.html
For example, if during the course of executing statements for a table, some of those statements modify the table, MySQL may collect statistics. (This may occur for bulk inserts or deletes, or some ALTER TABLE statements, for example.) If this ...
https://dev.mysql.com/doc/refman/5.7/en/controlling-query-plan-evaluation.html
The task of the query optimizer is to find an optimal plan for executing an SQL query. Because the difference in performance between “good” and “bad” plans can be orders of magnitude (that is, seconds versus hours or even days), most query ...For join queries, the number of possible plans investigated by the MySQL optimizer grows exponentially with the number of tables referenced in a ...
https://dev.mysql.com/doc/refman/5.7/en/replace.html
As with INSERT, if it is not possible to insert the new row into any of these partitions or subpartitions, the REPLACE statement fails with the error Found a row not matching the given partition set. such statements produce a warning in the error ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-txn.html
When a memcached operation inserts, updates, or deletes data in the underlying InnoDB table, the change might be committed to the InnoDB table instantly (if daemon_memcached_w_batch_size=1) or some time later (if the daemon_memcached_w_batch_size ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-wait-summary-tables.html
COUNT_STAR, SUM_TIMER_WAIT, MIN_TIMER_WAIT, AVG_TIMER_WAIT, MAX_TIMER_WAIT These columns aggregate all I/O operations. COUNT_READ, SUM_TIMER_READ, MIN_TIMER_READ, AVG_TIMER_READ, MAX_TIMER_READ These columns aggregate all read operations. The ...