ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Best Server Setup for ExpressionEngine

November 02, 2010 7:06am

Subscribe [1]
  • #1 / Nov 02, 2010 7:06am

    mrwoods09

    4 posts

    Hi,

    I currently have a number of ExpressionEngine sites setup on a server and I’m running in to major issues with sleeps within the MySQL database which in turn seems to kill my server after a while. Does anyone know the best server setup to use please?

    Currently I have this.

    Apache 2.2.14 (Win32)
    Php 5.3.0
    MySQL 5.1.39-community via TCP/IP
    
    Intel(R) Xeon(R) CPU
    E7440 @ 2.40GHz
    2.40 GHz, 2.00 GB or RAM
    
    Microsoft Windows Server 2003
    Web Edition
    Service Pack 2

    MySQL my.ini

    [client]
    
    port=3306
    
    [mysql]
    
    default-character-set=latin1
    
    [mysqld]
    
    port=3306
    basedir="C:/Program Files/MySQL/MySQL Server 5.1/"
    datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"
    default-character-set=latin1
    default-storage-engine=INNODB
    sql-mode=
    max_connections=100
    query_cache_size=0
    table_cache=256
    tmp_table_size=103M
    thread_cache_size=8
    myisam_max_sort_file_size=100G
    myisam_sort_buffer_size=205M
    key_buffer_size=175M
    read_buffer_size=64K
    read_rnd_buffer_size=256K
    sort_buffer_size=256K
    innodb_additional_mem_pool_size=7M
    innodb_flush_log_at_trx_commit=1
    innodb_log_buffer_size=3498K
    innodb_buffer_pool_size=339M
    innodb_log_file_size=24M
    innodb_thread_concurrency=8

    Apache Config

    ServerRoot "C:/Program Files/Apache Software Foundation/Apache2.2"
    
    Listen **.**.***.***:80
    
    LoadModule actions_module modules/mod_actions.so
    LoadModule alias_module modules/mod_alias.so
    LoadModule asis_module modules/mod_asis.so
    LoadModule auth_basic_module modules/mod_auth_basic.so
    LoadModule authn_default_module modules/mod_authn_default.so
    LoadModule authn_file_module modules/mod_authn_file.so
    LoadModule authz_default_module modules/mod_authz_default.so
    LoadModule authz_groupfile_module modules/mod_authz_groupfile.so
    LoadModule authz_host_module modules/mod_authz_host.so
    LoadModule authz_user_module modules/mod_authz_user.so
    LoadModule autoindex_module modules/mod_autoindex.so
    LoadModule cgi_module modules/mod_cgi.so
    LoadModule dir_module modules/mod_dir.so
    LoadModule env_module modules/mod_env.so
    LoadModule headers_module modules/mod_headers.so
    LoadModule include_module modules/mod_include.so
    LoadModule isapi_module modules/mod_isapi.so
    LoadModule log_config_module modules/mod_log_config.so
    LoadModule mime_module modules/mod_mime.so
    LoadModule negotiation_module modules/mod_negotiation.so
    LoadModule rewrite_module modules/mod_rewrite.so
    LoadModule setenvif_module modules/mod_setenvif.so
    
    
    <IfModule !mpm_netware_module>
    <IfModule !mpm_winnt_module>
    
    User daemon
    Group daemon
    
    </IfModule>
    </IfModule>
    
    ServerAdmin *****@**********.co.uk
    ServerName localhost
    
    <Directory >
        Options FollowSymLinks
        AllowOverride None
        Order deny,allow
        Deny from all
    </Directory>
    
    <Directory "C:/Program Files/Apache Software Foundation/Apache2.2/htdocs">
        Options Indexes FollowSymLinks
        AllowOverride None
        Order allow,deny
        Allow from all
    </Directory>
    
    <Directory "E:/MWEB/wwwroot-apache">
        Options Indexes FollowSymLinks
        AllowOverride All
        Order allow,deny
        Allow from all
    </Directory>
    
    <IfModule dir_module>
        DirectoryIndex index.php index.html
    </IfModule>
    
    <FilesMatch "^\.ht">
        Order allow,deny
        Deny from all
        Satisfy All
    </FilesMatch>
    
    ErrorLog "logs/error.log"
    LogLevel warn
    
    <IfModule log_config_module>
        LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
        LogFormat "%h %l %u %t \"%r\" %>s %b" common
    <IfModule logio_module>
         
          LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %I %O" combinedio
    </IfModule>
    
    CustomLog "logs/access.log" common
    
    </IfModule>
    
    <IfModule alias_module>
        ScriptAlias /cgi-bin/ "C:/Program Files/Apache Software Foundation/Apache2.2/cgi-bin/"
    </IfModule>
    
    <IfModule cgid_module>
       
    </IfModule>
    
    
    <Directory "C:/Program Files/Apache Software Foundation/Apache2.2/cgi-bin">
        AllowOverride None
        Options None
        Order allow,deny
        Allow from all
    </Directory>
    
    DefaultType text/plain
    
    <IfModule mime_module>
        TypesConfig conf/mime.types
        AddType application/x-compress .Z
        AddType application/x-gzip .gz .tgz
    </IfModule>
    
    EnableMMAP off
    EnableSendfile off
    Include conf/extra/httpd-vhosts.conf
    
    <IfModule ssl_module>
    SSLRandomSeed startup builtin
    SSLRandomSeed connect builtin
    </IfModule>
    
    PHPIniDir "C:/Program Files/Apache Software Foundation/Apache2.2/php/"
    LoadModule php5_module "C:/Program Files/Apache Software Foundation/Apache2.2/php/php5apache2_2.dll"
    
    Win32DisableAcceptEx
.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases