Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-issues.html
If this occurs, it is entirely possible for new data to be inserted into the source cluster without being recorded in the source SQL node's binary log. In the event of a node failure, errors in replication of NDB tables without primary keys can ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-documents-in-tables.html
In the following example, a document is passed as the final value to be inserted into the Info column. mysql-js> db.city.insert().values( None, "San Francisco", "USA", "California", '{"Population":830000}') Select a Record You can issue a query with ... In MySQL, a table may contain traditional relational data, JSON values, or ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-documents-in-tables.html
In the following example, a document is passed as the final value to be inserted into the Info column. mysql-py> db.city.insert().values( None, "San Francisco", "USA", "California", '{"Population":830000}') Select a Record You can issue a query with ... In MySQL, a table may contain traditional relational data, JSON values, or ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog-row-events.html
# at 218 #080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F BINLOG ' fAS3SBMBAAAALAAAANoAAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ= fAS3SBcBAAAAKAAAAAIBAAAQABEAAAAAAAEAA//8AQAAAAVhcHBsZQ== '/*!*/; ### INSERT INTO ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-table.html
Use OPTIMIZE TABLE in these cases, depending on the type of table: After doing substantial insert, update, or delete operations on an InnoDB table that has its own .ibd file because it was created with the innodb_file_per_table option enabled. After ...OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-diskio.html
(Measure at a time when the server is not doing bulk inserts; it is normal during bulk inserts for the modified pages percentage to rise significantly.) Log sequence number - Last checkpoint is at less than 7/8 or ideally less than 6/8 of the total ... If you follow best practices for database design and tuning techniques for SQL operations, but your database is still slow due to heavy disk I/O activity, consider these disk I/O ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...
https://dev.mysql.com/doc/refman/8.4/en/prepare.html
If a parameter is an immediate member of a SELECT list that is not part of an INSERT statement, the derived type of the parameter is VARCHAR, and its collation is determined by the value of collation_connection. If a parameter is an immediate member ... PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-variables.html
sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes to it on the source. However, when mysqlbinlog parses a SET @@sql_mode = mode statement, the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks.html
For example, to grant the priv_repl user account the INSERT privilege to add rows to the cust table in db1, issue the following statement: mysql> GRANT INSERT ON db1.cust TO 'priv_repl'@'%.example.com'; You assign the PRIVILEGE_CHECKS_USER account ... By default, MySQL replication (including Group Replication) does not carry out privilege checks when transactions that were already accepted by another server are applied on a replica or group ...