PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/using-gdb-on-mysqld.html
In this case, you should set the following environment variable in the shell before starting gdb: LD_ASSUME_KERNEL=2.4.1 export LD_ASSUME_KERNEL When running mysqld under gdb, you should disable the stack trace with --skip-stack-trace to be able to ... On most systems you can also start mysqld from gdb to get more information if mysqld ...With some older gdb ...
https://dev.mysql.com/doc/refman/5.7/en/sys-create-synonym-db.html
This can be used, for example, to create a shorter name by which to refer to a schema with a long name (such as info rather than INFORMATION_SCHEMA). Parameters in_db_name VARCHAR(64): The name of the schema for which to create the synonym. Given a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking-transaction-model.html
To implement a large-scale, busy, or highly reliable database application, to port substantial code from a different database system, or to tune MySQL performance, it is important to understand InnoDB locking and the InnoDB transaction model. This ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-migration.html
Restoring from a Logical Backup You can use a utility such as mysqldump to perform a logical backup, which produces a set of SQL statements that can be executed to reproduce the original database object definitions and table data for transfer to ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-installation.html
The CREATE FUNCTION and DROP FUNCTION statements require the INSERT and DROP privilege, respectively, for the mysql database. The function library base name is openssl_udf and the suffix is platform dependent. For example, the file name on Linux or ... MySQL Enterprise Encryption functions are located in a loadable function library file installed in the plugin directory (the directory named by the plugin_dir system ...
https://dev.mysql.com/doc/refman/5.7/en/myisampack.html
--character-sets-dir=dir_name Command-Line Format --character-sets-dir=dir_name Type Directory name The directory where character sets are installed. When the table is used later, the server reads into memory the information needed to decompress ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. Next, for every table in the query, we ...row ...
https://dev.mysql.com/doc/refman/5.7/en/alter-instance.html
The statement supports these actions: ALTER INSTANCE ROTATE INNODB MASTER KEY This action rotates the master encryption key used for InnoDB tablespace encryption. To perform this action, a keyring plugin must be installed and configured. If one of ... ALTER INSTANCE ROTATE INNODB MASTER KEY ALTER INSTANCE, introduced in MySQL 5.7.11, defines actions applicable to a MySQL server ...
https://dev.mysql.com/doc/refman/5.7/en/channels-commands-single-channel.html
To enable MySQL replication operations to act on individual replication channels, use the FOR CHANNEL channel clause with the following replication statements: CHANGE MASTER TO START SLAVE STOP SLAVE SHOW RELAYLOG EVENTS FLUSH RELAY LOGS SHOW SLAVE ...
https://dev.mysql.com/doc/refman/5.7/en/choosing-types.html
For optimum storage, you should try to use the most precise type in all cases. For example, if an integer column is used for values in the range from 1 to 99999, MEDIUMINT UNSIGNED is the best type. For high precision, you can always convert to a ...Of the types that represent all the required values, this type uses the least amount of ...