Results 1 to 3 of 3
  1. #1

    MySQL more RAM less CPU

    Hello,

    I always have ~1.5GB free RAM, how can I optimize server, that loads will be lower? I want that MySQL would use more RAM (then CPU load will be lower, yes?). My my.cnf

    Code:
    [[email protected] etc]# free -m
                 total       used       free     shared    buffers     cached
    Mem:          3042       2993         48          0         80       1164
    -/+ buffers/cache:       1748       1293
    Swap:         2054         15       2039
    Code:
    [mysqld]
    port            = 3306
    socket          = /var/lib/mysql/mysql.sock
    #skip-innodb
    skip-locking
    key_buffer = 512M
    #tmp_table_size             = 32M
    max_allowed_packet = 16M
    max_connections = 800
    #max_user_connections = 300
    table_cache = 20000
    join_buffer_size = 3M
    sort_buffer_size = 3M
    read_buffer_size = 3M
    myisam_sort_buffer_size = 128M
    thread_cache_size = 3000
    wait_timeout = 30
    connect_timeout = 10
    query_cache_limit = 4M
    query_cache_size = 256M
    query_cache_type = 1
    tmp_table_size = 300M
    thread_concurrency=4
    #log-bin=on-bin
    server-id=1
    
    [mysql.server]
    user=mysql
    basedir=/var/lib
    
    [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=32M
    sort_buffer=64M
    read_buffer=64M
    write_buffer=64M
    
    [myisamchk]
    key_buffer=32M
    sort_buffer=64M
    read_buffer=64M
    write_buffer=64M
    
    [mysqlhotcopy]
    interactive-timeout
    [[email protected] etc]# mysqladmin -u***** -p******* status
    Uptime: 85849 Threads: 4 Questions: 6296494 Slow queries: 1 Opens: 110275 Flush tables: 886 Open tables: 10 Queries per second avg: 73.344


    Thank you for your suggestions.
    Last edited by intserv; 09-19-2006 at 02:03 PM.

  2. #2
    Join Date
    Feb 2003
    Posts
    44
    How big are your indexes?

    What is MySQL mainly used for? (forum, busy website, etc.)

  3. #3
    Using mysql for webhosting server with ~250 clients, ~10 big websites.

Posting Permissions

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