PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/compilation-problems.html
When CMake starts, it looks for that file and reads its contents if it exists, on the assumption that the information is still correct. Each time you run CMake, you must run make again to recompile. The following list describes other problems that ...If you do reconfigure, take note of the following: If CMake is run after it has previously been run, it may use information that was gathered during its previous ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-backup.html
Hot and cold backups are physical backups that copy actual data files, which can be used directly by the mysqld server for faster restore. Hot Backups The mysqlbackup command, part of the MySQL Enterprise Backup component, lets you back up a running ... The key to safe database management is making regular ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-linux-native-aio.html
With synchronous I/O, query threads queue I/O requests, and InnoDB background threads retrieve the queued requests one at a time, issuing a synchronous I/O call for each. InnoDB uses the asynchronous I/O subsystem (native AIO) on Linux to perform ...Using the asynchronous I/O subsystem on Linux requires the libaio ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-memcached.html
Debug messages occur because new and updated values are sent directly to the InnoDB table without being saved in the memory cache, due to the innodb_only caching policy. Define additional table identifiers in the innodb_memcache.containers table, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-failover.html
Note @file is a string value such as '/var/log/mysql/replication-source-bin.00001', and so must be quoted when used in SQL or application code. Warning The secondary replication channel is to be started only if and when the primary replication ...
https://dev.mysql.com/doc/refman/8.0/en/scalar-subqueries.html
A scalar subquery is a simple operand, and you can use it almost anywhere a single column value or literal is legal, and you can expect it to have those characteristics that all operands have: a data type, a length, an indication that it can be ...
https://dev.mysql.com/doc/refman/8.0/en/server-configuration-validation.html
For additional checks to occur, correct the initial problem and run the server with --validate-config again. This command produces the same warnings, but also an error, so the error message is displayed along with the warnings and the exit code is ... As of MySQL 8.0.16, MySQL Server supports a --validate-config option that enables the startup configuration to be checked for problems without running the server in normal operational mode: mysqld --validate-config If no errors are found, the server terminates with an exit code of ...
https://dev.mysql.com/doc/refman/8.0/en/server-configuration.html
The MySQL server, mysqld, has many command options and system variables that can be set at startup to configure its operation. To determine the default command option and system variable values used by the server, execute this command: $> mysqld ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-socket-instances-table.html
The socket_instances table provides a real-time snapshot of the active connections to the MySQL server. Information available in this table provides a real-time snapshot of the active connections to the server. (Additional information is available ...The table contains one row per TCP/IP or Unix socket file ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-key.html
(In this case, simply using PARTITION BY KEY() would also be valid and have the same effect as PARTITION BY KEY(s1), since s1 is the table's primary key.) For additional information about this issue, see Section 26.6, “Restrictions and Limitations ... Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL ...