PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/data-dictionary-schema.html
Generally, the difference between MySQL data dictionary tables and system tables is that data dictionary tables contain metadata required to execute SQL queries, whereas system tables contain auxiliary data such as time zone and help information.
https://dev.mysql.com/doc/refman/9.7/en/data-masking-component-functions.html
masking_dictionary_term_add() permits you to add one dictionary term at a time. mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' characters. Nine digits ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking-components-vs-plugin.html
Note Only the data-masking components or the plugin should be enabled at a time. Previously, MySQL enabled masking and de-identification capabilities using a server-side plugin, but transitioned to use the component infrastructure as an alternative ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking.html
If you are using MySQL Enterprise Data Masking for the first time, consider installing the components for access to the ongoing enhancements only available with component infrastructure. Note MySQL Enterprise Data Masking is an extension included ...
https://dev.mysql.com/doc/refman/9.7/en/date-calculations.html
To determine how many years old each of your pets is, use the TIMESTAMPDIFF() function. DATE_ADD() enables you to add a time interval to a given date. MySQL provides several functions that you can use to perform calculations on dates, for example, ...
https://dev.mysql.com/doc/refman/9.7/en/dbug-package.html
Here are some example debug control strings as they might be specified on a shell command line: --debug=d:t --debug=d:f,main,subr1:F:L:t,20 --debug=d,input,output,files:n --debug=d:t:i:O,\\mysqld.trace For mysqld, it is also possible to change DBUG ... The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred ...
https://dev.mysql.com/doc/refman/9.7/en/ddl-rewriter-options.html
If values specified at startup time are incorrect, the ddl_rewriter plugin may fail to initialize properly and the server does not load it. This section describes the command options that control operation of the ddl_rewriter plugin. To control ...
https://dev.mysql.com/doc/refman/9.7/en/debugging-server.html
If mysqld starts to eat up CPU or memory or if it “hangs,” you can use mysqladmin processlist status to find out if someone is executing a query that takes a long time. If you are using some functionality that is very new in MySQL, you can try ...
https://dev.mysql.com/doc/refman/9.7/en/delete-optimization.html
The time required to delete individual rows in a MyISAM table is exactly proportional to the number of indexes. To delete rows more quickly, you can increase the size of the key cache by increasing the key_buffer_size system variable. To delete all ...
https://dev.mysql.com/doc/refman/9.7/en/derived-condition-pushdown-optimization.html
If a materialized derived table is a common table expression, conditions are not pushed down to it if it is referenced multiple times. When a derived table cannot be merged into the outer query (for example, if the derived table uses aggregation), ...