… a bug in MySQL 5.6 code? As MRR was used in both MySQL 5.6 and MariaDB 5.5. Handler_mrr_rowid_refills counts how many…-index-only columns) involves, reading an index record, and then using the PK column value in the index record to make a lookup in the PK. Both these lookups are performed in a single call to the storage…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…to statement level MySQL Replication which among other requirements, needs all auto-increment values in multiple value insert to be sequential. To…code simple and same for all insert cases – in fact if the insert is single value insert or the number of values in…
Post: MySQL Prepared Statements
August 2, 2006 By 19 Comments
…to close prepared statements – Many memory leaks reported in MySQL Server turned out to be prepare statements or cursors which were forgotten to…count variable to track number of open statements diretly. You can also adjust max_prepared_stmt_count variable which limits how…
Post: Innodb row size limitation
April 7, 2011 By 11 Comments
…mysql> INSERT INTO example -> VALUES…columns for a given row on a single…code, as it requires you to rewrite as joins queries that access all columns in the original table. It also requires you to…
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
…value (the row that is missing) is represented in the WHERE clause. The binary log does not carry column names, so each column…MySQL slaves to prevent accidental changes in data from happening! *edit* The MySQL 5.1 default binary logging format changed back to STATEMENT in MySQL…
Post: INSERT ON DUPLICATE KEY UPDATE and summary counters.
May 29, 2006 By 46 Comments
…MySQL feature. It was introduced in MySQL…counting…to do incremental single…column will have its value automatically updated to current timestamp on insert and update. We actually could have omitted now() in…code becomes simplier – less error prone and easy to…
