I am a programmer who is currently developing PHP software. I am very interested in developing database driven applications using MySQL PS that can scale to use the adjustable amount of RAM/CPU. I am currently working on data mining/information gathering programs that I think would work very well on this setup.
I would like to hear from people who have MySQL PS, how well does it perform for web applications? Is there a way to adjust the query cache and other server settings?