Slow like a granny...

Started by Zellenny, December 26, 2006, 09:21:35 AM

Previous topic - Next topic

c2h5oh

 Opened vs. Open tables:
(table_cache)    473042.3594 (should be <= 80) niiiiiice
"The day Microsoft makes something that does not suck is probably the day they start making vacuum cleaners"

Zellenny

Quote from: c2h5oh on January 06, 2007, 07:58:14 AM
Opened vs. Open tables:
(table_cache)    473042.3594 (should be <= 80) niiiiiice
I find that disturbing too :D

JayBachatero

1. Are you on a dedicated server or vps?
2. Can you chmod the /proc/loadavg, /proc/cpuinfo and /proc/meminfo to 555.  That way the otehr stats show in the status.php page.
3. How many posts/topics does your board have?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Zellenny

Quote from: JayBachatero on January 06, 2007, 02:25:42 PM
1. Are you on a dedicated server or vps?
2. Can you chmod the /proc/loadavg, /proc/cpuinfo and /proc/meminfo to 555.  That way the otehr stats show in the status.php page.
3. How many posts/topics does your board have?
1. No, its not a dedicated server

2. No, i dont have access to those files/folders

3. I have "6340 Posts in 648 Topics by 160 Members"

We will be transfering to other host next week, i will let you know what happends then ;)

青山 素子

Quote from: Zellenny on January 06, 2007, 11:32:24 AM
Quote from: c2h5oh on January 06, 2007, 07:58:14 AM
Opened vs. Open tables:
(table_cache)    473042.3594 (should be <= 80) niiiiiice
I find that disturbing too :D

That is one heavily-loaded SQL server. Certainly a very possible cause of slowness.
Motoko-chan
Director, Simple Machines

Note: Unless otherwise stated, my posts are not representative of any official position or opinion of Simple Machines.


JayBachatero

Quote from: Motoko-chan on January 07, 2007, 05:50:47 PM
Quote from: Zellenny on January 06, 2007, 11:32:24 AM
Quote from: c2h5oh on January 06, 2007, 07:58:14 AM
Opened vs. Open tables:
(table_cache)    473042.3594 (should be <= 80) niiiiiice
I find that disturbing too :D

That is one heavily-loaded SQL server. Certainly a very possible cause of slowness.
I agree with you Motoko.  I wonder what's the current load on this server.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Zellenny

*BUMP*

Hi again, we moved to another server, and its great, everything is working really fast!

http://www.ffcro.net/forum/index.php [nofollow] --> Page created in 0.2 seconds with 9 queries.

Thanks everyone!

Daniel15

Glad to see you solved the problem :)

Quote from: JayBachatero on January 06, 2007, 02:25:42 PM
2. Can you chmod the /proc/loadavg, /proc/cpuinfo and /proc/meminfo to 555.  That way the otehr stats show in the status.php page.
It's not CHMODding that's the problem, it's the fact that some hosts block the exec command (this is the command used by status.php to grab the data).

Daniel15, former Customisation team member, resigned due to lack of time. I still love everyone here :D.
Go to smfshop.com for SMFshop support, do NOT email or PM me!

JayBachatero

I guess that might be the problem here.  I had to chmod it on my site.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Daniel15

Quote from: JayBachatero on January 25, 2007, 11:45:27 PM
I guess that might be the problem here.  I had to chmod it on my site.
Yeah, some servers are stupid and have it chmodded to 0400 or similar... My server has it at 0444 ;)
Daniel15, former Customisation team member, resigned due to lack of time. I still love everyone here :D.
Go to smfshop.com for SMFshop support, do NOT email or PM me!

Advertisement: