MySQL anscheidend überlastet???

A

Aquafresh

Registered User
Hallo liebe Server Support Gemeinde,

als ich vorhin auf meine Webseite ging, traute ich meinen Augen nicht, plötzlich stand:

Code: 
Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/vhosts/habbonet.de/httpdocs/config.php on line 13
Datenbankfehler: Verbinden zur Datenbank fehlgeschlagen.

Bei Plesk ebenfalls das:

Code: 
ERROR: PleskFatalException
Unable to connect to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

0: /usr/local/psa/admin/plib/common_func.php3:151
	psaerror(string 'Unable to connect to database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)')
1: /usr/local/psa/admin/auto_prepend/auth.php3:90

Nachdem ich einen reboot erstellt hatte, und der Server wieder da war, ging alles wieder problemlos, nur ich versteh nicht, wie das zustande kommen kann, letztens war dieses Problem auch, nach reboot aber wieder ok.

Ich vermute, dass da etwas überlastet ist, kann aber keine Anzeichen erkennen.

beancounters:

Code: 
vs162054:~ # cat /proc/user_beancounters
Version: 2.5                                                                    
       uid  resource                     held              maxheld              barrier                limit              failcnt
    162054: kmemsize                  5128710             17777653             17777274             19555001             23049805
            lockedpages                     0                    8                  868                  868                    0
            privvmpages                 47218               129412               327680               344064                    0
            shmpages                     6466                 7122                25078                25078                    0
            dummy                           0                    0                    0                    0                    0
            numproc                        49                  156                  434                  434                    0
            physpages                   21695                60101                    0  9223372036854775807                    0
            vmguarpages                     0                    0               131072  9223372036854775807                    0
            oomguarpages                21695                60224               163840  9223372036854775807                    0
            numtcpsock                     22                  139                  434                  434                    0
            numflock                        6                   12                  694                  763                    0
            numpty                          2                    2                   43                   43                    0
            numsiginfo                      0                   36                 1024                 1024                    0
            tcpsndbuf                  241112               974216              4148094              5925758                    0
            tcprcvbuf                  344064               975160              4148094              5925758                    0
            othersockbuf                24976               334592              2074047              3851711                    0
            dgramrcvbuf                     0                13176              2074047              2074047                    0
            numothersock                   23                   94                  434                  434                    0
            dcachesize                      0                    0              3883246              3999744                    0
            numfile                      2047                 3150                 6944                 6944                    0
            dummy                           0                    0                    0                    0                    0
            dummy                           0                    0                    0                    0                    0
            dummy                           0                    0                    0                    0                    0
            numiptent                      10                   10                  128                  128                    0

top:

Code: 
vs162054:~ # top
top - 17:54:25 up 20 min,  2 users,  load average: 0.05, 0.09, 0.04
Tasks:  43 total,   1 running,  42 sleeping,   0 stopped,   0 zombie
Cpu(s):  0.8% us,  0.1% sy,  0.0% ni, 99.1% id,  0.0% wa,  0.0% hi,  0.0% si
Mem:   1310720k total,   183368k used,  1127352k free,        0k buffers
Swap:        0k total,        0k used,        0k free,        0k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
10023 wwwrun    15   0 29600  11m 4736 S  3.3  5.6   0:00.19 httpd2-prefork
 3881 mysql     16   0 26316 7024 3372 S  0.3  0.5   0:02.14 mysqld
    1 root      16   0   604  248  216 S  0.0  0.0   0:00.00 init
 3770 root      15   0  1456  612  512 S  0.0  0.0   0:00.01 syslogd
 3773 root      16   0  1396  372  312 S  0.0  0.0   0:00.00 klogd
 3792 root      15   0  2664  708  540 S  0.0  0.1   0:00.00 couriertcpd
 3794 root      15   0  2568  772  612 S  0.0  0.1   0:00.00 courierlogger
 3803 root      18   0  2664  700  532 S  0.0  0.1   0:00.00 couriertcpd
 3806 root      18   0  2436  620  472 S  0.0  0.0   0:00.00 courierlogger
 3814 root      22   0  2664  700  532 S  0.0  0.1   0:00.00 couriertcpd
 3816 root      18   0  2436  620  472 S  0.0  0.0   0:00.00 courierlogger
 3826 root      21   0  2664  700  532 S  0.0  0.1   0:00.00 couriertcpd
 3829 root      18   0  2436  620  472 S  0.0  0.0   0:00.00 courierlogger
 3844 root      17   0  2376 1136  920 S  0.0  0.1   0:00.00 mysqld_safe
 3888 root      16   0  4524 1216  848 S  0.0  0.1   0:00.03 sshd
 3896 root      16   0  2076  876  716 S  0.0  0.1   0:00.00 xinetd
 3980 named     18   0 36316 2700 1840 S  0.0  0.2   0:00.00 named

Gruss,
Aquafresh
 
Was ist an zweimal "can't connect to database" nicht zu verstehen?
Dein MySQL-Server lief nicht mehr. Ein Restart davon hätte wohl gereicht.

huschi.
 
Hallo Huschi,

ist denn sowas normal? Kann man da nicht irgendwas erhöhen, wie bei dem apache2? z.B MaxClients, oder so?;)

Gruss,
Aquafresh
 
Die grundsätzlichen Fragen sind aber:
- Warum lief er nicht mehr?
- Seit wann lief er nicht mehr?

Es kommen viele Gründe in Frage. Da Du einen vServer hast tippe ich mal auf Speicher-Mangel. Die Frage "wann" bleibt aber vorher zu beantworten.
Denn wenn es zufällig während des Logrotates geschah, kannst Du auch nicht viel dran ändern.

Zum MySQL-Tuning:
vServer: Speicherauslastung reduzieren

huschi.
 
zeig uns mal die Apache Konfiguration incl. Modules. Dann die MySQL Konfiguration /etc/my.cnf

Und lass [thread=14308]tuning-primer.sh[/thread] laufen.

Code: 
Timeout 
KeepAlive 
MaxKeeAliveRequests
KeepAliveTimeout

<IfModule prefork.c>
StartServers       
MinSpareServers    
MaxSpareServers    
ServerLimit       
MaxClients       
MaxRequestsPerChild
<IfModule>


HostnameLookups
Code: 
[mysqld]

key_buffer = 
sort_buffer_size = 
net_buffer_length =
read_buffer_size =
.....
wieso hast du in top 0K Buffers, 0K Caches, 0K Swap?
 
Last edited by a moderator:
Hallo,

diese sieht wie folgt aus:

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]
set-variable=local-infile=0
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 = 512K
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 4M

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

# The safe_mysqld script
skip-bdb

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

skip-bdb

[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

Gruss
 
Das tuning-primer-Script hilft in dem Fall wahrscheinlich nicht viel, da es meistens nur eine Erhöhung der Werte vorschlägt. Leider beachtet es fast nie den wirklich vorhandenen Speicher. Schon gar nicht bei vServern ohne Swap...

huschi.
 
hi,

ich glaube das ist die http.conf, oder?

Hier ein Auszug:

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)
#  |
#  `-- vhosts.d/ . . . . . . . . . . . . . .  for each virtual host, place one file here
#       `-- *.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

# 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.php index.htm

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

AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps

PS: Sorry, dass ich so spät geantwortet hab. :D
 
ok,

bitte sehr:

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            1
	# minimum number of server processes which are kept spare
	MinSpareServers         1
	# maximum number of server processes which are kept spare
	MaxSpareServers         3
	# 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  1000
</IfModule>

# worker MPM
<IfModule worker.c>
	# initial number of server processes to start
	StartServers            1
	# minimum number of worker threads which are kept spare
	MinSpareThreads        10
	# maximum number of worker threads which are kept spare
	MaxSpareThreads        20
	# maximum number of simultaneous client connections
	MaxClients             300
	# constant number of worker threads in each server process
	ThreadsPerChild        15
	# maximum number of requests a server process serves
	MaxRequestsPerChild  1000
</IfModule>

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

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

	AcceptMutex fcntl
</IfModule>

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

	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
 
du hast ne Menge RAM frei aber keine Buffers?
Code: 
Mem:   1310720k total,   183368k used,  1127352k free,        0k buffers
Swap:        0k total,        0k used,        0k free,        0k cached
wieso hast du keine Buffers + Caches?

Code: 
# KeepAliveTimeout: Number of seconds to wait for the next request from the
# same client on the same connection.
#
KeepAliveTimeout [COLOR="Red"]2[/COLOR]
kannst du auf 2 oder 4 setzen.
 
Last edited by a moderator:
Hallo noto,

die Cache und Buffers, sind die notwendig? ICh bin echt kein Linux Spezí. :D

Was wäre angenehmer 4 oder 2?

EDIT: Hab nun auf 2 gemacht, Apache muss denke ich, neugestartet werden, oder?

Gruss,
Alex
 
Last edited by a moderator:
KeeAliveTimeout 15

User ruft deine Seite auf und geht dann wieder. Apache würde nun 15 Sekunden warten bis die offenen Verbindung getrennt würde.

Darum 2

2 Sekunden nach der letzen Anfrage an den Server wird die Verbindung frei für bereits wartende Besucher.

Ein hoher Wert lohnt nur, wenn man immer die selben Besucher auf der Seite hat. Apache müsste dann nicht ständig neue TCP Verbindungen aufbauen.
 
Last edited by a moderator:
Hallo,

das ganze ging 2 Wochen gut, nun fängt das selbe wieder von vorne an, bin echt am verzweifeln.

Könnte man sonst vielleicht was dran machen?:(

Gruß,
Aquafresh
 
Also, wenn auf meiner Webseite, ein hoher Besucherandrang ist (knappe 50-60) Online sind, bricht nach einer Zeit, der mySQL Server ab. Logs, sowie beancounters haben nichts auffälliges gezeigt. Plesk geht danach auch nicht mehr.

Meine TS Server laufen auch wenn der mySQL Server weg ist.

Ich bin davon ausgegangen wenn man 25,-€ im Monat opfert, das man da schon was hat. (RootDS)

Sollte der Server nochmals abbrechen, bringe ich die beancountersanzeige sofort hierbei.

EDIT:
////////////

beancounters:

Code: 
vs162054:~ # cat /proc/user_beancounters
Version: 2.5                                                                    
       uid  resource                     held              maxheld              barrier                limit              failcnt
    162054: kmemsize                  4954720             17777270             17777274             19555001              3064035
            lockedpages                     0                    0                  868                  868                    0
            privvmpages                 50351               260531               327680               344064                   20
            shmpages                     7080                 7096                25078                25078                    0
            dummy                           0                    0                    0                    0                    0
            numproc                        58                  137                  434                  434                    0
            physpages                   21482               234341                    0  9223372036854775807                    0
            vmguarpages                     0                    0               131072  9223372036854775807                    0
            oomguarpages                21482               234341               163840  9223372036854775807                    0
            numtcpsock                     22                  152                  434                  434                    0
            numflock                        6                   11                  694                  763                    0
            numpty                          2                    2                   43                   43                    0
            numsiginfo                      0                   17                 1024                 1024                    0
            tcpsndbuf                  213304               700856              4148094              5925758                    0
            tcprcvbuf                  360448               979168              4148094              5925758                    0
            othersockbuf                36696               355960              2074047              3851711                    0
            dgramrcvbuf                     0                13632              2074047              2074047                    0
            numothersock                   29                   46                  434                  434                    0
            dcachesize                      0                    0              3883246              3999744                    0
            numfile                      1979                 2932                 6944                 6944                    0
            dummy                           0                    0                    0                    0                    0
            dummy                           0                    0                    0                    0                    0
            dummy                           0                    0                    0                    0                    0
            numiptent                      10                   10                  128                  128                    0
Liebe Grüße,
Alex
 
Last edited by a moderator:
Ist recht deutlich zu sehen, daß Du zuwenig Speicher hast, oder?
Reduziere Deine Einstellungen!
Wenn die Apache-Tuning-Parameter von oben noch aktuelle sind, ziehe vor allem ServerLimit und MaxClients weiter runter. Dein Server verkraftet wahrscheinlich nicht mal 150.

huschi.
 
You must log in or register to reply here.
Back
Top