PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/known-issues.html
SELECT statements that insert zero or NULL values into an AUTO_INCREMENT column. This section lists known issues in recent versions of MySQL. For information about platform-specific issues, see the installation and debugging instructions in Section ...
https://dev.mysql.com/doc/refman/9.7/en/literals.html
These include strings, numbers, hexadecimal and bit values, boolean values, and NULL. This section describes how to write literal values in MySQL. The section also covers various nuances that you may encounter when dealing with these basic types in ...
https://dev.mysql.com/doc/refman/9.7/en/log-file-maintenance.html
For example, execute these commands as root: mv /var/log/mysqld.log /var/log/mysqld.log.old install -omysql -gmysql -m0644 /dev/null /var/log/mysqld.log . As described in Section 7.4, “MySQL Server Logs”, MySQL Server can create several ...
https://dev.mysql.com/doc/refman/9.7/en/memory-storage-engine.html
(This is an uncommon feature for implementations of hash indexes.) Columns that are indexed can contain NULL values. The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory. Because ...
https://dev.mysql.com/doc/refman/9.7/en/myisam-storage-engine.html
MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful extensions. Table 18.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather ...
https://dev.mysql.com/doc/refman/9.7/en/myisamchk-general-options.html
stats_method influences how NULL values are treated for index statistics collection when the --analyze option is given. The options described in this section can be used for any type of table maintenance operation performed by myisamchk. The ...
https://dev.mysql.com/doc/refman/9.7/en/myisamchk.html
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). You can also use the CHECK TABLE and ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-limitations-performance.html
Unique hash indexes created with USING HASH cannot be used for accessing a table if NULL is given as part of the key. The following performance issues are specific to or especially pronounced in NDB Cluster: Range scans. There are query performance ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-limitations-unsupported.html
A number of features supported by other storage engines are not supported for NDB tables. Trying to use any of these features in NDB Cluster does not cause errors in or of itself; however, errors may occur in applications that expects the features ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-mysqld.html
row *************************** Id: 1 User: system user Host: db: Command: Daemon Time: 1 State: Waiting for event from ndbcluster Info: NULL Important To participate in an NDB Cluster, the mysqld process must be started with both the options ...To ...