PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/key-space.html
If the first index part is a string, it is also prefix compressed. Space compression makes the index file smaller than the worst-case figure if a string column has a lot of trailing space or is a VARCHAR column that is not always used to the full ...
https://dev.mysql.com/doc/refman/5.7/en/migrating-from-year2.html
YEAR(2) Limitations Issues with the YEAR(2) data type include ambiguity of displayed values, and possible loss of information when values are dumped and reloaded or converted to strings. Conversion of a 2-digit or 4-digit YEAR data value to string ... This section describes problems that can occur when using the 2-digit YEAR(2) data type and provides information about converting existing YEAR(2) columns to 4-digit year-valued columns, which can be declared as YEAR with an implicit display width of 4 characters, or equivalently as YEAR(4) with an explicit display ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-size-pl.html
This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage engine. Unlike the other utilities discussed in this section, it does not require ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-tips.html
Suppose that an indexed string column c1 is compared to a numeric value using WHERE c1 = 2222. For such comparisons, the string value is converted to a number and the operands are compared numerically (see Section 12.3, “Type Conversion in ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-parameters-table.html
The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and about return values for stored functions. The PARAMETERS table does not include built-in (native) functions or loadable ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
--binlog-do-db=db_name Command-Line Format --binlog-do-db=name Type String This option affects binary logging in a manner similar to the way that --replicate-do-db affects replication. --binlog-ignore-db=db_name Command-Line Format ... Startup ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-reference.html
These procedures invoke administrative functions that provide an API for lower-level tasks. The procedure uses firewall administrative functions to reload the in-memory rules for an account profile from the rules stored in the ...When enabled, the ...
https://dev.mysql.com/doc/refman/5.7/en/generated-column-index-optimizations.html
For comparisons of strings to indexed generated columns that compute a value from a JSON function that returns a quoted string, JSON_UNQUOTE() is needed in the column definition to remove the extra quotes from the function value. For example, if the ...For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
MySQL supports the following static probes, organized into groups of functionality. query-start(query, connectionid, database, user, host) query-done(status) query-start: Triggered after the query string has been received from the client. The ...To ...
https://dev.mysql.com/doc/refman/5.7/en/proxy-users.html
Suppose that my_auth_plugin returns a user name of employee to the server, based on the content of 'my_auth_string' and perhaps by consulting some external authentication system. When proxying occurs, the USER() and CURRENT_USER() functions can be ...The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking ...