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/implicit-commit.html
The CREATE TABLE statement in InnoDB is processed as a single transaction. SELECT.) Statements that implicitly use or modify tables in the mysql database. LOAD DATA causes an implicit commit only for tables using the NDB storage engine. The ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-ftdump.html
If you do not invoke myisam_ftdump in the directory where the table files are located, the table or index file name must be preceded by the path name to the table's database directory. It reads the MyISAM index file directly, so it must be run on ...
https://dev.mysql.com/doc/refman/8.0/en/grant.html
CREATE ROUTINE is not a routine-level privilege because you must have the privilege at the global or database level to create a routine in the first place. To grant a privilege with GRANT, you must have the GRANT OPTION privilege, and you must have ...These syntax restrictions apply: GRANT cannot mix granting both privileges and roles in the same ...
https://dev.mysql.com/doc/refman/8.0/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an out-of-range value is assigned to an integer column, MySQL stores the value ...When ...
https://dev.mysql.com/doc/refman/8.0/en/unix-signal-response.html
The server response to SIGUSR1 is a subset of the response to SIGHUP, enabling SIGUSR1 to be used as a more “lightweight” signal that flushes certain logs without the other SIGHUP effects such as flushing the thread and host caches and writing a ... On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the ...
https://dev.mysql.com/doc/refman/8.0/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-statistics-with-buffer.html
innodb_buffer_data The total number of InnoDB data bytes allocated for the table. innodb_buffer_free The total number of InnoDB nondata bytes allocated for the table (innodb_buffer_allocated − innodb_buffer_data). These views summarize table ...
https://dev.mysql.com/doc/refman/8.0/en/events-status-info.html
INTO var_list statements, if the query returns no rows, a warning with error code 1329 occurs (No data), and the variable values remain unchanged. The Event Scheduler writes information about event execution that terminates with an error or warning ...See Section 27.4.6, “The Event Scheduler and MySQL Privileges” for an ...For ...
https://dev.mysql.com/doc/refman/8.0/en/large-page-support.html
In the event sysctl returns an error relating to the file name, check the name of the corresponding file in /proc/sys/vm and use that instead. Check any configuration files such as my.cnf used by the server, and make sure that ...Before large pages ... Some hardware and operating system architectures support memory pages greater than the default (usually ...Applications that perform a lot of memory accesses may ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-setting.html
It is possible to change the logging format to STATEMENT, but doing so at runtime leads very rapidly to errors because InnoDB can no longer perform inserts. There are several reasons why a client might want to set binary logging on a per-session ...