…. For example, if I see a lot of queries in odd statuses, like “statistics”, I know something weird is going on… be changed. Queries can be broken into pieces, combined, or even eliminated entirely (we may suggest caching, or tell the customer… server, so it’s often worth another iteration, and sometimes even more after that. A really thorough audit can take up…
Post: Is VoltDB really as scalable as they claim?
February 28, 2011 By 3 Comments
… designed to be very fast (hundreds of thousands of TPS) even on low-end machines, by doing away with the usual… because of the lack of cross-node communication. What’s odd is that the k-factor of 0 reaches its peak… these are not high-end servers, and VoltDB should provide even higher performance on faster machines. I did not audit or…
Comment: Friday challange: linking with GPL code
May 10, 2009 By 20 Comments
LD_PRELOAD seems to be a bit odd, since then you distribute the launcher script which does that, … it’s not pre-load linking, at compile time, or even by that LD_PRELOAD thing, and it’s…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
… in MySQL 4.1, and indeed previously it did not even scale with one CPU as global lock was held during… multiple key caches for the same table, for example caching even/odd key blocks or something similar, or actually just keep hash…
Post: Percona Toolkit 2.0.1 and 1.0.2 released
January 3, 2012 By 5 Comments
…. It just works. It’s so magical, you don’t even have to give it any command-line options in a… production cases, then started all over again. Finally, a few odds and ends to wrap this up. If you’re interested…
Comment: Tokyo Tyrant - The Extras Part I : Is it Durable?
August 20, 2010 By 5 Comments
… database machine. Think: AS/400 or S390. One can can even schedule such tuning parameters, where the OS buffer/caches might… writes will be appreciably faster & if you mirror twice the odds are much lower readers will contend on disk heads against…
Comment: Slow Query Log analyzes tools
June 10, 2008 By 83 Comments
… high load, long periods of quite low load, and even the odd moment of practically zero load. This recreates all of them…
Comment: Full text search for all MySQL Storage Engines
June 29, 2006 By 37 Comments
14. Vadim: Darn, what are the odds that mysql will use sphinx as its native fulltext index …_match: 12.82, self: 11.51 read_hits: 1.31 ————— Even if the new SPH_MATCH_BOOLEAN is an improvement by…
