Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2005
    Posts
    268

    Optimize my.cnf?

    what is the best way to optimize my.cnf ?
    my server is Xeon 2.8ghz + 1gb ram. OS Centos and cpanel. There is only 3 sites in there, 1 is forums other is download site. At peak time, there are around 300 active users online. I have search around but those optimize do not work for my server. Last night my server load was 100, somehow the mysql load too much ( i think) . Thank guys

    p/s: last night, there were over 1050 processes, and 1046 running...
    Last edited by AndyJ; 04-18-2005 at 01:33 PM.

  2. #2
    Join Date
    May 2004
    Posts
    66
    why dont you put here the configuration you are putting , and also a snap shot from the command
    mysqladmin proc
    and also
    mysqladmin status

  3. #3
    Join Date
    Jan 2005
    Posts
    268
    mysqladmin process
    +-------+-----------+-----------+-----------+---------+------+-------+------------------+
    | Id | User | Host | db | Command | Time | State | Info |
    +-------+-----------+-----------+-----------+---------+------+-------+------------------+
    | 2824 | eximstats | localhost | eximstats | Sleep | 3364 | | |
    | 35397 | root | localhost | | Query | 0 | | show processlist |
    +-------+-----------+-----------+-----------+---------+------+-------+------------------+

    mysqladmin status
    Uptime: 29729 Threads: 2 Questions: 478947 Slow queries: 304 Opens: 424 Flush tables: 1 Open tables: 172 Queries per second avg: 16.110

    my.cnf
    [mysqld]
    set-variable = max_connections=350
    safe-show-database
    port=3306
    socket=/tmp/mysql.sock
    skip-locking
    connect_timeout=15
    key_buffer=16M
    join_buffer=1M
    record_buffer=1M
    sort_buffer=2M
    table_cache=1028
    thread_cache_size=286
    max_allowed_packet=5M
    wait_timeout=15
    query_cache_limit=1M
    query_cache_size=32M
    query_cache_type=1
    thread_concurrency=2

  4. #4
    Join Date
    Dec 2001
    Location
    NYC, NY
    Posts
    799
    its not a my.cnf issue.. its bad database layout for your clients
    Blog your life away
    http://photoblog.com

Posting Permissions

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