…look very good indeed. Peter will present the results in an “optimizer standoff” talk at… binary log enabled Faster queries through speedier joins, faster subqueries, and elimination of useless tables…improvements to partitioning, and the addition of multiple InnoDB buffer pools. Best of all, MariaDB …
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
… HEX AND BINARY DATA… 080703 23:46:16 InnoDB: Page checksum 587461377, prior-to-4.0.14-form checksum 772331632 InnoDB: stored checksum… your MyISAM table you use for recovery after MySQL crashes to make sure indexes are not corrupted. So we looked at how to get your data back from simple Innodb Table Corruption. In more complex cases you may need to use higher innodb…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… some changes, create a temporary table with ENGINE=InnoDB, and the InnoDB transaction ID does not change in SHOW INNODB STATUS. The statements are… did this, everything in the binary log so far comes from these statements. Let’s look at the binary logs: master > show master status…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 11 Comments
… on XFS file system Server was running innodb_file_per_table There was a production master and two … tables don’t have any text columns at all? Then, you read further. GNU grep won’t match binary strings. This isn’t new, I kind of knew grep couldn’t look for binary “junk”,…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… Users Conference was surely Storage Engines both looking at number of third party storage engine presented,… Auto Increment handling Yet another known Innodb problem is table locks which are taken for statement… and make binaries with them available. With current MySQL 5.0 I still see Innodb having…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…CentOS. If you are using InnoDB, it is also important that…if our salaries table is restored. mysql> SHOW TABLES; +———————+ | Tables_in_employees | +———————+ … | salaries | … …and a new binary log is created, looking at the current binary logs after…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…look at…innodb_file_per_table innodb_log_group_home_dir = /log/mysql/var/ innodb_checksums = 0 innodb_doublewrite = 0 innodb_buffer_pool_size = 5000m innodb…
Post: STOP: DELETE IGNORE on Tables with Foreign Keys Can Break Replication
February 2, 2012 By 1 Comment
…’s take a table with data as example, column c1 on table t2 references column c1 on table t1 – both …rows, none should be deleted at all, after all this is InnoDB right? Wrong, take a look at bug 44987. As …(http://dev.mysql.com/doc/refman/5.1/en/binary-log-mixed.html) thus failure to execute the …
Post: Concurrent inserts on MyISAM and the binary log
May 14, 2008 By 7 Comments
…table, selecting data from it and inserting into another table. Let’s look at what happens here: suppose you have two tables… have to be serialized for the binary log; otherwise replaying the binary log can result in a … by LOAD DATA INFILE. You can use InnoDB instead. Or you can do something more …
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
… Innodb tables but there are other things you need OS cache for – MyISAM tables (mysql database, temporary etc) will need it, .frm file, binary logs, or relay logs, Innodb Transactional Logs also like… things out. Two things to note about OS Swapping. First looking at “swap used” is not really helpful because you do not…
