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/error-log-rotation.html
If the location of the error log file is not writable by the server, the log-flushing operation fails to create a new log file. For example, on Linux, the server might write the error log to the /var/log/mysqld.log file, where the /var/log directory ... If you flush the error log using a FLUSH ERROR LOGS or FLUSH LOGS statement, or a mysqladmin flush-logs command, the server closes and reopens any error log file to which it is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-files-table.html
row *************************** FILE_ID: 0 FILE_NAME: ./ibdata1 FILE_TYPE: TABLESPACE TABLESPACE_NAME: innodb_system FREE_EXTENTS: 0 TOTAL_EXTENTS: 12 EXTENT_SIZE: 1048576 INITIAL_SIZE: 12582912 MAXIMUM_SIZE: NULL AUTOEXTEND_SIZE: 67108864 ... The ...For more information about data provided by the Information Schema FILES table, see Section 28.3.15, “The INFORMATION_SCHEMA FILES ...mysql> SELECT FILE_ID, FILE_NAME FROM INFORMATION_SCHEMA.FILES WHERE FILE_NAME LIKE '%ibtmp%'; +---------+-----------+ | FILE_ID | ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
FragmentLogFileSize Version (or later) NDB 8.0.13 Type or units bytes Default 16M Range 4M - 1G Restart Type Initial Node Restart: Requires a rolling restart of the cluster; each data node must be restarted with --initial. InitFragmentLogFiles ...It ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
ibdata file A set of files with names such as ibdata1, ibdata2, and so on, that make up the InnoDB system tablespace. If innodb_temp_data_file_path is not specified, the default behavior is to create a single auto-extending 12MB data file named ...C ...Instead of flushing all modified pages from the buffer pool to the data files at once, MySQL periodically flushes small sets of modified ...Experienced users can adjust the isolation level, trading off less ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-error-handling.html
If you run out of file space in a tablespace, a MySQL Table is full error occurs and InnoDB rolls back the SQL statement. Other errors are mostly detected by the MySQL layer of code (above the InnoDB storage engine level), and they roll back the ...
https://dev.mysql.com/doc/refman/8.0/en/not-enough-file-handles.html
If you get ERROR 'file_name' not found (errno: 23), Can't open file: file_name (errno: 24), or any other error with errno 23 or errno 24 from MySQL, it means that you have not allocated enough file descriptors for the MySQL server. You can either ...There is a commented-out line ulimit -n 256 in the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-moving-data-files-offline.html
The implicit addition of these directories permits moving system tablespace files, the data directory, or undo tablespace files without configuring the innodb_directories setting. (Unix shells treat it as a command terminator, for example.) Startup ... The innodb_directories variable, which defines directories to scan at startup for tablespace files, supports moving or restoring tablespace files to a new location while the server is ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-files-table.html
FREE_EXTENTS For InnoDB: The number of fully free extents in the current data file. TOTAL_EXTENTS For InnoDB: The number of full extents used in the current data file. Information reported by FILES is obtained from the InnoDB in-memory cache for ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-per-table-tablespaces.html
A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system in a single data file. File-per-table tablespace characteristics are described under the following topics in this section: ...An ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
When specifying a file name at startup, the file must exist or InnoDB returns a startup error indicating that there is no such file or directory. innodb_data_file_path Command-Line Format --innodb-data-file-path=file_name System Variable ...Certain ...For example, to enable or disable the InnoDB adaptive hash index, you can use --innodb-adaptive-hash-index or --skip-innodb-adaptive-hash-index on the command line, or innodb_adaptive_hash_index or skip_innodb_adaptive_hash_index in an option ...