Further speed up of mysql apache reverse squid

DrNeil · 01-13-2007, 04:13 PM

Hi,

I have a reverse squid, with Mysql 4.1 (my-large.cnf and the basic speed optimisations have been done keybuffer and thread cache) and Apache 2 on a 2 GHz 2 Gigabyte Debian server with PHP and memcached installed.

I get hit in the moment with 40.000 uniques and 170.000 pages and about 6GB traffic a day.

It runs reasonably OK, but what else could I do to speed up? Main bottleneck seems to be mysql in the moment. I have another large db in Mysql. Would dropping this db help?

Thanks

unSpawn · 01-21-2007, 05:38 PM

Check Jeremy's blog or any articles he did. I vaguely remember reading some stuff about site optimisation. LQ ain't running this nice w/o some tweaking.