I currently have a single dedicated server handling my web server and dedicated server for a small number of websites, however, I am running two sites that deal with fairly large databases (Large to me at least).
My server has 3 gigs of ram and is running Linux, Apache, MySQL and PHP. I occasionally get warnings from Plesk about my MySQL status being in the Red.
I really have no idea what is a high load or when I'll need a dedicated server for my databases. Looking at phpMyAdmin, I have the following stats:
Query statistics: Since its startup, 10,145,576 queries have been sent to the server (Server has been up 16 days)
7.15 queries per second, 430 per minute (I think)
Select query types have run 7,178 k.
Open_tables is 64 Opened_tables is 257.2 k
I'm just wondering at what point this will require another server, and how I can tell.