Take the 2-minute tour ×  I have a machine with 1 GB of RAM and
have set apache to use STARTSERVER OF 150, and MAXCLIENTS of
150, only half is used so I still have about 500 MB more of
spare RAM. I want MySQL to use this up as right now running AB
test shows that with a static image I get 6000req/sec and with
my CMS I am getting only 180req/sec which is a php script with
MySQL backend. I need to increase MySQL performance without
touching the SQL statements, just a a net admin rather than as a
programmer. Does MySQL have this option? 500MB of spare RAM, I
want to use that up.  share|improve this question  2 Answers 2
up vote 2 down vote accepted  If you are using MyISAM increase
If you are using InnoDB   Also there is usually my.cnf presets
in MySQL packages called my-huge.cnf, my-large.cnf, my-
medium.cnf and my-small.cnf you can search for them.  PS. You
should really google for some MySQL tuning examples for you
storage engine.  share|improve this answer Thank you. I get
6000req/sec on a static file, and