Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-warnings.html
Warnings are generated for DML statements such as INSERT, UPDATE, and LOAD DATA as well as DDL statements such as CREATE TABLE and ALTER TABLE. mysql> CREATE TABLE t1 (a TINYINT NOT NULL, b CHAR(4)); Query OK, 0 rows affected (0.05 sec) mysql> ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-performance-space-overview.html
When connected to a running MySQL server, MySQL Enterprise Backup performs hot backup for InnoDB tables. This type of backups blocks any write operations to the tables during the backup process, but still allow tables to be read. When connected to a ... When it comes to formulating your backup strategy, performance and storage space are the key ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.html
In addition to creating backups, mysqlbackup can pack and unpack backup data, apply to the backup data any changes to InnoDB tables that occurred during the backup operation, and restore data, index, and log files back to their original locations, ...During backup operations, mysqlbackup backs up: All InnoDB tables and indexes, including: The InnoDB system tablespace, which, by default contains all the InnoDB ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-vector-store-load.html
table_name: specifies the name of the vector store table to create. The VECTOR_STORE_LOAD routine generates vector embedding for the specified files or folders that are , and loads the embeddings into a new vector store table. By default, the ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-transactional.html
The downloaded script explicitly creates MyISAM tables, which do not support transactional semantics. To use transactional database access, we will need to change the storage engine of the tables in the world database. ALTER TABLE City ... Spring ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mysql-process-discovery-advisor-ref.html
Admin User The root user of the instance, or a user that has the SUPER, CREATE, and INSERT privileges on the schema in which the inventory table is created. The inventory table stores unique identifiers for the instance, and is created in the mysql ... The MySQL Process Discovery Advisor enables you to find and, optionally, establish a connection with unmonitored MySQL ...If you choose not to attempt a ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-transactional.html
The downloaded script explicitly creates MyISAM tables, which do not support transactional semantics. To use transactional database access, we will need to change the storage engine of the tables in the world database. ALTER TABLE City ... Spring ...
https://dev.mysql.com/doc/refman/8.4/en/copying-databases.html
In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. Note If GTIDs are in use on the server where you create the dump (gtid_mode=ON), by default, mysqldump ...You can then transfer the file to the other machine and feed it as input to the mysql ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-secondary-indexes-ndbrecord.html
*/ NdbDictionary::RecordSpecification spec[2]; spec[0].column= col1; spec[0].offset= offsetof(MyTableRow, attr1); // So that it goes nicely into the struct spec[0].nullbit_byte_offset= 0; spec[0].nullbit_bit_in_byte= 0; const NdbRecord *pk_record= ...*/ const NdbDictionary::Column *col1= myTable->getColumn("ATTR1"); if (col1 == NULL) APIERROR(myDict->getNdbError()); const NdbDictionary::Column *col2= myTable->getColumn("ATTR2"); if (col2 == NULL) APIERROR(myDict->getNdbError()); /* NdbRecord for primary key ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-advisors-intro-advisor-page-ref.html
Figure 19.2 Advisor Menu Control The Advisor menu is displayed: Figure 19.3 Advisor Pop-up Menu Table 19.3 Advisor Edit Menu Controls Name Description Copy Advisor Opens the Create New Advisor page and appends - Copy 1 to the Advisor name. Figure ...