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/optimizing-memory-tables.html
Hash indexes are only fast for queries that look up single values through the = operator, or a restricted set of values through the IN operator. Consider using MEMORY tables for noncritical data that is accessed often, and is read-only or rarely ...
https://dev.mysql.com/doc/refman/5.7/en/row-subqueries.html
If the t2 row col3 and col4 values are not equal the col1 and col2 values of any t1 row, the expression is FALSE and the query returns an empty result set. For information about how each operator works for row comparisons, see Section 12.4.2, ...
https://dev.mysql.com/doc/refman/5.7/en/table-scan-avoidance.html
Start mysqld with the --max-seeks-for-key=1000 option or use SET max_seeks_for_key=1000 to tell the optimizer to assume that no key scan causes more than 1,000 key seeks. This usually happens under the following conditions: The table is so small ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-pkg.html
This cannot be recovered so you must save this password for the initial login to MySQL. For example: Figure 2.17 MySQL Package Installer Wizard: Temporary Root Password Note MySQL expires this temporary root password after the initial login and ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-storage-overview.html
The MySQL pluggable storage engine architecture enables a database professional to select a specialized storage engine for a particular application need while being completely shielded from the need to manage any specific application coding ...The ...The MySQL server architecture isolates the application programmer and DBA from all of the low-level implementation details at the storage level, providing a consistent and easy application model and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-index-types.html
To get the best performance from queries, inserts, and other database operations, it is important to understand how InnoDB uses the clustered index to optimize the common lookup and DML operations. If there is no logical unique and non-null column ... Each InnoDB table has a special index called the clustered index that stores row ...
https://dev.mysql.com/doc/refman/5.7/en/server-plugins.html
The plugins supported by this interface include, but are not limited to, storage engines, INFORMATION_SCHEMA tables, full-text parser plugins, partitioning support, and server extensions. MySQL distributions include several plugins that implement ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-foreign-keys.html
When performing foreign key checks, InnoDB sets shared row-level locks on child or parent records that it must examine. row *************************** Table: shirt Create Table: CREATE TABLE `shirt` ( `id` smallint(5) unsigned NOT NULL ...For ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-functions.html
The following example shows how to convert the result of gen_rnd_email() to the utf8mb4 character set: SET @email = CONVERT(gen_rnd_email() USING utf8mb4); It may also be necessary to convert string arguments, as illustrated in Using Masked Data for ...If a string return value should be in a different character set, convert ...If a MySQL Enterprise Data Masking and De-Identification function is invoked from within the mysql client, binary string results ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-processes.html
For other types of API nodes, it is the name of the executable program connected to the cluster; NDB API applications can set a custom value for this using Ndb_cluster_connection::set_name(). By default, API nodes other than SQL nodes use ndb:// for ... This table contains information about NDB Cluster node processes; each node is represented by the row in the ...