… other for leaf nodes. The first 32 pages of a segment are allocated from…64 page extent is often done as a single 1 MB file read. PZ: “often” a bit… MUST use row-based binlogging and replication, and remember that the execution is not…and it would write at 100MBps vs 33MBps. Any plans to enable tuning…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…First lets talk about optimizing application vs getting better hardware. … schema changes, use of replication, caching, using memcached, sphinx,…64 box with 32G with good price/performance value while if you would like to go significantly higher like 32…just need another server a bit later. However if …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… A query thread normally posts about 64 page read requests per a readahead… I should note MySQL 5.0 vs 4.1 has a lot…keeping data smaller) or can a bit slow it down. Plus there …-year old HT’ed XEONs to 32 GB, 4x quad-core AMD Opterons… a separate computer, maybe a replication slave. Can you make the …
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
… One knock on Tokyo -vs- Memcached is Tokyo is not … is lacking. It does support replication which could make some rather…I increased the threads from 64 to 128. As time… where Tyrant may stumble a bit. Bottom line given a specific… above number were run with 32 Threads, Tyrant was started with…
