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/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/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/innodb-migration.html
Restoring from a Logical Backup You can use a utility such as mysqldump to perform a logical backup, which produces a set of SQL statements that can be executed to reproduce the original database object definitions and table data for transfer to ...
https://dev.mysql.com/doc/refman/5.7/en/sys-table-exists.html
Parameters in_db VARCHAR(64): The name of the database in which to check for table existance. Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-best-practices.html
Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is no obvious primary key. For fast join performance, define foreign keys on the join columns, and declare those columns ...Use joins wherever data is pulled from multiple tables based on identical ID values from those ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-background.html
Data compression enables smaller database size, reduced I/O, and improved throughput, at the small cost of increased CPU utilization. Compression is especially valuable for read-intensive applications, on systems with enough RAM to keep frequently ... Because processors and cache memories have increased in speed more than disk storage devices, many workloads are ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-benchmarking.html
To measure performance, consider the following factors: Whether you are measuring the speed of a single operation on a quiet system, or how a set of operations (a “workload”) works over a period of time. With simple tests, you usually test how ...Benchmarks are typically long-running and elaborate performance tests, where the results could dictate high-level choices such as hardware and storage configuration, or how soon to upgrade to a new MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/show-open-tables.html
The FROM clause, if present, restricts the tables shown to those present in the db_name database. SHOW OPEN TABLES output has these columns: Database The database containing the table. In_use The number of table locks or lock requests there are for ... SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open in the table ...
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/cannot-create.html
If you get an error of the following type for some queries, it means that MySQL cannot create a temporary file for the result set in the temporary directory: Can't create/write to file '\\sqla3fe_0.ism'. The preceding error is a typical message for ...One fix is to start mysqld with the --tmpdir option or to add the option to the [mysqld] section of your option ...