…Server: Intel core i970-3.20GHz. 12 logical cores (six physical cores). 12GB memory 4 disk 7200RPM RAID 10 array… MySQL 5.6.10 was doing more IO as a consequence. …. Innodb_old_blocks_time controls how long a page must be … buffer pool is smaller than the working set) having innodb_old_blocks_…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…quick preview, then explain exactly how Shard-Query works.Yes, Shard-Query scales …the proxy. The databases do 99.9% of the work, due to the …list of servers and some credentials are required to make this work. It can… flight_delayed`) — SQL TO SEND TO SHARDS Array ( [0] => SELECT origin_airport_id AS…
Comment: Slow Query Log analyzes tools
June 10, 2008 By 84 Comments
…work acceptably well in our case. It rebuilds the timing, connections, and queries the server… by connection id and datetime, # – is an array of all queries by that connection at…do this. #waitpid($pid,0); } } } # done!!! I got some quite interesting numbers our of it, and have learned a lot about how…
Post: RAID and Scale Out Discussions
June 12, 2007 By 3 Comments
… the company skilled enough to work with distributed systems. I think … often ask how large system is needs to growth and how much …use crappy boxes as redundant array of inexpensive servers, basically moving redundancy one … with their new Opteron servers. They also do not provide high volume internal…
