Site loading Slow and Intermittently

Started by slackerpunk, November 22, 2007, 10:19:21 PM

Previous topic - Next topic

青山 素子

Quote from: slackerpunk on January 06, 2008, 10:01:07 PM
Is there anyway to embed google ads instead of using ads management

Edit index.template.php for the theme and put the code in there.
Motoko-chan
Director, Simple Machines

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


slackerpunk

Quote from: Motoko-chan on January 06, 2008, 10:45:09 PM
Quote from: slackerpunk on January 06, 2008, 10:01:07 PM
Is there anyway to embed google ads instead of using ads management

Edit index.template.php for the theme and put the code in there.
not really well versed with php i know there are tags you can use can you point me to the right direction? thanks

metallica48423

any luck?

theres a post in tips and tricks about how to manually integrate adsense with a forum :)
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

slackerpunk

Quote from: BlackMage on January 12, 2008, 11:07:35 PM
any luck?

theres a post in tips and tricks about how to manually integrate adsense with a forum :)

I am going to try that

slackerpunk

Quote from: BlackMage on December 24, 2007, 12:31:18 AM
any luck?

Is it possible whatever control panel software is running is doing its log calculation or log rotation around these times? these processes eat a LOT of clock and memory and can cause significant slowdowns...

I suspect an oversold box as well

@BM

I was going to ask you about this I was thinking about this also..any idea how I can check on this?

GazOutEast

Re the slowdowns - a few days ago I had a heads up from my host that my site was using 98% of CPU and 100% of available memory, and even got the account suspended to make me do something about it.

Turns out it was because of using fake cron jobs with the Feedposter extension - soon as I disabled that, CPU & memory usage went back down to normal, and as an added bonus, page load dropped from average 45 queries taking 10-12 seconds down to a dozen queries taking under 1 second - the forum is lightening fast now.

Gaz
I have 20:20 vision - I can see anything bigger than 20" x 20"

青山 素子

Doing the whole "fake cron job" thing is almost always a bad idea. Most hosts let you manage real cron jobs, and you should do things that way if at all possible. If you can't find the interface, ask your host.

Glad you sorted it out.
Motoko-chan
Director, Simple Machines

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


GamingEvo.com

Quote from: jerm on November 22, 2007, 11:28:49 PM
Who's your host? I really don't want to play the blame game with your host.. but if it just random goes slow, then it is your hosts fault. If you are paying 3$ a month for 100gigs of bandwidth, then your host is just overselling and probably don't know what they are doing. They will always blame SMF for any "slow downs" because they don't know how to properly set up their servers.

I get the EXACT same thing, I'm a dedicated server and it's extremely fast however it does slow down with about 100+ users online at once.

青山 素子

GamingEvo, read over the stickies in this board, and make a new post if the tips don't improve your situation.
Motoko-chan
Director, Simple Machines

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


GamingEvo.com

Quote from: GazOutEast on January 17, 2008, 10:00:14 AM
Re the slowdowns - a few days ago I had a heads up from my host that my site was using 98% of CPU and 100% of available memory, and even got the account suspended to make me do something about it.

Turns out it was because of using fake cron jobs with the Feedposter extension - soon as I disabled that, CPU & memory usage went back down to normal, and as an added bonus, page load dropped from average 45 queries taking 10-12 seconds down to a dozen queries taking under 1 second - the forum is lightening fast now.

Gaz

Sorry I never read this..... I don't have any fake cron jobs, or cron jobs at all and it does the same thing. I fixed the issue with a new server but I just though like throwing it out there. I have my own topic too :P

Sarge

Disable hostname lookups from SMF Admin > Features and Options > Layout and Options tab. Hostname lookups caused thousands of zombie processes in my old server, as well as slowly degraded performance.

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

slackerpunk

Quote from: GazOutEast on January 17, 2008, 10:00:14 AM
Re the slowdowns - a few days ago I had a heads up from my host that my site was using 98% of CPU and 100% of available memory, and even got the account suspended to make me do something about it.

Turns out it was because of using fake cron jobs with the Feedposter extension - soon as I disabled that, CPU & memory usage went back down to normal, and as an added bonus, page load dropped from average 45 queries taking 10-12 seconds down to a dozen queries taking under 1 second - the forum is lightening fast now.

Gaz

if you are talking about the feed poster mod yeah it kinda eats up mem and cpu i've tried using that before but caused some issues so I had to remove it but it would be cool to have a mod like that...

anyway my datacenter went down last week and after the site went back up it loads faster now + I removed the karma description mod and the site has been working fine and fast up to now that is about 6 days.. will continue to monitor

slackerpunk

I am back.. well after about a month of good website functionality the problem came back haunting me...

Anyone who can recommend a my.cnf config file? its the only thing I haven't played with

Sarge

Quote from: slackerpunk on February 03, 2008, 11:19:01 PM
Anyone who can recommend a my.cnf config file? its the only thing I haven't played with

Do you have root access to the server via the shell? AFAIK, my.cnf is only editable by root (or whichever user had installed MySQL). If you cannot access my.cnf directly, ask your host if they would do these changes for you:
http://www.simplemachines.org/community/index.php?topic=214356.msg1407717#msg1407717

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

slackerpunk

Quote from: Sarge on February 04, 2008, 02:15:37 AM
Quote from: slackerpunk on February 03, 2008, 11:19:01 PM
Anyone who can recommend a my.cnf config file? its the only thing I haven't played with

Do you have root access to the server via the shell? AFAIK, my.cnf is only editable by root (or whichever user had installed MySQL). If you cannot access my.cnf directly, ask your host if they would do these changes for you:
http://www.simplemachines.org/community/index.php?topic=214356.msg1407717#msg1407717

I have root access on my vps.. thanks let me read that thread

Sarge

Make sure to adapt the MySQL settings according to your VPS configuration, particularly RAM and CPU usage and maximum usage allowed.

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

slackerpunk

yups that was why I was asking for suggestions by the way I posted a question on the thread you directed me to

Sarge

Quote from: slackerpunk on February 04, 2008, 04:24:32 AM
yups that was why I was asking for suggestions by the way I posted a question on the thread you directed me to

I replied, but please don't hijack other people's topics -- it makes support slower, more confusing and less efficient...

So please let's keep tackling your own situation in this topic (started by you), shall we? ;)

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

Sarge

Oh, and you should update Apache, MySQL and PHP to the latest versions (2.2.8, 5.0.51 and 5.2.5 respectively). The MySQL package version available for the operating system on your server might be a bit lower than 5.0.51, though.

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

slackerpunk

@Sarge

Sorry about that.. anyway

PHP Version 5.1.6
Apache/2.2.3 (CentOS)
Mysql 5.0.22

I might start with that..

also here is a copy of the post I made on the other thread (apologize for that)

Quote
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

skip-bdb

set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
#log-error=/var/log/mysqld.log
#pid-file=/var/run/mysqld/mysqld.pid
#skip-bdb

set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2

thread_cache_size = 256
table_cache = 1024
max_connections = 1000
max_user_connections = 1500
long_query_time = 5
query_cache_size = 64
max_heap_table_size - 32
tmp_table_size = 64
concurrent_insert = 2

Some Notes
Operating System:     Linux 2.6.9-023stab044.11-entnosplit
Processor:    Intel® Xeon® CPU E5310 @ 1.60GHz (400.081MHz)
Memory: 384MB Guaranteed 1024 Burst
Bandwidth: 450GB/month

Status Php File
-Usually around 100-150 users during peak hours
-I have APC installed Level 1 caching
-Mods
Ad management
Tinyportal
bookmarks
who voted what
youtube bbcode
signature settings mod

I will try and post mysqlreports probably tomorrow and tunning.sh

Advertisement: