RE: No working site highest mysql user on the server explanation needed.

[jonlarson]

I was trying to run a game script on my site.. I noticed that it was extremely slow, and was unsure why. Could it be this script? If it is I will delete it immediately. The script is called phpArcade

 

[garrettroyce]

I see no indication that your script uses a lot of disk I/O or SQL queries. The games are flash, which is a client side technology. The only queries are done for things like logins and high score updates, which are quite infrequent. So, I'm stumped why this would be happening. Perhaps one of the games is poorly designed?

You are more than welcome to delete your script and test it out for a few days to see if the problem is resolved. You can also speak to the software's authors and see if they have any suggestions to why this would be happening.

Please let me know how you would like to proceed.

 

[jonlarson]

It is very possible that a game is poorly designed. I will delete the script and test it on a local server of mine or something.

 

[garrettroyce]

Is there anything else on your account? The person who noticed this problem couldn't seem to find your site at all, so it is possible something else is on the account we didn't notice.

 

[jonlarson]

There was but I accidentally deleted it :| I was just about to re-upload the files when I noticed it was suspended.

 

[garrettroyce]

Ok, I see no reason why your account should be suspended. I'll check up on your site in a few minutes to confirm you have deleted the script. Before you upload this script again, you should probably post in this forum to notify staff you have had a problem in the past that you tried to resolve and they can advise you every step of the way. There are ways to benchmark MySQL, so you should be able to narrow things down, and as I mentioned speaking to the authors may yield some helpful feedback.

I'm looking over your account now. What is the purpose of irc.jonlarson.x10.bz?

 

[jonlarson]

It is just an A record that forwarded to my IP. I had to temporarily host an IRC server. It can actually be deleted now

---------- Post added at 01:36 AM ---------- Previous post was at 01:32 AM ----------

The script and database has been deleted.

 

[garrettroyce]

Nevermind, I re-read your post and I see that the IRC was not hosted on X10.

 

[jonlarson]

The IRC was not hosted on here though. It was hosted on my personal computer, and the A record just forwarded to it. Does that still bog it down or whatever?

 

[garrettroyce]

Sorry, I realized after I posted that I was mistaken. What you did was fine. Only the DNS is queried from X10's servers, after that, it's all your home server.

 

[jonlarson]

Ah, alright. That's what I thought. But I figured I could have been wrong. Thank's for all your help!

 

[garrettroyce]

No problem. Good luck with solving your problem. I believe we have resolved it here, but if you are suspended again, post a new thread and someone can escalate the issue to the attention of staff. My powers are very limited here, but you have been very cooperative and I think we have solved this problem for now.

 

[jonlarson]

Alright, I was a bit confused. Thank's for all your help.

---------- Post added at 02:07 AM ---------- Previous post was at 02:06 AM ----------

^ That was me not realizing there was a second page xD

But you're welcome for being cooperative and everything. Hopefully I can get this working.