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/apache.html
There are programs that let you authenticate your users from a MySQL database and also let you write your log files into a MySQL table.
https://dev.mysql.com/doc/refman/8.0/en/apis-perl.html
The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines without change. To use DBI with MySQL, install the following: The DBI module. Optionally, the DBD ...
https://dev.mysql.com/doc/refman/8.0/en/archive-storage-engine.html
The AUTO_INCREMENT column can have either a unique or nonunique index. The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. To enable this storage engine if you build MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-reading.html
The plugin ignores files that have been renamed manually and do not match the pattern, and files that were encrypted with a password no longer available in the keyring. The audit log plugin supports functions that provide an SQL interface for ...
https://dev.mysql.com/doc/refman/8.0/en/automatic-start.html
This section discusses methods for starting and stopping the MySQL server. Generally, you start the mysqld server in one of these ways: Invoke mysqld directly. On Windows, you can set up a MySQL service that runs automatically when Windows starts.
https://dev.mysql.com/doc/refman/8.0/en/backup-policy.html
A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL Enterprise Backup can perform a physical backup of an entire instance, with optimizations to minimize overhead and avoid disruption ...
https://dev.mysql.com/doc/refman/8.0/en/backup-strategy-summary.html
If you have such safe media, this technique can also be good for disk load balancing (which results in a performance improvement). In case of an operating system crash or power failure, InnoDB itself does all the job of recovering data. But to make ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-setting.html
You can select the binary logging format explicitly by starting the MySQL server with --binlog-format=type. The supported values for type are: STATEMENT causes logging to be statement based. Setting the binary logging format does not activate ...
https://dev.mysql.com/doc/refman/8.0/en/bit-value-literals.html
A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of a bit literal, use it in numeric context. For example, a bit literal assigned to a ...
https://dev.mysql.com/doc/refman/8.0/en/cache-index.html
After the indexes have been assigned, they can be preloaded into the cache if desired with LOAD INDEX INTO CACHE. | tbl_name PARTITION (partition_list) } IN key_cache_name tbl_index_list: tbl_name [{INDEX|KEY} (index_name[, index_name] ...)] ...