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/error-handling.html
This appendix describes the types of error information MySQL provides and how to obtain information about them. It describes common problems and errors that may occur and potential resolutions.
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-use_sys_malloc.html
When InnoDB was developed, the memory allocators supplied with operating systems and run-time libraries were often lacking in performance and scalability. At that time, there were no memory allocator libraries tuned for multi-core CPUs. Therefore, ...This allocator is guarded by a single mutex, which may become a ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-handles-table.html
It is autosized by default; to configure the table size, set the performance_schema_max_table_handles system variable at server startup. The Performance Schema exposes table lock information through the table_handles table to show the table locks ...Table lock instrumentation uses the wait/lock/table/sql/handler instrument, which is enabled by ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-best-practices.html
Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is no obvious primary key. For fast join performance, define foreign keys on the join columns, and declare those columns ...Use joins wherever data is pulled from multiple tables based on identical ID values from those ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-transaction-inconsistencies.html
CHANGE MASTER TO statements for that channel fail with an error, unless the applier threads are running and the CHANGE MASTER TO statement only sets receiver options. Thus issuing RESET SLAVE on a replica with gaps means the replica loses any ...To ... Inconsistencies in the sequence of transactions that have been executed from the relay log can occur depending on your replication ...
https://dev.mysql.com/doc/refman/5.7/en/starting-server-troubleshooting.html
This section provides troubleshooting suggestions for problems starting the server. For additional suggestions for Windows systems, see Section 2.3.5, “Troubleshooting a Microsoft Windows MySQL Server Installation”. Log files are located in the ...If you have problems starting the server, here are some things to try: Check the error log to see why the server does not ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking.html
As of MySQL 5.7.24, MySQL Enterprise Edition provides data masking and de-identification capabilities: Transformation of existing data to mask it and remove identifying characteristics, such as changing all digits of a credit card number but the ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-memory.html
myisamchk uses no more memory than its memory-related variables are set to. The default is to use only about 3MB to perform repairs. For example, if you have more than 512MB RAM available, you could use options such as these (in addition to any ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-memory-tables.html
Hash indexes are only fast for queries that look up single values through the = operator, or a restricted set of values through the IN operator. Consider using MEMORY tables for noncritical data that is accessed often, and is read-only or rarely ...
https://dev.mysql.com/doc/refman/5.7/en/row-subqueries.html
If the t2 row col3 and col4 values are not equal the col1 and col2 values of any t1 row, the expression is FALSE and the query returns an empty result set. For information about how each operator works for row comparisons, see Section 12.4.2, ...