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/innodb-performance-optimizer-statistics.html
You can manually modify the mysql.innodb_table_stats and mysql.innodb_index_stats tables to force a specific query optimization plan or to test alternative plans without modifying the database. This section describes how to configure persistent and ...Persistent optimizer statistics also provide control and flexibility with these additional benefits: You can use the innodb_stats_auto_recalc configuration option to control whether statistics are updated automatically after substantial changes to a ...
https://dev.mysql.com/doc/refman/5.7/en/logical-operators.html
Most of this is common to different SQL database servers, although some servers may return any nonzero value for TRUE. For example, the following statements all assess to TRUE: mysql> SELECT 10 IS TRUE; -> 1 mysql> SELECT -10 IS TRUE; -> 1 mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-definition-data-dumps.html
The --no-data option tells mysqldump not to dump table data, resulting in the dump file containing only statements to create the tables. Conversely, the --no-create-info option tells mysqldump to suppress CREATE statements from the output, so that ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-installation.html
$> mysql -u root -p < linux_install_firewall.sql Enter password: (enter root password here) Note As of MySQL 5.7.21, for a new installation of MySQL Enterprise Firewall, InnoDB is used instead of MyISAM for the firewall tables. Installation can be ... MySQL Enterprise Firewall installation is a one-time operation that installs the elements described in Section 6.4.6.1, “Elements of MySQL Enterprise ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-ndb-transid-mysql-connection-map-table.html
This information is used when populating the server_operations and server_transactions tables of the ndbinfo NDB Cluster information database. It is implemented as an INFORMATION_SCHEMA plugin; you can verify that it is supported by checking the ...
https://dev.mysql.com/doc/refman/5.7/en/rewriting-subqueries.html
Sometimes there are other ways to test membership in a set of values than by using a subquery. Today, MySQL Server and many other modern database systems offer a wide range of outer join types. MySQL Server supports multiple-table DELETE statements ...Also, on some occasions, it is not only possible to rewrite a query without a subquery, but it can be more efficient to make use of some of these techniques rather than to use ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-ftdump.html
--dump, -d Command-Line Format --dump Dump the index, including data offsets and word weights. Before using myisam_ftdump, be sure to issue a FLUSH TABLES statement first if the server is running. If you do not invoke myisam_ftdump in the directory ...It reads the MyISAM index file directly, so it must be run on the server host where the table is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-backup.html
MySQL Enterprise Backup performs hot backup operations for MySQL databases. Hot backups are performed while the database is running and applications are reading and writing to it. For these reasons, hot backups are desirable when your database ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-rsa-files.html
RSA key files enable MySQL to support secure password exchange over unencrypted connections for accounts authenticated by the sha256_password plugin. The following discussion describes how to create the files required for SSL and RSA support in ...
https://dev.mysql.com/doc/refman/5.7/en/examples.html
Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Supposing that each trader has a single fixed price per article, then (article, dealer) is a primary key for the records. Here ...