On 1/21/08 11:27 PM, "Hans Zaunere" <[EMAIL PROTECTED]> wrote: > I'm curious as to what you'll be doing with the 15k SCSIs - that would help > shed some light on how the RAM would be best used. I'm just using them in a RAID 1 configuration, hoping that they will help a database intensive application riddled with inefficiencies such as little caching. > What type of CPU(s)? Single processor, dual core XEON 5148LV, 2.33GHz
> In MySQL, it's probably not at the query cache so much, but rather at > buffers. Which buffers? That of course depends on your table types, > general schema layout, and query pattern. > If you have a lot of rows, or a competitive read/write ratio, then it's > probably more likely that the query cache will always get invalidated I'm thinking a query cache sounds useless for a highly dynamic application. So big buffers sound like a better strategy. Also sounds like I simply need to collect data to see what the actual read/write ration turns out to be over time. Thanks, Cliff _______________________________________________ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
