… what version of Innodb/MySQL would you recommend? I’ve been …backed disk controller write-back cache does the same thing. PZ… been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent… quantify what are the limits of different operations for different…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…limit scalabilty? A: It depends how you store $_SESSION. I have audited sites that stored $_SESSION in the MySQL database for persistence, but when we measured query load with pt-query…For best scalability, I’d recommend storing $_SESSION in an…with using a write-through cache? A: The InnoDB …
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… case by case basics before recommending the move. Is MyISAM used…limits, for example there is a dedicated slave available for all long reporting queries…see clustering by primary key, caching data, higher concurrency, background flushes…so common paths in the MySQL server – in particular Optimizer may…
