Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    959

    MySQL optimization for this kind of server

    Hello,

    Server Spec: Celeron 2.2Ghz + 512MB DDR Ram, IDE HDD, Fedora Linux 1, MySQL 4.0.18, Direct Admin

    Only 1 site, PHP+MySQL Forum, PHP+MySQL Flash Guestbook

    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=400
    #interactive_timeout=100
    wait_timeout=30
    connect_timeout=15
    thread_cache_size=128
    key_buffer=32M
    join_buffer=1M
    max_allowed_packet=5M
    table_cache=1024
    record_buffer=1M
    sort_buffer_size=2M
    read_buffer_size=2M
    max_connect_errors=10
    thread_concurrency=2
    
    [mysqldump]
    quick
    max_allowed_packet=16M
    
    [mysql]
    no-auto-rehash
    #safe-updates
    
    [isamchk]
    key_buffer=20M
    sort_buffer_size=20M
    read_buffer=2M
    write_buffer=2M
    
    [myisamchk]
    key_buffer=20M
    sort_buffer_size=20M
    read_buffer=2M
    write_buffer=2M
    
    [mysqlhotcopy]
    interactive-timeout
    What is funny in the top: the mysqld's time never ends...it stays on the top and the time reaches 500 minutes, and CPU usage is like 45%. But over CPU Load stay in 3.5 Max

    Thanks

  2. #2
    Join Date
    Mar 2003
    Location
    California USA
    Posts
    13,681
    [mysqld]
    key_buffer=16M
    join_buffer=1M
    record_buffer=1M
    sort_buffer=2M
    table_cache=1028
    max_connections=250
    thread_cache_size=128
    max_allowed_packet=5M
    connect_timeout=15
    query_cache_limit=1M
    query_cache_size=32M
    query_cache_type=1
    thread_concurrency=2

    [mysqldump]
    quick
    max_allowed_packet=16M

    [mysql]
    no-auto-rehash
    #safe-updates

    [isamchk]
    key_buffer=20M
    sort_buffer_size=20M
    read_buffer=2M
    write_buffer=2M

    [myisamchk]
    key_buffer=20M
    sort_buffer_size=20M
    read_buffer=2M
    write_buffer=2M

    [mysqlhotcopy]
    interactive-timeout

    Try this config out
    Last edited by Steven; 04-09-2004 at 05:22 PM.
    Steven Ciaburri | Industry's Best Server Management - Rack911.com
    Software Auditing - 400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com
    Fully Managed Dedicated Servers (Las Vegas, New York City, & Amsterdam) (AS62710)
    FreeBSD & Linux Server Management, Security Auditing, Server Optimization, PCI Compliance

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •