Today my site has been linked to from a big site and the load on my db server has shot up to about 10 (doing top). I checked vmstat and free and it's not swapping. So how can I lower the load? Are there any quick fixes I can do to lower it? It's a dual xeon 2G ram, using MySQL 4x. The web server is P4 and is doing fine. Thanks.
