sidsel wrote:How many queries per seconds is roughly the limit before you would consider moving MySQL to a server for itself?
Currently I have about 16 per second but most are from querycache.
If MySql is on a server for itself is the traffic/results slower than if it is a combined web/mysql server?
i doesnt depends so much on the number of queries / s, but on the complexity of queries. for example a LEFT JOIN of four tables or query with some subselects is much more complicated than a standard select from one table.
if your db engine is getting slow, check up the queryplaner and see if you have correctly created indexes and tables are optimized.
