Server lagt zur Zeit

Ok der Ping ist konstant niedrig. An der Anbindung scheint es nicht zu liegen, da ansonsten Schwankungen auftauchen würden.
Ich tippe auf Apache / MySQL Fehleinstellung poste doch auch deine /etc/my.cnf (oder wo sie bei dir liegt) bitte.

Die index.php ist sehr langsam, jedoch zeigt sie das Impressum (ohne Bilder) sehr schnell an. Zumal ich manchmal einen Apache Timeout bekomme.
 
Last edited by a moderator:
my.cnf:
Code: 
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# 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.
#
# 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          = /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
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

# 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
# (via the "enable-named-pipe" option) will render mysqld useless!
# 
skip-networking

# Replication Master Server (default)
# binary logging is required for replication
# log-bin

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id       = 1

# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
#    the syntax is:
#
#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
#    where you replace <host>, <user>, <password> by quoted strings and
#    <port> by the master's port number (3306 by default).
#
#    Example:
#
#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
#    MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
#    start replication for the first time (even unsuccessfully, for example
#    if you mistyped the password in master-password and the slave fails to
#    connect), the slave will create a master.info file, and any later
#    change in this file to the variables' values below will be ignored and
#    overridden by the content of the master.info file, unless you shutdown
#    the slave server, delete master.info and restart the slaver server.
#    For that reason, you may want to leave the lines below untouched
#    (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id       = 2
#
# The replication master for this slave - required
#master-host     =   <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user     =   <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password =   <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port     =  <port>
#
# binary logging - not required for slaves, but recommended
#log-bin

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

# Uncomment the following if you are using BDB tables
#bdb_cache_size = 4M
#bdb_max_lock = 10000

# 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
#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

# The safe_mysqld script
[safe_mysqld]
err-log=/var/lib/mysql/mysqld.log

[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 = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

In etc/apache2/ liegt bei mir keine apache2.conf
 
httpd.conf:
Code: 
#
# /etc/apache2/httpd.conf
#
# This is the main Apache server configuration file.  It contains the
# configuration directives that give the server its instructions.
# See <URL:http://httpd.apache.org/docs-2.0/> for detailed information about
# the directives.

# Based upon the default apache configuration file that ships with apache,
# which is based upon the NCSA server configuration files originally by Rob
# McCool. This file was knocked together by Peter Poeml <poeml+apache@suse.de>.

# If possible, avoid changes to this file. It does mainly contain Include
# statements and global settings that can/should be overridden in the
# configuration of your virtual hosts.


# Overview of include files, chronologically:
#
# httpd.conf
#  |
#  |-- uid.conf  . . . . . . . . . . . . . .  UserID/GroupID to run under
#  |-- server-tuning.conf  . . . . . . . . .  sizing of the server (how many processes to start, ...)
#  |-- sysconfig.d/loadmodule.conf . . . . .  [*] load these modules
#  |-- listen.conf . . . . . . . . . . . . .  IP adresses / ports to listen on
#  |-- mod_log_config.conf . . . . . . . . .  define logging formats
#  |-- sysconfig.d/global.conf . . . . . . .  [*] server-wide general settings
#  |-- mod_status.conf . . . . . . . . . . .  restrict access to mod_status (server monitoring)
#  |-- mod_info.conf . . . . . . . . . . . .  restrict access to mod_info
#  |-- mod_usertrack.conf  . . . . . . . . .  defaults for cookie-based user tracking
#  |-- mod_autoindex-defaults.conf . . . . .  defaults for displaying of server-generated directory listings
#  |-- mod_mime-defaults.conf  . . . . . . .  defaults for mod_mime configuration
#  |-- errors.conf . . . . . . . . . . . . .  customize error responses
#  |-- ssl-global.conf . . . . . . . . . . .  SSL conf that applies to default server _and all_ virtual hosts
#  |
#  |-- default-server.conf . . . . . . . . .  set up the default server that replies to non-virtual-host requests
#  |    |--mod_userdir.conf  . . . . . . . .  enable UserDir (if mod_userdir is loaded)
#  |    `--conf.d/apache2-manual?conf  . . .  add the docs ('?' = if installed)
#  |
#  |-- sysconfig.d/include.conf  . . . . . .  [*] your include files
#  |                                             (for each file to be included here, put its name
#  |                                              into APACHE_INCLUDE_* in /etc/sysconfig/apache2)
#  |
#       `-- *.conf . . . . . . . . . . . . .     (*.conf is automatically included)
#
#
# Files marked [*] are created from sysconfig upon server restart: instead of
# these files, you edit /etc/sysconfig/apache2



#  Filesystem layout:
#
# /etc/apache2/
#  |-- conf.d/
#  |   |-- apache2-manual.conf . . . . . . .  conf that comes with apache2-doc
#  |   |-- mod_php4.conf . . . . . . . . . .  (example) conf that comes with apache2-mod_php4
#  |   `-- ... . . . . . . . . . . . . . . .  other configuration added by packages
#  |-- default-server.conf
#  |-- errors.conf
#  |-- httpd.conf  . . . . . . . . . . . . .  top level configuration file
#  |-- listen.conf
#  |-- magic
#  |-- mime.types -> ../mime.types
#  |-- mod_autoindex-defaults.conf
#  |-- mod_info.conf
#  |-- mod_log_config.conf
#  |-- mod_mime-defaults.conf
#  |-- mod_perl-startup.pl
#  |-- mod_status.conf
#  |-- mod_userdir.conf
#  |-- mod_usertrack.conf
#  |-- server-tuning.conf
#  |-- ssl-global.conf
#  |-- ssl.crl/  . . . . . . . . . . . . . .  PEM-encoded X.509 Certificate Revocation Lists (CRL)
#  |-- ssl.crt/  . . . . . . . . . . . . . .  PEM-encoded X.509 Certificates
#  |-- ssl.csr/  . . . . . . . . . . . . . .  PEM-encoded X.509 Certificate Signing Requests
#  |-- ssl.key/  . . . . . . . . . . . . . .  PEM-encoded RSA Private Keys
#  |-- ssl.prm/  . . . . . . . . . . . . . .  public DSA Parameter Files
#  |-- sysconfig.d/  . . . . . . . . . . . .  files that are created from /etc/sysconfig/apache2
#  |   |-- global.conf
#  |   |-- include.conf
#  |   `-- loadmodule.conf
#  |-- uid.conf
#  `-- vhosts.d/ . . . . . . . . . . . . . .  put your virtual host configuration (*.conf) here
#      |-- vhost-ssl.template
#      `-- vhost.template



### Global Environment ######################################################
#
# The directives in this section affect the overall operation of Apache,
# such as the number of concurrent requests.

# run under this user/group id
Include /etc/apache2/uid.conf

# - how many server processes to start (server pool regulation)
# - usage of KeepAlive
Include /etc/apache2/server-tuning.conf

# ErrorLog: The location of the error log file.
# If you do not specify an ErrorLog directive within a <VirtualHost>
# container, error messages relating to that virtual host will be
# logged here.  If you *do* define an error logfile for a <VirtualHost>
# container, that host's errors will be logged there and not here.
ErrorLog /var/log/apache2/error_log

# generated from APACHE_MODULES in /etc/sysconfig/apache2
Include /etc/apache2/sysconfig.d/loadmodule.conf

# IP addresses / ports to listen on
Include /etc/apache2/listen.conf

# predefined logging formats
Include /etc/apache2/mod_log_config.conf

# generated from global settings in /etc/sysconfig/apache2
Include /etc/apache2/sysconfig.d/global.conf

# optional mod_status, mod_info
Include /etc/apache2/mod_status.conf
Include /etc/apache2/mod_info.conf

# optional cookie-based user tracking
# read the documentation before using it!!
Include /etc/apache2/mod_usertrack.conf

# configuration of server-generated directory listings
Include /etc/apache2/mod_autoindex-defaults.conf

# associate MIME types with filename extensions
TypesConfig /etc/apache2/mime.types
DefaultType text/plain
Include /etc/apache2/mod_mime-defaults.conf

# set up (customizable) error responses
Include /etc/apache2/errors.conf

# global (server-wide) SSL configuration, that is not specific to
# any virtual host
Include /etc/apache2/ssl-global.conf

# forbid access to the entire filesystem by default
<Directory />
    Options None
    AllowOverride None
    Order deny,allow
    Deny from all
</Directory>

# use .htaccess files for overriding,
AccessFileName .htaccess
# and never show them
<Files ~ "^\.ht">
    Order allow,deny
    Deny from all
</Files>

# List of resources to look for when the client requests a directory
DirectoryIndex at_domains_index.html index.html index.html.var index.shtml index.cfm index.htm index.php
### 'Main' server configuration #############################################
#
# The directives in this section set up the values used by the 'main'
# server, which responds to any requests that aren't handled by a
# <VirtualHost> definition.  These values also provide defaults for
# any <VirtualHost> containers you may define later in the file.
#
# All of these directives may appear inside <VirtualHost> containers,
# in which case these default settings will be overridden for the
# virtual host being defined.
#
Include /etc/apache2/default-server.conf


# Another way to include your own files
#
# The file below is generated from /etc/sysconfig/apache2,
# include arbitrary files as named in APACHE_CONF_INCLUDE_FILES and
# APACHE_CONF_INCLUDE_DIRS
Include /etc/apache2/sysconfig.d/include.conf


### Virtual server configuration ############################################
#
# VirtualHost: If you want to maintain multiple domains/hostnames on your
# machine you can setup VirtualHost containers for them. Most configurations
# use only name-based virtual hosts so the server doesn't need to worry about
# IP addresses. This is indicated by the asterisks in the directives below.
#
# Please see the documentation at
# <URL:http://httpd.apache.org/docs-2.0/vhosts/>
# for further details before you try to setup virtual hosts.
#
# You may use the command line option '-S' to verify your virtual host
# configuration.
#
Include /etc/apache2/vhosts.d/*.conf


# Note: instead of adding your own configuration here, consider
#       adding it in your own file (/etc/apache2/httpd.conf.local)
#       putting its name into APACHE_CONF_INCLUDE_FILES in
#       /etc/sysconfig/apache2 -- this will make system updates
#       easier :)
AddOutputFilter INCLUDES .shtml
AddType text/html .shtml

Include /etc/apache2/httpd.include

Ein bekannter sagte mir ich solle eventuell die Prozesse
höher setzen bei dem Besucheransturm.

Wäre dies eine Möglichkeit?
Und wie mache ich das?
 
Last edited by a moderator:
Hallo,

Code: 
# - how many server processes to start (server pool regulation)
# - usage of KeepAlive
Include /etc/apache2/server-tuning.conf

Dort kannst du solche Angaben tätigen.
Also in der Datei : /etc/apache2/server-tuning.conf
 
Poste sie mal (/etc/apache2/server-tuning.conf) dann kann man dir sagen welche Werte optimal sind.
Dein Hardware ist ein AMD 3000+, 1GB RAM wenn ich richtig liege?
 
Du liegst richtig!
Hier die server-tuning.conf:
Code: 
##
## Server-Pool Size Regulation (MPM specific)
##

# the MPM (multiprocessing module) is not a dynamically loadable module in the
# sense of other modules. It is a compile time decision which one is used. We
# provide different apache2 MPM packages, containing different httpd2 binaries
# compiled with the available MPMs. See APACHE_MPM in /etc/sysconfig/apache2.

# prefork MPM
<IfModule prefork.c>
        # number of server processes to start
        StartServers         5
        # minimum number of server processes which are kept spare
        MinSpareServers      5
        # maximum number of server processes which are kept spare
        MaxSpareServers     10
        # highest possible MaxClients setting for the lifetime of the Apache process.
        ServerLimit        150
        # maximum number of server processes allowed to start
        MaxClients         150
        # maximum number of requests a server process serves
        MaxRequestsPerChild  0
</IfModule>

# worker MPM
<IfModule worker.c>
        # initial number of server processes to start
        StartServers         2
        # minimum number of worker threads which are kept spare
        MinSpareThreads     25
        # maximum number of worker threads which are kept spare
        MaxSpareThreads     75
        # maximum number of simultaneous client connections
        MaxClients         150
        # constant number of worker threads in each server process
        ThreadsPerChild     25
        # maximum number of requests a server process serves
        MaxRequestsPerChild  0
</IfModule>

# leader MPM
<IfModule leader.c>
        # initial number of server processes to start
        StartServers         2
        # minimum number of worker threads which are kept spare
        MinSpareThreads     25
        # maximum number of worker threads which are kept spare
        MaxSpareThreads     75
        # maximum number of simultaneous client connections
        MaxClients         150
        # constant number of worker threads in each server process
        ThreadsPerChild     25
        # maximum number of requests a server process serves
        MaxRequestsPerChild  0
</IfModule>

# perchild MPM
<IfModule perchild.c>
        # constant number of server processes
        NumServers           5
        # initial number of worker threads in each server process
        StartThreads         5
        # minimum number of worker threads which are kept spare
        MinSpareThreads      5
        # maximum number of worker threads which are kept spare
        MaxSpareThreads     10
        # maximum number of worker threads in each server process
        MaxThreadsPerChild  20
        # maximum number of connections per server process
        MaxRequestsPerChild  0

        AcceptMutex fcntl
</IfModule>

# metux MPM
<IfModule metuxmpm.c>
        # initial number of worker threads in each server process
        StartThreads          5
        # minimum number of worker threads which are kept spare
        MinSpareThreads       5
        # maximum number of worker threads which are kept spare
        MaxSpareThreads      10
        # maximum number of connections per server process
        MaxRequestsPerChild   0

        Multiplexer     "wwwrun"        "www"

</IfModule>


#
# KeepAlive: Whether or not to allow persistent connections (more than
# one request per connection). Set to "Off" to deactivate.
#
KeepAlive On

#
# MaxKeepAliveRequests: The maximum number of requests to allow
# during a persistent connection. Set to 0 to allow an unlimited amount.
# We recommend you leave this number high, for maximum performance.
#
MaxKeepAliveRequests 100

#
# KeepAliveTimeout: Number of seconds to wait for the next request from the
# same client on the same connection.
#
KeepAliveTimeout 15

#
# EnableMMAP: Control whether memory-mapping is used to deliver
# files (assuming that the underlying OS supports it).
# The default is on; turn this off if you serve from NFS-mounted
# filesystems.  On some systems, turning it off (regardless of
# filesystem) can improve performance; for details, please see
# http://httpd.apache.org/docs-2.0/mod/core.html#enablemmap
#
#EnableMMAP off

#
# EnableSendfile: Control whether the sendfile kernel support is
# used  to deliver files (assuming that the OS supports it).
# The default is on; turn this off if you serve from NFS-mounted
# filesystems.  Please see
# http://httpd.apache.org/docs-2.0/mod/core.html#enablesendfile
#
#EnableSendfile off


#
# The following directives modify normal HTTP response behavior to
# handle known problems with browser implementations.
#
BrowserMatch "Mozilla/2" nokeepalive
BrowserMatch "MSIE 4\.0b2;" nokeepalive downgrade-1.0 force-response-1.0
BrowserMatch "RealPlayer 4\.0" force-response-1.0
BrowserMatch "Java/1\.0" force-response-1.0
BrowserMatch "JDK/1\.0" force-response-1.0

#
# The following directive disables redirects on non-GET requests for
# a directory that does not include the trailing slash.  This fixes a
# problem with Microsoft WebFolders which does not appropriately handle
# redirects for folders with DAV methods.
# Same deal with Apple's DAV filesystem and Gnome VFS support for DAV.
#
BrowserMatch "Microsoft Data Access Internet Publishing Provider" redirect-carefully
BrowserMatch "^WebDrive" redirect-carefully
BrowserMatch "^WebDAVFS/1.[012]" redirect-carefully
BrowserMatch "^gnome-vfs" redirect-carefully

Wie bereits erwähnt sind derzeit Sehr viele User
gleichzeitig online (z.Z. über 600).
Seitenaufbau dauert lange kommt dann aber
meist sehr schnell.
FTP & CO sind sehr schnell!
 
Ok.

Änderungen in der /etc/apache2/server-tuning.conf:

Code: 
# prefork MPM
<IfModule prefork.c>
        # number of server processes to start
        StartServers         10
        # minimum number of server processes which are kept spare
        MinSpareServers      50
        # maximum number of server processes which are kept spare
        MaxSpareServers     100
        # highest possible MaxClients setting for the lifetime of the Apache process.
        ServerLimit        300
        # maximum number of server processes allowed to start
        MaxClients         300
        # maximum number of requests a server process serves
        MaxRequestsPerChild  10000
</IfModule>

Änderungen in der /etc/my.cnf:

(Bei den eckigen Klammern suchen und darunter einfügen, oder vorhandene Werte abändern)

Code: 
[mysqld]
set-variable = max_connections=1000

key_buffer=64M
table_cache=256
sort_buffer=4M

Danach Apache/MySQL neustarten.
Sollte danach deutlich besser laufen.

MfG, h00ch
 
Bei Debian:

- apache2ctl restart
- /etc/init.d/mysqld restart

Bei Unsicherheit einfach

- cd /etc/init.d/
- ls

und dann gucken :D

Und mach mal einen neuen ApacheBench und zeig mal :D
 
Ich finde dort keine mysqld nur mysql!
Hier die Übersicht:
Code: 
.                    boot.clock          boot.localnet             cron         nfs               rc0.d           slpd
..                   boot.coldplug       boot.md                   earlykbd     nfsboot           rc1.d           spamd
.depend.boot         boot.crypto         boot.proc                 earlysyslog  nscd              rc2.d           sshd
.depend.start        boot.d              boot.quota                fbset        openct            rc3.d           syslog
.depend.stop         boot.device-mapper  boot.restore_permissions  gpm          pcscd             rc4.d           tdm2
Makefile             boot.evms           boot.rootfsck             halt         powerfail         rc5.d           xdm
README               boot.idedma         boot.sched                halt.local   powersaved        rc6.d           xinetd
SuSEfirewall2_init   boot.ipconfig       boot.scpm                 hwscan       psa               rcS.d           xntpd
SuSEfirewall2_setup  boot.isapnp         boot.scsidev              kbd          psa-spamassassin  reboot
apache2              boot.klog           boot.shm                  mailman      qmail             resmgr
atd                  boot.ldconfig       boot.swap                 mdadmd       quotad            rpasswdd
autoyast             boot.loadmodules    boot.sysctl               mysql        random            rpmconfigcheck
boot                 boot.local          boot.udev                 named        raw               single
boot.cleanup         boot.localfs        courier-imap              network      rc                skeleton
 
Nimm mysql ;)
also /etc/init.d/mysql restart.

Dann mach einen "ab" und poste mal. Würd mich freuen wenns geht.
 
Nächstes Problem:

/etc/init.d # mysql restart
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
 
Schnell behoben ;)

du versuchst gerade mit dem Clienten auf den Server "restart" zu connecten. Das geht natürlich nicht. ;)
Du willst ja den Server restarten deswegen einfach eingeben:

Code: 
/etc/init.d/mysql restart

Solltest du wie eben in /etc/init.d schon sein, dann musst du ein "./mysql restart" ausführen.
Ohne die Angabe "./", welche auf das aktuelle Verzeichnis deutet, sucht Linux die ausführbare Datei in deiner PATH Angabe (/bin,/sbin...usw).
 
Ok nun kommt das hier:
Code: 
/etc/init.d # ./mysql restart
Restarting service MySQL
./mysql: line 238: ./mysql: No such file or directory
./mysql: line 239: ./mysql: No such file or directory

Ach ja die Zeile war nicht da:
sort_buffer = 4M

Stattdessen die hier:
sort_buffer_size = 4M

Ist das gleiche denke ich.

Hier nun der neue ab2:
Code: 
p15201960:/etc # ab2 -n 10 -c 10 http://www.partybabe.net/index.php
This is ApacheBench, Version 2.0.41-dev <$Revision: 1.121.2.12 $> apache-2.0
Copyright (c) 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Copyright (c) 1998-2002 The Apache Software Foundation, http://www.apache.org/

Benchmarking www.partybabe.net (be patient).....done


Server Software:        Apache/2.0.53
Server Hostname:        www.partybabe.net
Server Port:            80

Document Path:          /index.php
Document Length:        12581 bytes

Concurrency Level:      10
Time taken for tests:   0.123300 seconds
Complete requests:      10
Failed requests:        0
Write errors:           0
Total transferred:      127430 bytes
HTML transferred:       125810 bytes
Requests per second:    81.10 [#/sec] (mean)
Time per request:       123.300 [ms] (mean)
Time per request:       12.330 [ms] (mean, across all concurrent requests)
Transfer rate:          1005.68 [Kbytes/sec] received

Connection Times (ms)
              min  mean[+/-sd] median   max
Connect:        0    0   0.0      0       0
Processing:    56   91  23.3     96     122
Waiting:       53   87  24.5     85     122
Total:         56   91  23.3     96     122

Percentage of the requests served within a certain time (ms)
  50%     96
  66%    100
  75%    113
  80%    121
  90%    122
  95%    122
  98%    122
  99%    122
 100%    122 (longest request)
 
Last edited by a moderator:
Also bislang sieht es doch super aus.
Lass es laufen und beobachte es.

Sollte es wider Erwarten Probleme geben, poste es einfach.
 
Ein riesen Dankeschön für deine Hilfe.
Könntest du eventuell mal die Änderungen erläutern,
damit ich daraus auch bisschen lerne?
Weil nur einfach nach Anweisung machen
bringt auf Dauer auch nichts :)
 
OK.

Als erstes ist immer wichtig zu gucken worans liegen könnte. Wenn also Ping und die sonstigen Dienste problemlos klappen kann man sich auf den problemmachenden Dienst beschränken.

In diesem Fall Apache. Apache arbeitet mit MySQL Hand in Hand also muss man beide bei Performance Problemen beobachten.
Am besten ist zur Fehleranalyse des Webservers der ApacheBench. Er tut nämlich genau das, was ein User mit seinem Browser macht.

In deinem Fall war das Problem schnell zu lokalisieren:
Code: 
Time per request:       48891.277 [ms] (mean)

Der Apache war überlastet und die Requests wurden in eine Warteschlange gestellt. Also musstest du die MaxClients erhöhen.
Damit der Apache die alle bewältigen kann sollte man auch die Anzahl der Apache Prozesse optimieren.

Zu MySQL:

MySQL erlaubt standardmässig nur 100 gleichzeitige Verbindungen, was bei 300 Clients zuwenig wäre. Also erhöht man max_connections.
Die restlichen Einstellungen sind kleine Performanceoptimierungen, die Erfahrungswerte sind und von der Arbeitsspeichergröße abhängig sind.

Im Internet gibt es viele HowTos, jedoch solltest du nicht das erste gleich nehmen. Viele Leute haben unterschiedliche Meinungen, abhängig von Versionen/Hardwareausstattung/Belastung.

Ich empfehle zum rantasten:

- SSF (Erfahrungswerte anderer User)
- http://h07.org/projects/apachetuning/
- http://httpd.apache.org/docs/2.0/mod/prefork.html

Nicht zuviel am Anfang und frage lieber einmal nach bevor du eine Änderung machst. Wichtig: IMMER in der Apache Dokumentation gucken, welchen Wert du änderst und was er bewirkt!

MfG, h00ch
 
ist es normal oder besser gesagt ok, dass ich bei meinem Strato Power Server auf einem mittelgroßen Simpleboard mit gerade 20 online Usern bei einem ab2 -n 100 -c 10 eine Time per request von 200 ms (Transfer rate 90 KB/s ) bekomme oder sollte ich da auch noch versuchen apache-tuning und mysql zu optimieren?
 
Last edited by a moderator:
You must log in or register to reply here.
Back
Top