mysql Issue

[shahed]

Ok, I been running my site for 2 months with Oscommerce, its going good. but all of a sudden it slows down so much,
I think there is a issue with matrix mysql server, it slowing like hell.
take a look at this one:
http://bdbazar.com/nshop/product_inf...oducts_id/1126

See how header loads fast but rest of the page is really slow..that means mysql is slow. I soon have to look for alternative , so please advice me.

[admin]

Loaded right up with in Netscape for me it said it took 2.853 sec to load it here at my home.. Seems to be fine to me..


Note this is one min after your posted the problem as well.

[admin]

I also checked the load on the server to be sure nothing is wrong..

mysql.hsphere.cc 0.65, 0.60, 0.56 12 days, 5:22,
mysql1.hsphere.cc 0.00, 0.00, 0.00 1 day, 5:32,


Both look more then good to me.

[shahed]

check ur PM please

[vonbrocklin]

I just checked it out and did about 20 page loads, averaging between 9 and 10 seconds per page load. Seems awfully slow to me, not sure what the problem would be though.

[shahed]

I do not know how Admin get that faster load, all of my clients are saying its taking forever, mine with DSL is talking a lot of time, and today I didn't have order compare to 15/20 orders everyday.
I'm totally p****ed about it.. its holiday time , my pick time

[admin]

Can you put in a ticket for me.. Send it to support@vortechhosting.com ATTN:Mike and also put a link to this post..

Thanks

[Garreg]

Everything loaded up fine for me here in the UK - and I'm on a 56k connection (awe.... )

I did get the following when accessing the 'Featured' link (top right)

"Warning: Can't connect to MySQL server on 'mysql.sjhosting1.com' (61) in /hsphere/local/home/sjhost1/bdbazar.com/nshop/includes/functions/database.php on line 19

Warning: MySQL Connection Failed: Can't connect to MySQL server on 'mysql.sjhosting1.com' (61) in /hsphere/local/home/sjhost1/bdbazar.com/nshop/includes/functions/database.php on line 19
Unable to connect to database server!"

But there again I've also been getting a mysql error on a vBulletin site I operate error (61) - perhaps theres something a drift here.....

If that of any help ?

[vonbrocklin]

This seems to be getting worse. I just checked again and I am getting page loads of 42 -55 seconds according to Netscape. (Some pages are not even loading.) For the record I am on a high speed DSL connection in the midwestern U.S. Please keep us posted on what the issue is and how it was resolved. I have a proposal out for a large osCommerce site and am curious what is going wrong. I hope this gets solved for you. Gotta be extremely frustrating...

p.s. I was not getting the MySQL errors reported by Garreg.

[kpcreativos]

It looks go fast from Spain , with DSL connection. No MySQL errors reported.

[shahed]

I cant even go to the site today, static one works fine
http://bdbazar.com/catalog (Static old version)
but this one has mysql version
http://bdbazar.com/nshop

Mike it didn't help whatever u did

I am checking into this. The on you called static
Thats not pulling any information from mysql????

[shahed]

no static one do not have any mysql

[admin]

http://bdbazar.com/nshop/ loaded for me in 1.4 sec this time with no problems but hostnet may of changed something by now.

[shahed]

ok whatever admin is doing, its getting better now.. but not good enough though