New Server, Optimization required... (vps)

محروم.كوم · #1 04-28-2009, 01:30 AM

1.

VPS

2.

Intel Core 2 Quad Q6600
Mem: 2026836k total
150 GB of HDD
PHP/5.2.8
Apache/2.0.63
cPanel 11.24.4-R35075 - WHM 11.24.2 - X 3.9
CENTOS 5.3 i686
MySQL: 4.1.22

3.

3.8.1

4. -
5. -

6.

top - 2350 up 52 min, 2 users, load average: 4.96, 4.35, 4.41
Tasks: 155 total, 9 running, 146 sleeping, 0 stopped, 0 zombie
Cpu(s): 21.8%us, 77.7%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.3%hi, 0.2%si, 0.0%st
Mem: 2026836k total, 994936k used, 1031900k free, 40696k buffers
Swap: 2031608k total, 0k used, 2031608k free, 552824k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3110 mysql 16 0 451m 82m 4204 S 172.8 4.2 58:47.35 mysqld
4615 radyodh 15 0 171m 6100 2476 R 3.7 0.3 1:11.60 sc_trans
7058 nobody 16 0 355m 13m 5312 S 3.7 0.7 0:01.64 httpd
7268 nobody 16 0 355m 13m 4740 R 3.3 0.7 0:00.58 httpd
7082 nobody 16 0 355m 14m 5544 S 2.3 0.7 0:01.36 httpd
6962 nobody 16 0 356m 16m 6744 S 1.7 0.8 0:02.81 httpd
6965 nobody 15 0 355m 15m 6856 S 1.3 0.8 0:02.46 httpd
6967 nobody 18 0 355m 15m 7216 R 1.3 0.8 0:02.20 httpd
7043 nobody 16 0 355m 14m 5924 S 1.3 0.7 0:01.64 httpd
7279 nobody 15 0 355m 13m 5212 S 1.3 0.7 0:00.37 httpd
4604 radyodh 15 0 38600 2200 748 S 1.0 0.1 0:19.37 sc_serv
6092 nobody 15 0 355m 19m 10m S 1.0 1.0 0:03.32 httpd
6722 nobody 15 0 355m 15m 6824 S 1.0 0.8 0:03.66 httpd
7052 nobody 15 0 355m 15m 6648 S 1.0 0.8 0:01.52 httpd
7049 nobody 18 0 355m 13m 4728 S 0.7 0.7 0:01.72 httpd
7317 nobody 16 0 355m 13m 4736 S 0.7 0.7 0:00.22 httpd

top - 23:39:41 up 53 min, 2 users, load average: 5.87, 4.76, 4.55
Tasks: 158 total, 1 running, 155 sleeping, 0 stopped, 2 zombie
Cpu0 : 19.7%us, 65.1%sy, 0.0%ni, 14.8%id, 0.0%wa, 0.0%hi, 0.4%si, 0.0%st
Cpu1 : 20.0%us, 41.3%sy, 0.0%ni, 38.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 2026836k total, 992152k used, 1034684k free, 40748k buffers
Swap: 2031608k total, 0k used, 2031608k free, 555036k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3110 mysql 15 0 439m 71m 4204 S 131.2 3.6 60:08.24 mysqld
7052 nobody 16 0 355m 15m 6648 S 11.7 0.8 0:01.92 httpd
7317 nobody 16 0 355m 16m 7596 S 9.8 0.8 0:00.55 httpd
7375 nobody 16 0 355m 13m 4696 S 9.8 0.7 0:00.36 httpd
7287 nobody 15 0 355m 13m 4764 S 7.8 0.7 0:00.75 httpd
6313 nobody 16 0 355m 15m 7196 S 5.9 0.8 0:02.03 httpd
4615 radyodh 15 0 171m 6100 2476 S 3.9 0.3 1:13.04 sc_trans
7350 root 15 0 2196 1044 796 R 3.9 0.1 0:00.24 top
4604 radyodh 15 0 38600 2200 748 S 2.0 0.1 0:19.89 sc_serv
1 root 15 0 2068 628 544 S 0.0 0.0 0:06.69 init
2 root RT -5 0 0 0 S 0.0 0.0 0:00.07 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.04 ksoftirqd/0
4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0
5 root RT -5 0 0 0 S 0.0 0.0 0:00.02 migration/1
6 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1

7.

[mysqld]
low_priority_updates=1
long_query_time = 4
concurrent_insert=2
datadir=/var/lib/mysql
query_cache_limit=4M
query_cache_size = 100M
query_cache_type = 1
max_connections=500
interactive_timeout=300
wait_timeout=100
connect_timeout=10
thread_cache_size=128
key_buffer=200M
join_buffer=1M
max_allowed_packet=16M
table_cache=2000
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
thread_concurrency=2
myisam_sort_buffer_size=64M
server-id=1
[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8000
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
log-queries-not-using-indexes

8.

| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 1815 |
| Com_insert_select | 4 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 25 |
| 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 | 118 |
| 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 | 45194 |
| Com_set_option | 240 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 1 |
| Com_show_charsets | 3 |
| Com_show_collations | 3 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 3 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 1 |
| 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 | 13 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 4 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 37 |
| Com_show_triggers | 0 |
| Com_show_variables | 11 |
| 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 | 4 |
| Com_unlock_tables | 25 |
| Com_update | 1754 |
| Com_update_multi | 23 |
| 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 | 1200 |
| Created_tmp_disk_tables | 136 |
| Created_tmp_files | 7 |
| Created_tmp_tables | 4164 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 143 |
| Handler_delete | 1100 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 1121 |
| Handler_read_key | 2407386 |
| Handler_read_next | 15270220 |
| Handler_read_prev | 3026 |
| Handler_read_rnd | 177302 |
| Handler_read_rnd_next | 932930871 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 51344 |
| Handler_write | 100250 |
| Innodb_buffer_pool_pages_data | 72 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 163 |
| Innodb_buffer_pool_pages_free | 439 |
| Innodb_buffer_pool_pages_latched | 0 |
| Innodb_buffer_pool_pages_misc | 1 |
| Innodb_buffer_pool_pages_total | 512 |
| Innodb_buffer_pool_read_ahead_rnd | 2 |

| Innodb_buffer_pool_read_ahead_seq | 0 |
| Innodb_buffer_pool_read_requests | 8118 |
| Innodb_buffer_pool_reads | 54 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 299 |
| Innodb_data_fsyncs | 146 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |

| Innodb_data_read | 3362816 |
| Innodb_data_reads | 73 |
| Innodb_data_writes | 269 |
| Innodb_data_written | 5400576 |
| Innodb_dblwr_pages_written | 163 |
| Innodb_dblwr_writes | 25 |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 33 |
| Innodb_log_writes | 58 |
| Innodb_os_log_fsyncs | 84 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 46080 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 0 |
| Innodb_pages_read | 72 |
| Innodb_pages_written | 163 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 0 |
| Innodb_row_lock_time_avg | 0 |
| Innodb_row_lock_time_max | 0 |
| Innodb_row_lock_waits | 0 |
| Innodb_rows_deleted | 0 |
| Innodb_rows_inserted | 27 |
| Innodb_rows_read | 143 |
| Innodb_rows_updated | 27 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 175795 |
| Key_blocks_used | 5964 |
| Key_read_requests | 6252302 |
| Key_reads | 5967 |
| Key_write_requests | 7633 |
| Key_writes | 4048 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 59 |
| Ndb_cluster_node_id | 0 |
| Ndb_config_from_host | |
| Ndb_config_from_port | 0 |
| Ndb_number_of_data_nodes | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 654 |
| Open_streams | 0 |
| Open_tables | 400 |
| Opened_tables | 422 |
| Prepared_stmt_count | 0 |
| Qcache_free_blocks | 494 |
| Qcache_free_memory | 92780864 |
| Qcache_hits | 73344 |
| Qcache_inserts | 40989 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 4245 |
| Qcache_queries_in_cache | 1350 |
| Qcache_total_blocks | 3559 |
| Questions | 134549 |
| Rpl_status | NULL |
| Select_full_join | 12 |
| Select_full_range_join | 0 |
| Select_range | 4652 |
| Select_range_check | 0 |
| Select_scan | 16936 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 1 |
| Slow_queries | 211 |
| Sort_merge_passes | 1 |
| Sort_range | 863 |
| Sort_rows | 647743 |
| Sort_scan | 12614 |
| Table_locks_immediate | 84059 |
| Table_locks_waited | 251 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 29 |
| Threads_connected | 30 |
| Threads_created | 59 |
| Threads_running | 1 |
| Uptime | 10652 |
| Uptime_since_flush_status | 10652 |
+-----------------------------------+------------+
Uptime: 10652 Threads: 30 Questions: 134564 Slow queries: 211 Opens: 422 Flush tables: 1 Open tables: 400 Queries per second avg: 12.633
mysqladmin Ver 8.41 Distrib 5.0.67, for redhat-linux-gnu on i686
Copyright (C) 2000-2006 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.0.67-community
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 2 hours 57 min 32 sec
Threads: 30 Questions: 134564 Slow queries: 211 Opens: 422 Flush tables: 1 Open tables: 400 Queries per second avg: 12.633
+------+---------------+-----------+---------------+---------+------+--------------+---------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+---------------+-----------+---------------+---------+------+--------------+---------------------------------------------------------------+
| 1080 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 8 | | |
| 1090 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 3 | | |
| 1096 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 6 | | |
| 1104 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 1 | | |
| 1108 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 4 | | |
| 1112 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 3 | | |
| 1136 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 1 | | |
| 1138 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 3 | | |
| 1145 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 5 | | |
| 1154 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 4 | | |
| 1161 | tahmin_tahmin | localhost | tahmin_tahmin | Query | 0 | Sending data | SELECT COUNT(*) AS posts FROM post WHERE dateline >1240778769 |
| 1165 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 6 | | |
| 1169 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 4 | | |
| 1170 | iek_fega | localhost | iek_kamyon | Sleep | 92 | | |
| 1171 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 0 | | |
| 1175 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 4 | | |
| 1176 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 4 | | |
| 1177 | iek_fega | localhost | iek_kamyon | Sleep | 67 | | |
| 1183 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 3 | | |
| 1184 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 7 | | |
| 1186 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 8 | | |
| 1187 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 4 | | |
| 1188 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 3 | | |
| 1189 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 2 | | |
| 1190 | tahmin_tahmin | localhost | tahmin_tahmin | Query | 0 | Sending data | SELECT COUNT(*) AS posts FROM post WHERE dateline >1240778769 |
| 1191 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 1 | | |
| 1193 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 5 | | |
| 1194 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 7 | | |
| 1195 | tahmin_tahmin | localhost | tahmin_tahmin | Sleep | 8 | | |
| 1199 | root | localhost | | Query | 0 | | show processlist |
+------+---------------+-----------+---------------+---------+------+--------------+---------------------------------------------------------------+

9.

Not only. Some users use SMF and Php-Nuke...

10.

250-350 on an average. ~2000 users and 60000-80000 page views a day.Cookie timeout - 86400

11.

http://tahminder.com/phpinfo.php

12.

KeepAlive On
MaxKeepAliveRequests 1000
KeepAliveTimeout 2
UseCanonicalName Off
AccessFileName .htaccess
DefaultType text/plain
HostnameLookups Off

StartServers 10
MinSpareServers 10
MaxSpareServers 15
MaxClients 180
MaxRequestsPerChild 1000

13. -

14.

root@lin1 [~]# uname -a
Linux lin1.wtchost.com 2.6.18-92.1.22.el5 #1 SMP Tue Dec 16 1243 EST 2008 i686 i686 i386 GNU/Linux

root@lin1 [~]# ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 32000
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) 32000
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

root@lin1 [~]# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz
stepping : 11
cpu MHz : 2399.439
cache size : 4096 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss nx lm constant_tsc pni cx16 lahf_lm
bogomips : 4802.52

processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz
stepping : 11
cpu MHz : 2399.439
cache size : 4096 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss nx lm constant_tsc pni cx16 lahf_lm
bogomips : 4800.65 __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
Server Optimization Requst - Moved to new server	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	08-02-2009 10:30 AM
Web Server + DB Server Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-29-2009 08:20 PM
Web Server + DB Server Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-29-2009 08:40 AM
Server Optimization Request. First time optimization	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-08-2009 04:40 AM
Server Optimization Request - Please help! Server loads way too high!	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-05-2009 02:00 AM