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/mysql-shell-tutorial-python-table-select.html
MySQL provides the following operators to specify search conditions: OR (||), AND (&&), XOR, IS, NOT, BETWEEN, IN, LIKE, !=, <>, >, >=, <, <=, &, |, <<, >>, +, -, *, /, ~, and %. mysql-py> db.city.select() ... You can use the select() method to ...
https://dev.mysql.com/doc/refman/8.0/en/mysqld.html
mysqld, also known as MySQL Server, is a single multithreaded program that does most of the work in a MySQL installation. MySQL Server manages access to the MySQL data directory that contains databases and tables. Note Some installation packages ...
https://dev.mysql.com/doc/refman/8.0/en/source-installation.html
Building MySQL from the source code enables you to customize build parameters, compiler optimizations, and installation location. For a list of systems on which MySQL is known to run, see ...Before you proceed with an installation from source, ...
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html
The size penalty for storing the hex string in a CHAR column is at least two times, up to eight times if the value is stored in a column that uses the utf8mb4 character set (where each character uses 4 bytes). Caution Passwords or other sensitive ...
https://dev.mysql.com/doc/refman/8.0/en/windows-postinstallation.html
GUI tools exist that perform most of the tasks described in this section, including: MySQL Installer: Used to install and upgrade MySQL products. If necessary, initialize the data directory and create the MySQL grant tables. Windows installation ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
Only this format supports the optional query time and size statistics, which are available from MySQL 8.0.30. Adding Query Statistics for Outlier Detection In MySQL 8.0.30 and later, you can extend log files in JSON format with optional data fields ...For best security, write the audit log to a directory accessible only to the MySQL server and to users with a legitimate reason to view the ... This section describes how to configure audit logging characteristics, such as the file to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-innodb-engines.html
The NDB storage engine is implemented using a distributed, shared-nothing architecture, which causes it to behave differently from InnoDB in a number of ways. For those unaccustomed to working with NDB, unexpected behaviors can arise due to its ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-preparation.html
Preparing the NDB Cluster for replication consists of the following steps: Check all MySQL servers for version compatibility (see Section 25.7.2, “General Requirements for NDB Cluster Replication”). If the source cluster is already in use, you ...To provide replication backup capability, you also need to add an --ndb-connectstring option to the replica's my.cnf file prior to starting the replication ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool.html
Note MySQL Enterprise Thread Pool is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition includes MySQL Enterprise Thread Pool, implemented using a server plugin. The default thread-handling model in ...
https://dev.mysql.com/doc/refman/8.0/en/data-directory.html
Information managed by the MySQL server is stored under a directory known as the data directory. All MySQL installations have certain standard databases: The mysql directory corresponds to the mysql system schema, which contains information ...The ...