MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 61 to 70 of 76 total results

https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html

Changing the column data type ALTER TABLE tbl_name CHANGE c1 c1 BIGINT, ALGORITHM=COPY; Changing the column data type is only supported with ALGORITHM=COPY. Online support details, syntax examples, and usage notes for DDL operations are provided ...

6.6.6 myisampack — Generate Compressed, Read-Only MyISAM Tables

https://dev.mysql.com/doc/refman/8.0/en/myisampack.html

For example, a BIGINT column (eight bytes) can be stored as a TINYINT column (one byte) if all its values are in the range from -128 to 127. When the table is used later, the server reads into memory the information needed to decompress columns.

25.6.16.46 The ndbinfo memory_per_fragment Table

https://dev.mysql.com/doc/refman/8.0/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 ...

25.6.16.47 The ndbinfo nodes Table

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-nodes.html

This table contains information on the status of data nodes. For each data node that is running in the cluster, a corresponding row in this table provides the node's node ID, status, and uptime. For nodes that are starting, it also shows the ...

17.20.3 Setting Up the InnoDB memcached Plugin

https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-setup.html

mysql> CREATE TABLE city ( city_id VARCHAR(32), name VARCHAR(1024), state VARCHAR(1024), country VARCHAR(1024), flags INT, cas BIGINT UNSIGNED, expiry INT, primary key(city_id) ) ENGINE=InnoDB; Add an entry to the innodb_memcache.containers table so ... This section describes how to set up the daemon_memcached plugin on a MySQL ...

25.4.3.9 MySQL Server Options and Variables for NDB Cluster

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-options-variables.html

This means that (for example) a join on an INT column and a BIGINT column also cannot be pushed down. This section provides information about MySQL server options, server and status variables that are specific to NDB Cluster. For general ...

26.1 Overview of Partitioning in MySQL

https://dev.mysql.com/doc/refman/8.0/en/partitioning-overview.html

This section provides a conceptual overview of partitioning in MySQL 8.0. For information on partitioning restrictions and feature limitations, see Section 26.6, “Restrictions and Limitations on Partitioning”. The SQL standard does not provide ...

25.5.28 ndb_size.pl — NDBCLUSTER Size Requirement Estimator

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-size-pl.html

This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage engine. Unlike the other utilities discussed in this section, it does not require ...

17.20.8 InnoDB memcached Plugin Internals

https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-internals.html

It must be mapped to a BIGINT of at least 8 bytes. InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from embedded InnoDB. InnoDB API functions are passed ...

25.2.4 What is New in MySQL NDB Cluster 8.0

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html

This column must be one of INT or BIGINT; the allowed range of the offset value is the same as the signed version of that type (this allows the offset to be negative if desired). The following sections describe changes in the implementation of ...

Displaying 61 to 70 of 76 total results