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/mysql-installer-workflow.html
Lower Case Sets the lower_case_table_names option value to 1 (default), in which table names are stored in lowercase on disk and comparisons are not case-sensitive. Preserve Given Case Sets the lower_case_table_names option value to 2, in which ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-documents-collections.html
When you are using MySQL as a Document Store, collections are containers within a schema that you can create, list, and drop. Internally, they are stored in an efficient binary format that enables fast lookups and updates. Collections contain JSON ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-collections.html
When you are using MySQL as a Document Store, collections are containers within a schema that you can create, list, and drop. Internally, they are stored in an efficient binary format that enables fast lookups and updates. Collections contain JSON ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-userguide.html
This enables you to use MySQL as a Document Store, sometimes referred to as “using NoSQL”. For more information, see Chapter 22, Using MySQL as a Document Store. MySQL Shell is an advanced client and code editor for MySQL Server. In addition to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-tips.html
Alt+F7 deletes all input lines stored in memory for the current history buffer. This section provides information about techniques for more effective use of mysql and about mysql operational behavior. Input-Line Editing Disabling Interactive ...
https://dev.mysql.com/doc/refman/8.0/en/no-login-pluggable-authentication.html
Use cases for this plugin include: Accounts that must be able to execute stored programs and views with elevated privileges without exposing those privileges to ordinary users. An account that authenticates using mysql_no_login may be used as the ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-blob.html
Rather than testing for equality against a very long text string, you can store a hash of the column value in a separate column, index that column, and test the hashed value in queries. When storing a large blob containing textual data, consider ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-numeric.html
Since large numeric values can be stored in fewer bytes than the corresponding strings, it is faster and takes less memory to transfer and compare them. Information in the database is likely to be stored in a more compact format than in the text ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html
Statements that are not read only are those that invoke a stored function that modifies data as a side effect. It does not apply to SELECT statements in stored programs and is ignored. One means of control over optimizer strategies is to set the ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-storage-layout.html
Use the VARCHAR data type instead of CHAR to store variable-length strings or for columns with many NULL values. A CHAR(N) column always takes N characters to store data, even if the string is shorter or its value is NULL. Once your data reaches a ...