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/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/9.7/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/9.7/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. To use MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. See Section 13.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/9.7/en/error-log-destination-configuration.html
This is true even for sinks such as log_sink_json that can be enabled multiple times; all instances write to the console. This section describes which server options configure the default error log destination, which can be the console or a named ...
https://dev.mysql.com/doc/refman/9.7/en/error-log-event-fields.html
Core Error Event Fields Optional Error Event Fields Core Error Event Fields These error event fields are core fields: time The event timestamp, with microsecond precision. Error events intended for the error log contain a set of fields, each of ...
https://dev.mysql.com/doc/refman/9.7/en/error-log.html
The error log contains a record of mysqld startup and shutdown times. This section discusses how to configure the MySQL server for logging of diagnostic messages to the error log. For information about selecting the error message character set and ...
https://dev.mysql.com/doc/refman/9.7/en/events-privileges.html
You can view current values for all of these at one time by running the statement SHOW STATUS LIKE '%event%';. To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system variable.
https://dev.mysql.com/doc/refman/9.7/en/execute.html
You can execute a given prepared statement multiple times, passing different variables to it or setting the variables to different values before each execution. EXECUTE stmt_name [USING @var_name [, @var_name] ...] After preparing a statement with ...
https://dev.mysql.com/doc/refman/9.7/en/expired-password-handling.html
Pass the CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS flag to mysql_real_connect() at connect time: MYSQL mysql; mysql_init(&mysql); if (!mysql_real_connect(&mysql, host, user, password, db, port, unix_socket, CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS)) { ...