… binary log coordinates when the snapshot was taken and saves it into a file specified as variable on the script. Below is the binary log…-bin.000022 336796712 Using the coordinates above, I can start searching for the position of the DELETE statement so we can… know for a fact that for every MySQL restart, the logs are flushed and a new binary log is created, looking at the current binary logs after…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
….gz binary from dev.mysql.com), and for the other tests I used Percona Server based on 5.5.8. Addressing a… them in searching for optimal values. innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log_at… with the adaptive_checkpoint algorithm disabled), but with giant log files. I used a log file of 8000MB*2, just to see what…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…Flexviews (the primary purpose of FlexCDC). Feed search engines like Sphinx or Solr only …a metadata table: $ mysql -e ‘select * from flexviews.binlog_consumer_status\G’ -uroot *************************** 1. row *************************** server_id: 999 master_log_file: binary_log.000001 master_log…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… prefix compression prevents one from using a binary search on a B-tree node. We could not compare a search key K to an index record… approaches where some prefix information is stored, and a search almost as efficient as a binary search can be performed. But InnoDB’s adaptive hash… InnoDB’s group commit works again. PZ: You can disable binary logging to get Group Commit back. Though this is often not…
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
… to a statement based binary log. Since row-based logs only contain information about changed rows, a replication slave which does not find a row… –base64-output=decode-rows -v > decoded.log Examine the decoded binary log with the ‘less’ utility, and search forward for the value 340718: # at…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…backups etc – because Sphinx is doing all search heavy lifting we only need to insert…log write speed is usually minimal. At the same time if reliability is desired it might be good idea to keep Binary Logs… to understand what is happening and why. A lot of pieces – filesystem, disk scheduling, …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…. And besides, most applications have a lot of the same components. Tagging, friends, queues, click tracking, search, paginated displays — we’ve seen these and dozens of other common patterns done a hundred different ways. The… use a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to get more information than the slow log gives…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… all storage engines. Lets start with a bit of history. When MySQL was …binary logs from master. It does not affect Innodb and other storage engines transaction logs, slow query log or general log…_query_expansion_limit, ft_stopword_file FullText search related variables. As FullText currently works …
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
…test”) InnoDB: Database page corruption on disk or a failed and crash with assertion failure. So …of similar statements to find exact number doing “binary search” Note even if you do not use …, insert buffer merge or recovery from transactional logs all together. Though the lower recovery mode …
Post: Percona Server 5.5.8 Beta Release
February 16, 2011 By 16 Comments
…for download. This is a beta release of …(see Multiple Adaptive Hash Search Partitions. Bug fixed: #688866. (… Kinoshita) New variable log_warnings_silence replaced old variable suppress_log_warning_1592. Bug…the following links: Downloads – binary distributions and Percona Software Repositories…
