Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning.html
\! ls -l data/test/big_table.ibd CREATE TABLE key_block_size_4 LIKE big_table; ALTER TABLE key_block_size_4 key_block_size=4 row_format=compressed; INSERT INTO key_block_size_4 SELECT * FROM big_table; commit; -- Check how much space is needed for a ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
It outputs the three INSERT statements following USE test, but not the three INSERT statements following USE db2. mysqlbinlog --database=db2 does not output the first two INSERT statements because there is no default database. It does not output the ... The server's binary log consists of files containing “events” that describe modifications to database ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-sql-result-sets.html
An SqlResult combines a result set produced by, for example, INSERT, and a data set, produced by, for example, SELECT in one. An SqlResult instance exports methods for accessing data and to retrieving the last inserted ID or number of affected rows.
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
For a unique index, an error occurs regardless of SQL mode because reducing the index length might enable insertion of nonunique entries that do not meet the specified uniqueness requirement. When you insert a value of NULL (recommended) or 0 into ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.4/en/internal-locking.html
The MyISAM storage engine supports concurrent inserts to reduce contention between readers and writers for a given table: If a MyISAM table has no free blocks in the middle of the data file, rows are always inserted at the end of the data file. In ... This section discusses internal locking; that is, locking performed within the MySQL server itself to manage contention for table contents by multiple ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-net-vb.html
The following sample creates a table my_vb_net and demonstrates the use in VB.
https://dev.mysql.com/doc/internals/en/guided-tour-skeleton.html
Important files we'll be walking through: /sql/mysqld.cc /sql/sql_parse.cc /sql/sql_prepare.cc /sql/sql_insert.cc /sql/ha_myisam.cc /myisam/mi_write.c This is not as simple as what we've just done. Our objective is to follow the server from the time ... And now we're going to walk through something harder, namely the ...
https://dev.mysql.com/doc/x-devapi-userguide/en/collections-as-relational-tables.html
The following example shows how to insert a JSON document string into the doc field. Applications that seek to store standard SQL columns with Documents can cast a collection to a table. In this case a collection can be fetched as a Table object ...
https://dev.mysql.com/doc/x-devapi-userguide/en/transaction-handling.html
Transactions can be used to group operations into an atomic unit. Either all operations of a transaction succeed when they are committed, or none. It is possible to roll back a transaction as long as it has not been committed. Transactions can be ...
https://dev.mysql.com/doc/refman/8.4/en/archive-storage-engine.html
The ARCHIVE engine supports INSERT, REPLACE, and SELECT, but not DELETE or UPDATE. ARCHIVE does not support inserting a value into an AUTO_INCREMENT column less than the current maximum column value. There are several types of insertions that are ...