hostfry

Registered
Apr 11, 2010
2
0
51
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
 
Last edited: