Site is ultra slow and is driving me crazy! (S O L V E D)

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1   Site is ultra slow and is driving me crazy! (S O L V E D)
rhinoz
CZ Newbie
rhinoz has been a member for over 19 year's 19 Year Member
Gender: Male
Status: Offline
Joined: Oct 24, 2005
0.00 posts per day
Posts: 16
Points: 651
   
Hello,

This is my first post as I don't normally have trouble.

I think my hosting provider is feeding me bull.
Up until last night my site was screaming fast along with the subdomains. Now its ultra slow, I'm talking 1-2 mins slow!
He says I should use mysql_connect instead of mysql_pconnect (which I think is a cop-out)
Its just like someone threw a brick wall up in the site and its just dog slow.

They say its leaving too many connections behind but its only mysel;f and my other admin who are using it.

Here's what he showed me (I've taken out the db name and username for obvious reasons)

| 32 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 39 | | |
| 33 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 38 | | |
| 35 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 38 | | |
| 36 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 38 | | |
| 38 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 38 | | |
| 39 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 38 | | |
| 40 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 37 | | |
| 41 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 37 | | |
| 42 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 37 | | |
| 43 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 37 | | |
| 44 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 37 | | |
| 45 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 37 | | |
| 46 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 36 | | |
| 47 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 36 | | |
| 48 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 36 | | |
| 49 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 36 | | |
| 51 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 36 | | |
| 53 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 35 | | |
| 54 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 35 | | |
| 55 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 35 | | |
| 56 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 35 | | |
| 57 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 35 | | |
| 58 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 34 | | |
| 59 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 34 | | |
| 60 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 34 | | |
| 61 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 34 | | |
| 62 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 34 | | |
| 63 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 33 | | |
| 64 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 33 | | |
| 65 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 33 | | |
| 66 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 33 | | |
| 68 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 33 | | |
| 69 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 32 | | |
| 70 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 32 | | |
| 71 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 32 | | |
| 72 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 32 | | |
| 73 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 32 | | |
| 74 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 31 | | |
| 75 | xxxxxxx_user1 | localhost | xxxxxxx_db1 | Sleep | 31 | | |

Hope someone can help with this as I know Codezwiz's staff and members are fanatstic at solving problems.

Thanks

RM

P.s, as I was writing this, I just got another message from the hosting company, it gets better!


===================
Hello,

On our servers each site can make only 25 connections to mysql, so as to avoid overloading of mysql.Please optimize your mysql queries so that it does not make persistent connections.

Please let us know if you have any further queries we will be glad to assist you.
===================

*falls off of chair in dispair*

RUNNING PHPNUKE 7.9



Back to top Reply with quote
#2   re: Site is ultra slow and is driving me crazy!
rhinoz
CZ Newbie
rhinoz has been a member for over 19 year's 19 Year Member
Gender: Male
Status: Offline
Joined: Oct 24, 2005
0.00 posts per day
Posts: 16
Points: 651
   
***** Update******

Backed up sql and all files and transferred it to another domain I have, an I'm STILL getting the same results!

Changed Config.php to match DB I created on other domain, same result.

This has really got me mad because I was going to launch the site live today icon_sad.gif



Back to top Reply with quote
#3   re: Site is ultra slow and is driving me crazy!
rhinoz
CZ Newbie
rhinoz has been a member for over 19 year's 19 Year Member
Gender: Male
Status: Offline
Joined: Oct 24, 2005
0.00 posts per day
Posts: 16
Points: 651
   
****** Update *******

The site does come up but its taking approx 90 seconds to load and thats about as fast as it gets. I'm thinking that there is a problem within the Database itself. What it is, I have no idea!

Should have given this earlier, this is the additional domain I'm testing it on:

http://www.kevmark.com/



Back to top Reply with quote
#4   
Staffie
CZ Revered Member
 Codezwiz Site Donator
uk.gif
Occupation: Investigation Officer
Age: 39
Gender: Male
Website:
Status: Offline
Joined: May 27, 2003
0.19 posts per day
Posts: 1454
Points: 401,085
   
possible that u r runnin to many sql queries, as i have no experience with nuke its the only thing i can say tbh. Maybe someone else will be able to tell you more.




_________________
Back to top Reply with quote
#5   re: Site is ultra slow and is driving me crazy!
rhinoz
CZ Newbie
rhinoz has been a member for over 19 year's 19 Year Member
Gender: Male
Status: Offline
Joined: Oct 24, 2005
0.00 posts per day
Posts: 16
Points: 651
   
I was kinda getting that feeling but what could do that seeing as no changes were made to the DB?

Its almost as if its searching for approval to appear on the website. I was asking one of the hosting support staff about ".htaccess" in case it was searching for permissions. That was like talking to a Dolphin on lessons on how to sky-dive, was pointless.



Back to top Reply with quote
#6   
Staffie
CZ Revered Member
 Codezwiz Site Donator
uk.gif
Occupation: Investigation Officer
Age: 39
Gender: Male
Website:
Status: Offline
Joined: May 27, 2003
0.19 posts per day
Posts: 1454
Points: 401,085
   
do you have any whos online module so you can see how many users are connected to your site? It may be possible that if it is usually just you and your freind who was on the site that goggle and the other search bots have found your site and are making the connection to the site slower.




_________________
Back to top Reply with quote
#7   re: Site is ultra slow and is driving me crazy!
rhinoz
CZ Newbie
rhinoz has been a member for over 19 year's 19 Year Member
Gender: Male
Status: Offline
Joined: Oct 24, 2005
0.00 posts per day
Posts: 16
Points: 651
   
I tried that and even the hosting admin said that the queries where coming from the site itself. I thought that it could be a search engine but seeing as its on the different test domain now and still doing the same thing, I have to eliminate that thought.

Who's online showed zero visitors and 2 registered (Myself and my other admin)

Here's the test domain again in case you missed it:

http://www.kevmark.com/



Back to top Reply with quote
#8   
Staffie
CZ Revered Member
 Codezwiz Site Donator
uk.gif
Occupation: Investigation Officer
Age: 39
Gender: Male
Website:
Status: Offline
Joined: May 27, 2003
0.19 posts per day
Posts: 1454
Points: 401,085
   
wow u aint rong, is the test domain and the main domain with the same hosting company?




_________________
Back to top Reply with quote
#9   re: Site is ultra slow and is driving me crazy!
rhinoz
CZ Newbie
rhinoz has been a member for over 19 year's 19 Year Member
Gender: Male
Status: Offline
Joined: Oct 24, 2005
0.00 posts per day
Posts: 16
Points: 651
   
Nope, different companies.

I also just installed a bare PHPnuke on the test domain too so you can compare the 2 of them

Problem Test Domain:
http://kevmark.com


New installed Test Domain:
http://kevmark.com/ffs/


You can imagine what "ffs" means !


Back to top Reply with quote
#10   
Greenhouse
CZ Newbie
Greenhouse has been a member for over 19 year's 19 Year Member
sweden.gif
Gender: Male
Status: Offline
Joined: Oct 29, 2005
0.00 posts per day
Posts: 2
Points: 39
   
Greetings, yo!
I'm the other admin mentioned. As i'm located in Sweden i cannot look at the DB directly, but hopefully i can assist in brainstorming this bugger.
Funny thing is that a few of the subdomains are still as fast as before, so they are not embraced in this temporary realm of tranquility. This detail might give an idea about where to look for the error.




_________________
^.^
Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum