Search Results
https://dev.mysql.com/doc/refman/8.4/en/ibd2sdi.html
See http://dev.mysql.com/doc/refman/8.4/en/dbug-package.html -d, --dump-file=name Dump the tablespace SDI into the file passed by user. -i, --id=# Retrieve the SDI record matching the id passed by user. -t, --type=# Retrieve the SDI records matching ... ibd2sdi is a utility for extracting serialized dictionary information (SDI) from InnoDB tablespace ...
https://dev.mysql.com/doc/refman/8.4/en/innochecksum.html
cat t1.ibd | innochecksum --write=crc32 - > a.ibd Running innochecksum on Multiple User-defined Tablespace Files The following examples demonstrate how to run innochecksum on multiple user-defined tablespace files (.ibd files). On Windows systems, ...This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-internals.html
The patterns of values in your data determine how well it compresses, but typical user data often compresses by 50% or more. Unlike compression performed by an application, or compression features of some other database management systems, InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-temporary-tablespace.html
Session Temporary Tablespaces Session temporary tablespaces store user-created temporary tables and internal temporary tables created by the optimizer when InnoDB is configured as the storage engine for on-disk internal temporary tables. A maximum ... InnoDB uses session temporary tablespaces and a global temporary ...
https://dev.mysql.com/doc/refman/8.4/en/invoking-programs.html
$> mysql --user=root test $> mysqladmin extended-status variables $> mysqlshow --help $> mysqldump -u root personnel Arguments that begin with a single or double dash (-, --) specify program options. For example, the mysql program interprets the ...
https://dev.mysql.com/doc/refman/8.4/en/json-utility-functions.html
The argument can also be a valid JSON document or a string which can be parsed as one—either as a literal value or as the value of a user variable—in which case the function returns 0. This section documents utility functions that act on JSON ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-options.html
--keyring-migration-user=user_name Command-Line Format --keyring-migration-user=user_name Type String The user name of the MySQL account used for connecting to the running server that is currently using one of the key migration keystores. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-service.html
If there is no user context, this value can be NULL. The value need not actually be a “user”; the meaning depends on the application. Functions that implement the keyring function interface pass the value of CURRENT_USER() as the user_id value ... MySQL Server supports a keyring service that enables internal components and plugins to securely store sensitive information for later ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-apt-repo.html
During the installation, you are asked to supply a password for the root user for your MySQL installation. Users who want to set a password later can leave the password field blank in the dialogue box and just press Ok; in that case, root access to ... This section provides guidance on installing MySQL using the MySQL APT ...
https://dev.mysql.com/doc/refman/8.4/en/load-data-local-security.html
Such a server could access any file on the client host to which the client user has read access. In this environment, the client with respect to the MySQL server actually is the Web server, not a remote program being run by users who connect to the ... The LOAD DATA statement loads a data file into a ...