…you need Both Memcached and the MySQL query cache are limited in size. If you try to cache more information than you can…commands can be used to either replace the contents of, or insert new data into the summary table. One advantage of… and thus they may be out of sync with the underlying data. If …
Post: Tokyo Tyrant - The Extras Part I : Is it Durable?
November 10, 2009 By 5 Comments
…you really need to directly call the sync command. In my previous post someone pointed out…sync after writes ruined performance. Looking at the code you can see why calling a sync after each write can…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…filtered out only queries of this pattern and got a simplified part of production… what you would expect from 24 core system. For comparison you can checkSysbench …_select,mysql_execute_command,mysql_parse,dispatch_command,do_command,do_handle_one…wait,os_event_wait_low,sync_array_wait_event,mutex_spin…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
… behavior helps to preserve consistency however it can scare hell out of you, giving you no access to the data at all. … active sync /dev/sda3 1 8 19 1 active sync /dev/sdb3 2 8 35 2 active sync /dev/… by design as using such commands wrong way can ruin your RAID array. What you can do instead is to …
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
…ensure the master and slave are in sync (once the test load is stopped)…./backtrace.gdb:20: Error in sourced command file: No registers. # 2011-12-21T14:… this for yourself during a run, you can try the new option –test-debug…. build of the server, but other than that, they are ready to run out of …
Post: Using Flexviews - part one, introduction to materialized views
March 23, 2011 By 3 Comments
…command described above. This similarity is fairly superficial though. While both store results in a table, the MV represents the results of…can can be refreshed to a specific point in time, not just “now”. This means that you can maintain multiple MVs and keep them synced… Flexviews figures out what …
