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/installing-source-distribution.html
Create the directory and go there: $> mkdir bld $> cd bld Configure the build directory. To do this, starting with mysql-src as your current working directory, create the directory build and then go there: $> mkdir build $> cd build Configure the ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-component-installation.html
A keyring component or plugin must be loaded early during the server startup sequence so that other components can access it as necessary during their own initialization. The database administrator has the responsibility for creating any manifest ...
https://dev.mysql.com/doc/refman/8.0/en/binary-installation.html
Create a mysql User and Group If your system does not already have a user and group to use for running mysqld, you may need to create them. $> groupadd mysql $> useradd -r -g mysql -s /bin/false mysql Note Because the user is required only for ...
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', price DOUBLE(16,2) DEFAULT 0.00 ); SERIAL DEFAULT VALUE is a special case. Suppose that a table t is defined as follows: CREATE TABLE t (i INT NOT NULL); In this case, i has no ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-internals.html
LZ77 compression works by finding sequences of data that are repeated within the data to be compressed. If innodb_strict_mode is ON, MySQL checks the maximum row size during CREATE TABLE or CREATE INDEX. If you create a table when innodb_strict_mode ... This section describes some internal implementation details about compression for InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/account-categories.html
For example, the CREATE USER privilege enables not only creation of new accounts, but modification and removal of existing accounts. Without the system user concept, a user who has the CREATE USER privilege can modify or drop any existing account, ... As of MySQL 8.0.16, MySQL incorporates the concept of user account categories, based on the SYSTEM_USER ...
https://dev.mysql.com/doc/refman/8.0/en/drop-tablespace.html
DROP [UNDO] TABLESPACE tablespace_name [ENGINE [=] engine_name] This statement drops a tablespace that was previously created using CREATE TABLESPACE. Only undo tablespaces created using CREATE UNDO TABLESPACE syntax can be dropped. If it is not ...
https://dev.mysql.com/doc/refman/8.0/en/events-privileges.html
The EVENT privilege governs the creation, modification, and deletion of events. In this example, the EVENT privilege on the schema myschema is removed from the jon@ghidora user account: REVOKE EVENT ON myschema.* FROM jon@ghidora; Important Revoking ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html
There is an exception for CREATE DATABASE, ALTER DATABASE, and DROP DATABASE. The database being created, altered, or dropped is considered to be the default database when determining whether to output the statement. Suppose that the binary log just ... The server's binary log consists of files containing “events” that describe modifications to database ...
https://dev.mysql.com/doc/refman/8.0/en/ndb-restore-different-number-nodes.html
See Section 25.6.8.2, “Using The NDB Cluster Management Client to Create a Backup”, for information about how to do this. The files created by the backup on each data node are listed here, where N is the node ID and B is the backup ID. Note When ... It is possible to restore from an NDB backup to a cluster having a different number of data nodes than the original from which the backup was ...