What do you mean AsylumDemon? I hang out here when I can. Things got busy with my Japanese classes and all
lol
I mentioned it on the other boards too except my own.
Sidicas:I'd
expect CPU-bound SQL queries to be quite cheap these days.. The
page runs a query every time it refreshes right? Then maybe you could
try increasing the refresh time on the page? Because sometimes I just
leave it sitting in another tab
You don't have your own dedicated
computer for streaming the audio? Couldnt' you use that as the MySQL
server? Or does it have to be on the host? Could it be google bot /
webcrawlers that are hitting the links for request? I dunno, I've
never run an Internet Radio Station before, but SQL queries should be a
dime a million if you know what I mean..
I found
out what caused it thanks to reports and error logs. I added more
Sakura Wars songs, the category list updated and removed invalid
entries and rebuilt the entire database. This is a free mysql
host as well. I would have hosted it here since my connection is
still pretty fast but verizon blocks our ports and my friends server is
on VerizonFIOS as well so the ports are blocked for him. I
am going to be a little bit more flexible on the request now.
Since I found out what caused it. I will try to rebuild the
database on the localhost from now on, then upload the new tables via
phpmyadmin. To Answer some questions:
1. The page refreashes so that is a query, but its only one table.
2.
I Only have three computers. One I am on is my main rig and does
to much to do anything else, The other one under it is the dedicated
computer that runs SAM Broadcaster. That should not be running
anything but the radio station, the Third one is a MAC G3 that is
running other backup servers.
3. Google bots are off those pages luckilly. As far as I know they are. lol
4. Since my mysql queries are on a free host, I can't really complain. lol.