PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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. MySQL 8.0.22 and later supports derived condition pushdown for eligible subqueries. When a derived table cannot ...
https://dev.mysql.com/doc/refman/8.0/en/engine-condition-pushdown-optimization.html
For example, in a my.cnf file, use these lines: [mysqld] optimizer_switch=engine_condition_pushdown=off At runtime, disable condition pushdown like this: SET optimizer_switch='engine_condition_pushdown=off'; Limitations. This optimization improves ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-configuring.html
This behavior is not the default because it increases the time taken to process content that cannot be decrypted or verified at all. MySQL Enterprise Encryption lets you limit keys to a length that provides adequate security for your requirements ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-installation.html
This differs from their use at function invocation time, for which you can use any lettercase. In releases before MySQL 8.0.30, the functions provided by MySQL Enterprise Encryption are installed by creating them individually, based on the ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-usage.html
The following general considerations apply when choosing key lengths and encryption algorithms: The strength of encryption for private and public keys increases with the key size, but the time for key generation increases as well. Key string values ... To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to ...