PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/installing.html
This section describes how to secure the initial MySQL root user account, which has no password until you assign one. For information about those platforms that are officially supported, see ...If you plan to upgrade an existing version of MySQL to ...A summary of the procedure follows and later sections provide the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benefits.html
If you split up related data into different tables, you can set up foreign keys that enforce referential integrity. When you design a database with appropriate primary key columns for each table, operations involving those columns are automatically ... InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of what was happening in the database at the time, you don't need to do anything special after restarting the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-variable-table-migration.html
Before MySQL 5.7.9, selecting from the INFORMATION_SCHEMA tables produces an empty result set plus a deprecation warning. The INFORMATION_SCHEMA has tables that contain system and status variable information (see Section 24.3.11, “The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-consumer-filtering.html
For example, if you do not care about historical event information, disable the history consumers: UPDATE performance_schema.setup_consumers SET ENABLED = 'NO' WHERE NAME LIKE '%history%'; The consumer settings in the setup_consumers table form a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-shutdowns.html
For the greatest possible durability and consistency in a replication setup using InnoDB with transactions, you should also set innodb_flush_log_at_trx_commit=1. Setting sync_relay_log_info to 0 causes no writes to be forced to disk and the server ...However, the replica notices the network outage only after receiving no data from the source for slave_net_timeout ...
https://dev.mysql.com/doc/refman/5.7/en/show-privileges.html
Privileges belonging to a specific user are displayed by the SHOW GRANTS statement. row *************************** Privilege: Create Context: Databases,Tables,Indexes Comment: To create new databases and tables *************************** 4. row ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-start.html
myisam_recover_options=mode Set the mode for automatic recovery of crashed MyISAM tables. Note This is a limit per thread! delay_key_write=ALL Don't flush key buffers between writes for any MyISAM table. myisam_sort_buffer_size Set the size of the ... The following options to mysqld can be used to change the behavior of MyISAM ...
https://dev.mysql.com/doc/refman/5.7/en/server-logs.html
(The DDL log is always created when required, and has no user-configurable options; see Section 5.4.6, “The DDL Log”.) The following log-specific sections provide information about the server options that enable logging. For information about ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld.html
When MySQL server starts, it listens for network connections from client programs and manages access to databases on behalf of those clients. For a complete list of options, run this command: mysqld --verbose --help MySQL Server also has a set of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-porting-memcached.html
If you store several different classes of information using memcached, consider setting up a separate InnoDB table for each type of data. Preferably, configure a stable set of table definitions for use with the daemon_memcached plugin, and leave the ...This is because InnoDB performs best for large-scale insertions if primary key values are added in sorted order (as they are with auto-increment ...