SMF Support > Server Performance and Configuration

SMF gets slower as time goes by

(1/6) > >>

Seta Soujiro:
I think there's something wrong with my php or Apache or MySQL configuration or something. 

When httpd and mysqld are started for the first time, for the first ten minutes or so SMF

runs really fast and the time displayed on the bottom of the screen is never above 1 second

to generate the page.  But then after about fifteen minutes or when more than one or two

people are online, it starts slowing down and goes from 1 second to generate the page, to

about 4 seconds, and then to 13 seconds, and finally about 27 seconds to generate each page.

The only solution that I've found is to restart both httpd and mysqld every fifteen minutes,

and change the priority of Apache to -19. But then nobody can use the website for about 20

or more seconds every fifteen minutes.  I'm using Red Hat Enterprise Linux 4.1.  The

internet connection is I think 1.5Mb/s.  I only have 32MB of memory though.  Does anyone

have any advise about how I should configure?

Ben_S:
32MB?

It's deffinatly going to be slow if thats the case.

[Unknown]:
Is MySQL configured for such a small amount of ram?  You should be using something similar to my-tiny.cnf.

-[Unknown]

Seta Soujiro:
I can't find my-tiny.cnf  Where can I get it?

Grudge:
I don't have a my-tiny - but here's the contents of a my-small:


--- Code: ---# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
#
# 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 /usr/local/mysql/var) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

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

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
net_buffer_length = 2K
thread_stack = 64K

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (using the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
server-id = 1

# Uncomment the following if you want to log updates
#log-bin

# Uncomment the following if you are NOT using BDB tables
#skip-bdb

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

[mysqldump]
quick
max_allowed_packet = 16M

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

[isamchk]
key_buffer = 8M
sort_buffer_size = 8M

[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout


--- End code ---

Navigation

[0] Message Index

[#] Next page