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/performance-schema-status-monitoring.html
Performance_schema_xxx_instances_lost indicates how many instances of object type xxx could not be created. If the server cannot create a given instrumented mutex instance, it increments Performance_schema_mutex_instances_lost. INSTALL PLUGIN ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
For example, this CREATE TABLE statement does not work because the CONCAT function cannot be used to construct an enumeration value: CREATE TABLE sizes ( size ENUM('small', CONCAT('med','ium'), 'large') ); You also cannot employ a user variable as ... An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation ...
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/sys-sys-config-update-set-user.html
The sys_config_update_set_user trigger for the sys_config table is similar to the sys_config_insert_set_user trigger, but for UPDATE statements.
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
To discuss problems with other users, you can use the MySQL Community Slack. If a database table is related to the problem, include the output from the SHOW CREATE TABLE db_name.tbl_name statement in the bug report. The information helps us create a ... Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at ...
https://dev.mysql.com/doc/refman/5.7/en/copying-databases.html
In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. You might have to run commands as the MySQL root user on the new machine until you have the mysql ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-support.html
IPv6 addresses can be specified in account names in statements such as CREATE USER, GRANT, and REVOKE. For example: mysql> CREATE USER 'bill'@'::1' IDENTIFIED BY 'secret'; mysql> GRANT SELECT ON mydb.* TO 'bill'@'::1'; IPv6 functions enable ...MySQL ... Support for IPv6 in MySQL includes these capabilities: MySQL Server can accept TCP/IP connections from clients connecting over ...
https://dev.mysql.com/doc/refman/5.7/en/alter-view.html
ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = user] [SQL SECURITY { DEFINER | INVOKER }] VIEW view_name [(column_list)] AS select_statement [WITH [CASCADED | LOCAL] CHECK OPTION] This statement changes the definition of a view, ...