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/host-cache.html
For permanent failures, the host name remains NULL and the validation flag is set to true. For example, to set the size to 100 at startup, put these lines in the server my.cnf file: [mysqld] host_cache_size=200 To change the size to 300 at runtime, ... The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-installation.html
At runtime, these source-side system variables are available: SET GLOBAL rpl_semi_sync_master_enabled = {0|1}; SET GLOBAL rpl_semi_sync_master_timeout = N; On the replica side, this system variable is available: SET GLOBAL ...For general information ... Semisynchronous replication is implemented using plugins, so the plugins must be installed into the server to make them ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
RENAME TABLE tbl_name TO new_tbl_name changes internally generated foreign key constraint names and user-defined foreign key constraint names that begin with the string “tbl_name_ibfk_” to reflect the new table name. Regardless of the statement ...You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new ...
https://dev.mysql.com/doc/refman/5.7/en/show.html
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. Many MySQL APIs (such as PHP) enable you to treat the result returned from a SHOW statement as you would a result set from a ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-schemata-table.html
Caution Because a global privilege is considered a privilege for all databases, any global privilege enables a user to see all database names with SHOW DATABASES or by examining the INFORMATION_SCHEMA SCHEMATA table. A schema is a database, so the ...The SCHEMATA table has these columns: CATALOG_NAME The name of the catalog to which the schema ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-statistics-estimation.html
The auto-rehash feature enables automatic name completion of database, table, and column names for interactive users. The default setting for innodb_stats_on_metadata was changed to OFF when persistent optimizer statistics were enabled by default in ...For information about persistent optimizer statistics, see Section 14.8.11.1, “Configuring Persistent Optimizer Statistics ...Optimizer statistics ...
https://dev.mysql.com/doc/refman/5.7/en/communication-errors.html
If the log_error_verbosity system variable is set to 3, you might find messages like this in your error log: [Note] Aborted connection 854 to db: 'employees' user: 'josh' If a client is unable even to connect, the server increments the ... If ...See ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-installation.html
This section covers hardware and software requirements; networking issues; installation of NDB Cluster; basic configuration issues; starting, stopping, and restarting the cluster; loading of a sample database; and performing queries. A common ...The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-scaleout.html
Figure 16.1 Using Replication to Improve Performance During Scale-Out If the part of your code that is responsible for database access has been properly abstracted/modularized, converting it to run with a replicated setup should be very smooth and ...Most websites fit into this category, where users are browsing the website, reading articles, posts, or viewing ... You can use replication as a scale-out solution; that is, where ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-hosts-table.html
This is NULL for an internal thread, or for a user session that failed to authenticate. To set the table size explicitly, set the performance_schema_hosts_size system variable at server startup. The hosts table contains a row for each host from ...