Apache Mysql PHP configuration

Discussion in 'Apache' started by naresh.technical, Oct 9, 2012.

  1. #1
    Hi,I want to configure Apache, Mysql and PHP. I got configuration process for the installers. But i dont want install any one of these softwares in my machine. So i have downlaod all zip files for Apache, Mysql and PHP. Here is the actually problem. Please share configuration process when we are using zip files of Apache, Mysql and PHP.Thanks for all in advance..........RegardsNaresh
     
    naresh.technical, Oct 9, 2012 IP
  2. SolidShellSecurity

    SolidShellSecurity Banned

    Messages:
    262
    Likes Received:
    3
    Best Answers:
    1
    Trophy Points:
    45
    #2
    Configuration depends on many things. Do you need help with setup?
     
    SolidShellSecurity, Oct 10, 2012 IP
  3. wetbupa

    wetbupa Peon

    Messages:
    119
    Likes Received:
    2
    Best Answers:
    1
    Trophy Points:
    0
    #3
    Actually, for every server Mysql,Apache and php configuration is different , but I will provide you with the examples of configuration I am using:

    Apache configuration:

    Timeout 300
    TraceEnable Off
    ServerSignature Off
    ServerTokens ProductOnly
    FileETag None
    StartServers 5
    <IfModule prefork.c>
    MinSpareServers 5
    MaxSpareServers 10
    </IfModule>
    ServerLimit 256
    MaxClients 150
    MaxRequestsPerChild 10000
    KeepAlive Off
    KeepAliveTimeout 5
    MaxKeepAliveRequests 100

    RewriteEngine on
    RewriteMap LeechProtect prg:/usr/local/cpanel/bin/leechprotect
    RewriteLock /usr/local/apache/logs/rewrite_lock

    Mysql configuration:

    ## MySQL Config ##
    [mysqld]
    socket=/tmp/mysql.sock
    local-infile=0
    datadir=/var/lib/mysql
    tmpdir=/home/mysql_tmp
    skip-locking
    skip-bdb
    #skip-networking
    safe-show-database
    query_cache_limit=1M
    query_cache_size=64M ## 32MB for every 1GB of RAM
    query_cache_type=1
    max_user_connections=50
    max_connections=300
    interactive_timeout=180
    wait_timeout=180
    connect_timeout=120
    thread_cache_size=128
    key_buffer=256M ## 128MB for every 1GB of RAM
    join_buffer=1M
    max_connect_errors=20
    max_allowed_packet=16M
    table_cache=1024
    record_buffer=1M
    sort_buffer_size=2M ## 1MB for every 1GB of RAM
    read_buffer_size=2M ## 1MB for every 1GB of RAM
    read_rnd_buffer_size=2M ## 1MB for every 1GB of RAM
    thread_concurrency=16 ## Number of CPUs x 2
    myisam_sort_buffer_size=32M
    server-id=1
    default-character-set=cp1251
    init-connect="SET NAMES cp1251"
    default-collation=cp1251_general_ci
    log-slow-queries = /var/log/mysql_slow_queries.log
    delayed_insert_limit=20
    delayed_insert_timeout=5
    # this can be used on your own wish.
    #collation-server=latin1_general_ci
    [mysql.server]
    user=mysql
    [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
    #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

    PHP configuration ( main features):

    ;;;;;;;;;;;;;;;;;;;
    ; Resource Limits ;
    ;;;;;;;;;;;;;;;;;;;

    max_execution_time = 30
    max_input_time = 60
    memory_limit = 64M
     
    wetbupa, Oct 17, 2012 IP