Hi !

Ich versuche jetzt seit mehreren Tage meine Load von dem Apache und dem MySQL Server runter zu bekommen.

Mein System:

P4 2,4 GHZ
1 GB Ram
80 GB HDD
Linux: Redhat:7.3 / ENSIM
MySQL Version: 4.0.18-standard
Apache: 1.3.27

Ich poste einfach mal meine kompletten Configs, ich weiß nicht mehr weiter, immer ist die Load bei 10-50
Habe ein WBB Forum, was den gesammten Speed braucht, meine Vermutung ist, dass der MYSQL Server total falsch eingerichtet ist.
Am Tag sind auf dem Server ca 13.000 Besucher, leider grault es viele weg, dass es brechend langsam läuft :(.

Was meint ihr?


MySQL Config:
---------------------------------------------------------------------------------------------

[mysqld]
socket=/home/virtual/FILESYSTEMTEMPLATE/.mysqlsock/mysql.sock
datadir=/var/lib/mysql
skip-locking
skip-innodb
query_cache_limit=5M
query_cache_size=60M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=5M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=16M
read_buffer_size=16M
max_connect_errors=10
thread_concurrency=2
myisam_sort_buffer_size=64M
log-bin
server-id=1

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

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout
[client]
socket=/home/virtual/FILESYSTEMTEMPLATE/.mysqlsock/mysql.sock

---------------------------------------------------------------------------------------------

Apache Config KOMPLETT:
---------------------------------------------------------------------------------------------

ServerType standalone
ServerRoot /etc/httpd

#LockFile /var/lock/httpsd.lock

PidFile /var/run/httpd.pid


ScoreBoardFile /var/run/httpd.scoreboard


#ResourceConfig conf/srm.conf
#AccessConfig conf/access.conf


Timeout 250


KeepAlive On


MaxKeepAliveRequests 10


KeepAliveTimeout 15


MinSpareServers 5
MaxSpareServers 10


StartServers 7


MaxClients 1500


#MaxRequestsPerChild 30


#Listen 3000
#Listen 12.34.56.78:80


#BindAddress *

#LoadModule mmap_static_module modules/mod_mmap_static.so
LoadModule env_module modules/mod_env.so
#LoadModule define_module modules/mod_define.so
LoadModule config_log_module modules/mod_log_config.so
LoadModule agent_log_module modules/mod_log_agent.so
LoadModule referer_log_module modules/mod_log_referer.so
#LoadModule mime_magic_module modules/mod_mime_magic.so
LoadModule mime_module modules/mod_mime.so
LoadModule negotiation_module modules/mod_negotiation.so
LoadModule status_module modules/mod_status.so
LoadModule info_module modules/mod_info.so
LoadModule includes_module modules/mod_include.so
LoadModule autoindex_module modules/mod_autoindex.so
LoadModule dir_module modules/mod_dir.so
LoadModule cgi_module modules/mod_cgi.so
LoadModule asis_module modules/mod_asis.so
LoadModule imap_module modules/mod_imap.so
LoadModule action_module modules/mod_actions.so
#LoadModule speling_module modules/mod_speling.so
LoadModule userdir_module modules/mod_userdir.so
LoadModule proxy_module modules/libproxy.so
LoadModule alias_module modules/mod_alias.so
LoadModule rewrite_module modules/mod_rewrite.so
LoadModule access_module modules/mod_access.so
LoadModule auth_module modules/mod_auth.so
LoadModule anon_auth_module modules/mod_auth_anon.so
LoadModule db_auth_module modules/mod_auth_db.so
LoadModule digest_module modules/mod_digest.so
#LoadModule cern_meta_module modules/mod_cern_meta.so
LoadModule expires_module modules/mod_expires.so
LoadModule headers_module modules/mod_headers.so
LoadModule usertrack_module modules/mod_usertrack.so
#LoadModule example_module modules/mod_example.so
#LoadModule unique_id_module modules/mod_unique_id.so
LoadModule setenvif_module modules/mod_setenvif.so
<IfDefine SSL>
LoadModule ssl_module modules/libssl.so
</IfDefine>
#LoadModule sxnet_module modules/mod_sxnet.so
#LoadModule bandwidth_module modules/mod_bandwidth.so
#<IfDefine vwh_frontpage_module>
#LoadModule frontpage_module modules/mod_frontpage.so
#</IfDefine>

# Additional modules, not included by default
#LoadModule php_module modules/mod_php.so
#LoadModule php3_module modules/libphp3.so
<IfDefine vwh_php4_module>
LoadModule php4_module modules/libphp4.so
</IfDefine>
<IfDefine vwh_perl_module>
LoadModule perl_module modules/libperl.so
</IfDefine>
#LoadModule jserv_module modules/mod_jserv.so
#LoadModule dav_module modules/libdav.so
#LoadModule roaming_module modules/mod_roaming.so

# bandwidth module...

<IfDefine vwh_httpdmon_module>
LoadModule httpdmon_module /usr/lib/apache/httpdmon.so
</IfDefine>

# defines module...

<IfDefine vwh_httpd_defines_module>
LoadModule httpd_defines_module /usr/lib/apache/httpd_defines.so
</IfDefine>

#<IfDefine vwh_mod_jk_module>
#LoadModule jk_module /usr/lib/apache/mod_jk.so
#LoadModule fastcgi_module modules/mod_fastcgi.so
#</IfDefine>


ClearModuleList
#AddModule mod_mmap_static.c
AddModule mod_env.c
#AddModule mod_gzip.c
#AddModule mod_define.c
AddModule mod_log_config.c
AddModule mod_log_agent.c
AddModule mod_log_referer.c
#AddModule mod_mime_magic.c
AddModule mod_mime.c
AddModule mod_negotiation.c
AddModule mod_status.c
AddModule mod_info.c
AddModule mod_include.c
AddModule mod_autoindex.c
AddModule mod_dir.c
AddModule mod_cgi.c
AddModule mod_asis.c
AddModule mod_imap.c
AddModule mod_actions.c
#AddModule mod_speling.c
AddModule mod_userdir.c
AddModule mod_proxy.c
AddModule mod_alias.c
AddModule mod_rewrite.c
AddModule mod_access.c
AddModule mod_auth.c
AddModule mod_auth_anon.c
AddModule mod_auth_db.c
AddModule mod_digest.c
#AddModule mod_cern_meta.c
AddModule mod_expires.c
AddModule mod_headers.c
AddModule mod_usertrack.c
#AddModule mod_example.c
#AddModule mod_unique_id.c
AddModule mod_so.c
AddModule mod_setenvif.c

<IfDefine SSL>
AddModule mod_ssl.c
</IfDefine>
#AddModule mod_sxnet.c
#AddModule mod_bandwidth.c
#<IfDefine vwh_frontpage_module>
#AddModule mod_frontpage.c
#</IfDefine>

# Additional Modules, not included by default
#AddModule mod_php.c
#AddModule mod_php3.c
<IfDefine vwh_php4_module>
AddModule mod_php4.c
</IfDefine>
<IfDefine vwh_perl_module>
AddModule mod_perl.c
</IfDefine>

#AddModule mod_jserv.c
#AddModule mod_dav.c
#AddModule mod_roaming.c

<IfDefine vwh_httpdmon_module>
AddModule httpdmon.c
</IfDefine>

<IfDefine vwh_httpd_defines_module>
AddModule httpd_defines.c
</IfDefine>

#<IfDefine vwh_mod_jk_module>
#AddModule mod_jk.c
#AddModule mod_fastcgi.c
#</IfDefine>


#ExtendedStatus On


Port 80

<IfDefine SSL>
Listen 80
Listen 443
</IfDefine>


User apache
Group apache


ServerAdmin root@ns1.keinplan.com


ServerName ns1.keinplan.com


DocumentRoot /var/www/html


<Directory />
Options None
AllowOverride None
</Directory>


<Directory /var/www/html>

Order allow,deny
Allow from all
</Directory>

UserDir public_html


#<Directory /*/public_html>
# AllowOverride FileInfo AuthConfig Limit
# Options MultiViews Indexes SymLinksIfOwnerMatch IncludesNoExec
# <Limit GET POST OPTIONS PROPFIND>
# Order allow,deny
# Allow from all
# </Limit>
# <Limit PUT DELETE PATCH PROPPATCH MKCOL COPY MOVE LOCK UNLOCK>
# Order deny,allow
# Deny from all
# </Limit>
#</Directory>


DirectoryIndex index.php index.php3 index.php4 index.html index.htm index.shtml index.cgi index.pl index.jsp


AccessFileName .htaccess


<Files .htaccess>
Order allow,deny
Deny from all
</Files>


#CacheNegotiatedDocs


UseCanonicalName On


TypesConfig /etc/mime.types


DefaultType text/plain


<IfModule mod_mime_magic.c>
MIMEMagicFile conf/magic
</IfModule>


HostnameLookups off


# ErrorLog logs/error_log


LogLevel warn


LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
LogFormat "%h %l %u %t \"%r\" %>s %b" common
LogFormat "%{Referer}i -> %U" referer
LogFormat "%{User-agent}i" agent

# CustomLog logs/access_log common


#CustomLog logs/referer_log referer
#CustomLog logs/agent_log agent


#CustomLog logs/access_log combined


#ServerSignature On


Alias /icons/ /var/www/icons/

<Directory /var/www/icons>
Options MultiViews
AllowOverride None
Order allow,deny
Allow from all
</Directory>


ScriptAlias /cgi-bin/ /var/www/cgi-bin/


<Directory /var/www/cgi-bin>
AllowOverride None
# Options ExecCGI FollowSymLinks
Order allow,deny
Allow from all
</Directory>

IndexOptions FancyIndexing

AddIconByEncoding (CMP,/icons/compressed.gif) x-compress x-gzip

AddIconByType (TXT,/icons/text.gif) text/*
AddIconByType (IMG,/icons/image2.gif) image/*
AddIconByType (SND,/icons/sound2.gif) audio/*
AddIconByType (VID,/icons/movie.gif) video/*

AddIcon /icons/binary.gif .bin .exe
AddIcon /icons/binhex.gif .hqx
AddIcon /icons/tar.gif .tar
AddIcon /icons/world2.gif .wrl .wrl.gz .vrml .vrm .iv
AddIcon /icons/compressed.gif .Z .z .tgz .gz .zip
AddIcon /icons/a.gif .ps .ai .eps
AddIcon /icons/layout.gif .html .shtml .htm .pdf
AddIcon /icons/text.gif .txt
AddIcon /icons/c.gif .c
AddIcon /icons/p.gif .pl .py
AddIcon /icons/f.gif .for
AddIcon /icons/dvi.gif .dvi
AddIcon /icons/uuencoded.gif .uu
AddIcon /icons/script.gif .conf .sh .shar .csh .ksh .tcl
AddIcon /icons/tex.gif .tex
AddIcon /icons/bomb.gif core

AddIcon /icons/back.gif ..
AddIcon /icons/hand.right.gif README
AddIcon /icons/folder.gif ^^DIRECTORY^^
AddIcon /icons/blank.gif ^^BLANKICON^^

DefaultIcon /icons/unknown.gif


#AddDescription "GZIP compressed document" .gz
#AddDescription "tar archive" .tar
#AddDescription "GZIP compressed tar archive" .tgz


ReadmeName README
HeaderName HEADER


IndexIgnore .??* *~ *# HEADER* README* RCS CVS *,v *,t

AddEncoding x-compress Z
AddEncoding x-gzip gz


#AddLanguage en .en
#AddLanguage fr .fr
AddLanguage de .de
#AddLanguage da .da
#AddLanguage el .el
#AddLanguage it .it


LanguagePriority en fr de


<IfModule mod_php3.c>
AddType application/x-httpd-php3 .php3
AddType application/x-httpd-php3-source .phps
</IfModule>
#Setup mime types for mod_php4
<IfModule mod_php4.c>
AddType application/x-httpd-php .php .php4 .php3
</IfModule>
# The following is for PHP/FI (PHP2):
<IfModule mod_php.c>
AddType application/x-httpd-php .phtml
</IfModule>

#AddHandler cgi-script .cgi


AddType text/html .shtml
AddHandler server-parsed .shtml


#AddHandler send-as-is asis

AddHandler imap-file map

#AddHandler type-map var

<IfModule mod_perl.c>
Alias /perl/ /var/www/perl/
<Location /perl>
SetHandler perl-script
PerlHandler Apache::Registry
PerlSendHeader On
Options +ExecCGI
</Location>
</IfModule>

#MetaDir .web

#MetaSuffix .meta


#ErrorDocument 500 "The server made a boo boo.
ErrorDocument 404 http://www.keinplan/index.html

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


#<Location /server-status>
# SetHandler server-status
# Order deny,allow
# Deny from all
# Allow from .your_domain.com
#</Location>


#<Location /server-info>
# SetHandler server-info
# Order deny,allow
# Deny from all
# Allow from .your_domain.com
#</Location>

# Allow access to local system documentation from localhost
Alias /doc /usr/doc
<Directory /usr/doc>
order deny,allow
deny from all
allow from localhost
# Options FollowSymLinks
</Directory>

Alias /horde /usr/share/horde
<Directory /usr/share/horde>
DirectoryIndex index.html index.php3 index.htm index.shtml index.cgi
<IfModule mod_php3.c>
php3_magic_quotes_gpc Off
</IfModule>
</Directory>

#<Location /cgi-bin/phf*>
# Deny from all
# ErrorDocument 403 http://phf.apache.org/phf_abuse_log.cgi
#</Location>

#<IfModule mod_proxy.c>
#ProxyRequests On
#
#<Directory proxy:*>
# Order deny,allow
# Deny from all
# Allow from .your_domain.com
#</Directory>

#ProxyVia On

#CacheRoot /var/cache/httpd
#CacheSize 5
#CacheGcInterval 4
#CacheMaxExpire 24
#CacheLastModifiedFactor 0.1
#CacheDefaultExpire 1
#NoCache a_domain.com another_domain.edu joes.garage_sale.com

#</IfModule>
# End of proxy directives.

#NameVirtualHost 12.34.56.78:80
NameVirtualHost XXX.XXX.XXX.XX

#<VirtualHost _default_:*>
#</VirtualHost>

<IfDefine SSL>
AddType application/x-x509-ca-cert .crt
AddType application/x-pkcs7-crl .crl
</IfDefine>

<IfModule mod_ssl.c>

SSLSessionCache dbm:/var/cache/ssl_scache
SSLSessionCacheTimeout 300
SSLMutex file:/var/run/ssl_mutex
SSLRandomSeed startup builtin
SSLRandomSeed connect builtin
#SSLRandomSeed startup file:/dev/random 512
#SSLRandomSeed startup file:/dev/urandom 512
#SSLRandomSeed connect file:/dev/random 512
#SSLRandomSeed connect file:/dev/urandom 512
SSLLog logs/ssl_engine_log
SSLLogLevel warn

</IfModule>

<IfDefine SSL.default>


<VirtualHost XXX.XXX.XXX.XX:443>

#DocumentRoot /var/www/html
ServerName ns1.keinplan.com
ServerAdmin root@ns1.keinplan.com
# ErrorLog /var/log/httpd/error_log-ssl
# TransferLog /var/log/httpd/access_log-ssl

SSLEngine on

SSLCertificateFile /etc/httpd/conf/ssl.crt/server.crt

SSLCertificateKeyFile /etc/httpd/conf/ssl.key/server.key

SetEnvIf User-Agent ".*MSIE.*" nokeepalive ssl-unclean-shutdown

Include /etc/appliance/apacheconf

</VirtualHost>

</IfDefine>

<Location /html/usage>
Order deny,allow
Deny from all
Allow from localhost
</Location>
#<IfModule mod_jserv.c>
# Include /etc/httpd/conf/jserv.conf
#</IfModule>
#<IfModule mod_roaming.c>
# Include /etc/httpd/conf/roaming.conf
#</IfModule>

#<IfModule mod_jk.c>
# JkWorkersFile /etc/httpd/conf/workers.properties
# JkLogFile /var/log/httpd/mod_jk.log
# JkLogLevel error
#</IfModule>

#<IfModule mod_perl.c>
# Include /etc/httpd/conf/asp.conf
#</IfModule>

#ScriptAlias /mailman/ /usr/share/mailman/cgi-bin/
#Alias /pipermail/ /usr/share/mailman/archives/public/

<IfDefine vwh_php4_module>
php_admin_flag safe_mode off
</IfDefine>

<VirtualHost XXX.XXX.XXX.XX:80>
Include /etc/appliance/apacheconf
</VirtualHost>

# Include all the virtual host config files
Include /etc/httpd/conf/virtual

<IfModule mod_fastcgi.c>
AddHandler fastcgi-script fcgi
ScriptAlias /fcgi-bin/ "/var/www/fcgi-bin/"
</IfModule>

du solltest deinem mysql Server mal beibringen, das er sich
vom Hauptspeicher des Rechners ne große Ecke abbeissen darf :D


set-variable = key_buffer=128M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=1M
set-variable = table_cache=128
set-variable = sort_buffer=4M
set-variable = record_buffer=4M
set-variable = myisam_sort_buffer=64M
set-variable = thread_cache=4
set-variable = thread_concurrency=4


eventuell sogar noch mehr

ok, habe die my.cnf nun auf dies hier geändert.

[mysqld]
socket=/home/virtual/FILESYSTEMTEMPLATE/.mysqlsock/mysql.sock
datadir=/var/lib/mysql
skip-locking
skip-innodb
query_cache_limit=5M
query_cache_size=60M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=4
key_buffer=128M
join_buffer=5M
max_allowed_packet=1M
thread_stack=1M
table_cache=128
record_buffer=4M
sort_buffer_size=4M
read_buffer_size=16M
max_connect_errors=10
thread_concurrency=4
myisam_sort_buffer_size=64M
log-bin
server-id=1

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

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=1M

[mysql]
no-auto-rehash

[isamchk]
key_buffer=128M
sort_buffer=4M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=128M
sort_buffer=4M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout
[client]
socket=/home/virtual/FILESYSTEMTEMPLATE/.mysqlsock/mysql.sock


evtl. ist dies hier noch von Bedeutung

Server Apache/1.3.27 (Unix)
Red-Hat/Linux
mod_perl/1.26
PHP/4.3.5RC3
mod_ssl/2.8.12
OpenSSL/0.9.6b


Aktuelle Load bei nicht gerade vielen Surfern auf dem Forum (25-33):

11:54pm up 3 days, 2:15, 1 user, load average: 1.15, 1.40, 1.35
270 processes: 267 sleeping, 2 running, 1 zombie, 0 stopped
CPU states: 45.7% user, 9.6% system, 0.0% nice, 44.5% idle
Mem: 1023388K av, 983212K used, 40176K free, 0K shrd, 9444K buff
Swap: 2048276K av, 194140K used, 1854136K free 181364K cached

hmm, vielleicht nicht ganz im Sinne der Erfinders :(


12:08am up 3 days, 2:29, 1 user, load average: 25.85, 18.36, 10.14
403 processes: 361 sleeping, 39 running, 3 zombie, 0 stopped
CPU states: 80.3% user, 19.6% system, 0.0% nice, 0.0% idle
Mem: 1023388K av, 995324K used, 28064K free, 0K shrd, 2152K buff
Swap: 2048276K av, 298020K used, 1750256K free 76220K cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
30586 mysql 17 0 42408 33M 1768 R 6.2 3.3 0:00 mysqld
30527 mysql 15 0 42408 33M 1768 S 6.0 3.3 0:00 mysqld
30658 mysql 15 0 42408 33M 1768 S 6.0 3.3 0:00 mysqld
30460 mysql 16 0 42408 33M 1768 S 5.0 3.3 0:00 mysqld
30621 mysql 16 0 42408 33M 1768 S 5.0 3.3 0:00 mysqld
30656 mysql 16 0 42408 33M 1768 S 4.9 3.3 0:00 mysqld
30424 mysql 16 0 42408 33M 1768 S 4.7 3.3 0:00 mysqld
30727 mysql 16 0 42408 33M 1768 S 4.6 3.3 0:00 mysqld
30442 mysql 16 0 42408 33M 1768 S 4.4 3.3 0:00 mysqld
30641 root 16 0 19816 10M 6980 R 4.4 1.0 0:00 MailScanner
29912 mysql 15 0 42408 33M 1768 S 4.1 3.3 0:00 mysqld
29764 mysql 15 0 42408 33M 1768 S 4.0 3.3 0:00 mysqld
29893 mysql 15 0 42408 33M 1768 S 3.9 3.3 0:00 mysqld
30490 mysql 15 0 42408 33M 1768 S 2.8 3.3 0:00 mysqld
29505 postgres 18 0 4756 4628 2544 R 2.6 0.4 0:01 postmaster
30519 mysql 15 0 42408 33M 1768 S 2.6 3.3 0:00 mysqld
29543 postgres 18 0 7488 7360 2556 R 2.3 0.7 0:01 postmaster
30473 root 16 0 1512 1512 796 R 2.1 0.1 0:06 top
29629 apache 15 0 9440 7392 5192 S 1.7 0.7 0:00 httpd
31431 root 16 0 19804 6432 3968 S 1.4 0.6 0:05 MailScanner
29487 apache 15 0 8132 6004 5620 S 1.3 0.5 0:00 httpd

kann es sein, das deine mysql Configuration mächtig confuse ist?
Meine sieht nur so aus


# You can copy this to one of:
# /etc/mysql/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 use all long options that the program supports.
# Run the program with --help to get a list of available options

# This will be passed to all mysql clients
[client]
#password = my_password
port = 3306
socket = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

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

[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
#
# You can also put it into /var/log/mysql/mysql.log but I leave it in /var/log
# for backward compatibility. Both location gets rotated by the cronjob.
#log = /var/log/mysql/mysql.log
log = /var/log/mysql.log
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-locking
#
# The skip-networkin option will no longer be set via debconf menu.
# You have to manually change it if you want networking i.e. the server
# listening on port 3306. The default is "disable" - for security reasons.
# skip-networking
set-variable = key_buffer=128M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=1M
set-variable = table_cache=128
set-variable = sort_buffer=4M
set-variable = record_buffer=4M
set-variable = myisam_sort_buffer=64M
set-variable = thread_cache=4
set-variable = thread_concurrency=4
#
# Here you can see queries with especially long duration
#log-slow-queries = /var/log/mysql/mysql-slow.log
#
# The following can be used as easy to replay backup logs or for replication
#server-id = 1
#log-bin = /var/log/mysql/mysql-bin.log
#binlog-do-db = include_database_name
#binlog-ignore-db = include_database_name
#
# Read the manual if you want to enable InnoDB!
skip-innodb

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

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

[isamchk]
set-variable = key_buffer=16M

ich weiß nicht, können wir uns mal im ICQ unterhalten ?

40612049

ich denke, dass du gut ahnung hast, was ich nicht unbedingt von mir behaupten will.

vielleicht weiß ja jemand, was ich noch so für Apache Module deaktiveren kann, denke das wäre auch hilfreich !

wenn ich deins nehme

[root@ns1 bin]# /sbin/service mysqld start
dirname: too many arguments
Try `dirname --help' for more information.
mkdir: too few arguments
Try `mkdir --help' for more information.
dirname: too many arguments
Try `dirname --help' for more information.
chown: too few arguments
Try `chown --help' for more information.
dirname: too many arguments
Try `dirname --help' for more information.
chmod: too few arguments
Try `chmod --help' for more information.
/etc/init.d/mysqld: [: /home/virtual/FILESYSTEMTEMPLATE/.mysqlsock/mysql.sock: binary operator expected
/etc/init.d/mysqld: [: /home/virtual/FILESYSTEMTEMPLATE/.mysqlsock/mysql.sock: binary operator expected
/etc/init.d/mysqld: [: /home/virtual/FILESYSTEMTEMPLATE/.mysqlsock/mysql.sock: binary operator expected



EDIT:

habe mit deinen Seittings nochmal rumgespielt und nur fehler :( MYSQL ließ sich nicht mehr starten, erst mit meiner alten Config.

ich bekomme gleich nen anfall, kann mir denn da keiner helfen :((((((((((((((((((((((((((((((((


12:18pm up 15 min, 1 user, load average: 16.74, 12.79, 9.39
365 processes: 354 sleeping, 11 running, 0 zombie, 0 stopped
CPU states: 85.9% user, 14.0% system, 0.0% nice, 0.0% idle
Mem: 1023388K av, 1009524K used, 13864K free, 0K shrd, 4156K buff
Swap: 2048276K av, 0K used, 2048276K free 216152K cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
9106 mysql 17 0 29656 28M 2020 R 9.7 2.8 0:00 mysqld
1242 apache 15 0 13872 13M 9348 S 4.8 1.3 0:03 httpd
8050 apache 15 0 29988 29M 9332 S 4.8 2.9 0:00 httpd
1156 apache 16 0 12384 12M 9336 R 2.9 1.2 0:01 httpd

ZU HILFE !!!

12:25pm up 22 min, 1 user, load average: 26.38, 19.70, 13.67
549 processes: 534 sleeping, 49 running, 1 zombie, 0 stopped
CPU states: 24.8% user, 74.7% system, 0.0% nice, 0.4% idle
Mem: 1023388K av, 1011864K used, 11524K free, 0K shrd, 2152K buff
Swap: 2048276K av, 22352K used, 2025924K free 85892K cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
1209 apache 19 0 11888 11M 9308 R 12.4 1.1 0:02 httpd
1959 apache 15 0 11856 11M 9324 S 5.0 1.1 0:01 httpd
1364 apache 18 0 13252 12M 9312 R 4.9 1.2 0:02 httpd
12889 mysql 17 0 34660 33M 2028 S 4.4 3.3 0:00 mysqld
12898 mysql 17 0 34660 33M 2028 S 3.1 3.3 0:00 mysqld
12388 apache 17 0 11544 11M 9288 S 2.8 1.1 0:00 httpd
12957 apache 15 0 9612 9568 9192 S 2.5 0.9 0:00 httpd
11722 root 15 0 1428 1428 796 R 2.3 0.1 0:03 top
13022 postgres 15 0 2820 2820 2404 D 2.3 0.2 0:00 postmaster
12788 apache 16 0 11656 11M 9280 S 2.2 1.1 0:00 httpd
10147 apache 17 0 14468 14M 9324 S 1.9 1.4 0:00 httpd
12720 mysql 15 0 34652 33M 2028 S 1.8 3.3 0:00 mysqld
5 root 16 0 0 0 0 RW 1.7 0.0 0:01 kswapd
12808 mysql 15 0 34656 33M 2028 S 1.7 3.3 0:00 mysqld
8377 apache 16 0 11248 10M 9312 S 1.6 1.0 0:00 httpd
1354 apache 16 0 11200 10M 9340 S 1.3 1.0 0:01 httpd

hör bitte auf zu spammen! :teach:

komisches Forum, ich muss doch infos posten, damit man mir helfen kann ?!? lol

Leider konnte mir bis jetzt keiner einen wirklich guten Tipp geben, ganz im gegenteil, mein Server ist noch mehr abgekachelt als sonnst auch.

du postest hier x-mal dasselbe zeug, teilweise über 3 postings hinweg ...
nimm für sowas nen attachment....

zu deinem problem:
wenn du einen eigenen server betreibst, soltest du wissen, was du tust ...
oder ... dich mit der materie eingehend befassen ... oder ... (weil es ja mal
wieder dringend ist) jemanden beauftragen, der es kann, wenn es dir hier
nicht schnell genug geht.