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/charset-conversion.html
To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. The following statement accomplishes this: ALTER TABLE t MODIFY col1 CHAR(50) CHARACTER SET utf8; Conversion may be lossy if the column contains ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-limits.html
Note Bulk loading, TRUNCATE TABLE, and ALTER TABLE are handled as special cases by running multiple transactions, and so are not subject to this limitation. Memory consumed when data is inserted into an NDB table is not automatically recovered when ... In this section, we list limits found in NDB Cluster that either differ from limits found in, or that are not found in, standard ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-connection-control-failed-login-attempts-table.html
This table provides information about the current number of consecutive failed connection attempts per account (user/host combination). Notes The CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS plugin must be activated for this table to be available, and ...CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS has these columns: USERHOST The user/host combination indicating an account that has failed connection attempts, in 'user_name'@'host_name' ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-connection-control-table-reference.html
Table 24.9 INFORMATION_SCHEMA Connection Control Tables Table Name Description Introduced CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Current number of consecutive failed connection attempts per account 5.7.17 .
https://dev.mysql.com/doc/refman/5.7/en/information-schema-firewall-table-reference.html
Table 24.10 INFORMATION_SCHEMA Firewall Tables Table Name Description MYSQL_FIREWALL_USERS Firewall in-memory data for account profiles MYSQL_FIREWALL_WHITELIST Firewall in-memory data for account profile allowlists .
https://dev.mysql.com/doc/refman/5.7/en/information-schema-thread-pool-table-reference.html
Table 24.7 INFORMATION_SCHEMA Thread Pool Tables Table Name Description TP_THREAD_GROUP_STATE Thread pool thread group states TP_THREAD_GROUP_STATS Thread pool thread group statistics TP_THREAD_STATE Thread pool thread information .
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-table-fragments.html
The table_fragments table provides information about the fragmentation, partitioning, distribution, and (internal) replication of NDB tables.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-table-replicas.html
The table_replicas table provides information about the copying, distribution, and checkpointing of NDB table fragments and fragment replicas.
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-many-tables.html
If you have configured non-persistent optimizer statistics (a non-default configuration), InnoDB computes index cardinality values for a table the first time that table is accessed after startup, instead of storing such values in the table. This ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-memory-tables.html
Consider using MEMORY tables for noncritical data that is accessed often, and is read-only or rarely updated. Benchmark your application against equivalent InnoDB or MyISAM tables under a realistic workload, to confirm that any additional ...On the ...