The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mysql and Server optimization request

Discussion in 'Workarounds and Optimization' started by hostfry, Dec 7, 2010.

  1. hostfry

    hostfry Registered

    Joined:
    Apr 11, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    I should mention that my websites are opening really slow and after a pause since i moved to new server.


    1- It is a dedicated server

    2- Server specs
    Code:
    Core AMD Phenom II X6 Thuban
    12GB DDR3 RAM
    250GB HDD
    cenots 
    cat /proc/cpuinfo

    Code:
    processor       : 0
    vendor_id       : AuthenticAMD
    cpu family      : 16
    model           : 10
    model name      : AMD Phenom(tm) II X6 1055T Processor
    stepping        : 0
    cpu MHz         : 800.000
    cache size      : 512 KB
    physical id     : 0
    siblings        : 6
    core id         : 0
    cpu cores       : 6
    apicid          : 0
    fdiv_bug        : no
    hlt_bug         : no
    f00f_bug        : no
    coma_bug        : no
    fpu             : yes
    fpu_exception   : yes
    cpuid level     : 6
    wp              : yes
    flags            : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat  pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb  rdtscp lm 3dnowext 3dnow constant_tsc nonstop_tsc pni cx16 popcnt  lahf_lm cmp_legacy svm extapic cr8legacy abm sse4a misalignsse  3dnowprefetch osvw ibs ts ttp tm stc 100mhzsteps hwpstate [8] [9]
    bogomips        : 1600.15
    
    processor       : 1
    vendor_id       : AuthenticAMD
    cpu family      : 16
    model           : 10
    model name      : AMD Phenom(tm) II X6 1055T Processor
    stepping        : 0
    cpu MHz         : 800.000
    cache size      : 512 KB
    physical id     : 0
    siblings        : 6
    core id         : 1
    cpu cores       : 6
    apicid          : 1
    fdiv_bug        : no
    hlt_bug         : no
    f00f_bug        : no
    coma_bug        : no
    fpu             : yes
    fpu_exception   : yes
    cpuid level     : 6
    wp              : yes
    flags            : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat  pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb  rdtscp lm 3dnowext 3dnow constant_tsc nonstop_tsc pni cx16 popcnt  lahf_lm cmp_legacy svm extapic cr8legacy abm sse4a misalignsse  3dnowprefetch osvw ibs ts ttp tm stc 100mhzsteps hwpstate [8] [9]
    bogomips        : 1600.15
    
    processor       : 2
    vendor_id       : AuthenticAMD
    cpu family      : 16
    model           : 10
    model name      : AMD Phenom(tm) II X6 1055T Processor
    stepping        : 0
    cpu MHz         : 800.000
    cache size      : 512 KB
    physical id     : 0
    siblings        : 6
    core id         : 2
    cpu cores       : 6
    apicid          : 2
    fdiv_bug        : no
    hlt_bug         : no
    f00f_bug        : no
    coma_bug        : no
    fpu             : yes
    fpu_exception   : yes
    cpuid level     : 6
    wp              : yes
    flags            : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat  pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb  rdtscp lm 3dnowext 3dnow constant_tsc nonstop_tsc pni cx16 popcnt  lahf_lm cmp_legacy svm extapic cr8legacy abm sse4a misalignsse  3dnowprefetch osvw ibs ts ttp tm stc 100mhzsteps hwpstate [8] [9]
    bogomips        : 1600.15
    
    processor       : 3
    vendor_id       : AuthenticAMD
    cpu family      : 16
    model           : 10
    model name      : AMD Phenom(tm) II X6 1055T Processor
    stepping        : 0
    cpu MHz         : 800.000
    cache size      : 512 KB
    physical id     : 0
    siblings        : 6
    core id         : 3
    cpu cores       : 6
    apicid          : 3
    fdiv_bug        : no
    hlt_bug         : no
    f00f_bug        : no
    coma_bug        : no
    fpu             : yes
    fpu_exception   : yes
    cpuid level     : 6
    wp              : yes
    flags            : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat  pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb  rdtscp lm 3dnowext 3dnow constant_tsc nonstop_tsc pni cx16 popcnt  lahf_lm cmp_legacy svm extapic cr8legacy abm sse4a misalignsse  3dnowprefetch osvw ibs ts ttp tm stc 100mhzsteps hwpstate [8] [9]
    bogomips        : 1600.15
    
    processor       : 4
    vendor_id       : AuthenticAMD
    cpu family      : 16
    model           : 10
    model name      : AMD Phenom(tm) II X6 1055T Processor
    stepping        : 0
    cpu MHz         : 800.000
    cache size      : 512 KB
    physical id     : 0
    siblings        : 6
    core id         : 4
    cpu cores       : 6
    apicid          : 4
    fdiv_bug        : no
    hlt_bug         : no
    f00f_bug        : no
    coma_bug        : no
    fpu             : yes
    fpu_exception   : yes
    cpuid level     : 6
    wp              : yes
    flags            : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat  pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb  rdtscp lm 3dnowext 3dnow constant_tsc nonstop_tsc pni cx16 popcnt  lahf_lm cmp_legacy svm extapic cr8legacy abm sse4a misalignsse  3dnowprefetch osvw ibs ts ttp tm stc 100mhzsteps hwpstate [8] [9]
    bogomips        : 1600.15
    
    processor       : 5
    vendor_id       : AuthenticAMD
    cpu family      : 16
    model           : 10
    model name      : AMD Phenom(tm) II X6 1055T Processor
    stepping        : 0
    cpu MHz         : 800.000
    cache size      : 512 KB
    physical id     : 0
    siblings        : 6
    core id         : 5
    cpu cores       : 6
    apicid          : 5
    fdiv_bug        : no
    hlt_bug         : no
    f00f_bug        : no
    coma_bug        : no
    fpu             : yes
    fpu_exception   : yes
    cpuid level     : 6
    wp              : yes
    flags            : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat  pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb  rdtscp lm 3dnowext 3dnow constant_tsc nonstop_tsc pni cx16 popcnt  lahf_lm cmp_legacy svm extapic cr8legacy abm sse4a misalignsse  3dnowprefetch osvw ibs ts ttp tm stc 100mhzsteps hwpstate [8] [9]
    bogomips        : 1600.15
    
    3- I am running Vbulletin 4.0x

    4- i am using MySQL Version 5.0.91-community-log with innodb database for vbulletin

    5- Don't know how it was compiled to installed.

    6- top
    Code:
    top - 12:48:40 up  1:45,  1 user,  load average: 22.85, 19.92, 21.12
    Tasks: 417 total,   2 running, 415 sleeping,   0 stopped,   0 zombie
    Cpu0  : 24.9%us, 29.9%sy,  0.0%ni,  0.0%id, 45.2%wa,  0.0%hi,  0.0%si,  0.0%st
    Cpu1  : 69.8%us, 26.9%sy,  0.0%ni,  0.0%id,  3.3%wa,  0.0%hi,  0.0%si,  0.0%st
    Cpu2  : 12.3%us, 32.9%sy,  0.0%ni, 37.9%id, 16.9%wa,  0.0%hi,  0.0%si,  0.0%st
    Cpu3  : 17.6%us, 31.9%sy,  0.0%ni,  0.0%id, 50.5%wa,  0.0%hi,  0.0%si,  0.0%st
    Cpu4  : 20.2%us, 39.7%sy,  0.0%ni,  0.0%id, 38.4%wa,  0.0%hi,  1.7%si,  0.0%st
    Cpu5  : 29.7%us, 18.7%sy,  0.0%ni, 10.7%id, 40.3%wa,  0.0%hi,  0.7%si,  0.0%st
    Mem:  12211496k total, 10571768k used,  1639728k free,   371880k buffers
    Swap:  5406712k total,        0k used,  5406712k free,  5483008k cached
    
    7- my.cnf configuration
    Code:
    mysqld]
    set-variable = max_connections=500
    log-slow-queries
    safe-show-database
    8- mysqlreport
    Code:
    MySQL 5.0.91-community-  uptime 0 2:9:54        Tue Dec  7 13:14:21 2010
    
    __ Key _________________________________________________________________
    Buffer used     7.08M of   8.00M  %Used:  88.48
      Current       7.94M            %Usage:  99.33
    Write hit      93.10%
    Read hit       98.41%
    
    __ Questions ___________________________________________________________
    Total         930.78k   119.4/s
      DMS         794.44k   101.9/s  %Total:  85.35
      Com_         91.20k    11.7/s            9.80
      COM_QUIT     44.95k     5.8/s            4.83
      +Unknown        190     0.0/s            0.02
    Slow 10 s      18.98k     2.4/s            2.04  %DMS:   2.39  Log:  ON
    DMS           794.44k   101.9/s           85.35
      SELECT      728.93k    93.5/s           78.31         91.75
      UPDATE       33.92k     4.4/s            3.64          4.27
      INSERT       18.07k     2.3/s            1.94          2.28
      DELETE       12.57k     1.6/s            1.35          1.58
      REPLACE         944     0.1/s            0.10          0.12
    Com_           91.20k    11.7/s            9.80
      change_db    53.03k     6.8/s            5.70
      set_option   37.74k     4.8/s            4.05
      show_tables     186     0.0/s            0.02
    
    __ SELECT and Sort _____________________________________________________
    Scan          124.46k    16.0/s %SELECT:  17.07
    Range          97.92k    12.6/s           13.43
    Full join      10.75k     1.4/s            1.48
    Range check         0       0/s            0.00
    Full rng join       0       0/s            0.00
    Sort scan      88.93k    11.4/s
    Sort range     29.74k     3.8/s
    Sort mrg pass  48.56k     6.2/s
    
    __ Table Locks _________________________________________________________
    Waited         20.20k     2.6/s  %Total:   1.74
    Immediate       1.14M   146.4/s
    
    __ Tables ______________________________________________________________
    Open              317 of   64    %Cache: 495.31
    Opened          1.07M   137.0/s
    
    __ Connections _________________________________________________________
    Max used          266 of  500      %Max:  53.20
    Total          44.96k     5.8/s
    
    __ Created Temp ________________________________________________________
    Disk table     27.85k     3.6/s
    Table          62.57k     8.0/s    Size:  32.0M
    File           33.43k     4.3/s
    
    __ Threads _____________________________________________________________
    Running           229 of  236
    Cached              0 of    0      %Hit:      0
    Created        44.95k     5.8/s
    Slow                0       0/s
    
    __ Aborted _____________________________________________________________
    Clients             7     0.0/s
    Connects            4     0.0/s
    
    __ Bytes _______________________________________________________________
    Sent            4.22G  541.1k/s
    Received      328.54M   42.2k/s
    
    __ InnoDB Buffer Pool __________________________________________________
    Usage           8.00M of   8.00M  %Used: 100.00
    Read hit       97.40%
    Pages
      Free              0            %Total:   0.00
      Data            508                     99.22 %Drty:   3.35
      Misc              4                      0.78
      Latched                                  0.00
    Reads         227.51M   29.2k/s
      From file     5.91M   758.3/s            2.60
      Ahead Rnd    202591    26.0/s
      Ahead Sql    755711    97.0/s
    Writes        118.96k    15.3/s
    Flushes        32.13k     4.1/s
    Wait Free           0       0/s
    
    __ InnoDB Lock _________________________________________________________
    Waits              63     0.0/s
    Current             0
    Time acquiring
      Total         68498 ms
      Average        1087 ms
      Max           25150 ms
    
    __ InnoDB Data, Pages, Rows ____________________________________________
    Data
      Reads         7.70M   987.3/s
      Writes       45.13k     5.8/s
      fsync        20.02k     2.6/s
      Pending
        Reads           0
        Writes          0
        fsync           1
    
    Pages
      Created         445     0.1/s
      Read         15.86M    2.0k/s
      Written      32.13k     4.1/s
    
    Rows
      Deleted       1.10k     0.1/s
      Inserted      3.83k     0.5/s
      Read        627.98M   80.6k/s
      Updated      10.04k     1.3/s
    
    9- I am using other scripts like wordpress too on the server

    10- average users are almost 600 guests and 100 members with cookie time of 1 hr.

    11- no optimizations done in httpd.conf

    12- uname -a
    Code:
    Linux host1.mobicreed.com 2.6.18-194.26.1.el5PAE #1 SMP Tue Nov 9 13:34:42 EST 2  010 i686 athlon i386 GNU/Linux
    
    ulimit -aH
    Code:
    core file size          (blocks, -c) unlimited
    data seg size           (kbytes, -d) unlimited
    scheduling priority             (-e) 0
    file size               (blocks, -f) unlimited
    pending signals                 (-i) 204800
    max locked memory       (kbytes, -l) 32
    max memory size         (kbytes, -m) unlimited
    open files                      (-n) 1024
    pipe size            (512 bytes, -p) 8
    POSIX message queues     (bytes, -q) 819200
    real-time priority              (-r) 0
    stack size              (kbytes, -s) unlimited
    cpu time               (seconds, -t) unlimited
    max user processes              (-u) 204800
    virtual memory          (kbytes, -v) unlimited
    file locks                      (-x) unlimited
    
    13- Database Index Size

    Code:
    +------------------+
    | Total Index Size |
    +------------------+
    | 849.06 MB        |
    +------------------+
    1 row in set (41.32 sec)
    Total Size of Table Data
    Code:
    +-----------------+
    | Total Data Size |
    +-----------------+
    | 3163.74 MB      |
    +-----------------+
    1 row in set (8.52 sec)
    
    mysqlstatus

    Code:
    Aborted_clients     7
    Aborted_connects     4
    Binlog_cache_disk_use     0
    Binlog_cache_use     0
    Bytes_received     392630257
    Bytes_sent     3247811009
    Com_admin_commands     95
    Com_alter_db     0
    Com_alter_table     0
    Com_analyze     0
    Com_backup_table     0
    Com_begin     0
    Com_call_procedure     0
    Com_change_db     64828
    Com_change_master     0
    Com_check     0
    Com_checksum     0
    Com_commit     0
    Com_create_db     0
    Com_create_function     0
    Com_create_index     0
    Com_create_table     10
    Com_create_user     0
    Com_dealloc_sql     0
    Com_delete     14934
    Com_delete_multi     0
    Com_do     0
    Com_drop_db     0
    Com_drop_function     0
    Com_drop_index     0
    Com_drop_table     10
    Com_drop_user     0
    Com_execute_sql     0
    Com_flush     2
    Com_grant     2
    Com_ha_close     0
    Com_ha_open     0
    Com_ha_read     0
    Com_help     0
    Com_insert     21250
    Com_insert_select     10
    Com_kill     0
    Com_load     0
    Com_load_master_data     0
    Com_load_master_table     0
    Com_lock_tables     27
    Com_optimize     0
    Com_preload_keys     0
    Com_prepare_sql     0
    Com_purge     0
    Com_purge_before_date     0
    Com_rename_table     0
    Com_repair     0
    Com_replace     1128
    Com_replace_select     0
    Com_reset     0
    Com_restore_table     0
    Com_revoke     0
    Com_revoke_all     0
    Com_rollback     0
    Com_savepoint     0
    Com_select     878551
    Com_set_option     44646
    Com_show_binlog_events     0
    Com_show_binlogs     1
    Com_show_charsets     1
    Com_show_collations     1
    Com_show_column_types     0
    Com_show_create_db     0
    Com_show_create_table     0
    Com_show_databases     1
    Com_show_errors     0
    Com_show_fields     65
    Com_show_grants     4
    Com_show_innodb_status     0
    Com_show_keys     0
    Com_show_logs     0
    Com_show_master_status     0
    Com_show_ndb_status     0
    Com_show_new_master     0
    Com_show_open_tables     0
    Com_show_privileges     0
    Com_show_processlist     33
    Com_show_slave_hosts     0
    Com_show_slave_status     0
    Com_show_status     10
    Com_show_storage_engines     0
    Com_show_tables     192
    Com_show_triggers     0
    Com_show_variables     10
    Com_show_warnings     0
    Com_slave_start     0
    Com_slave_stop     0
    Com_stmt_close     0
    Com_stmt_execute     0
    Com_stmt_fetch     0
    Com_stmt_prepare     0
    Com_stmt_reset     0
    Com_stmt_send_long_data     0
    Com_truncate     10
    Com_unlock_tables     27
    Com_update     40336
    Com_update_multi     37
    Com_xa_commit     0
    Com_xa_end     0
    Com_xa_prepare     0
    Com_xa_recover     0
    Com_xa_rollback     0
    Com_xa_start     0
    Compression     OFF
    Connections     54253
    Created_tmp_disk_tables     33885
    Created_tmp_files     40146
    Created_tmp_tables     75211
    Delayed_errors     0
    Delayed_insert_threads     0
    Delayed_writes     0
    Flush_commands     1
    Handler_commit     16286
    Handler_delete     11783
    Handler_discover     0
    Handler_prepare     0
    Handler_read_first     249532
    Handler_read_key     232157635
    Handler_read_next     2275547901
    Handler_read_prev     50178357
    Handler_read_rnd     17178033
    Handler_read_rnd_next     1180790138
    Handler_rollback     0
    Handler_savepoint     0
    Handler_savepoint_rollback     0
    Handler_update     94717318
    Handler_write     546686031
    Innodb_buffer_pool_pages_data     506
    Innodb_buffer_pool_pages_dirty     16
    Innodb_buffer_pool_pages_flushed     38324
    Innodb_buffer_pool_pages_free     0
    Innodb_buffer_pool_pages_misc     6
    Innodb_buffer_pool_pages_total     512
    Innodb_buffer_pool_read_ahead_rnd     242025
    Innodb_buffer_pool_read_ahead_seq     895876
    Innodb_buffer_pool_read_requests     268457824
    Innodb_buffer_pool_reads     6941795
    Innodb_buffer_pool_wait_free     0
    Innodb_buffer_pool_write_requests     144662
    Innodb_data_fsyncs     23690
    Innodb_data_pending_fsyncs     1
    Innodb_data_pending_reads     0
    Innodb_data_pending_writes     0
    Innodb_data_read     3079409664
    Innodb_data_reads     9052192
    Innodb_data_writes     53654
    Innodb_data_written     1274426880
    Innodb_dblwr_pages_written     38324
    Innodb_dblwr_writes     4987
    Innodb_log_waits     0
    Innodb_log_write_requests     24602
    Innodb_log_writes     13420
    Innodb_os_log_fsyncs     13761
    Innodb_os_log_pending_fsyncs     1
    Innodb_os_log_pending_writes     0
    Innodb_os_log_written     18476544
    Innodb_page_size     16384
    Innodb_pages_created     543
    Innodb_pages_read     18800044
    Innodb_pages_written     38324
    Innodb_row_lock_current_waits     0
    Innodb_row_lock_time     77214
    Innodb_row_lock_time_avg     989
    Innodb_row_lock_time_max     25150
    Innodb_row_lock_waits     78
    Innodb_rows_deleted     1691
    Innodb_rows_inserted     4435
    Innodb_rows_read     744331097
    Innodb_rows_updated     12017
    Key_blocks_not_flushed     0
    Key_blocks_unused     4969
    Key_blocks_used     7245
    Key_read_requests     1111373930
    Key_reads     18311270
    Key_write_requests     3423673
    Key_writes     206772
    Last_query_cost     0.000000
    Max_used_connections     266
    Not_flushed_delayed_rows     0
    Open_files     89
    Open_streams     0
    Open_tables     64
    Opened_tables     1239596
    Prepared_stmt_count     0
    Qcache_free_blocks     0
    Qcache_free_memory     0
    Qcache_hits     0
    Qcache_inserts     0
    Qcache_lowmem_prunes     0
    Qcache_not_cached     0
    Qcache_queries_in_cache     0
    Qcache_total_blocks     0
    Queries     1120948
    Questions     1120948
    Rpl_status     NULL
    Select_full_join     12617
    Select_full_range_join     0
    Select_range     117816
    Select_range_check     0
    Select_scan     148152
    Slave_open_temp_tables     0
    Slave_retried_transactions     0
    Slave_running     OFF
    Slow_launch_threads     0
    Slow_queries     22257
    Sort_merge_passes     58745
    Sort_range     35928
    Sort_rows     60389557
    Sort_scan     106756
    Table_locks_immediate     1375942
    Table_locks_waited     22877
    Tc_log_max_pages_used     0
    Tc_log_page_size     0
    Tc_log_page_waits     0
    Threads_cached     0
    Threads_connected     29
    Threads_created     54252
    Threads_running     8
    Uptime     9231
    mysqlvariables
    Code:
    auto_increment_increment     1
    auto_increment_offset     1
    automatic_sp_privileges     ON
    back_log     50
    basedir     /
    binlog_cache_size     32768
    bulk_insert_buffer_size     8388608
    character_set_client     latin1
    character_set_connection     latin1
    character_set_database     latin1
    character_set_filesystem     binary
    character_set_results     latin1
    character_set_server     latin1
    character_set_system     utf8
    character_sets_dir     /usr/share/mysql/charsets/
    collation_connection     latin1_swedish_ci
    collation_database     latin1_swedish_ci
    collation_server     latin1_swedish_ci
    completion_type     0
    concurrent_insert     1
    connect_timeout     10
    datadir     /var/lib/mysql/
    date_format     %Y-%m-%d
    datetime_format     %Y-%m-%d %H:%i:%s
    default_week_format     0
    delay_key_write     ON
    delayed_insert_limit     100
    delayed_insert_timeout     300
    delayed_queue_size     1000
    div_precision_increment     4
    keep_files_on_create     OFF
    engine_condition_pushdown     OFF
    expire_logs_days     0
    flush     OFF
    flush_time     0
    ft_boolean_syntax     + -><()~*:""&|
    ft_max_word_len     84
    ft_min_word_len     4
    ft_query_expansion_limit     20
    ft_stopword_file     (built-in)
    group_concat_max_len     1024
    have_archive     YES
    have_bdb     NO
    have_blackhole_engine     YES
    have_compress     YES
    have_community_features     NO
    have_profiling     NO
    have_crypt     YES
    have_csv     YES
    have_dynamic_loading     YES
    have_example_engine     YES
    have_federated_engine     YES
    have_geometry     YES
    have_innodb     YES
    have_isam     NO
    have_merge_engine     YES
    have_ndbcluster     NO
    have_openssl     NO
    have_ssl     NO
    have_query_cache     YES
    have_raid     NO
    have_rtree_keys     YES
    have_symlink     YES
    hostname     host1.mobicreed.com
    init_connect      
    init_file      
    init_slave      
    innodb_additional_mem_pool_size     1048576
    innodb_autoextend_increment     8
    innodb_buffer_pool_awe_mem_mb     0
    innodb_buffer_pool_size     8388608
    innodb_checksums     ON
    innodb_commit_concurrency     0
    innodb_concurrency_tickets     500
    innodb_data_file_path     ibdata1:10M:autoextend
    innodb_data_home_dir      
    innodb_adaptive_hash_index     ON
    innodb_doublewrite     ON
    innodb_fast_shutdown     1
    innodb_file_io_threads     4
    innodb_file_per_table     OFF
    innodb_flush_log_at_trx_commit     1
    innodb_flush_method      
    innodb_force_recovery     0
    innodb_lock_wait_timeout     50
    innodb_locks_unsafe_for_binlog     OFF
    innodb_log_arch_dir      
    innodb_log_archive     OFF
    innodb_log_buffer_size     1048576
    innodb_log_file_size     5242880
    innodb_log_files_in_group     2
    innodb_log_group_home_dir     ./
    innodb_max_dirty_pages_pct     90
    innodb_max_purge_lag     0
    innodb_mirrored_log_groups     1
    innodb_open_files     300
    innodb_rollback_on_timeout     OFF
    innodb_support_xa     ON
    innodb_sync_spin_loops     20
    innodb_table_locks     ON
    innodb_thread_concurrency     8
    innodb_thread_sleep_delay     10000
    innodb_use_legacy_cardinality_algorithm     ON
    interactive_timeout     28800
    join_buffer_size     131072
    key_buffer_size     8384512
    key_cache_age_threshold     300
    key_cache_block_size     1024
    key_cache_division_limit     100
    language     /usr/share/mysql/english/
    large_files_support     ON
    large_page_size     0
    large_pages     OFF
    lc_time_names     en_US
    license     GPL
    local_infile     ON
    locked_in_memory     OFF
    log     OFF
    log_bin     OFF
    log_bin_trust_function_creators     OFF
    log_error      
    log_queries_not_using_indexes     OFF
    log_slave_updates     OFF
    log_slow_queries     ON
    log_warnings     1
    long_query_time     10
    low_priority_updates     OFF
    lower_case_file_system     OFF
    lower_case_table_names     0
    max_allowed_packet     1048576
    max_binlog_cache_size     4294963200
    max_binlog_size     1073741824
    max_connect_errors     10
    max_connections     500
    max_delayed_threads     20
    max_error_count     64
    max_heap_table_size     16777216
    max_insert_delayed_threads     20
    max_join_size     18446744073709551615
    max_length_for_sort_data     1024
    max_prepared_stmt_count     16382
    max_relay_log_size     0
    max_seeks_for_key     4294967295
    max_sort_length     1024
    max_sp_recursion_depth     0
    max_tmp_tables     32
    max_user_connections     0
    max_write_lock_count     4294967295
    multi_range_count     256
    myisam_data_pointer_size     6
    myisam_max_sort_file_size     2146435072
    myisam_mmap_size     4294967295
    myisam_recover_options     OFF
    myisam_repair_threads     1
    myisam_sort_buffer_size     8388608
    myisam_stats_method     nulls_unequal
    net_buffer_length     16384
    net_read_timeout     30
    net_retry_count     10
    net_write_timeout     60
    new     OFF
    old_passwords     OFF
    open_files_limit     2500
    optimizer_prune_level     1
    optimizer_search_depth     62
    pid_file     /var/lib/mysql/host1.mobicreed.com.pid
    plugin_dir      
    port     3306
    preload_buffer_size     32768
    protocol_version     10
    query_alloc_block_size     8192
    query_cache_limit     1048576
    query_cache_min_res_unit     4096
    query_cache_size     0
    query_cache_type     ON
    query_cache_wlock_invalidate     OFF
    query_prealloc_size     8192
    range_alloc_block_size     4096
    read_buffer_size     131072
    read_only     OFF
    read_rnd_buffer_size     262144
    relay_log      
    relay_log_index      
    relay_log_info_file     relay-log.info
    relay_log_purge     ON
    relay_log_space_limit     0
    rpl_recovery_rank     0
    secure_auth     OFF
    secure_file_priv      
    server_id     0
    skip_external_locking     ON
    skip_networking     OFF
    skip_show_database     OFF
    slave_compressed_protocol     OFF
    slave_load_tmpdir     /tmp/
    slave_net_timeout     3600
    slave_skip_errors     OFF
    slave_transaction_retries     10
    slow_launch_time     2
    socket     /var/lib/mysql/mysql.sock
    sort_buffer_size     2097144
    sql_big_selects     ON
    sql_mode      
    sql_notes     ON
    sql_warnings     OFF
    ssl_ca      
    ssl_capath      
    ssl_cert      
    ssl_cipher      
    ssl_key      
    storage_engine     MyISAM
    sync_binlog     0
    sync_frm     ON
    system_time_zone     EST
    table_cache     64
    table_lock_wait_timeout     50
    table_type     MyISAM
    thread_cache_size     0
    thread_stack     196608
    time_format     %H:%i:%s
    time_zone     SYSTEM
    timed_mutexes     OFF
    tmp_table_size     33554432
    tmpdir     /tmp/
    transaction_alloc_block_size     8192
    transaction_prealloc_size     4096
    tx_isolation     REPEATABLE-READ
    updatable_views_with_limit     YES
    version     5.0.91-community-log
    version_comment     MySQL Community Edition (GPL)
    version_compile_machine     i686
    version_compile_os     pc-linux-gnu
    wait_timeout     28800
     
    #1 hostfry, Dec 7, 2010
    Last edited: Dec 7, 2010
Loading...

Share This Page