… foreground threads were responsible for moving pages to the free list via buf_flush_free_margin. I did a lot of work for the innodb_fast_free_list option to fix the stalls and that change makes 5… in 5.6. In 5.6 a background thread, buf_flush_page_cleaner_thread, should be moving all pages to the free list…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… foreground threads were responsible for moving pages to the free list via buf_flush_free_margin. I did a lot of work for the innodb_fast_free_list option to fix the stalls and that change makes 5… in 5.6. In 5.6 a background thread, buf_flush_page_cleaner_thread, should be moving all pages to the free list…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… Indeed, there is no information about the table structure in an InnoDB page. Normally we either recover the …741 | 4 | 1 | 0 | 0 | | 738 | +————–+—–+——–+——+——–+———+————–+——-+ SYS_INDEXES This table lists all indexes the table has, secondary as well as…
Post: Percona Live MySQL Conference and Expo 2013: It feels like 2007 again
March 21, 2013 By Leave a Comment
…, and I would have a hard time listing all of the ones on my list to attend — but you can check all… of the conference is not talks, but what happens in between them — in the conference center halls and behind the curtains. If… MySQL Conference and Expo 2013. It runs April 22-25 in Santa Clara, California. But just remember: Advanced Rate tickets end…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… started with a baseline HDD configuration for MySQL (configuration A, listed at the bottom of this post) and then tried three… configuration for purposes of comparison. Given the apparent differences in time-based flushing in vCache and FlashCache, both cache devices were set… is fairly crippled and ineffectual. FlashCache does substantially better, coming in at an average of around 600 tps, but vCache is…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… utilities designed to provide functionality similar to that of FlashCache. In particular, Virident engaged Percona to do a usability and feature…; vCache does not. This is something that could prove useful in certain situations. Winner: FlashCache. Operational Monitoring: Both solutions offer plenty… be so different between the two cache solutions, I’m listing it here. The vCache manual indicates that “flush period” specifies…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 11, 2013 By 13 Comments
…” to “users” — just because TokuDB has experienced great community interest in the past month hardly guarantees them any more business success…). I would say that there have been 2 business successes in the MySQL space — MySQL AB itself because they could support… company. I guess you could also add Innobase to the list too.
Post: Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver
May 6, 2013 By 2 Comments
… @@hostname without /*!50038*/ pt-stalk prints the wrong variable name in verbose mode when –function is used And more The first… DSNs in a DSN table (–recursion-method=dsn). See https://launchpad.net/percona-toolkit/+milestone/2.2.2 for the full list of bugs fixed in Percona Toolkit 2.2.2. Visit http://www…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
… with putting on this event that it’s impossible to list them all. The conference would be meaningless, though, without great… four days. Special thanks go to our Conference Committee and, in particular, to the Committee Chair, Shlomi Noach, for working through… leaders presenting insights on technology, the market, and the community in a cooperative atmosphere. We run Percona Live MySQL conferences to…
Comment: Looking for RAID Controller without Battery Learning problems ?
April 26, 2013 By 11 Comments
http://lists.us.dell.com/pipermail/linux-poweredge/2012-June/046470.html transparent learn cycle NOTE: Virtual disks stays in Write Back…
