News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Here is my status.php can you guys tell me if this is good or not?

Started by khampster, December 11, 2006, 06:19:52 PM

Previous topic - Next topic

khampster

SMF Version: SMF 1.1
I am experencing a problem with my site.  currently I have no optimizer or whatever installed with this site, but I tried to raise my cache size with my hosting company (dot5hosting.com) they are not willing to help me out on that, so right now I am stuck with what I got now which is 256KB for table_cache.  Which is pretty low, I need to find a way to work this issue out so I can get the forum going again.  I have alot of members complaining about the speed of the forum how it "lags" on performance. 

If you guys have any thoughts or opinions to get this problem solved for me, would be appreciated.  I am running SMF 1.1 (latest model) and its slowing everyone down!! HELP!!


Simple Machines
Server Status
Basic Information
December 11, 2006, 03:24:02 PM
Operating System: FreeBSD 4.11-STABLE
Load averages: 36.79, 40.07, 45.75
Current processes: 204 (79 sleeping, 110 running, 15 zombie)
Processes by CPU: httpd (99) 37.8%, qmail-remote (1) 7.0%, clamd (1) 4.2%, perl5.8.3 (3) 4.6%, clamscan (1) 2.2%, perl (5) 2.0%, (other) (50) 0.8%
MySQL Statistics
MySQL 4.0.x
Connections per second: 0.5855
Kilobytes received per second: 2.7659
Kilobytes sent per second: 3.9717
Queries per second: 17.8735
Percentage of slow queries: 0.0001
Opened vs. Open tables:
(table_cache) 249.6406 (should be <= 80)
Table cache usage:
(table_cache) 1 (should be >= 0.5 and <= 0.9)
Key buffer read hit rate:
(key_buffer_size) 0.0075 (should be <= 0.01)
Key buffer write hit rate:
(key_buffer_size) 0.3908 (should be <= 0.5)
Thread cache hit rate:
(thread_cache_size) 171.9454 (should be >= 30 )
Thread cache usage:
(thread_cache_size) 0.5 (should be >= 0.7 and <= 0.9)
Temporary table disk usage:
(tmp_table_size) 0.1462 (should be <= 0.5)
Sort merge pass rate:
(sort_buffer) 0 (should be <= 0.001)
Query cache enabled:
(query_cache_type) 1 (should be >= 1 and <= 1)
Query cache miss rate:
(query_cache_limit) 0.2693 (should be <= 0.5)
Query cache prune rate:
(query_cache_size) 0.1027 (should be <= 0.05)

MySQL status
Aborted_clients: 2366
Aborted_connects: 657
Bytes_received: 792658928
Bytes_sent: 1138221639
Com_admin_commands: 247
Com_alter_table: 1064
Com_analyze: 0
Com_backup_table: 0
Com_begin: 1422
Com_change_db: 268161
Com_change_master: 0
Com_check: 0
Com_commit: 1403
Com_create_db: 7
Com_create_function: 0
Com_create_index: 0
Com_create_table: 687
Com_delete: 67959
Com_delete_multi: 0
Com_drop_db: 10
Com_drop_function: 0
Com_drop_index: 0
Com_drop_table: 42
Com_flush: 75
Com_grant: 0
Com_ha_close: 0
Com_ha_open: 0
Com_ha_read: 0
Com_insert: 219113
Com_insert_select: 1682
Com_kill: 0
Com_load: 0
Com_load_master_data: 0
Com_load_master_table: 0
Com_lock_tables: 284
Com_optimize: 820
Com_purge: 0
Com_rename_table: 0
Com_repair: 0
Com_replace: 3443
Com_replace_select: 0
Com_reset: 0
Com_restore_table: 0
Com_revoke: 0
Com_rollback: 0
Com_savepoint: 0
Com_select: 959448
Com_set_option: 542
Com_show_binlog_events: 0
Com_show_binlogs: 74
Com_show_create: 482
Com_show_databases: 111
Com_show_fields: 642
Com_show_grants: 551
Com_show_innodb_status: 0
Com_show_keys: 479
Com_show_logs: 0
Com_show_master_status: 0
Com_show_new_master: 0
Com_show_open_tables: 0
Com_show_processlist: 640
Com_show_slave_hosts: 0
Com_show_slave_status: 0
Com_show_status: 364
Com_show_tables: 4352
Com_show_variables: 265
Com_slave_start: 0
Com_slave_stop: 0
Com_truncate: 121
Com_unlock_tables: 290
Com_update: 630841
Com_update_multi: 0
Connections: 163864
Created_tmp_disk_tables: 18707
Created_tmp_files: 4
Created_tmp_tables: 127933
Delayed_errors: 0
Delayed_insert_threads: 0
Delayed_writes: 0
Flush_commands: 1
Handler_commit: 0
Handler_delete: 70568
Handler_read_first: 115697
Handler_read_key: 117759807
Handler_read_next: 317280089
Handler_read_prev: 2177775
Handler_read_rnd: 5305597
Handler_read_rnd_next: 915132512
Handler_rollback: 0
Handler_update: 69401740
Handler_write: 11107223
Key_blocks_used: 124690
Key_read_requests: 160194118
Key_reads: 1195460
Key_write_requests: 2201534
Key_writes: 860290
Max_used_connections: 93
Not_flushed_delayed_rows: 0
Not_flushed_key_blocks: 0
Open_files: 485
Open_streams: 0
Open_tables: 256
Opened_tables: 63908
Qcache_free_blocks: 2464
Qcache_free_memory: 27338632
Qcache_hits: 2603669
Qcache_inserts: 865065
Qcache_lowmem_prunes: 98527
Qcache_not_cached: 89382
Qcache_queries_in_cache: 15566
Qcache_total_blocks: 35418
Questions: 5002161
Rpl_status: NULL
Select_full_join: 36421
Select_full_range_join: 46
Select_range: 18375
Select_range_check: 92
Select_scan: 346893
Slave_open_temp_tables: 0
Slave_running: OFF
Slow_launch_threads: 3
Slow_queries: 403
Sort_merge_passes: 2
Sort_range: 84443
Sort_rows: 54172199
Sort_scan: 142956
Ssl_accept_renegotiates: 0
Ssl_accepts: 0
Ssl_callback_cache_hits: 0
Ssl_cipher:
Ssl_cipher_list:
Ssl_client_connects: 0
Ssl_connect_renegotiates: 0
Ssl_ctx_verify_depth: 0
Ssl_ctx_verify_mode: 0
Ssl_default_timeout: 0
Ssl_finished_accepts: 0
Ssl_finished_connects: 0
Ssl_session_cache_hits: 0
Ssl_session_cache_misses: 0
Ssl_session_cache_mode: NONE
Ssl_session_cache_overflows: 0
Ssl_session_cache_size: 0
Ssl_session_cache_timeouts: 0
Ssl_sessions_reused: 0
Ssl_used_session_cache_entries: 0
Ssl_verify_depth: 0
Ssl_verify_mode: 0
Ssl_version:
Table_locks_immediate: 2421689
Table_locks_waited: 2728
Threads_cached: 4
Threads_connected: 4
Threads_created: 953
Threads_running: 1
Uptime: 279864

MySQL variables
back_log: 50
basedir: /usr/local/mysql/
binlog_cache_size: 32768
bulk_insert_buffer_size: 8388608
character_set: latin1
character_sets: latin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin1_de latin2 latin5 sjis swe7 tis620 ujis usa7 win1250 win1251ukr win1251
concurrent_insert: ON
connect_timeout: 5
convert_character_set:
datadir: /usr/local/mysql/var/
default_week_format: 0
delay_key_write: ON
delayed_insert_limit: 100
delayed_insert_timeout: 300
delayed_queue_size: 1000
flush: OFF
flush_time: 0
ft_boolean_syntax: + -><()~*:""&|
ft_max_word_len: 254
ft_max_word_len_for_sort: 20
ft_min_word_len: 4
ft_stopword_file: (built-in)
have_bdb: NO
have_crypt: YES
have_innodb: DISABLED
have_isam: YES
have_openssl: YES
have_query_cache: YES
have_raid: NO
have_symlink: YES
init_file:
innodb_additional_mem_pool_size: 1048576
innodb_autoextend_increment: 8
innodb_buffer_pool_size: 8388608
innodb_data_file_path:
innodb_data_home_dir:
innodb_fast_shutdown: ON
innodb_file_io_threads: 4
innodb_flush_log_at_trx_commit: 1
innodb_flush_method:
innodb_force_recovery: 0
innodb_lock_wait_timeout: 50
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_table_locks: ON
innodb_thread_concurrency: 8
interactive_timeout: 28800
join_buffer_size: 131072
key_buffer_size: 134217728
language: /usr/local/mysql/share/mysql/english/
large_files_support: ON
license: GPL
local_infile: ON
log: OFF
log_bin: OFF
log_error:
log_slave_updates: OFF
log_slow_queries: OFF
log_update: OFF
log_warnings: 1
long_query_time: 10
low_priority_updates: OFF
lower_case_file_system: OFF
lower_case_table_names: 0
max_allowed_packet: 5241856
max_binlog_cache_size: 4294967295
max_binlog_size: 1073741824
max_connect_errors: 10
max_connections: 100
max_delayed_threads: 20
max_heap_table_size: 16777216
max_insert_delayed_threads: 20
max_join_size: 4294967295
max_relay_log_size: 0
max_seeks_for_key: 4294967295
max_sort_length: 1024
max_tmp_tables: 32
max_user_connections: 0
max_write_lock_count: 4294967295
myisam_max_extra_sort_file_size: 268435456
myisam_max_sort_file_size: 2147483647
myisam_recover_options: OFF
myisam_repair_threads: 1
myisam_sort_buffer_size: 67108864
net_buffer_length: 16384
net_read_timeout: 30
net_retry_count: 1000000
net_write_timeout: 60
new: OFF
open_files_limit: 16384
pid_file: /usr/local/mysql/var/df15.dot5hosting.com.pid
port: 3306
protocol_version: 10
query_alloc_block_size: 8192
query_cache_limit: 4194304
query_cache_size: 67108864
query_cache_type: ON
query_cache_wlock_invalidate: OFF
query_prealloc_size: 8192
range_alloc_block_size: 2048
read_buffer_size: 2093056
read_only: OFF
read_rnd_buffer_size: 4190208
rpl_recovery_rank: 0
server_id: 1
skip_external_locking: ON
skip_networking: OFF
skip_show_database: OFF
slave_net_timeout: 3600
slow_launch_time: 2
socket: /tmp/mysql.sock
sort_buffer_size: 4194296
sql_mode: 0
table_cache: 256
table_type: MYISAM
thread_cache_size: 8
thread_stack: 196608
timezone: PST
tmp_table_size: 33554432
tmpdir: /var/tmp/
transaction_alloc_block_size: 8192
transaction_prealloc_size: 4096
tx_isolation: REPEATABLE-READ
version: 4.0.27
version_comment: Source distribution
version_compile_os: unknown-freebsd4.11
wait_timeout: 30


Daniel15

QuoteLoad averages:    36.79, 40.07, 45.75
Sorry to say, but that's absolutely horrible!! No wonder why your site lags! Ideally, the load average should be less than 1 (and should definately not be about 5 or higher for an extended period). Is the load like that often? If so, you should really consider changing to a new web host.

As a comparison, here's the load average from a server I help administer (a server for cwhnetworks.com):

root@protious [~]# uptime
03:41:38 up 15 days, 14:32,  2 users,  load average: 0.46, 0.16, 0.15
Daniel15, former Customisation team member, resigned due to lack of time. I still love everyone here :D.
Go to smfshop.com for SMFshop support, do NOT email or PM me!

khampster

Quote from: Daniel15 on December 12, 2006, 04:44:34 AM
QuoteLoad averages:    36.79, 40.07, 45.75
Sorry to say, but that's absolutely horrible!! No wonder why your site lags! Ideally, the load average should be less than 1 (and should definately not be about 5 or higher for an extended period). Is the load like that often? If so, you should really consider changing to a new web host.

As a comparison, here's the load average from a server I help administer (a server for cwhnetworks.com):

root@protious [~]# uptime
03:41:38 up 15 days, 14:32,  2 users,  load average: 0.46, 0.16, 0.15


i will be considering in switching new hosts... this one is just being stupid, and the customer service wont work things out with me. give me some referrals and i will check them out :)

Christian A. Herrnboeck


1.00? Are you kidding? The only type of server that should have a max load of 1.00 is a single-core, single-cpu box. Most hosting servers are Dual-core, or Dual-CPU, or AT LEAST Hyperthreaded. Loads on these types of boxes can be 2 - 4 without any issues.

I know one server, is a dual-core, quad-cpu Xeon (5300 series CPU) which has load at around 6.50, and that equates to ~45% CPU usage.

Nevertheless, a load of 36.79, 40.07, 75.75 is typical of an oversold host, and will cause great performance troubles with dynamic scripts like SMF.


Regards,
Christian A. Herrnboeck


Farmers:Producing food for the world!

jerm

Have you been able to resolve this issue? Moving to a new host help you out?

Advertisement: