SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    Aug 2003
    Location
    Chile
    Posts
    146
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Help me tune my server a bit

    Hello, my server consists of a Dual Xenon irwingdale with 4gb of ram running Fedora Core6.

    php 5.1.6-3.6.fc6
    mysql 5.0.27-1.fc6

    my.cnf looks like this:

    # The MySQL server
    [mysqld]
    port = 3306
    socket = /var/lib/mysql/mysql.sock
    skip-locking
    key_buffer = 64M
    max_allowed_packet = 1M
    table_cache = 30000
    sort_buffer_size = 1M
    read_buffer_size = 8M
    read_rnd_buffer_size = 4M
    myisam_sort_buffer_size = 64M
    thread_cache_size = 8
    query_cache_size= 128M
    max_heap_table_size = 384M
    open_files_limit = 65535
    long_query_time = 5
    tmp_table_size = 384M
    max_connections = 150
    # Try number of CPU's*2 for thread_concurrency
    thread_concurrency = 8

    The site is getting about 12000 unique visits per day, with around 100k page views per day. What can I do to speed it up?

  2. #2
    SitePoint Zealot
    Join Date
    Jun 2007
    Posts
    150
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    What table types do you use? MyISAM, InnoDB?

    What kind of free memory are you seeing at the moment?


Bookmarks

Posting Permissions

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