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)