I'm running a Wordpress installation on an Amazon Ec2 micro instance(linux ami). Using the default configuration Apache kept using up all the memory and shutting down mysql rendering wordpress non-functional.
I adjusted my apache configuration based on information from Making WordPress Stable on EC2-Micro and changed the mysql configuration to the sample configuration for small servers.Those adjustments seem to have dealt with the memory issue.
However, I noticed that with mysqld service turned off cpu usage hovers around 0 -5% with 10% being a peak but as soon as I start mysql cpu time stays between 40 -60%. Is this normal? and what can I do to remedy it if it is not. Its just a test server so there's virtually no traffic to the site.I also checked with mysqladmin processlist and stat commands,there was no indication of any 'evil' queries.