I've recently had a site suspended on a shared server for MySQL using too many resources. Over the past two weeks I've worked on optimizing my queries - most use 1-2 tables (3 max) and are pretty basic; Almost all are selects, a few updates, and a rare insert. I've also gone over my database making sure all columns queried/joined against have indexes. Don't know what else I can do. FYI - I'm getting 10-13K uniques/day, ~100K page views, using pconnects. The admin emailed me a process list and MySQL had 43(!) processes open. Would there be any problems on a dedicated server?
Thanks!
Thanks!