PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html
For advanced users, this chapter also contains a description of the pluggable storage engine architecture (see Section 15.11, “Overview of MySQL Storage Engine Architecture”). InnoDB is a transaction-safe (ACID compliant) storage engine for ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-usage.html
The system tablespace (space 0, the .ibdata files) can contain user-created tables, but it also contains internal system data, which is never compressed. Creating a Compressed Table in File-Per-Table Tablespace To create a compressed table in a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-sys-get-config.html
If the variable does not exist or is NULL, the routine reads the option value from the table and sets the user-defined variable to that value. For more information about the relationship between configuration options and their corresponding ...By ...
https://dev.mysql.com/doc/refman/5.7/en/extensions-to-ansi.html
Functions and operators To make it easier for users who migrate from other SQL environments, MySQL Server supports aliases for many functions. Some SQL servers provide the same functionality but call this User space. (In MySQL Server, these ...For ... MySQL Server supports some extensions that are likely not to be found in other SQL ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-implementations.html
MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one mapping from character codes to weights. Complex collations for ...For 8-bit characters, character codes map to weights in case-insensitive ...It is a case-insensitive collation, so the uppercase and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-row-format.html
Records in the clustered index contain fields for all user-defined columns. Records in the clustered index contain fields for all user-defined columns. For example, a CHAR(255) column can exceed 768 bytes if the maximum byte length of the character ... The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML ...As more rows fit into a single disk page, ...
https://dev.mysql.com/doc/refman/5.7/en/command-line-options.html
The second instructs mysql to prompt for the password value and to use test as the default database. An exception to this rule is the option for specifying your MySQL password. This option can be given in long form as --password=pass_val or as ...An ... Program options specified on the command line follow these rules: Options are given after the command ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tables-table.html
TABLE_SCHEMA The name of the schema (database) to which the table belongs. TABLE_TYPE BASE TABLE for a table, VIEW for a view, or SYSTEM VIEW for an INFORMATION_SCHEMA table. For partitioned tables, ENGINE shows the name of the storage engine used ...The TABLES table has these columns: TABLE_CATALOG The name of the catalog to which the table ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
It is not true for names of columns, constraints, databases, partitions, statements prepared with PREPARE, tables, triggers, users, and user-defined variables. If you plan to set the lower_case_table_names system variable to 1 on Unix, you must ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-notes.html
For use in single user mode, an entry for _mysql (note the underscore prefix) should already exist within the system /etc/passwd file. Choosing "Don't Allow" means this password won't be visible for use. You may need (or want) to create a specific ... You should keep the following issues and notes in mind: As of macOS 10.14 (Majave), the macOS MySQL 5.7 Installer application requires permission to control System Events so it can display a generated (temporary) MySQL root ...