PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.3Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/account-names.html
MySQL stores account names in grant tables in the mysql system database using separate columns for the user name and host name parts: The user table contains one row for each account. The User and Host columns store the user name and host name.
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
The audit log plugin stores encryption passwords in the keyring; see Encrypting Audit Log Files. If not, the plugin automatically generates a random initial encryption password and stores it in the keyring. This section describes how to configure ...
https://dev.mysql.com/doc/refman/8.0/en/blackhole-storage-engine.html
The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store it. Inserts into a BLACKHOLE table do not store any data, but if statement based binary logging is enabled, the SQL statements are ...To ...
https://dev.mysql.com/doc/refman/8.0/en/bnl-bka-optimization.html
Several rows in the incremental buffer can refer to the same row r whose columns are stored in the previous join buffers insofar as all these rows match row r. With the first scenario, a portion of the join buffer is reserved to store row IDs ... In ...
https://dev.mysql.com/doc/refman/8.0/en/comments.html
If this format is used to comment stored programs, the comments are not retained in the program body. If there is a concern that optimizer-hint comments may be stored in object definitions so that dump files when reloaded with mysql would result in ... MySQL Server supports three comment styles: From a # character to the end of the ...
https://dev.mysql.com/doc/refman/8.0/en/cost-model.html
These estimates are stored in the server_cost and engine_cost tables in the mysql system database and are configurable at any time. DBAs can use this column to provide information about why a cost estimate row stores a particular value. The server ... To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query ...
https://dev.mysql.com/doc/refman/8.0/en/creating-tables.html
How about age? That might be of interest, but it is not a good thing to store in a database. Instead, it is better to store a fixed value such as date of birth. For example, if you store death date in the database, you can easily calculate how old a ...You want a table that contains a record for each of your ...
https://dev.mysql.com/doc/refman/8.0/en/datetime.html
In particular, any fractional part in a value inserted into a DATETIME or TIMESTAMP column is stored rather than discarded. As long as the time zone setting remains constant, you get back the same value you store. If you store a TIMESTAMP value, and ...This section describes their characteristics, how they are similar, and how they ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-tablespace-encryption.html
How do I know which data to encrypt? Compliance with the PCI-DSS standard requires that credit card numbers (Primary Account Number, or 'PAN') be stored in encrypted form. When data-at-rest encryption is used, individual tablespace keys are stored ...Is data decrypted for users who are authorized to see it? ...
https://dev.mysql.com/doc/refman/8.0/en/functions.html
Expressions can be written using values from several sources, such as literal values, column values, NULL, variables, built-in functions and operators, loadable functions, and stored functions (a type of stored object). For information about ...