PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-files.html
The files table is empty if no disk data objects have been created in NDB. See Section 25.6.11.1, “NDB Cluster Disk Data Objects”, for more information.
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-memory-per-fragment.html
memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual fragments. See the Notes later in this section to see how you can use this to find out ...