ColdFusion Hosting by CFDynamics - Dedicated Servers::
Find out more information on our Dedicated Enhanced plans. Full Server Backups Done Weekly. Patches for IIS, OS, CF, and SQL *Shared SQL servers are backed up nightly.
http://www.cfdynamics.com/dedicated/dedicatedhosting.cfmHOME |
Hello,
first of all, I don't know much how to use the WHM, because I am new on how to use it.
So, some questions I don't know how to answer to them! :(
1. It is on dedicated server.
2. Server Spec.:
Intel(R) Celeron(R) CPU 2.20GHz
1 gb ram
60GB HDD
Linux
Server Version: Apache/1.3.34 (Unix)
PHP/4.4.2
MySQL version 4.1.14-standard
3. if you use mysql 4.x instead of mysql 3.23.x, do you have
any innodb type databases/tables on your server ?
No.
8. vB is the only thing on the server.
9. average and max concurrent users on vB forum: 30usrs+40guests @ 15mins
12. vB version 3.5.3
Please, if you can help me in how to find the important information that you need in steps, I will do it.
well that looks very low cpu usage and lightly loaded on mysql
can you post the contents of your /etc/my.cnf file (use ssh telnet and type)
cat /etc/my.cnf
server load over 1 doesn't necessarily mean there's a problem unless your forum's performance is suffering
Also, I read some threads. So, do I need to apply what they gave us?
Like here: http://www.vbulletin.com/forum/showthread.php?threadid=69070 ?
Thanks alot. I made these steps at the time in which I have less members and vistors.
And the Server Load now is : 0.24 cpu
top
top - 01:35:48 up 15:18, 1 user, load average: 0.20, 0.16, 0.12
Tasks: 100 total, 1 running, 99 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0% us, 0.4% sy, 0.0% ni, 99.6% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 1036072k total, 880368k used, 155704k free, 51872k buffers
Swap: 2048248k total, 128k used, 2048120k free, 384244k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
25623 root 16 0 1952 948 748 R 0.4 0.1 0:00.10 top
1 root 16 0 1688 556 476 S 0.0 0.1 0:00.18 init
2 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
3 root RT 0 0 0 0 S 0.0 0.0 0:00.00 watchdog/0
4 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/0
5 root 13 -5 0 0 0 S 0.0 0.0 0:00.02 khelper
6 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kthread
8 root 10 -5 0 0 0 S 0.0 0.0 0:00.34 kblockd/0
9 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 kacpid
97 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 khubd
146 root 15 0 0 0 0 S 0.0 0.0 0:00.24 pdflush
148 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 aio/0
147 root 15 0 0 0 0 S 0.0 0.0 0:01.39 kswapd0
233 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kseriod
318 root 15 0 0 0 0 S 0.0 0.0 0:00.04 kjournald
1053 root 11 -5 1580 460 384 S 0.0 0.0 0:00.01 udevd
1220 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 kauditd
mysqladmin -u root -p var ext stat
pid_file /var/lib/mysql/host.qataru.com.pid
port 3306
preload_buffer_size 32768
protocol_version 10
query_alloc_block_size 8192
query_cache_limit 1048576
Dedicated Servers | Hostway Web Resources::
When you outgrow the shared server environment and need power, space and flexibility, transitioning your business to a dedicated server is an obvious choice.
http://www.hostway.com/web-resources/anatomy/dedicated-servers/HOME |
What is dedicated server? - A Word Definition From the ::
A dedicated server is a single computer in a network reserved for serving the needs of the network. A dedicated server could also be a computer that manages printer
http://www.webopedia.com/TERM/D/dedicated_server.htmlHOME |
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 2048
read_buffer_size 1044480
read_only OFF
read_rnd_buffer_size 262144
relay_log_purge ON
relay_log_space_limit 0
rpl_recovery_rank 0
secure_auth OFF
server_id 0
skip_external_locking ON
skip_networking OFF
skip_show_database OFF
slave_net_timeout 3600
slave_transaction_retries 0
slow_launch_time 2
socket /var/lib/mysql/mysql.sock
sort_buffer_size 1048568
sql_mode
storage_engine MyISAM
sql_notes OFF
sql_warnings OFF
sync_binlog 0
sync_replication 0
sync_replication_slave_id 0
sync_replication_timeout 0
sync_frm ON
system_time_zone EST
table_cache 512
table_type MyISAM
thread_cache_size 8
thread_stack 126976
time_format %H:%i:%s
time_zone SYSTEM
tmp_table_size 33554432
tmpdir
transaction_alloc_block_size 8192
transaction_prealloc_size 4096
tx_isolation REPEATABLE-READ
version 4.1.14-standard
version_comment MySQL Community Edition - Standard (GPL)
version_compile_machine i686
version_compile_os pc-linux-gnu
wait_timeout 20
+---------------------------------+------------------------------------------+
+----------------------------+------------+
Variable_name Value
+----------------------------+------------+
Aborted_clients 208
Aborted_connects 18
Binlog_cache_disk_use 0
Binlog_cache_use 0
Bytes_received 144686814
Bytes_sent 2279334624
Com_admin_commands 0
Com_alter_db 0
Com_alter_table 27
Com_analyze 0
Com_backup_table 0
Com_begin 3
Com_change_db 20700
Com_change_master 0
Com_check 323
Com_checksum 0
Com_commit 3
Com_create_db 2
Com_create_function 0
Com_create_index 37
Com_create_table 21
Com_dealloc_sql 0
Com_delete 3097
Com_delete_multi 0
Com_do 0
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 0
Com_drop_user 0
Com_execute_sql 0
Com_flush 12
Com_grant 35
Com_ha_close 0
Com_ha_open 0
Com_ha_read 0
Com_help 0
Com_insert 4499
Com_insert_select 212
Com_kill 0
Com_load 0
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 588
Com_optimize 323
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 2489
Com_replace_select 0
Com_reset 0
Com_restore_table 0
Com_revoke 2
Com_revoke_all 0
Com_rollback 0
Com_savepoint 0
Com_select 221702
Com_set_option 256
Com_show_binlog_events 0
Com_show_binlogs 1
Com_show_charsets 8
Com_show_collations 8
Com_show_column_types 0
Com_show_create_db 1
Com_show_create_table 30
Com_show_databases 24
Com_show_errors 0
Com_show_fields 30
Com_show_grants 7
Com_show_innodb_status 0
Com_show_keys 0
Com_show_logs 0
Com_show_master_status 0
Com_show_new_master 0
Com_show_open_tables 0
Com_show_privileges 0
Com_show_processlist 187
Com_show_slave_hosts 0
Com_show_slave_status 0
Com_show_status 3
Com_show_storage_engines 0
Com_show_tables 82
Com_show_variables 39
Com_show_warnings 0
Com_slave_start 0
Com_slave_stop 0
Com_stmt_prepare 0
Com_stmt_execute 0
Com_stmt_send_long_data 0
Com_stmt_reset 0
Com_stmt_close 0
Com_truncate 0
Com_unlock_tables 588
Com_update 33318
Com_update_multi 3
Connections 21116
Created_tmp_disk_tables 977
Created_tmp_files 5501
Created_tmp_tables 11410
Delayed_errors 0
Delayed_insert_threads 0
Delayed_writes 0
Flush_commands 1
Handler_commit 0
Handler_delete 5681
Handler_discover 0
Handler_read_first 26685
Handler_read_key 148756357
Handler_read_next 48091092
Handler_read_prev 144481
Handler_read_rnd 1129390
Handler_read_rnd_next 200453310
Handler_rollback 0
Handler_update 8711534
Handler_write 2064568
Key_blocks_not_flushed 0
Key_blocks_unused 416273
Key_blocks_used 134897
Key_read_requests 426011685
Key_reads 1125568
Key_write_requests 49926
Key_writes 37184
Max_used_connections 18
Not_flushed_delayed_rows 0
Open_files 304
Open_streams 0
Open_tables 184
Opened_tables 791
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
Questions 309652
Rpl_status NULL
Select_full_join 10
Select_full_range_join 0
Select_range 68487
Select_range_check 0
Select_scan 45209
Slave_open_temp_tables 0
Slave_running OFF
Slave_retried_transactions 0
Slow_launch_threads 12
Slow_queries 369
Sort_merge_passes 2749
Sort_range 28406
Sort_rows 177874685
Sort_scan 24765
Table_locks_immediate 436348
Table_locks_waited 3429
Threads_cached 7
Threads_connected 1
Threads_created 161
Threads_running 1
Uptime 55589
+----------------------------+------------+
Uptime: 55589 Threads: 1 Questions: 309653 Slow queries: 369 Opens: 791 Flush tables: 1 Open tables: 184 Queries per second avg: 5.570
df -h
Filesystem Size Used Avail Use% Mounted on
/dev/hda5 2.0G 521M 1.4G 28% /
/dev/hda1 99M 14M 81M 15% /boot
none 506M 0 506M 0% /dev/shm
/dev/hda8 58G 389M 55G 1% /home
/dev/hda7 1.5G 35M 1.4G 3% /tmp
/dev/hda3 3.9G 2.6G 1.2G 70% /usr
/dev/hda2 6.8G 1.3G 5.2G 20% /var
no no that thread is not what you need to do...
i need info asked at http://www.vbulletin.com/forum/showthread.php?t=70117
ssh telnet into your server and type the commands
top
mysqladmin -u root -p var ext stat
df -h
and post their outputs
Many thanks sir for your help ..
this is the contents of /etc/my.cnf file:
[mysqld]
set-variable = max_connections=1000
set-variable = wait_timeout=20
set-variable = max_connect_errors=1000
skip-locking
set-variable = key_buffer=488M
set-variable = max_allowed_packet=1M
set-variable = table_cache=512
set-variable = sort_buffer=1M
set-variable = record_buffer=1M
set-variable = myisam_sort_buffer_size=61M
set-variable = thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=2
#server-id = 1
[safe_mysqld]
open-files-limit = 8192
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
set-variable = key_buffer=488M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=488M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout
okay there's your problem values in my.cnf are set way too high for such a under powered celeron cpu server
do 2 things
1. change my.cnf to below one and restart mysql server
[mysqld]
safe-show-database
back_log = 50
skip-innodb
max_connections = 500
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 120
connect_timeout = 10
tmp_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384
default-storage-engine = MyISAM
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
2. Install APC Cache lastest version from http://pecl.php.net/package/APC. Read install guide at http://www.vbulletin.com/forum/showthread.php?t=165367
 Where was the last debate on wednesday with Mccain and Obama?
 INSTANCE / WAITING FOR SPRING
|
Server Optimisation for dedicated server !!