Speeding up page load

We had several tech look at it, partially because we are down so many times, they say the programs is we are using to much resources manly memory to keep the sites up. It's my opinion I've upgraded memory on the move and again with the host. We never went down prior to the move with alot less memory. When I post a simple forum just one the site get sick , I know other esselback forums have 100's if not thousands of visitors at the same time. I wounder if my 3 mouth old site uses more resources than the very big one.

My simple goal is to fix the problem.

something also new when we post articles several words are changed basicly any ' turn in &&^%&*

Speeding up page load

sorry were down, all ten site they say 256k ram.

Speeding up page load

Sounds like you need a new/better hosting company.

Speeding up page load

I am not aware of any memory leaks that Storyteller causes. How much Ram has this machine?

Speeding up page load

Caleb : Have you checked any of your logs to see why the erver is stopping
Randy Durig : yes
Randy Durig : http://www.esselbach.com/thread.php?id=404&page=2 other think its you here is the link
Randy Durig : we have had many popole over a week try to solve this, is thier someone who will take the real time to fix a problem
Caleb : We show nothing wrong with the server
Caleb : have you verified your PHP code is not causing memory leaks
Randy Durig : then why are we down
Caleb : have you verified your PHP code is not causing memory leaks
Randy Durig : we don't know
Randy Durig : you told us to buy a higher level of service and that would stop the problem but now today this.
Randy Durig : hello
Caleb : Nov 14 11:22:01 durig xinetd[14929]: 14929 {mem_fault_handler} invalid permissions for mapped object
Nov 14 11:22:01 durig xinetd[14929]: 14929 {mem_fault_handler} Address of fault: 40116327
Nov 14 11:22:01 durig xinetd[14929]: 14929 {mem_fault_handler} invalid permissions for mapped object
Nov 14 11:22:01 durig xinetd[14929]: 14929 {mem_fault_handler} Address of fault: 40116327
Nov 14 11:22:01 durig xinetd[14929]: 14929 {mem_fault_handler} invalid permissions for mapped object
Nov 14 11:23:16 durig xinetd[15932]: execv( /usr/sbin/sendmail ) failed: Cannot allocate memory (errno = 12)

Caleb : [Sun Nov 13 18:38:25 2005] [error] (12)Cannot allocate memory: fork: Unable to fork new process
[Sun Nov 13 18:38:35 2005] [error] (12)Cannot allocate memory: fork: Unable to fork new process
[Mon Nov 14 02:25:57 2005] [error] (12)Cannot allocate memory: fork: Unable to fork new process

Randy Durig : help me what this mean
Caleb : I show server is up now
Caleb : but we had to restart it
Randy Durig : what is the problem why do we go down so often thanks for the restart
Caleb : Most likely a script or something else is causing the memory to spkie and then new processes cannot be forked

they claim
Vthe server hardware is fine as well as the OS

Speeding up page load

I worked with tech support many times trying everything that anybody suggest. The site was running fine for a few days then this morning complete failure all
10 sites were down.

Last night when i posted any new article every page on ret-ret we went off line the came back about a minute later to two latter.

I talked to the sever support many time and of course they think it's software.

Speeding up page load

Originally posted by randy:

The issues came up after we moved hosts

Then it is most likely a problem with the server itself. I assume some settings need to be optimized. If the server is completely freezing, it may be even a hardware problem.

The other possibility is that one of the modifications causes these performance problems.

Speeding up page load

I don't know if this helps but after the move I notice for the first time this, buy the way it's very cool, but when we were up for a couple hours I didn't notice that app was running.

Welcome back, carrie!
There are 1 new stories (1 on all websites) and 1 forum topics (1 on all websites) since your last visit. Click here to logout.

Speeding up page load

All nine sites went down again, we were up and running for about 2 hours. I loaded some articles in retirement-retirement.com and it brought down not only ret-ret but all 9 other sites.

The issues came up after we moved hosts are first host was very slow. The real probem seems after any little post either in the forum or a new article, the site gets sick.

Speeding up page load

we are back to life

Speeding up page load

I had them tech support weak the site and I also moved the hosting plan so it has more momorey. The home page does not seem to respond. the back pages seem to be working well.

Speeding up page load

Your Xeon server should handle alot more traffic without any problem. The largest Storyteller based website that I know is in the 20 million pageviews range.

When did you noticed the performance issues the first time? After your move or before?

Speeding up page load

about 7000 last month almost 5000 now it was really starting to grow

Speeding up page load

The server is located at a datacenter? If so, you may want to ask a support technican to take a look at the server configuration (my.cnf and httpd.conf) and tweak some settings?

How many pageviews/month is Retriement Retirement generating? You can see this information under Stats/View Stats.

Speeding up page load

sorry this posting is new to me

all 9 websites at the host have been down more than they been up this morning.

Speeding up page load

I suggest "file cache only" for Linux servers

Speeding up page load

I got the admin user switched to #1
I set the cache to "yes" and chose memory/file cache
is that the best option?

thanks for all your help

Speeding up page load

You could give her the password of the first admin account.

Maybe the best is you change the first account to a default admin account that all admins can share. You can edit this account under Users => Edit/Remove in the Storyteller control panel.

Speeding up page load

As the owner of the site can I give lalawren that first admin postion

Speeding up page load

Only the first admin can view this settings.

Speeding up page load

Well that's another issue
when i log in to Retriement Retirement with the admin username and password, I don't get the "Other" options to set those configs - Everything else shows up - templates, categories, etc.

Speeding up page load

That's odd . Please check the following setting in the Storyteller admin section under Other/Config:

- Using Cache
- Caching Method

Speeding up page load

Yes they are:
investment-investment.us
is an example

Speeding up page load

Are the other Storyteller websites also heavily modified?

Speeding up page load

I switched my.cnf to the my-medium.cnf.
that went fine
I then went to stop the SQL server and got an error
Also none of our database sites would load
I did a system reboot
Then I switched it back to the my-large.cnf
I still can't shut down and restart the MySQL server, but all our storyteller sites are loading except retirement-retirement

so I'm back where we started!

Speeding up page load

Philipp and Laura thanks you for all your help. This site is important to me so THANKS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!1111

Speeding up page load

Ok, let try the smaller configuration:

cp /usr/share/doc/mysql-server-3.23.58/my-medium.cnf /etc/my.cnf 

service mysqld restart

Is the speed now better or is there no difference at all?

Speeding up page load

Well. Retirement-retirement.com (the problem site) isn't loading at all Not sure what's up with that!
the other sites are running fine

Speeding up page load

Is the speed now better?

Speeding up page load

that worked fine - no errors
it seemed to take just fine:
[root@durig webadmin]# cat /etc/my.cnf
# Example mysql config file for large systems.
#
# This is for large system with memory = 512M where the system runs mainly
# MySQL.
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
#
# One can in this file use all long options that the program supports.
# If you want to know which options a program support, run the program
# with --help option.

# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = key_buffer=256M
set-variable = max_allowed_packet=1M
set-variable = table_cache=256
set-variable = sort_buffer=1M
set-variable = record_buffer=1M
set-variable = myisam_sort_buffer_size=64M
set-variable = thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=8
log-bin
server-id = 1

# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=64M
#set-variable = bdb_max_lock=100000

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /var/lib/mysql/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#set-variable = innodb_buffer_pool_size=256M
#set-variable = innodb_additional_mem_pool_size=20M
# Set .._log_file_size to 25 % of buffer pool size
#set-variable = innodb_log_file_size=64M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#set-variable = innodb_lock_wait_timeout=50

# Point the following paths to different dedicated disks
#tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[mysqlhotcopy]
interactive-timeout

Speeding up page load

A quick explanation:
my-large.cnf, my-huge.cnf, my-medium.cnf, my-small.cnf are MySQL reference example configurations that should work on any MySQL installation.

Now run the following as root:

mv /etc/my.cnf /etc/my.cnf-old

cp /usr/share/doc/mysql-server-3.23.58/my-large.cnf /etc/my.cnf

service mysqld restart

Any problems?

Speeding up page load

[root@durig webadmin]# locate my-
/usr/share/doc/mysql-server-3.23.58/my-large.cnf
/usr/share/doc/mysql-server-3.23.58/my-huge.cnf
/usr/share/doc/mysql-server-3.23.58/my-medium.cnf
/usr/share/doc/mysql-server-3.23.58/my-small.cnf
/usr/share/ssl/certs/make-dummy-cert

Speeding up page load

Did you used nano to edit the file?

Another idea. Run as root:

updatedb

and then post the output of

locate my-

Speeding up page load

I tried the new my.cnf file as posted above. I could stop mysql, but it would not restart. I moved the original my.cnf file back and mysql would restart.

Here's the error after trying the new my.cnf:

[root@durig etc]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]

Speeding up page load

again, should I get the same results as previously?

No, you should see the new configuration.

Here a step by step guide:

1) Switch to the root account

su -

and enter the root password. This step is necessary to allow you to edit system files.

2) Change to the /etc directory and move my.cnf to my.cnf-old

cd /etc

mv my.cnf my.cnf-old

3) Create a new my.cnf and edit it in the nano editor

nano /etc/my.cnf

then copy & paste the above configuration in the editor. Finally press ctrl+X and then Y (+return) to save the new file.

4) Restart the MySQL server. This is not related to the webserver.

Is this a managed server? In this case you should open a support ticket with the company that manages the server and ask a support technican to reconfigure the MySQL server for you.

Speeding up page load

I replaced the my.cnf file, then stopped and started the web server. When I run

cat /etc/my.cnf

again, should I get the same results as previously?

This is what I get now, after replacing my.cnf:
[webadmin@durig webadmin]$ cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Speeding up page load

Make a backup of my.cnf and replace it with:

[mysqld] 

datadir=/var/lib/mysql 

socket=/var/lib/mysql/mysql.sock 



#

# * Fine Tuning

#

max_connections = 500

key_buffer = 32M

myisam_sort_buffer_size = 64M

join_buffer_size = 1M

read_buffer_size = 1M

sort_buffer_size = 2M

table_cache = 1800

thread_cache_size = 384

wait_timeout = 900

connect_timeout = 10

tmp_table_size = 64M

max_allowed_packet = 64M

max_connect_errors = 10

read_rnd_buffer_size = 524288

bulk_insert_buffer_size = 8M

thread_concurrency = 4



#

# * Query Cache Configuration

#

query_cache_limit = 1M

query_cache_size = 64M

query_cache_type = 1

query_prealloc_size = 16384

query_alloc_block_size = 16384



[mysql.server] 

user=mysql 

basedir=/var/lib 



[safe_mysqld] 

err-log=/var/log/mysqld.log 

pid-file=/var/run/mysqld/mysqld.pid



[mysqld_safe] 

open_files_limit = 8192



[mysqldump]

quick

quote-names

max_allowed_packet      = 16M



[mysql]

#no-auto-rehash # faster start of mysql but no tab completition



[isamchk]

key_buffer              = 16M



[myisamchk] 

key_buffer = 64M 

sort_buffer = 64M

read_buffer = 16M

write_buffer = 16M

Then restart the MySQL server with: service mysql restart or service mysqld restart (this depends on the installed MySQL version).

Is the performance now better?

Speeding up page load

Sorry that was incomplete

[webadmin@durig retirement-retirement.com]$ cat /etc/my.cnf


[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Speeding up page load

yes the results are
[webadmin@durig retirement-retirement.com]$ cat /etc/my.cnf

Speeding up page load

Can you or someone that has root access to the server post the output of the following command:

cat /etc/my.cnf