PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/custom-benchmarks.html
A free benchmark suite is the Open Source Database Benchmark, available at http://osdb.sourceforge.net/. In most cases, performance problems turn out to be due to issues of basic database design (for example, table scans are not good under high ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-multiple-buffer-pools.html
For systems with buffer pools in the multi-gigabyte range, dividing the buffer pool into separate instances can improve concurrency, by reducing contention as different threads read and write to cached pages. This feature is typically intended for ...Multiple buffer pool instances are configured using the innodb_buffer_pool_instances configuration option, and you might also adjust the innodb_buffer_pool_size ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-stages-history-long-table.html
To set the table size explicitly, set the performance_schema_events_stages_history_long_size system variable at server startup. The Performance Schema autosizes the value of N during server startup. For more information about the relationship ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-history-long-table.html
To set the table size explicitly, set the performance_schema_events_statements_history_long_size system variable at server startup. For more information about the relationship between the three events_statements_xxx event tables, see Section 25.9, ... The events_statements_history_long table contains the N most recent statement events that have ended globally, across all ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-history-long-table.html
To set the table size explicitly, set the performance_schema_events_transactions_history_long_size system variable at server startup. The Performance Schema autosizes the value of N is autosized at server startup. For more information about the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-history-long-table.html
To set the table size explicitly, set the performance_schema_events_waits_history_long_size system variable at server startup. The Performance Schema autosizes the value of N during server startup. For more information about the relationship between ... The events_waits_history_long table contains N the most recent wait events that have ended globally, across all ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-float.html
For DECIMAL columns, MySQL performs operations with a precision of 65 decimal digits, which should solve most common inaccuracy problems. The correct way to do floating-point number comparison is to first decide on an acceptable tolerance for ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-load-data.html
When binlog_format=MIXED is set, the statement is logged in row-based format. When binlog_format=STATEMENT is set, note that LOAD DATA does not generate a warning, unlike other unsafe statements. LOAD DATA is considered unsafe for statement-based ...These temporary files are not automatically removed by mysqlbinlog or any other MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-interface.html
These settings help as the number of replicas increases, because contention for locks can slow down performance. There is one plugin for the source side and one for the replica side. To enable or disable the plugin, set this variable to 1 or 0, ...
https://dev.mysql.com/doc/refman/5.7/en/archive-storage-engine.html
When you create an ARCHIVE table, the server creates a table format file in the database directory. The ARCHIVE engine also supports the AUTO_INCREMENT table option in CREATE TABLE statements to specify the initial sequence value for a new table or ...To examine the source for the ARCHIVE engine, look in the storage/archive directory of a MySQL source ... The ARCHIVE storage ...