mysql take all resources

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Mr.samy
    New Member
    • Feb 2008
    • 13
    • 3.8.x

    mysql take all resources

    Hello ,

    i have Intel(R) Xeon(R) CPU E5405 @ 2.00GHz server with 8 cpus and 6 giga ram

    and my forum have 8k unique visitors per day ,

    and forum mysql take all resource and make load very very high

    see for ex :
    PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
    4519 mysql 15 0 689m 324m 4016 S 454.0 5.4 56:36.81 mysqld


    take more than 400 % from cpu

    and this my.cnf config

    PHP Code:
    [mysqld]
    #datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    skip
    -locking
    #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
    =100
    max_connections
    =200
    interactive_timeout
    =30
    wait_timeout
    =200
    connect_timeout
    =200
    thread_cache_size
    =128
    key_buffer
    =128M ## 64MB 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
    =3M ## 1MB for every 1GB of RAM
    read_buffer_size=3M ## 1MB for every 1GB of RAM
    read_rnd_buffer_size=3M  ## 1MB for every 1GB of RAM
    thread_concurrency=## Number of CPUs x 2
    myisam_sort_buffer_size=64M
    server
    -id=1
    log_slow_queries
    =/var/log/mysql-slow-queries.log
    long_query_time
    =2
    old
    -passwords 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
    =32M
    read_buffer
    =16M
    write_buffer
    =16M

    [myisamchk]
    key_buffer=32M
    sort_buffer
    =32M
    read_buffer
    =16M
    write_buffer
    =16M
    open_files_limit
    =8192


    [mysqlhotcopy]
    interactive-timeout 
    i hope some one here check that !! and advise me what i do !

    realted ticket : Ticketid: 1062285
    Last edited by Mr.samy; Mon 14 Mar '11, 2:19am.
    [URL="http://betna.ma3hd.net"]منتديات بيتنا[/URL="http://betna.ma3hd.net"] | [URL="http://ds.ma3hd.net"]download engine[/URL="http://ds.ma3hd.net"] | [URL="http://dc.ma3hd.net"]ma3hd docs| [/URL="http://dc.ma3hd.net"][URL="http://games.ma3hd.net/"]العاب فلاش [/URL="http://games.ma3hd.net/"]| [URL="http://pharmacy.ma3hd.net"]online pharmacy[/URL="http://pharmacy.ma3hd.net"]
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Please see this thread for help with optimizing your server:



    Then post the requested info in a new thread in that forum.

    Also please note that we do this as a courtesy but optimizing servers is not really a part of vBulletin support.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...