Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-moving-data-files-offline.html
Add the directories of file-per-table and general tablespaces created with an absolute path or in a location outside of the data directory to the innodb_directories setting. The innodb_directories variable, which defines directories to scan at ...
https://dev.mysql.com/doc/internals/en/too-greedy-test.html
Let's assume we have to check that every new created table causes a row in information_schema.tables. --replace_column 15 <CREATE_TIME> 16 <UPDATE_TIME> 17 <CHECK_TIME> SELECT * FROM information_schema.tables; The SELECT above makes the test ...The ...It is to be expected that such a test requires frequent maintenance like adjustment of expected ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-setting.html
Examples include all DDL (data definition language) statements such as CREATE TABLE, ALTER TABLE, or DROP TABLE. If a session has open temporary tables, the replication format cannot be changed for the session (SET @@SESSION.binlog_format). If any ... You can select the binary logging format explicitly by starting the MySQL server with ...
https://dev.mysql.com/doc/refman/8.4/en/encryption-functions.html
One way to make collisions detectable is to make the hash column a primary key. These functions support the use of a key derivation function (KDF) to create a cryptographically strong secret key from the information passed in key_str. When you use a ...If you want to store these results, use a column with a VARBINARY or BLOB binary string data ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-implementation-notes.html
The driver uses SHOW CREATE TABLE to retrieve this information, so if any other storage engines add support for foreign keys, the driver would transparently support them as well. You must use a column alias with the value of the column to the actual ... MySQL Connector/J, as a rigorous implementation of the JDBC API, passes all of the tests in the publicly available version of Oracle's JDBC compliance test ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-event-handling.html
#include <NdbApi.hpp> // Used for cout #include <stdio.h> #include <iostream> #include <unistd.h> #ifdef VM_TRACE #include <my_global.h> #endif #ifndef assert #include <assert.h> #endif /** * Assume that there is a table which is being updated by * ...The source code for this program may be found in the NDB Cluster source tree, in the file ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html
The driver uses SHOW CREATE TABLE to retrieve this information, so if any other storage engines add support for foreign keys, the driver would transparently support them as well. You must use a column alias with the value of the column to the actual ... MySQL Connector/J, as a rigorous implementation of the JDBC API, passes all of the tests in the publicly available version of Oracle's JDBC compliance test ...
https://dev.mysql.com/doc/refman/8.4/en/database-use.html
You can do so by creating tables to hold your data and loading them with the desired information. Then you can answer different sorts of questions about your animals by retrieving data from the tables. You can use the test database (if you have ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-full-text-plugins.html
The following procedure describes how the plugin library is created: To write a full-text parser plugin, include the following header file in the plugin source file. This is the value that identifies the plugin as being legal for use in a WITH ...
https://dev.mysql.com/doc/refman/8.4/en/char.html
The length of a CHAR column is fixed to the length that you declare when you create the table. See Section 10.4.7, “Limits on Table Column Count and Row Size”. The following table illustrates the differences between CHAR and VARCHAR by showing ... The CHAR and VARCHAR types are similar, but differ in the way they are stored and ...