Originally posted by ashley75

thanks again for all of the advise, but the database is not running as fast as I expect and the performance get worst if someone update something in the database. Below is the memory stats I got this morning:
Ah, now we come to the real problem. The database is slow, how do I tune it?

Find out where your bottlenecks are. Look at your disks, are they at 100%. What does your CPU say? What does vmstat say? Are only some queries slow? Which ones?