SMF Support > Server Performance and Configuration
README: Checklist for performance problems
webvision:
thanks for sharing
faminsk:
I installed staus.php onto the server I am using. See the info I get from it below. Why am I not getting the Basic Info?
And now...what do I do with it? I think the server folks have the MySQL settings...
Please advise.
I am using SMF 1.1.1
--- Quote ---Basic Information
March 10, 2007, 09:50:39 AM
MySQL Statistics
MySQL 4.0.x
Connections per second: 9.611
Kilobytes received per second: 48.3823
Kilobytes sent per second: 42.3521
Queries per second: 285.3803
Percentage of slow queries: 0
Opened vs. Open tables:
(table_cache) 3225.4023 (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.0188 (should be <= 0.01)
Key buffer write hit rate:
(key_buffer_size) 0.2717 (should be <= 0.5)
Thread cache hit rate:
(thread_cache_size) 70.4363 (should be >= 30 )
Thread cache usage:
(thread_cache_size) 0.375 (should be >= 0.7 and <= 0.9)
Temporary table disk usage:
(tmp_table_size) 0.2726 (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.2248 (should be <= 0.5)
Query cache prune rate:
(query_cache_size) 0.5352 (should be <= 0.05)
MySQL status
Aborted_clients: 101
Aborted_connects: 8
Bytes_received: 2193784557
Bytes_sent: 1920357917
Com_admin_commands: 527
Com_alter_table: 73
Com_analyze: 1
Com_backup_table: 0
Com_begin: 998
Com_change_db: 640933
Com_change_master: 0
Com_check: 29
Com_commit: 446
Com_create_db: 1
Com_create_function: 0
Com_create_index: 0
Com_create_table: 23728
Com_delete: 124255
Com_delete_multi: 2
Com_drop_db: 1
Com_drop_function: 0
Com_drop_index: 0
Com_drop_table: 159
Com_flush: 3
Com_grant: 1
Com_ha_close: 0
Com_ha_open: 0
Com_ha_read: 0
Com_insert: 158618
Com_insert_select: 386
Com_kill: 0
Com_load: 0
Com_load_master_data: 0
Com_load_master_table: 0
Com_lock_tables: 2228
Com_optimize: 247
Com_purge: 0
Com_rename_table: 0
Com_repair: 36
Com_replace: 36858
Com_replace_select: 6
Com_reset: 0
Com_restore_table: 0
Com_revoke: 0
Com_rollback: 559
Com_savepoint: 0
Com_select: 2386983
Com_set_option: 63516
Com_show_binlog_events: 0
Com_show_binlogs: 30
Com_show_create: 44767
Com_show_databases: 34
Com_show_fields: 107665
Com_show_grants: 222
Com_show_keys: 1521
Com_show_logs: 0
Com_show_master_status: 0
Com_show_new_master: 0
Com_show_open_tables: 0
Com_show_processlist: 8
Com_show_slave_hosts: 0
Com_show_slave_status: 0
Com_show_status: 140
Com_show_innodb_status: 0
Com_show_tables: 53632
Com_show_variables: 3677
Com_slave_start: 0
Com_slave_stop: 0
Com_truncate: 19
Com_unlock_tables: 2245
Com_update: 316281
Connections: 425576
Created_tmp_disk_tables: 61507
Created_tmp_tables: 225653
Created_tmp_files: 81
Delayed_insert_threads: 0
Delayed_writes: 3
Delayed_errors: 0
Flush_commands: 1
Handler_commit: 218
Handler_delete: 123373
Handler_read_first: 467066
Handler_read_key: 79067871
Handler_read_next: 100441763
Handler_read_prev: 11379054
Handler_read_rnd: 12525976
Handler_read_rnd_next: 1440716491
Handler_rollback: 6491
Handler_update: 7499446
Handler_write: 17317002
Key_blocks_used: 249380
Key_read_requests: 148017336
Key_reads: 2783393
Key_write_requests: 1908123
Key_writes: 518383
Max_used_connections: 45
Not_flushed_key_blocks: 0
Not_flushed_delayed_rows: 0
Open_tables: 256
Open_files: 474
Open_streams: 0
Opened_tables: 825703
Questions: 12636639
Qcache_queries_in_cache: 19561
Qcache_inserts: 2034309
Qcache_hits: 8229453
Qcache_lowmem_prunes: 1277419
Qcache_not_cached: 348143
Qcache_free_memory: 21729776
Qcache_free_blocks: 7188
Qcache_total_blocks: 50437
Rpl_status: NULL
Select_full_join: 53557
Select_full_range_join: 6277
Select_range: 88980
Select_range_check: 89
Select_scan: 603249
Slave_open_temp_tables: 0
Slave_running: OFF
Slow_launch_threads: 0
Slow_queries: 444
Sort_merge_passes: 40
Sort_range: 145062
Sort_rows: 15502038
Sort_scan: 350626
Table_locks_immediate: 4392008
Table_locks_waited: 1157
Threads_cached: 3
Threads_created: 6042
Threads_connected: 22
Threads_running: 1
Uptime: 44280
MySQL variables
back_log: 50
basedir: /usr/local/mysql-4.0.20-hw/
binlog_cache_size: 32768
bulk_insert_buffer_size: 8388608
character_set: latin1
character_sets: latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
concurrent_insert: ON
connect_timeout: 300
convert_character_set:
datadir: /usr/local/mysql/data/
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_min_word_len: 4
ft_max_word_len: 254
ft_max_word_len_for_sort: 20
ft_stopword_file: (built-in)
have_bdb: NO
have_crypt: YES
have_innodb: YES
have_isam: YES
have_raid: NO
have_symlink: YES
have_openssl: NO
have_query_cache: YES
init_file:
innodb_additional_mem_pool_size: 1048576
innodb_buffer_pool_size: 8388608
innodb_data_file_path: ibdata1:10M:autoextend
innodb_data_home_dir:
innodb_file_io_threads: 4
innodb_force_recovery: 0
innodb_thread_concurrency: 8
innodb_flush_log_at_trx_commit: 1
innodb_fast_shutdown: ON
innodb_flush_method:
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_mirrored_log_groups: 1
innodb_max_dirty_pages_pct: 90
interactive_timeout: 28800
join_buffer_size: 131072
key_buffer_size: 268435456
language: /usr/local/mysql-4.0.20-hw/share/mysql/english/
large_files_support: ON
license: GPL
local_infile: ON
locked_in_memory: OFF
log: OFF
log_update: OFF
log_bin: OFF
log_slave_updates: OFF
log_slow_queries: ON
log_warnings: ON
long_query_time: 2
low_priority_updates: OFF
lower_case_file_system: OFF
lower_case_table_names: 0
max_allowed_packet: 16776192
max_binlog_cache_size: 4294967295
max_binlog_size: 1073741824
max_connections: 5000
max_connect_errors: 1000
max_delayed_threads: 20
max_insert_delayed_threads: 20
max_heap_table_size: 16777216
max_join_size: 4294967295
max_relay_log_size: 0
max_seeks_for_key: 4294967295
max_sort_length: 1024
max_user_connections: 20
max_tmp_tables: 32
max_write_lock_count: 4294967295
myisam_max_extra_sort_file_size: 268435456
myisam_max_sort_file_size: 2147483647
myisam_repair_threads: 1
myisam_recover_options: OFF
myisam_sort_buffer_size: 67108864
net_buffer_length: 16384
net_read_timeout: 30
net_retry_count: 10
net_write_timeout: 60
new: OFF
open_files_limit: 25010
pid_file: /usr/local/mysql/data/ldb400.van.ca.siteprotect.com.pid
log_error: /var/log/mysql/mysql-error.log
port: 3306
protocol_version: 10
query_alloc_block_size: 8192
query_cache_limit: 1048576
query_cache_size: 67108864
query_cache_type: ON
query_prealloc_size: 8192
range_alloc_block_size: 2048
read_buffer_size: 1044480
read_only: OFF
read_rnd_buffer_size: 262144
rpl_recovery_rank: 0
server_id: 1
slave_net_timeout: 3600
skip_external_locking: ON
skip_networking: OFF
skip_show_database: OFF
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: 126976
tx_isolation: REPEATABLE-READ
timezone: PST
tmp_table_size: 33554432
tmpdir: /tmp/
transaction_alloc_block_size: 8192
transaction_prealloc_size: 4096
version: 4.0.20-standard-log
version_comment: Official MySQL-standard binary
version_compile_os: pc-linux
wait_timeout: 28800
--- End quote ---
Daniel15:
--- Quote ---Why am I not getting the Basic Info?
--- End quote ---
Most likely, your web host disallows use of the system(), exec() or shell_exec() command. To check this, take a look at the disable_functions setting on a phpinfo page (What is phpinfo.php?) .
Note that it's a good idea to disable those functions ;)
faminsk:
Thanks....now if i can only figure out how to fix the indexing problems I am having and why some of these numbers are so whacked!!
Off the check phpinfo.php (that I know how to do).....OK back from checking.....there are no values in disable_functions
Travelin Man
haco:
thank you
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version