PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-usage.html
Create the secret by passing the key length to create_dh_parameters(), then pass the secret as the “key length” to create_asymmetric_priv_key(). Limit CPU usage by key-generation operations The create_asymmetric_priv_key() and ... To use MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/programs-overview.html
mysql_install_db This program initializes the MySQL data directory, creates the mysql database and initializes its grant tables with default privileges, and sets up the InnoDB system tablespace. mysql_ssl_rsa_setup This program creates the SSL ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-data-directories.html
It has the default set of MySQL accounts and no user data. Copy an Existing Data Directory With this method, any MySQL accounts or user data present in the data directory are carried over to the new data directory. There are different methods of ...
https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
mysql> CREATE TABLE t (a VARCHAR(10000), b VARCHAR(10000), c VARCHAR(10000), d VARCHAR(10000), e VARCHAR(10000), f VARCHAR(10000), g VARCHAR(6000)) ENGINE=InnoDB CHARACTER SET latin1; ERROR 1118 (42000): Row size too large. You have to change some ... This section describes limits on the number of columns in tables and the size of individual ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
CREATE TABLE Failure Due to Orphan Table A symptom of an out-of-sync data dictionary is that a CREATE TABLE statement fails. InnoDB: You can drop the orphaned table inside InnoDB by InnoDB: creating an InnoDB table with the same name in another ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. Ranges should be contiguous but not overlapping, and are defined using the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-nodes.html
This is one of: NOTHING, CMVMI, STARTING, STARTED, SINGLEUSER, STOPPING_1, STOPPING_2, STOPPING_3, or STOPPING_4. SINGLEUSER is displayed in the status column for all data nodes when the cluster is in single user mode (see Section 21.6.6, “NDB ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-connection-configuration-table.html
(CHANGE MASTER TO option: MASTER_PORT) USER The user name of the account used to connect to the replication source server. (CHANGE MASTER TO option: MASTER_USER) NETWORK_INTERFACE The network interface that the replica is bound to, if any. This ...
https://dev.mysql.com/doc/refman/5.7/en/security.html
These include choosing good passwords, not granting unnecessary privileges to users, ensuring application security by preventing SQL injections and data corruption, and others. Access control and security within the database system itself, including ... When thinking about security within a MySQL installation, you should consider a wide range of possible topics and how they affect the security of your MySQL server and related applications: General factors that affect ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
In addition to user data, the page format includes some internal system data that is not compressed. For example: USE test; SET GLOBAL innodb_file_per_table=1; SET GLOBAL innodb_file_format=Barracuda; SET GLOBAL autocommit=0; -- Create an ... Most ...