Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-internal-data.html
This is not like user tables, where the data changes only when application-initiated updates occur. The data exposed by the transaction and locking tables (INFORMATION_SCHEMA INNODB_TRX table, Performance Schema data_locks and data_lock_waits ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-schema.html
This type of tuning is primarily for expert users who evaluate optimization strategies to overcome performance bottlenecks. This section provides a brief introduction to InnoDB integration with Performance Schema. For comprehensive Performance ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-model.html
Typically, several users are permitted to lock every row in InnoDB tables, or any random subset of the rows, without causing InnoDB memory exhaustion. The InnoDB transaction model aims to combine the best properties of a multi-versioning database ...
https://dev.mysql.com/doc/refman/8.4/en/installing.html
This section describes how to secure the initial MySQL root user account, which has no password until you assign one. A summary of the procedure follows and later sections provide the details. If you plan to upgrade an existing version of MySQL to a ...
https://dev.mysql.com/doc/refman/8.4/en/internal-functions.html
CAN_ACCESS_COLUMN(ARGS) CAN_ACCESS_DATABASE(ARGS) CAN_ACCESS_TABLE(ARGS) CAN_ACCESS_USER(ARGS) CAN_ACCESS_VIEW(ARGS) GET_DD_COLUMN_PRIVILEGES(ARGS) GET_DD_CREATE_OPTIONS(ARGS) GET_DD_INDEX_SUB_PART_LENGTH(ARGS) INTERNAL_AUTO_INCREMENT(ARGS) ...
https://dev.mysql.com/doc/refman/8.4/en/language-structure.html
This chapter discusses the rules for writing the following elements of SQL statements when using MySQL: Literal values such as strings and numbers Identifiers such as database, table, and column names Keywords and reserved words User-defined and ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation.html
The user you use to perform the installation must have administrator privileges. For a list of macOS versions that the MySQL server supports, see https://www.mysql.com/support/supportedplatforms/database.html. MySQL for macOS is available in a ...
https://dev.mysql.com/doc/refman/8.4/en/metadata-locking.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 14.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-server-clients.html
"mysql_read_default_file=/usr/local/mysql/data/my.cnf"; $dbh = DBI->connect($dsn, $user, $password); See Section 31.9, “MySQL Perl API”. Start the client with --protocol=TCP to connect using TCP/IP, --protocol=SOCKET to connect using a Unix ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-unix-servers.html
Note The discussion here uses mysqld_safe to launch multiple instances of MySQL. For MySQL installation using an RPM distribution, server startup and shutdown is managed by systemd on several Linux platforms. On these platforms, mysqld_safe is not ...