PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/communication-errors.html
Other reasons for problems with aborted connections or aborted clients: The max_allowed_packet variable value is too small or queries require more memory than you have allocated for mysqld. If connection problems occur such as communication errors ...
https://dev.mysql.com/doc/refman/8.0/en/compilation-problems.html
The following list describes other problems that have been found to occur most often when compiling MySQL: To define which C and C++ compilers to use, you can define the CC and CXX environment variables. If you do reconfigure, take note of the ...
https://dev.mysql.com/doc/refman/8.0/en/compressed-format.html
Compressed tables have the following characteristics: Compressed tables take very little disk space. If values in an integer column have a small range, the column is stored using the smallest possible type. Compressed storage format is a read-only ...
https://dev.mysql.com/doc/refman/8.0/en/copying-databases.html
You might have to run commands as the MySQL root user on the new machine until you have the mysql database in place. In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing ...
https://dev.mysql.com/doc/refman/8.0/en/counting-rows.html
Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one record per pet. COUNT(*) counts the number of rows, so the query to count your animals looks like this: mysql> ...
https://dev.mysql.com/doc/refman/8.0/en/create-event.html
Event names are not case-sensitive, so you cannot have two events named myevent and MyEvent in the same schema. Note Statements such as SELECT or SHOW that merely return a result set have no effect when used in an event; the output from these is not ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ...
https://dev.mysql.com/doc/refman/8.0/en/create-resource-group.html
Use of different ranges for system and user groups ensures that user threads never have a higher priority than system threads. CREATE RESOURCE GROUP group_name TYPE = {SYSTEM|USER} [VCPU [=] vcpu_spec [, vcpu_spec] ...] [THREAD_PRIORITY [=] N] ...
https://dev.mysql.com/doc/refman/8.0/en/create-role.html
To use this statement, you must have the global CREATE ROLE or CREATE USER privilege. (These role attributes can be changed later with the ALTER USER statement, by users who have the global CREATE USER privilege.) CREATE ROLE either succeeds for all ... CREATE ROLE [IF NOT EXISTS] role [, role ] ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html
(Exception: A TEMPORARY table hides a non-TEMPORARY table of the same name, so it can have the same CHECK constraint names as well.) Beginning generated constraint names with the table name helps ensure schema uniqueness because table names also ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-gipks.html
Beginning with MySQL 8.0.30, MySQL supports generated invisible primary keys for any InnoDB table that is created without an explicit primary key. When the sql_generate_invisible_primary_key server system variable is set to ON, the MySQL server ...