[MySQL 4.0] MySQL und Apache, Load immer sehr hoch !

Einklappen
X
 
  • Filter
  • Zeit
  • Anzeigen
Alles löschen
neue Beiträge

  • [MySQL 4.0] MySQL und Apache, Load immer sehr hoch !

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

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

    Kommentar


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

      Kommentar


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

        Code:
        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
        TBT

        Die zwei wichtigsten Regeln für eine berufliche Karriere:
        1. Verrate niemals alles was du weißt!


        PHP 2 AllPatrizier II Browsergame

        Kommentar


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

          Zuletzt geändert von Snacke; 12.03.2004, 23:53.

          Kommentar


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

            Kommentar


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

              Code:
              # 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
              TBT

              Die zwei wichtigsten Regeln für eine berufliche Karriere:
              1. Verrate niemals alles was du weißt!


              PHP 2 AllPatrizier II Browsergame

              Kommentar


              • #8
                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.

                Kommentar


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

                  Kommentar


                  • #10
                    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.
                    Zuletzt geändert von Snacke; 13.03.2004, 12:01.

                    Kommentar


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

                      Kommentar


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

                        Kommentar


                        • #13
                          hör bitte auf zu spammen!
                          INFO: Erst suchen, dann posten![color=red] | [/color]MANUAL(s): PHP | MySQL | HTML/JS/CSS[color=red] | [/color]NICE: GNOME Do | TESTS: Gästebuch[color=red] | [/color]IM: Jabber.org |


                          Kommentar


                          • #14
                            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.

                            Kommentar


                            • #15
                              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.
                              Kissolino.com

                              Kommentar

                              Lädt...
                              X