…summary tables which was done by executing some huge group by query, doing some stuff with results and then populating tables…PHP config variable because that only controls memory which passes via PHP memory management which does not apply to MySQL result set…
Comment: PHP Large result sets and summary tables.
July 8, 2007 By 8 Comments
[...] Zaitsev over at MySQL Performance Blog has a post entitled PHP Large Result Sets and Summary Tables. This post completely caught me by surprise because (embarrassingly enough) I had no idea you could [...]
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… common. > I would also note for many PHP applications abstraction layer is > not the main …use query and external caching of result sets is generally a good idea and having pre-compiled summary data ready …in my > Why MySQL Could be slow with Large Tables article. Deciding whether or not to let …
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
…and was about same for 10 100 and 1000 tables which could be because of extent allocation for rather large tables. For 10000 tables…Summary: There are few basic things we can learn from these results – Concurrent growth of many tables causes data fragmentation and affects table…
