WEB Dual Xeon to Woodcrest... Will I be gaining much?

Discussion in 'OT Technology' started by Vatoloco, Aug 5, 2007.

  1. Vatoloco

    Vatoloco In a pinch, though, you could jam it into someone'

    Joined:
    Jul 16, 2001
    Messages:
    86,251
    Likes Received:
    245
    Location:
    @Vatoloco_OT
    I currently have:

    Intel Dual Xeon 3.4GHz, 4GB RAM, 2 250GB SATA hdd's - $350/month


    I'm thinking about getting:

    Dual Intel Woodcrest 5130, 4GB RAM, 2 146GB SCSI 10k hdd's - $480/month




    I really don't understand the difference between woodcrest and dual xeon. They are both dual core processors aren't they? So is woodcrest and scsi worth the extra $130/month?



    I know I need something better though. The site is getting 10,000,000+ pageviews a month. This load is pretty normal for a weekend when the site isn't very busy:

    [​IMG]

    Weekdays during peak hours the load is almost always 3+
     
  2. Tony Stark

    Tony Stark John McCain has an illegitimate mexican baby

    Joined:
    Jun 27, 2003
    Messages:
    40,060
    Likes Received:
    0
    well what problems do you currently experience with your current setup?
     
  3. Vatoloco

    Vatoloco In a pinch, though, you could jam it into someone'

    Joined:
    Jul 16, 2001
    Messages:
    86,251
    Likes Received:
    245
    Location:
    @Vatoloco_OT
    Things are almost always running sluggish. Server load only drops below 1.0 late at night and even that is getting rare. Short jumps to 9+ in the load and services (like httpd, mysql) failing and restarting are completely normal during peak hours on the weekdays.
     
  4. Vatoloco

    Vatoloco In a pinch, though, you could jam it into someone'

    Joined:
    Jul 16, 2001
    Messages:
    86,251
    Likes Received:
    245
    Location:
    @Vatoloco_OT
    This means my current server is dual-processor and dual-core, right?

    Code:
    -bash-2.05b$ cat /proc/cpuinfo
    processor       : 0
    vendor_id       : GenuineIntel
    cpu family      : 15
    model           : 4
    model name      : Intel(R) Xeon(TM) CPU 3.40GHz
    stepping        : 1
    cpu MHz         : 3391.603
    cache size      : 1024 KB
    physical id     : 0
    siblings        : 2
    runqueue        : 0
    fdiv_bug        : no
    hlt_bug         : no
    f00f_bug        : no
    coma_bug        : no
    fpu             : yes
    fpu_exception   : yes
    cpuid level     : 3
    wp              : yes
    flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov                                                                               pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm nx lm
    bogomips        : 6763.31
    
    processor       : 1
    vendor_id       : GenuineIntel
    cpu family      : 15
    model           : 4
    model name      : Intel(R) Xeon(TM) CPU 3.40GHz
    stepping        : 1
    cpu MHz         : 3391.603
    cache size      : 1024 KB
    physical id     : 0
    siblings        : 2
    runqueue        : 0
    fdiv_bug        : no
    hlt_bug         : no
    f00f_bug        : no
    coma_bug        : no
    fpu             : yes
    fpu_exception   : yes
    cpuid level     : 3
    wp              : yes
    flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov                                                                               pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm nx lm
    bogomips        : 6763.31
    
    processor       : 2
    vendor_id       : GenuineIntel
    cpu family      : 15
    model           : 4
    model name      : Intel(R) Xeon(TM) CPU 3.40GHz
    stepping        : 1
    cpu MHz         : 3391.603
    cache size      : 1024 KB
    physical id     : 6
    siblings        : 2
    runqueue        : 2
    fdiv_bug        : no
    hlt_bug         : no
    f00f_bug        : no
    coma_bug        : no
    fpu             : yes
    fpu_exception   : yes
    cpuid level     : 3
    wp              : yes
    flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov                                                                               pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm nx lm
    bogomips        : 6763.31
    
    processor       : 3
    vendor_id       : GenuineIntel
    cpu family      : 15
    model           : 4
    model name      : Intel(R) Xeon(TM) CPU 3.40GHz
    stepping        : 1
    cpu MHz         : 3391.603
    cache size      : 1024 KB
    physical id     : 6
    siblings        : 2
    runqueue        : 2
    fdiv_bug        : no
    hlt_bug         : no
    f00f_bug        : no
    coma_bug        : no
    fpu             : yes
    fpu_exception   : yes
    cpuid level     : 3
    wp              : yes
    flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov                                                                               pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm nx lm
    bogomips        : 6763.31
    
    If my research is right a Woodcrest runs at 2.0GHz and since my current server is 3.4GHz, wouldn't a dual-core dual-processor woodcrest be a step down? I don't understand why they charge more for the woodcrest.
     
  5. thomor25

    thomor25 I make money online....

    Joined:
    Jun 11, 2000
    Messages:
    11,101
    Likes Received:
    0
    Location:
    Denver Colorado
    scsi will be wwhat makes it perform better. Also have you had someone optimize the server? I used to do this for the servers i had which ran close to 70k phpbb forums. Post your httpd.conf and your my.cnf or pm it to me and I'll tell you what to change to make it perform better.
     
  6. Vatoloco

    Vatoloco In a pinch, though, you could jam it into someone'

    Joined:
    Jul 16, 2001
    Messages:
    86,251
    Likes Received:
    245
    Location:
    @Vatoloco_OT
    Yeah, I've been told scsi would probably help quite a bit... especially since often when the server load is sky high the iowait is also approaching 100%.


    I have spent a little time in the past trying to optimize but I really didn't know what I was doing. I just went through posts on other forums and tried some of the suggestions to see what would happen. Any help on optimizing would be appreciated.

    my.cnf
    Code:
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    skip-locking
    skip-innodb
    query_cache_limit=1M
    query_cache_size=32M
    query_cache_type=1
    max_connections=500
    interactive_timeout=100
    wait_timeout=14400
    connect_timeout=10
    thread_cache_size=128
    key_buffer=150M
    join_buffer_size=1M
    max_allowed_packet=16M
    table_cache=1500
    read_buffer_size=1M
    sort_buffer_size=1M
    read_buffer_size=1M
    read_rnd_buffer_size=768K
    max_connect_errors=10
    thread_concurrency=4
    myisam_sort_buffer_size=64M
    server-id=1
    
    [mysql.server] 
    user=mysql 
    basedir=/var/lib 
    
    [safe_mysqld] 
    err-log=/var/log/mysqld.log 
    open_files_limit=8192 
    
    [mysqldump] 
    quick 
    max_allowed_packet=16M
    
    [mysql]
    no-auto-rehash 
    #safe-updates
    
    [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 
    
    httpd.conf
    Code:
    #-
    #Rlimit added by apachelimits.pl
    #-
    RLimitMEM 291803136
    RLimitCPU 240
    ##
    Alias /bandwidth/ /usr/local/bandmin/htdocs/
    
    
    
    
    ## httpd.conf -- Apache HTTP server configuration file
    ##
    
    #
    # Based upon the NCSA server configuration files originally by Rob McCool.
    #
    # 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/> for detailed information about
    # the directives.
    #
    # Do NOT simply read the instructions in here without understanding
    # what they do.  They're here only as hints or reminders.  If you are unsure
    # consult the online docs. You have been warned.  
    #
    # After this file is processed, the server will look for and process
    # /usr/local/apache/conf/srm.conf and then /usr/local/apache/conf/access.conf
    # unless you have overridden these with ResourceConfig and/or
    # AccessConfig directives here.
    #
    # The configuration directives are grouped into three basic sections:
    #  1. Directives that control the operation of the Apache server process as a
    #     whole (the 'global environment').
    #  2. Directives that define the parameters of the 'main' or 'default' server,
    #     which responds to requests that aren't handled by a virtual host.
    #     These directives also provide default values for the settings
    #     of all virtual hosts.
    #  3. Settings for virtual hosts, which allow Web requests to be sent to
    #     different IP addresses or hostnames and have them handled by the
    #     same Apache server process.
    #
    # Configuration and logfile names: If the filenames you specify for many
    # of the server's control files begin with "/" (or "drive:/" for Win32), the
    # server will use that explicit path.  If the filenames do *not* begin
    # with "/", the value of ServerRoot is prepended -- so "logs/foo.log"
    # with ServerRoot set to "/usr/local/apache" will be interpreted by the
    # server as "/usr/local/apache/logs/foo.log".
    #
    
    ### Section 1: Global Environment
    #
    # The directives in this section affect the overall operation of Apache,
    # such as the number of concurrent requests it can handle or where it
    # can find its configuration files.
    #
    
    #
    # ServerType is either inetd, or standalone.  Inetd mode is only supported on
    # Unix platforms.
    #
    ServerType standalone
    
    #
    # ServerRoot: The top of the directory tree under which the server's
    # configuration, error, and log files are kept.
    #
    # NOTE!  If you intend to place this on an NFS (or otherwise network)
    # mounted filesystem then please read the LockFile documentation
    # (available at <URL:http://www.apache.org/docs/mod/core.html#lockfile>);
    # you will save yourself a lot of trouble.
    #
    ServerRoot /usr/local/apache
    
    #
    # The LockFile directive sets the path to the lockfile used when Apache
    # is compiled with either USE_FCNTL_SERIALIZED_ACCEPT or
    # USE_FLOCK_SERIALIZED_ACCEPT. This directive should normally be left at
    # its default value. The main reason for changing it is if the logs
    # directory is NFS mounted, since the lockfile MUST BE STORED ON A LOCAL
    # DISK. The PID of the main server process is automatically appended to
    # the filename. 
    #
    #LockFile /usr/local/apache/logs/httpd.lock
    
    #
    # PidFile: The file in which the server should record its process
    # identification number when it starts.
    #
    PidFile /usr/local/apache/logs/httpd.pid
    
    #
    # ScoreBoardFile: File used to store internal server process information.
    # Not all architectures require this.  But if yours does (you'll know because
    # this file will be  created when you run Apache) then you *must* ensure that
    # no two invocations of Apache share the same scoreboard file.
    #
    ScoreBoardFile /usr/local/apache/logs/httpd.scoreboard
    
    #
    # In the standard configuration, the server will process httpd.conf (this 
    # file, specified by the -f command line option), srm.conf, and access.conf 
    # in that order.  The latter two files are now distributed empty, as it is 
    # recommended that all directives be kept in a single file for simplicity.  
    # The commented-out values below are the built-in defaults.  You can have the 
    # server ignore these files altogether by using "/dev/null" (for Unix) or
    # "nul" (for Win32) for the arguments to the directives.
    #
    #ResourceConfig /usr/local/apache/conf/srm.conf
    #AccessConfig /usr/local/apache/conf/access.conf
    
    #
    # Timeout: The number of seconds before receives and sends time out.
    # NoteToSelf - I had this set at 60 on the old P4 server
    #
    Timeout 300
    
    #
    # KeepAlive: Whether or not to allow persistent connections (more than
    # one request per connection). Set to "Off" to deactivate.
    # NoteToSelf - 2006-05-21 - I turned set this to Off to see what happens
    #
    KeepAlive Off
    
    #
    # 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.
    # NoteToSelf - I had this set at 2 on the old server.
    # NoteToSelf - This was originally set at 15 on this server
    #
    KeepAliveTimeout 2
    
    #
    # Server-pool size regulation.  Rather than making you guess how many
    # server processes you need, Apache dynamically adapts to the load it
    # sees --- that is, it tries to maintain enough server processes to
    # handle the current load, plus a few spare servers to handle transient
    # load spikes (e.g., multiple simultaneous requests from a single
    # Netscape browser).
    #
    # It does this by periodically checking how many servers are waiting
    # for a request.  If there are fewer than MinSpareServers, it creates
    # a new spare.  If there are more than MaxSpareServers, some of the
    # spares die off.  The default values are probably OK for most sites.
    #
    MinSpareServers 5
    MaxSpareServers 10
    
    #
    # Number of servers to start initially --- should be a reasonable ballpark
    # figure.
    #
    StartServers 5
    
    #
    # Limit on total number of servers running, i.e., limit on the number
    # of clients who can simultaneously connect --- if this limit is ever
    # reached, clients will be LOCKED OUT, so it should NOT BE SET TOO LOW.
    # It is intended mainly as a brake to keep a runaway server from taking
    # the system with it as it spirals down...
    # NoteToSelf - I had this set at 260 on the old P4 server
    # NoteToSelf - This was originally at 150 on this server 
    # NoteToSelf - I had this set to 200 prior to 2006-07-25
    #
    MaxClients 150
    
    #
    # MaxRequestsPerChild: the number of requests each child process is
    # allowed to process before the child dies.  The child will exit so
    # as to avoid problems after prolonged use when Apache (and maybe the
    # libraries it uses) leak memory or other resources.  On most systems, this
    # isn't really needed, but a few (such as Solaris) do have notable leaks
    # in the libraries. For these platforms, set to something like 10000
    # or so; a setting of 0 means unlimited.
    #
    # NOTE: This value does not include keepalive requests after the initial
    #       request per connection. For example, if a child process handles
    #       an initial request and 10 subsequent "keptalive" requests, it
    #       would only count as 1 request towards this limit.
    # NoteToSelf - I had this set at 1000 on the old P4 server
    #
    MaxRequestsPerChild 0
    
    #
    # Listen: Allows you to bind Apache to specific IP addresses and/or
    # ports, instead of the default. See also the <VirtualHost>
    # directive.
    #
    #Listen 3000
    #Listen 12.34.56.78:80
    
    #
    # BindAddress: You can support virtual hosts with this option. This directive
    # is used to tell the server which IP address to listen to. It can either
    # contain "*", an IP address, or a fully qualified Internet domain name.
    # See also the <VirtualHost> and Listen directives.
    #
    #BindAddress *
    
    #
    # Dynamic Shared Object (DSO) Support
    #
    # To be able to use the functionality of a module which was built as a DSO you
    # have to place corresponding `LoadModule' lines at this location so the
    # directives contained in it are actually available _before_ they are used.
    # Please read the file http://httpd.apache.org/docs/dso.html for more
    # details about the DSO mechanism and run `httpd -l' for the list of already
    # built-in (statically linked and thus always available) modules in your httpd
    # binary.
    #
    # Note: The order in which modules are loaded is important.  Don't change
    # the order below without expert advice.
    #
    # Example:
    # LoadModule foo_module libexec/mod_foo.so
    LoadModule rewrite_module     libexec/mod_rewrite.so
    LoadModule expires_module     libexec/mod_expires.so
    LoadModule php4_module        libexec/libphp4.so
    LoadModule bwlimited_module   libexec/mod_bwlimited.so
    LoadModule bytes_log_module   libexec/mod_log_bytes.so
    LoadModule auth_passthrough_module libexec/mod_auth_passthrough.so
    LoadModule evasive_module     libexec/mod_evasive.so
    
    #  Reconstruction of the complete module list from all available modules
    #  (static and shared ones) to achieve correct module execution order.
    #  [WHENEVER YOU CHANGE THE LOADMODULE SECTION ABOVE UPDATE THIS, TOO]
    ClearModuleList
    AddModule mod_env.c
    AddModule mod_log_config.c
    AddModule mod_mime.c
    AddModule mod_negotiation.c
    AddModule mod_status.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_userdir.c
    AddModule mod_alias.c
    AddModule mod_rewrite.c
    AddModule mod_access.c
    AddModule mod_auth.c
    AddModule mod_expires.c
    AddModule mod_so.c
    AddModule mod_setenvif.c
    <IfDefine SSL>
    AddModule mod_ssl.c
    </IfDefine>
    # AddModule mod_frontpage.c
    AddModule mod_php4.c
    AddModule mod_bwlimited.c
    AddModule mod_log_bytes.c
    AddModule mod_auth_passthrough.c
    AddModule mod_evasive.c
    
    <IfModule mod_evasive.c>
    DOSHashTableSize 3097
    DOSPageCount 2
    DOSSiteCount 50
    DOSPageInterval 1
    DOSSiteInterval 1
    DOSBlockingPeriod 90
    </IfModule>
    
    #
    # ExtendedStatus controls whether Apache will generate "full" status
    # information (ExtendedStatus On) or just basic information (ExtendedStatus
    # Off) when the "server-status" handler is called. The default is Off.
    #
    #ExtendedStatus On
    
    ### Section 2: '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.
    #
    
    #
    # If your ServerType directive (set earlier in the 'Global Environment'
    # section) is set to "inetd", the next few directives don't have any
    # effect since their settings are defined by the inetd configuration.
    # Skip ahead to the ServerAdmin directive.
    #
    
    #
    # Port: The port to which the standalone server listens. For
    # ports < 1023, you will need httpd to be run as root initially.
    #
    Port 80
    
    ##
    ##  SSL Support
    ##
    ##  When we also provide SSL we have to listen to the 
    ##  standard HTTP port (see above) and to the HTTPS port
    ##
    <IfDefine SSL>
    Listen 80
    Listen 443
    </IfDefine>
    
    #
    # If you wish httpd to run as a different user or group, you must run
    # httpd as root initially and it will switch.  
    #
    # User/Group: The name (or #number) of the user/group to run httpd as.
    #  . On SCO (ODT 3) use "User nouser" and "Group nogroup".
    #  . On HPUX you may not be able to use shared memory as nobody, and the
    #    suggested workaround is to create a user www and use that user.
    #  NOTE that some kernels refuse to setgid(Group) or semctl(IPC_SET)
    #  when the value of (unsigned)Group is above 60000; 
    #  don't use Group "#-1" on these systems!
    #
    User nobody
    Group nobody
    
    #
    # ServerAdmin: Your address, where problems with the server should be
    # e-mailed.  This address appears on some server-generated pages, such
    # as error documents.
    #
    ServerAdmin [email protected]
    
    #
    # ServerName allows you to set a host name which is sent back to clients for
    # your server if it's different than the one the program would get (i.e., use
    # "www" instead of the host's real name).
    #
    # Note: You cannot just invent host names and hope they work. The name you 
    # define here must be a valid DNS name for your host. If you don't understand
    # this, ask your network administrator.
    # If your host doesn't have a registered DNS name, enter its IP address here.
    # You will have to access it by its address (e.g., http://123.45.67.89/)
    # anyway, and this will make redirections work in a sensible way.
    #
    # 127.0.0.1 is the TCP/IP local loop-back address, often named localhost. Your 
    # machine always knows itself by this address. If you use Apache strictly for 
    # local testing and development, you may use 127.0.0.1 as the server name.
    #
    ServerName dirtysanchez.donkeypuncher.com
    
    #
    # DocumentRoot: The directory out of which you will serve your
    # documents. By default, all requests are taken from this directory, but
    # symbolic links and aliases may be used to point to other locations.
    #
    DocumentRoot /usr/local/apache/htdocs
    
    #
    # Each directory to which Apache has access, can be configured with respect
    # to which services and features are allowed and/or disabled in that
    # directory (and its subdirectories). 
    #
    # First, we configure the "default" to be a very restrictive set of 
    # permissions.  
    #
    <Directory />
    Options All
    AllowOverride All
    </Directory>
    
    #
    # Note that from this point forward you must specifically allow
    # particular features to be enabled - so if something's not working as
    # you might expect, make sure that you have specifically enabled it
    # below.
    #
    
    #
    # This should be changed to whatever you set DocumentRoot to.
    #
    <Directory "/usr/local/apache/htdocs">
    
    #
    # This may also be "None", "All", or any combination of "Indexes",
    # "Includes", "FollowSymLinks", "ExecCGI", or "MultiViews".
    #
    # Note that "MultiViews" must be named *explicitly* --- "Options All"
    # doesn't give it to you.
    #
        Options Indexes FollowSymLinks MultiViews
    
    #
    # This controls which options the .htaccess files in directories can
    # override. Can also be "All", or any combination of "Options", "FileInfo", 
    # "AuthConfig", and "Limit"
    #
        AllowOverride None
    
    #
    # Controls who can get stuff from this server.
    #
        Order allow,deny
        Allow from all
    </Directory>
    
    #
    # UserDir: The name of the directory which is appended onto a user's home
    # directory if a ~user request is received.
    #
    <IfModule mod_userdir.c>
    UserDir public_html
    </IfModule>
    
    #
    # Control access to UserDir directories.  The following is an example
    # for a site where these directories are restricted to read-only.
    #
    #<Directory /home/*/public_html>
    #    AllowOverride FileInfo AuthConfig Limit
    #    Options MultiViews Indexes SymLinksIfOwnerMatch IncludesNoExec
    #    <Limit GET POST OPTIONS PROPFIND>
    #        Order allow,deny
    #        Allow from all
    #    </Limit>
    #    <LimitExcept GET POST OPTIONS PROPFIND>
    #        Order deny,allow
    #        Deny from all
    #    </LimitExcept>
    #</Directory>
    
    #
    # DirectoryIndex: Name of the file or files to use as a pre-written HTML
    # directory index.  Separate multiple entries with spaces.
    #
    <IfModule mod_dir.c>
    DirectoryIndex index.html index.wml index.cgi index.shtml index.jsp index.js index.jp index.php4 index.php3 index.php index.phtml index.htm default.htm default.html home.htm
    </IfModule>
    
    #
    # AccessFileName: The name of the file to look for in each directory
    # for access control information.
    #
    AccessFileName .htaccess
    
    #
    # The following lines prevent .htaccess files from being viewed by
    # Web clients.  Since .htaccess files often contain authorization
    # information, access is disallowed for security reasons.  Comment
    # these lines out if you want Web visitors to see the contents of
    # .htaccess files.  If you change the AccessFileName directive above,
    # be sure to make the corresponding changes here.
    #
    # Also, folks tend to use names such as .htpasswd for password
    # files, so this will protect those as well.
    #
    
    <Files ~ "^error_log$">
    Order allow,deny
    Deny from all
    Satisfy All
    </Files>
    
    <Files ~ "^\.ht">
        Order allow,deny
        Deny from all
        Satisfy All
    </Files>
    
    #
    # CacheNegotiatedDocs: By default, Apache sends "Pragma: no-cache" with each
    # document that was negotiated on the basis of content. This asks proxy
    # servers not to cache the document. Uncommenting the following line disables
    # this behavior, and proxies will be allowed to cache the documents.
    #
    #CacheNegotiatedDocs
    
    #
    # UseCanonicalName:  (new for 1.3)  With this setting turned on, whenever
    # Apache needs to construct a self-referencing URL (a URL that refers back
    # to the server the response is coming from) it will use ServerName and
    # Port to form a "canonical" name.  With this setting off, Apache will
    # use the hostname:port that the client supplied, when possible.  This
    # also affects SERVER_NAME and SERVER_PORT in CGI scripts.
    #
    UseCanonicalName Off
    
    #
    # TypesConfig describes where the mime.types file (or equivalent) is
    # to be found.
    #
    <IfModule mod_mime.c>
        TypesConfig /usr/local/apache/conf/mime.types
    </IfModule>
    
    #
    # DefaultType is the default MIME type the server will use for a document
    # if it cannot otherwise determine one, such as from filename extensions.
    # If your server contains mostly text or HTML documents, "text/plain" is
    # a good value.  If most of your content is binary, such as applications
    # or images, you may want to use "application/octet-stream" instead to
    # keep browsers from trying to display binary files as though they are
    # text.
    #
    DefaultType text/plain
    
    #
    # The mod_mime_magic module allows the server to use various hints from the
    # contents of the file itself to determine its type.  The MIMEMagicFile
    # directive tells the module where the hint definitions are located.
    # mod_mime_magic is not part of the default server (you have to add
    # it yourself with a LoadModule [see the DSO paragraph in the 'Global
    # Environment' section], or recompile the server and include mod_mime_magic
    # as part of the configuration), so it's enclosed in an <IfModule> container.
    # This means that the MIMEMagicFile directive will only be processed if the
    # module is part of the server.
    #
    <IfModule mod_mime_magic.c>
        MIMEMagicFile /usr/local/apache/conf/magic
    </IfModule>
    
    #
    # HostnameLookups: Log the names of clients or just their IP addresses
    # e.g., www.apache.org (on) or 204.62.129.132 (off).
    # The default is off because it'd be overall better for the net if people
    # had to knowingly turn this feature on, since enabling it means that
    # each client request will result in AT LEAST one lookup request to the
    # nameserver.
    #
    HostnameLookups Off
    
    #
    # 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.
    #
    # NoteToSelf this was not inititally commented out
    #ErrorLog /usr/local/apache/logs/error_log
    
    #
    # LogLevel: Control the number of messages logged to the error_log.
    # Possible values include: debug, info, notice, warn, error, crit,
    # alert, emerg.
    #
    # NoteToSelf this was originally set to warn
    LogLevel crit
    
    #
    # The following directives define some format nicknames for use with
    # a CustomLog directive (see below).
    #
    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
    
    #
    # The location and format of the access logfile (Common Logfile Format).
    # If you do not define any access logfiles within a <VirtualHost>
    # container, they will be logged here.  Contrariwise, if you *do*
    # define per-<VirtualHost> access logfiles, transactions will be
    # logged therein and *not* in this file.
    #
    # NoteToSelf this was not initially commented out
    #CustomLog /usr/local/apache/logs/access_log common
    
    #
    # If you would like to have agent and referer logfiles, uncomment the
    # following directives.
    #
    #CustomLog /usr/local/apache/logs/referer_log referer
    #CustomLog /usr/local/apache/logs/agent_log agent
    
    #
    # If you prefer a single logfile with access, agent, and referer information
    # (Combined Logfile Format) you can use the following directive.
    #
    #CustomLog /usr/local/apache/logs/access_log combined
    
    #
    # Optionally add a line containing the server version and virtual host
    # name to server-generated pages (error documents, FTP directory listings,
    # mod_status and mod_info output etc., but not CGI generated documents).
    # Set to "EMail" to also include a mailto: link to the ServerAdmin.
    # Set to one of:  On | Off | EMail
    #
    ServerSignature Off
    
    # EBCDIC configuration:
    # (only for mainframes using the EBCDIC codeset, currently one of:
    # Fujitsu-Siemens' BS2000/OSD, IBM's OS/390 and IBM's TPF)!!
    # The following default configuration assumes that "text files"
    # are stored in EBCDIC (so that you can operate on them using the
    # normal POSIX tools like grep and sort) while "binary files" are
    # stored with identical octets as on an ASCII machine.
    #
    # The directives are evaluated in configuration file order, with
    # the EBCDICConvert directives applied before EBCDICConvertByType.
    #
    # If you want to have ASCII HTML documents and EBCDIC HTML documents
    # at the same time, you can use the file extension to force
    # conversion off for the ASCII documents:
    # > AddType       text/html .ahtml
    # > EBCDICConvert Off=InOut .ahtml
    #
    # EBCDICConvertByType  On=InOut text/* message/* multipart/*
    # EBCDICConvertByType  On=In    application/x-www-form-urlencoded
    # EBCDICConvertByType  On=InOut application/postscript model/vrml
    # EBCDICConvertByType Off=InOut */*
    
    
    #
    # Aliases: Add here as many aliases as you need (with no limit). The format is 
    # Alias fakename realname
    #
    <IfModule mod_alias.c>
    
        #
        # Note that if you include a trailing / on fakename then the server will
        # require it to be present in the URL.  So "/icons" isn't aliased in this
        # example, only "/icons/".  If the fakename is slash-terminated, then the 
        # realname must also be slash terminated, and if the fakename omits the 
        # trailing slash, the realname must also omit it.
        #
        Alias /icons/ "/usr/local/apache/icons/"
    
        <Directory "/usr/local/apache/icons">
            Options Indexes MultiViews
            AllowOverride None
            Order allow,deny
            Allow from all
        </Directory>
    
        # This Alias will project the on-line documentation tree under /manual/
        # even if you change the DocumentRoot. Comment it if you don't want to 
        # provide access to the on-line documentation.
        #
        Alias /manual/ "/usr/local/apache/htdocs/manual/"
    
        <Directory "/usr/local/apache/htdocs/manual">
            Options Indexes FollowSymlinks MultiViews
            AllowOverride None
            Order allow,deny
            Allow from all
        </Directory>
    
        #
        # ScriptAlias: This controls which directories contain server scripts.
        # ScriptAliases are essentially the same as Aliases, except that
        # documents in the realname directory are treated as applications and
        # run by the server when requested rather than as documents sent to the client.
        # The same rules about trailing "/" apply to ScriptAlias directives as to
        # Alias.
        #
        ScriptAlias /cgi-bin/ "/usr/local/apache/cgi-bin/"
    
        #
        # "/usr/local/apache/cgi-bin" should be changed to whatever your ScriptAliased
        # CGI directory exists, if you have that configured.
        #
        <Directory "/usr/local/apache/cgi-bin">
            AllowOverride None
            Options None
            Order allow,deny
            Allow from all
        </Directory>
    
    </IfModule>
    # End of aliases.
    
    #
    # Redirect allows you to tell clients about documents which used to exist in
    # your server's namespace, but do not anymore. This allows you to tell the
    # clients where to look for the relocated document.
    # Format: Redirect old-URI new-URL
    #
    
    #
    # Directives controlling the display of server-generated directory listings.
    #
    <IfModule mod_autoindex.c>
    
        #
        # FancyIndexing is whether you want fancy directory indexing or standard
        #
        IndexOptions FancyIndexing
    
        #
        # AddIcon* directives tell the server which icon to show for different
        # files or filename extensions.  These are only displayed for
        # FancyIndexed directories.
        #
        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 is which icon to show for files which do not have an icon
        # explicitly set.
        #
        DefaultIcon /icons/unknown.gif
    
        #
        # AddDescription allows you to place a short description after a file in
        # server-generated indexes.  These are only displayed for FancyIndexed
        # directories.
        # Format: AddDescription "description" filename
        #
        #AddDescription "GZIP compressed document" .gz
        #AddDescription "tar archive" .tar
        #AddDescription "GZIP compressed tar archive" .tgz
    
        #
        # ReadmeName is the name of the README file the server will look for by
        # default, and append to directory listings.
        #
        # HeaderName is the name of a file which should be prepended to
        # directory indexes. 
        #
        ReadmeName README.html
        HeaderName HEADER.html
    
        #
        # IndexIgnore is a set of filenames which directory indexing should ignore
        # and not include in the listing.  Shell-style wildcarding is permitted.
        #
        IndexIgnore .??* *~ *# HEADER* README* RCS CVS *,v *,t
    
    </IfModule>
    # End of indexing directives.
    
    #
    # Document types.
    #
    <IfModule mod_mime.c>
    
        #
        # AddLanguage allows you to specify the language of a document. You can
        # then use content negotiation to give a browser a file in a language
        # it can understand.  
        #
        # Note 1: The suffix does not have to be the same as the language 
        # keyword --- those with documents in Polish (whose net-standard 
        # language code is pl) may wish to use "AddLanguage pl .po" to 
        # avoid the ambiguity with the common suffix for perl scripts.
        #
        # Note 2: The example entries below illustrate that in quite
        # some cases the two character 'Language' abbreviation is not
        # identical to the two character 'Country' code for its country,
        # E.g. 'Danmark/dk' versus 'Danish/da'.
        #
        # Note 3: In the case of 'ltz' we violate the RFC by using a three char 
        # specifier. But there is 'work in progress' to fix this and get 
        # the reference data for rfc1766 cleaned up.
        #
        # Danish (da) - Dutch (nl) - English (en) - Estonian (ee)
        # French (fr) - German (de) - Greek-Modern (el)
        # Italian (it) - Korean (kr) - Norwegian (no) - Norwegian Nynorsk (nn)
        # Portugese (pt) - Luxembourgeois* (ltz)
        # Spanish (es) - Swedish (sv) - Catalan (ca) - Czech(cs)
        # Polish (pl) - Brazilian Portuguese (pt-br) - Japanese (ja)
        # Russian (ru)
        #
        AddLanguage da .dk
        AddLanguage nl .nl
        AddLanguage en .en
        AddLanguage et .ee
        AddLanguage fr .fr
        AddLanguage de .de
        AddLanguage el .el
        AddLanguage he .he
        AddCharset ISO-8859-8 .iso8859-8
        AddLanguage it .it
        AddLanguage ja .ja
        AddCharset ISO-2022-JP .jis
        AddLanguage kr .kr
        AddCharset ISO-2022-KR .iso-kr
        AddLanguage nn .nn
        AddLanguage no .no
        AddLanguage pl .po
        AddCharset ISO-8859-2 .iso-pl
        AddLanguage pt .pt
        AddLanguage pt-br .pt-br
        AddLanguage ltz .lu
        AddLanguage ca .ca
        AddLanguage es .es
        AddLanguage sv .sv
        AddLanguage cs .cz .cs
        AddLanguage ru .ru
        AddLanguage zh-TW .zh-tw
        AddCharset Big5         .Big5    .big5
        AddCharset WINDOWS-1251 .cp-1251
        AddCharset CP866        .cp866
        AddCharset ISO-8859-5   .iso-ru
        AddCharset KOI8-R       .koi8-r
        AddCharset UCS-2        .ucs2
        AddCharset UCS-4        .ucs4
        AddCharset UTF-8        .utf8
    
        # LanguagePriority allows you to give precedence to some languages
        # in case of a tie during content negotiation.
        #
        # Just list the languages in decreasing order of preference. We have
        # more or less alphabetized them here. You probably want to change this.
        #
        <IfModule mod_negotiation.c>
            LanguagePriority en da nl et fr de el it ja kr no pl pt pt-br ru ltz ca es sv tw
        </IfModule>
    
        #
        # AddType allows you to tweak mime.types without actually editing it, or to
        # make certain files to be certain types.
        #
        AddType application/x-tar .tgz
    
        #
        # AddEncoding allows you to have certain browsers uncompress
        # information on the fly. Note: Not all browsers support this.
        # Despite the name similarity, the following Add* directives have nothing
        # to do with the FancyIndexing customization directives above.
        #
        AddEncoding x-compress .Z
        AddEncoding x-gzip .gz .tgz
        #
        # If the AddEncoding directives above are commented-out, then you
        # probably should define those extensions to indicate media types:
        #
        #AddType application/x-compress .Z
        #AddType application/x-gzip .gz .tgz
    
        #
        # AddHandler allows you to map certain file extensions to "handlers",
        # actions unrelated to filetype. These can be either built into the server
        # or added with the Action command (see below)
        #
        # If you want to use server side includes, or CGI outside
        # ScriptAliased directories, uncomment the following lines.
        #
        # To use CGI scripts:
        #
    AddType application/x-httpd-php .php
    AddType application/x-httpd-php .php4
    AddType application/x-httpd-php .php3
    AddType application/x-httpd-php-source .phps
    AddType application/x-httpd-php .phtml
    AddHandler cgi-script .cgi .pl
    AddType text/html .shtml
    AddType application/x-tar .tgz
    AddType text/vnd.wap.wml .wml
    AddType image/vnd.wap.wbmp .wbmp
    AddType text/vnd.wap.wmlscript .wmls
    AddType application/vnd.wap.wmlc .wmlc
    AddType application/vnd.wap.wmlscriptc .wmlsc
    
    
        #
        # To use server-parsed HTML files
        #
        #AddType text/html .shtml
    AddHandler server-parsed .shtml
    
        #
        # Uncomment the following line to enable Apache's send-asis HTTP file
        # feature
        #
        #AddHandler send-as-is asis
    
        #
        # If you wish to use server-parsed imagemap files, use
        #
        #AddHandler imap-file map
    
        #
        # To enable type maps, you might want to use
        #
        #AddHandler type-map var
    
    </IfModule>
    # End of document types.
    
    #
    # Action lets you define media types that will execute a script whenever
    # a matching file is called. This eliminates the need for repeated URL
    # pathnames for oft-used CGI file processors.
    # Format: Action media/type /cgi-script/location
    # Format: Action handler-name /cgi-script/location
    #
    
    #
    # MetaDir: specifies the name of the directory in which Apache can find
    # meta information files. These files contain additional HTTP headers
    # to include when sending the document
    #
    #MetaDir .web
    
    #
    # MetaSuffix: specifies the file name suffix for the file containing the
    # meta information.
    #
    #MetaSuffix .meta
    
    #
    # Customizable error response (Apache style)
    #  these come in three flavors
    #
    #    1) plain text
    #ErrorDocument 500 "The server made a boo boo.
    #  n.b.  the single leading (") marks it as text, it does not get output
    #
    #    2) local redirects
    #ErrorDocument 404 /missing.html
    #  to redirect to local URL /missing.html
    #ErrorDocument 404 /cgi-bin/missing_handler.pl
    #  N.B.: You can redirect to a script or a document using server-side-includes.
    #
    #    3) external redirects
    #ErrorDocument 402 http://www.example.com/subscription_info.html
    #  N.B.: Many of the environment variables associated with the original
    #  request will *not* be available to such a script.
    
    #
    # Customize behaviour based on the browser
    #
    <IfModule mod_setenvif.c>
    
        #
        # The following directives modify normal HTTP response behavior.
        # The first directive disables keepalive for Netscape 2.x and browsers that
        # spoof it. There are known problems with these browser implementations.
        # The second directive is for Microsoft Internet Explorer 4.0b2
        # which has a broken HTTP/1.1 implementation and does not properly
        # support keepalive when it is used on 301 or 302 (redirect) responses.
        #
        BrowserMatch "Mozilla/2" nokeepalive
        BrowserMatch "MSIE 4\.0b2;" nokeepalive downgrade-1.0 force-response-1.0
    
        #
        # The following directive disables HTTP/1.1 responses to browsers which
        # are in violation of the HTTP/1.0 spec by not being able to grok a
        # basic 1.1 response.
        #
        BrowserMatch "RealPlayer 4\.0" force-response-1.0
        BrowserMatch "Java/1\.0" force-response-1.0
        BrowserMatch "JDK/1\.0" force-response-1.0
    
    </IfModule>
    # End of browser customization directives
    
    #
    # Allow server status reports, with the URL of http://servername/server-status
    # Change the ".example.com" to match your domain to enable.
    #
    #<Location /server-status>
    #    SetHandler server-status
    #    Order deny,allow
    #    Deny from all
    #    Allow from .example.com
    #</Location>
    
    #
    # Allow remote server configuration reports, with the URL of
    # http://servername/server-info (requires that mod_info.c be loaded).
    # Change the ".example.com" to match your domain to enable.
    #
    #<Location /server-info>
    #    SetHandler server-info
    #    Order deny,allow
    #    Deny from all
    #    Allow from .example.com
    #</Location>
    
    #
    # There have been reports of people trying to abuse an old bug from pre-1.1
    # days.  This bug involved a CGI script distributed as a part of Apache.
    # By uncommenting these lines you can redirect these attacks to a logging 
    # script on phf.apache.org.  Or, you can record them yourself, using the script
    # support/phf_abuse_log.cgi.
    #
    #<Location /cgi-bin/phf*>
    #    Deny from all
    #    ErrorDocument 403 http://phf.apache.org/phf_abuse_log.cgi
    #</Location>
    
    ### Section 3: Virtual Hosts
    #
    # 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://www.apache.org/docs/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.
    
    #
    # Use name-based virtual hosting.
    #
    #NameVirtualHost *:80
    
    #
    # VirtualHost example:
    # Almost any Apache directive may go into a VirtualHost container.
    # The first VirtualHost section is used for requests without a known
    # server name.
    #
    #<VirtualHost *:80>
    #    ServerAdmin [email protected]
    #    DocumentRoot /www/docs/dummy-host.example.com
    #    ServerName dummy-host.example.com
    #    ErrorLog logs/dummy-host.example.com-error_log
    #    CustomLog logs/dummy-host.example.com-access_log common
    #</VirtualHost>
    
    #<VirtualHost _default_:*>
    #</VirtualHost>
    
    ##
    ##  SSL Global Context
    ##
    ##  All SSL configuration in this context applies both to
    ##  the main server and all SSL-enabled virtual hosts.
    ##
    
    #
    #   Some MIME-types for downloading Certificates and CRLs
    #
    <IfDefine SSL>
    AddType application/x-x509-ca-cert .crt
    AddType application/x-pkcs7-crl    .crl
    </IfDefine>
    
    <IfModule mod_ssl.c>
    
    #   Pass Phrase Dialog:
    #   Configure the pass phrase gathering process.
    #   The filtering dialog program (`builtin' is a internal
    #   terminal dialog) has to provide the pass phrase on stdout.
    SSLPassPhraseDialog  builtin
    
    #   Inter-Process Session Cache:
    #   Configure the SSL Session Cache: First the mechanism 
    #   to use and second the expiring timeout (in seconds).
    #SSLSessionCache        none
    #SSLSessionCache        shmht:/usr/local/apache/logs/ssl_scache(512000)
    #SSLSessionCache        shmcb:/usr/local/apache/logs/ssl_scache(512000)
    SSLSessionCache         dbm:/usr/local/apache/logs/ssl_scache
    SSLSessionCacheTimeout  300
    
    #   Semaphore:
    #   Configure the path to the mutual exclusion semaphore the
    #   SSL engine uses internally for inter-process synchronization. 
    SSLMutex  file:/usr/local/apache/logs/ssl_mutex
    
    #   Pseudo Random Number Generator (PRNG):
    #   Configure one or more sources to seed the PRNG of the 
    #   SSL library. The seed data should be of good random quality.
    #   WARNING! On some platforms /dev/random blocks if not enough entropy
    #   is available. This means you then cannot use the /dev/random device
    #   because it would lead to very long connection times (as long as
    #   it requires to make more entropy available). But usually those
    #   platforms additionally provide a /dev/urandom device which doesn't
    #   block. So, if available, use this one instead. Read the mod_ssl User
    #   Manual for more details.
    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
    
    #   Logging:
    #   The home of the dedicated SSL protocol logfile. Errors are
    #   additionally duplicated in the general error log file.  Put
    #   this somewhere where it cannot be used for symlink attacks on
    #   a real server (i.e. somewhere where only root can write).
    #   Log levels are (ascending order: higher ones include lower ones):
    #   none, error, warn, info, trace, debug.
    SSLLog      /usr/local/apache/logs/ssl_engine_log
    SSLLogLevel info
    
    </IfModule>
    
    <IfDefine SSL>
    
    ##
    ## SSL Virtual Host Context
    ##
    
    
    </IfDefine>
    
    
    NameVirtualHost 71.65.432.10:80
    
    
    <VirtualHost 71.65.432.10>
    BytesLog domlogs/dirtysanchez.donkeypuncher.com-bytes_log
    ServerName dirtysanchez.donkeypuncher.com
    DocumentRoot /usr/local/apache/htdocs
    </VirtualHost>
    
    
    <Location /whm-server-status>
        SetHandler server-status
        Order deny,allow
        Deny from all
        Allow from 127.0.0.1
    </Location>
    ExtendedStatus On
    
    
    <VirtualHost 71.65.432.10>
    ServerAlias www.donkeypuncher.com donkeypuncher.com
    ServerAdmin [email protected]
    DocumentRoot /home/donkeypuncher/public_html
    #BytesLog domlogs/donkeypuncher.com-bytes_log
    ServerName www.donkeypuncher.com
    ServerAlias donkeypunch.com www.donkeypunch.com
    ServerAlias donkeypunching.com www.donkeypunching.com
    ServerAlias donkeypunched.com www.donkeypunched.com
    ServerAlias donkeypuncher.info www.donkeypuncher.info
    ServerAlias dirty-sanchez.com www.dirty-sanchez.com
    ServerAlias donkeypuncherer.com www.donkeypuncherer.com
    <IfModule mod_userdir.c>
    Userdir disabled
    Userdir enabled donkeypuncher 
    </IfModule>
    <IfModule mod_php4.c>
    php_admin_value open_basedir "/home/donkeypuncher:/usr/lib/php:/usr/local/lib/php:/tmp"
    </IfModule>
    User donkeypuncher
    Group donkeypuncher
    #CustomLog domlogs/donkeypuncher.com combined
    ScriptAlias /cgi-bin/ /home/donkeypuncher/public_html/cgi-bin/
    </VirtualHost>
    
    
    
    
    
    <VirtualHost 71.65.432.10>
    ServerAlias sofaketo.com
    ServerAdmin [email protected]
    DocumentRoot /home/sofaketo/public_html
    BytesLog domlogs/sofaketo.com-bytes_log
    ServerName www.sofaketo.com
    ServerAlias sofaketo.org www.sofaketo.org
    ServerAlias sofaketo.net www.sofaketo.net
    ServerAlias sofake2.com www.sofake2.com
    
    <IfModule mod_userdir.c>
      Userdir disabled
      Userdir enabled sofaketo 
    </IfModule>
    
    <IfModule mod_php4.c>
      php_admin_value open_basedir "/home/sofaketo:/usr/lib/php:/usr/local/lib/php:/tmp"
    </IfModule>
    <IfModule mod_php5.c>
      php_admin_value open_basedir "/home/sofaketo:/usr/lib/php:/usr/local/lib/php:/tmp"
    </IfModule>
    
    User sofaketo
    Group sofaketo
    CustomLog /usr/local/apache/domlogs/sofaketo.com combined
    ScriptAlias /cgi-bin/ /home/sofaketo/public_html/cgi-bin/
    </VirtualHost>
    
    
    ErrorDocument 400 /400.html
    ErrorDocument 401 /401.html
    ErrorDocument 403 /403.html
    ErrorDocument 404 /404.html
    ErrorDocument 500 /500.html
    ScriptAlias /cgi-sys/ /usr/local/cpanel/cgi-sys/
    Alias /sys_cpanel/ /usr/local/cpanel/sys_cpanel/
    Alias /java-sys/ /usr/local/cpanel/java-sys/
    Alias /img-sys/ /usr/local/cpanel/img-sys/
    Alias /akopia/ /usr/local/cpanel/3rdparty/interchange/share/akopia/
    Alias /neo-images/ /usr/local/cpanel/base/neomail/neo-images/
    ScriptAliasMatch ^/cpanel/(.*) /usr/local/cpanel/cgi-sys/redirect.cgi
    ScriptAlias /cpanel /usr/local/cpanel/cgi-sys/redirect.cgi
    ScriptAlias /whm /usr/local/cpanel/cgi-sys/whmredirect.cgi
    ScriptAlias /securewhm /usr/local/cpanel/cgi-sys/swhmredirect.cgi
    ScriptAlias /webmail /usr/local/cpanel/cgi-sys/wredirect.cgi
    ScriptAliasMatch ^/webmail/(.*) /usr/local/cpanel/cgi-sys/wredirect.cgi
    ScriptAliasMatch ^/kpanel/(.*) /usr/local/cpanel/cgi-sys/redirect.cgi
    ScriptAlias /controlpanel /usr/local/cpanel/cgi-sys/redirect.cgi
    ScriptAlias /securecontrolpanel /usr/local/cpanel/cgi-sys/sredirect.cgi
    Alias /mailman/archives/ /usr/local/cpanel/3rdparty/mailman/archives/public/
    ScriptAlias /mailman/ /usr/local/cpanel/3rdparty/mailman/cgi-bin/
    Alias /pipermail/ /usr/local/cpanel/3rdparty/mailman/archives/public/
    Alias /interchange/ /usr/local/cpanel/3rdparty/interchange/share/interchange/
    Alias /interchange-5/ /usr/local/cpanel/3rdparty/interchange/share/interchange-5/
    
    Yeah, the domains were updated to fakeness for OT posting purposes. And, yes, I really do have most logging disabled. I never used the logs and processing and rotating them used a huge amount of resources.
     
  7. thomor25

    thomor25 I make money online....

    Joined:
    Jun 11, 2000
    Messages:
    11,101
    Likes Received:
    0
    Location:
    Denver Colorado
    for the httpd.cnf

    Timeout 1
    KeepAlive On
    MaxKeepAliveRequests 500
    MinSpareServers 10
    MaxSpareServers 50
    StartServers 10
    MaxClients 1000

    and restart apache


    see how that does


    then rename your current my.cnf to myold.cnf and try this one

    Code:
    [client]
    port = 3306
    socket = /var/lib/mysql/mysql.sock
    [mysqld]
    user = mysql
    skip-locking
    max_connections =150000000
    key_buffer = 16M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 2M
    sort_buffer_size = 2M
    table_cache = 1024
    thread_cache_size = 64
    wait_timeout = 30
    connect_timeout = 10
    max_allowed_packet = 16M
    max_connect_errors = 10000000000000000000000000000
    query_cache_limit = 1M
    query_cache_size = 64M
    query_cache_type = 1
    skip-innodb
    safe-show-database
    [mysqld_safe] 
    open_files_limit = 8192
    [mysqldump]
    quick
    max_allowed_packet = 16M
    [mysql]
    no-auto-rehash
    [isamchk]
    key_buffer = 256M
    sort_buffer_size = 256M
    read_buffer = 2M
    write_buffer = 2M
    [myisamchk]
    key_buffer = 256M
    sort_buffer_size = 256M
    read_buffer = 2M
    write_buffer = 2M
    [mysqlhotcopy]
    interactive-timeout
     
  8. waffler

    waffler Errrbuddy in this bitch get tipsy

    Joined:
    Jun 30, 2002
    Messages:
    1,148
    Likes Received:
    0
    Location:
    winnipeg
    what site do you run?
     
  9. thomor25

    thomor25 I make money online....

    Joined:
    Jun 11, 2000
    Messages:
    11,101
    Likes Received:
    0
    Location:
    Denver Colorado
    when i upgraded i went from two sata raptors in raid1 to 2 scsi drives in raid1, the performance increase was amazing.

    With that config I was able to bring servers with loads of 6 down to a .5

    I don't think he wants to say thats why he took out the urls.
     
  10. Vatoloco

    Vatoloco In a pinch, though, you could jam it into someone'

    Joined:
    Jul 16, 2001
    Messages:
    86,251
    Likes Received:
    245
    Location:
    @Vatoloco_OT
    Yeah, like right now:

    [​IMG]

    I think SCSI's or maybe just more memory so it doesn't have to swap as much would make a big difference.

    I'll try your my.cnf and httpd suggestions above for a little while and see if I notice a difference. Thanks!



    Yeah, I would rather keep it on the down low. OT is one of the few sites I'm on where my identity isn't public. I want to keep it that way. :)
     
  11. thomor25

    thomor25 I make money online....

    Joined:
    Jun 11, 2000
    Messages:
    11,101
    Likes Received:
    0
    Location:
    Denver Colorado
    watch it, sometimes it went up when you restart apache and then it went down, where is it at now?
     
  12. Vatoloco

    Vatoloco In a pinch, though, you could jam it into someone'

    Joined:
    Jul 16, 2001
    Messages:
    86,251
    Likes Received:
    245
    Location:
    @Vatoloco_OT
    I haven't tried your suggested changes yet. That screenshot was from my originals. It does that from time to time. It'll spike for about 5 or 10 minutes and then return to a more normal 1-3.
     
  13. thomor25

    thomor25 I make money online....

    Joined:
    Jun 11, 2000
    Messages:
    11,101
    Likes Received:
    0
    Location:
    Denver Colorado
    you got aim? I was gonna say I hope that wasn't after my httpd change.

    I never had someones go as high as 18 but that timeout set to 1 is def gonna help
     
  14. thomor25

    thomor25 I make money online....

    Joined:
    Jun 11, 2000
    Messages:
    11,101
    Likes Received:
    0
    Location:
    Denver Colorado
    did you try it yet?
     
  15. Vatoloco

    Vatoloco In a pinch, though, you could jam it into someone'

    Joined:
    Jul 16, 2001
    Messages:
    86,251
    Likes Received:
    245
    Location:
    @Vatoloco_OT
    Yeah, I tried the httpd.conf suggestions and it seemed to bring the server load WAY down but I also kept getting 404 messages when trying to load the site so I went back to my old one. When I get some more time I'll try the my.cnf and tweak the numbers a little for the httpd.conf and see what happens.



    As far as upgrading to Woodcrest though, is there any improvement over Dual Xeons? Or am I just better off trying to get them to swap scsi's into my current server?
     
  16. thomor25

    thomor25 I make money online....

    Joined:
    Jun 11, 2000
    Messages:
    11,101
    Likes Received:
    0
    Location:
    Denver Colorado
    just swap for scsi. the load is being caused by the iowait

    set the KeepAliveTimeout to 20 and try it again and see if you get 404 errors.
     
  17. crazybenf

    crazybenf Active Member

    Joined:
    Nov 14, 2001
    Messages:
    15,575
    Likes Received:
    2
    I recommend using a dedicated SQL machine for anything with that much traffic.
     
  18. DigiCrime

    DigiCrime If Only!

    Joined:
    Oct 25, 2001
    Messages:
    33,001
    Likes Received:
    101
    Location:
    St. Louis
    What he said. The more connections you allow mysql to have the worst the situation gets most likely. Running all your services on one machine is taxing for any processor to keep up. For something like that you need 16 gigs of ram probably ram but I wouldnt, Id get a second server. What is your port speed 10 or 100? If your only utilizing a 10mbp speed and your traffic is around even 8mbps it doesnt leave you much room for any added traffic if you should get a sudden rise in volume.

    If you upgrade I dont think youll see that much improvement what you'll need eventually if not already is a second server and a cross over connect. Most datacenters will allow you to setup a crossover with your own hardware (router and cable) or they can provide one so that you can use mysql on one and apache on the other.

    Also on your system you want to disable anything you are NOT using. Checking thru crons and make sure they run during a time when the server is not under a load such as at night probably. If a second second system is out of your budget you can attempt to run a server upgrade but run your msql on a second drive.

    What is your OS specifications if I may ask what brand of linux/os just looking at your process list, doesnt look like mysql is your problem but rather httpd traffic. In top hit T and it sorts processes by time, give you an idea of processes that are running the longest to shortest.
     
  19. DigiCrime

    DigiCrime If Only!

    Joined:
    Oct 25, 2001
    Messages:
    33,001
    Likes Received:
    101
    Location:
    St. Louis
    some commands to help you sort thru httpd traffic.

    netstat -nap | grep 80
    List all trafic on port 80

    netstat -tan | grep ':80 ' | awk '{print $6}' | sort | uniq -c
    List particular traffic like TIME_WAIT, ESTABLISH

    Say you had some high amount of connections on TIME_WAIT

    netstat -pan | sort +4 | grep TIME_WAIT | awk '{print $5}' | sed -e s/':.*'/''/g | sort | uniq -c | sort -k 1 -nr | head -n 20

    Will return a list of traffic startnig with most to lease on time wait..

    Also what kernel are you using? : uname -a
     
  20. Vatoloco

    Vatoloco In a pinch, though, you could jam it into someone'

    Joined:
    Jul 16, 2001
    Messages:
    86,251
    Likes Received:
    245
    Location:
    @Vatoloco_OT
    I am running the mysql database on its own harddrive and I'm on a 100mbps line.

    Sorted by T:
    [​IMG]

    OS is Red Hate Enterprise (v3, I think). Kernel is "2.4.21-27.ELsmp #1 SMP i686 i686 i386 GNU/Linux"


    I'll have to look into multiple servers. I remember looking at them before and it seemed like things started getting pretty pricey when I went that route.
     
  21. crazybenf

    crazybenf Active Member

    Joined:
    Nov 14, 2001
    Messages:
    15,575
    Likes Received:
    2
    Just add a new server and only use it for mysql. Most of the time, the host wont even meter traffic within the datacenter. (free mysql traffic ftw) Especially a bonus if all local traffic is gbit.

    A dedicated mysql machine should NOT cost you more than $150/mo. (of course this depends on who you host with)
     
  22. DigiCrime

    DigiCrime If Only!

    Joined:
    Oct 25, 2001
    Messages:
    33,001
    Likes Received:
    101
    Location:
    St. Louis
    what he said ^ most dont monitor the traffic for a crossover so you should be good. a 2.6 kernel probgably do ya some good
     
  23. Vatoloco

    Vatoloco In a pinch, though, you could jam it into someone'

    Joined:
    Jul 16, 2001
    Messages:
    86,251
    Likes Received:
    245
    Location:
    @Vatoloco_OT
    $150 only gets me a single dual-core processor with a gig of RAM and a SATA hdd. Is that really going to be better moving mysql from a Dual Processor, Dual Core with 4 gigs of RAM?
     
  24. thomor25

    thomor25 I make money online....

    Joined:
    Jun 11, 2000
    Messages:
    11,101
    Likes Received:
    0
    Location:
    Denver Colorado
    you will want scsi for a sql server. dual core 2gb ram and scsi hd and you are ready to go.
     
  25. Vatoloco

    Vatoloco In a pinch, though, you could jam it into someone'

    Joined:
    Jul 16, 2001
    Messages:
    86,251
    Likes Received:
    245
    Location:
    @Vatoloco_OT
    I'm looking at about $250 for something like that. :wtc:
     

Share This Page