PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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, ...
https://dev.mysql.com/doc/refman/5.7/en/table-scan-avoidance.html
Start mysqld with the --max-seeks-for-key=1000 option or use SET max_seeks_for_key=1000 to tell the optimizer to assume that no key scan causes more than 1,000 key seeks. This usually happens under the following conditions: The table is so small ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-general-options.html
--defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File name Read this option file after the global option file but (on Unix) before the user option file. The options described in this section can be used for ...The sections following this one describe options that pertain only to specific operations, such as table checking or ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-consumer-filtering.html
For example, if you do not care about historical event information, disable the history consumers: UPDATE performance_schema.setup_consumers SET ENABLED = 'NO' WHERE NAME LIKE '%history%'; The consumer settings in the setup_consumers table form a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-shutdowns.html
For the greatest possible durability and consistency in a replication setup using InnoDB with transactions, you should also set innodb_flush_log_at_trx_commit=1. Setting sync_relay_log_info to 0 causes no writes to be forced to disk and the server ...However, the replica notices the network outage only after receiving no data from the source for slave_net_timeout ...
https://dev.mysql.com/doc/refman/5.7/en/ddl-log.html
There are no user-configurable server options or variables associated with this file. The DDL log, or metadata log, records metadata operations generated by data definition statements affecting table partitioning, such as ALTER TABLE t3 DROP ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-objects-summary-global-by-type-table.html
row *************************** OBJECT_TYPE: TABLE OBJECT_SCHEMA: mysql OBJECT_NAME: user COUNT_STAR: 14 SUM_TIMER_WAIT: 365567592 MIN_TIMER_WAIT: 1141704 AVG_TIMER_WAIT: 26111769 MAX_TIMER_WAIT: 334783032 ... The Performance Schema maintains the ...row *************************** OBJECT_TYPE: TABLE OBJECT_SCHEMA: test OBJECT_NAME: t COUNT_STAR: 3 SUM_TIMER_WAIT: 263126976 MIN_TIMER_WAIT: 1522272 AVG_TIMER_WAIT: 87708678 MAX_TIMER_WAIT: 258428280 ...