On Dec 2, 2003, at 04:50, Brion Vibber wrote:
If I can get PHP up and running I'll try rebuilding the links table and see how long that takes...
Okay, got that started: ... 6000 of 352641 articles scanned (58 articles and 1302 titles per second) Title cache hits: 37% ...
IO is fairly light, and the processes seem CPU-bound; usage bounces between about 50/50 mysqld/php to more like 75/25. Between them they only use a single processor, though, since PHP waits for MySQL to process and return an entire query before continuing.
I've put in the stock my-huge.cnf with slight modifications; bumped key cache and innodb buffer cache up to 1 gig each, innodb log file to 128meg (good? bad?), and set the transaction log to only force disk flushes at most once per second.
-- brion vibber (brion @ pobox.com)