Performance Tuning MySQL & PHP

[dfex]

Does anyone know how to tune MySQL for speed? I think I read somewhere that if you are accessing the database from the local system you could get MySQL to use sockets instead of TCP/IP and that it would speed up the performance.

I also want to install some PHP caching software but I don't know which one works best

Thanks for your time,

John

[Amit]

For PHP Cache and Cachers .... check out
PHP Caches and Debuggers

[prequel]

check out

http://i4net.tv/marticle/get.php?act...le&articleid=3

http://www.mysql.com/doc/O/p/Optimizing_the_Server.html

http://www.mysql.com/doc/M/y/MySQL_Optimization.html

http://www.mysql.com/doc/L/i/Linux.html