Search Results
https://dev.mysql.com/doc/refman/8.4/en/loading-tables.html
You could create a text file pet.txt containing one record per line, with values separated by tabs, and given in the order in which the columns were listed in the CREATE TABLE statement. In its simplest form, you supply values for each column, in ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/mysql-cluster-ndbinfo-dict-obj-tree.html
This means that you must know the name of any tablespace or log file group associated with a given table, or obtain this information from SHOW CREATE TABLE and then querying INFORMATION_SCHEMA.FILES, or similar means as shown here: mysql> SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-option-tables.html
ndb-default-column-format: Use this value (FIXED or DYNAMIC) by default for COLUMN_FORMAT and ROW_FORMAT options when creating or adding table columns. ndb_read_backup: Enable read from any replica for all NDB tables; use NDB_TABLE=READ_BACKUP={0|1} ... The following list includes command-line options, system variables, and status variables applicable within mysqld when it is running as an SQL node in an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-params-ndbd.html
InitialLogFileGroup: Describes log file group that is created during initial start. MaxNoOfOpenFiles: Maximum number of files open per data node.(One thread is created per file). PartitionsPerNode: Determines the number of table partitions created ... The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-list.html
For more detailed syntactical information, see Section 15.1.20, “CREATE TABLE Statement”. List partitioning in MySQL is similar to range partitioning in many ways. As in partitioning by RANGE, each partition must be explicitly defined. The ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-auto-increment.html
The instructions just given are subject to the limitations of CREATE TABLE ... If a table definition includes any of those characteristics, create t2 using a CREATE TABLE statement that is identical to the one used to create t1, but with the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-usage.html
In addition, because temporary tables can be read only from the thread which created them, there is seldom if ever any benefit obtained from replicating them, even when using statement-based format. The MySQL server tracks the logging mode that was ... MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format ...
https://dev.mysql.com/doc/refman/8.4/en/replication-setup-replicas.html
If you are setting up a new replication environment using the data from a different existing database server to create a new source, run the dump file generated from that server on the new source. The process for importing data to the replica ...
https://dev.mysql.com/doc/refman/8.4/en/resignal.html
RESIGNAL may change some or all information before passing it on. RESIGNAL is related to SIGNAL, but instead of originating a condition as SIGNAL does, RESIGNAL relays existing condition information, possibly after modifying it. RESIGNAL makes it ...