consigli x velocizzare un vps

[Mattrace]

ciao a tutti

possiedo un vps linux(il server è collocato in america) con debian 3.1 pannello di controllo vhcs2

ho hostato 5 siti in html e purtroppo li carica troppo lentamente

i tempi di risposta del server dall'italia con conessione libero adsl 4mbps e di 160ms

la ram e di 384 mb

qualche consiglio x velocizzare l'apertura dei siti?

qualche dettaglio:

1) tipo di server: vps * siti hostati 7

2) Specifiche del server

velocità cpu / singolo o multiprocessore: 2 processori Intel(R) Pentium(R) D CPU 3.40GHz
Ram: 384mb
Tipo HD/configurazione: hdd 10gb
Sistema Operativo: debian sarge
apache/IIS version: Apache/2.0.54 (Debian GNU/Linux
PHP version: PHP/4.3.10-22
MySQL version: 4.0.24

3) no nessuno usa innodb

4)il mysqld è stato installato tramite apt-get install mysql

5)

top - 10:57:58 up 11:22, 1 user, load average: 0.00, 0.00, 0.00
Tasks: 42 total, 2 running, 40 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0% us, 0.2% sy, 0.0% ni, 99.8% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 393216k total, 266188k used, 127028k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1 root 15 0 1508 516 452 S 0.0 0.1 0:00.96 init
5327 root 16 0 1568 540 440 S 0.0 0.1 0:00.48 syslogd
5339 bind 18 0 47016 2604 1712 S 0.0 0.7 0:00.33 named
5350 root 19 0 1676 384 316 S 0.0 0.1 0:00.00 courierlogger
5351 root 16 0 1808 508 420 S 0.0 0.1 0:00.02 authdaemond.pla
5352 root 16 0 1808 244 156 S 0.0 0.1 0:00.00 authdaemond.pla
5353 root 16 0 1808 244 156 S 0.0 0.1 0:00.00 authdaemond.pla
5354 root 16 0 1808 244 156 S 0.0 0.1 0:00.01 authdaemond.pla
5355 root 16 0 1808 244 156 S 0.0 0.1 0:00.01 authdaemond.pla
5356 root 16 0 1808 244 156 S 0.0 0.1 0:00.02 authdaemond.pla
5367 root 16 0 1784 488 416 S 0.0 0.1 0:00.06 couriertcpd
5369 root 16 0 1684 472 400 S 0.0 0.1 0:00.02 courierlogger
5375 root 16 0 1784 488 416 S 0.0 0.1 0:00.07 couriertcpd
5378 root 16 0 1676 468 400 S 0.0 0.1 0:00.01 courierlogger
5394 root 18 0 2508 1232 1016 S 0.0 0.3 0:00.00 mysqld_safe
5441 root 18 0 2508 560 344 S 0.0 0.1 0:00.00 mysqld_safe
5442 mysql 16 0 128m 15m 3300 S 0.0 4.0 0:09.69 mysqld
5443 root 16 0 1500 508 440 S 0.0 0.1 0:00.00 logger
5700 root 16 0 2968 1164 984 S 0.0 0.3 0:00.17 master
5704 postfix 16 0 3020 1248 1032 S 0.0 0.3 0:00.01 qmgr
5710 root 16 0 3480 904 660 S 0.0 0.2 0:00.33 sshd
5714 root 18 0 1496 380 316 S 0.0 0.1 0:00.00 vhcs2_daemon
5721 nobody 16 0 4604 1312 620 S 0.0 0.3 0:00.35 proftpd
5724 daemon 16 0 1684 360 280 S 0.0 0.1 0:00.00 atd
5727 root 16 0 1776 744 604 S 0.0 0.2 0:00.06 cron
17878 root 16 0 14572 4824 3056 S 0.0 1.2 0:00.61 apache2
17880 www-data 16 0 19672 9756 2844 S 0.0 2.5 0:00.26 apache2
17881 www-data 15 0 20220 10m 2884 S 0.0 2.6 0:00.64 apache2
17882 www-data 15 0 20532 10m 2848 S 0.0 2.7 0:00.57 apache2
17883 www-data 15 0 20356 10m 3068 S 0.0 2.7 0:00.25 apache2
17884 www-data 16 0 20532 10m 2832 S 0.0 2.7 0:00.37 apache2
18282 www-data 16 0 20944 10m 2808 S 0.0 2.8 0:00.47 apache2
9290 www-data 16 0 20532 10m 2800 S 0.0 2.7 0:00.31 apache2
28534 postfix 15 0 2980 1116 944 S 0.0 0.3 0:00.00 pickup
20259 postfix 16 0 5480 2316 1860 S 0.0 0.6 0:00.00 smtpd
20328 www-data 16 0 14572 2736 948 S 0.0 0.7 0:00.00 apache2
3465 root 16 0 16508 1760 1408 S 0.0 0.4 0:00.00 sshd
5137 weba 16 0 16676 1404 1024 R 0.0 0.4 0:00.02 sshd
5139 weba 16 0 2560 1424 1148 S 0.0 0.4 0:00.00 bash
5234 root 15 0 2560 1424 1148 S 0.0 0.4 0:00.00 bash
11762 root 16 0 2728 444 360 S 0.0 0.1 0:00.00 imaplogin
12133 root 16 0 2068 1044 836 R 0.0 0.3 0:00.00 top

6)

#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "/var/lib/mysql/my.cnf" to set server-specific options or
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/se...variables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
#
# * Fine Tuning
#
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log = /var/log/mysql.log
#log = /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement
#
# Here you can see queries with especially long duration
#log-slow-queries = /var/log/mysql/mysql-slow.log
#
# The following can be used as easy to replay backup logs or for replication.
#server-id = 1
log-bin = /var/log/mysql/mysql-bin.log
# See /etc/mysql/debian-log-rotate.conf for the number of files kept.
max_binlog_size = 104857600
#binlog-do-db = include_database_name
#binlog-ignore-db = include_database_name
#
# * BerkeleyDB
#
# The use of BerkeleyDB is now discouraged and support for it will probably
# cease in the next versions.
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Feature
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# If you want to enable SSL support (recommended) read the manual or my
# HOWTO in /usr/share/doc/mysql-server/SSL-MINI-HOWTO.txt.gz
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem



[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer = 32M

7)

+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| back_log | 50 |
| basedir | /usr/ |
| bdb_cache_size | 8388600 |
| bdb_log_buffer_size | 0 |
| bdb_home | |
| bdb_max_lock | 10000 |
| bdb_logdir | |
| bdb_shared_data | OFF |
| bdb_tmpdir | |
| bdb_version | Sleepycat Software: Berkeley DB 3.2.9a: (March 5, 2005) |
| 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 | /var/lib/mysql/ |
| 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 | DISABLED |
| have_crypt | YES |
| have_innodb | YES |
| have_isam | YES |
| have_raid | YES |
| have_symlink | YES |
| have_openssl | NO |
| have_query_cache | YES |
| init_file | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| 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 |
| innodb_max_purge_lag | 0 |
| innodb_table_locks | ON |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 16777216 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_update | OFF |
| log_bin | ON |
| log_slave_updates | OFF |
| log_slow_queries | 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 | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 104857600 |
| max_connections | 100 |
| max_connect_errors | 10 |
| 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 | 0 |
| 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 | 8388608 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| open_files_limit | 1024 |
| pid_file | /var/run/mysqld/mysqld.pid |
| log_error | |
| port | 3306 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_size | 16777216 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 131072 |
| 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 | /var/run/mysqld/mysqld.sock |
| sort_buffer_size | 2097144 |
| sql_mode | 0 |
| table_cache | 64 |
| table_type | MYISAM |
| thread_cache_size | 0 |
| thread_stack | 131072 |
| tx_isolation | REPEATABLE-READ |
| timezone | CET |
| tmp_table_size | 33554432 |
| tmpdir | /tmp/ |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| version | 4.0.24_Debian-10sarge2-log |
| version_comment | Source distribution |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 28800 |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+--------------------------+----------+
| Variable_name | Value |
+--------------------------+----------+
| Aborted_clients | 0 |
| Aborted_connects | 2 |
| Bytes_received | 331882 |
| Bytes_sent | 16515176 |
| Com_admin_commands | 4 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 153 |
| Com_change_master | 0 |
| Com_check | 244 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_delete | 108 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 1 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 407 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_purge | 1 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 0 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 178 |
| Com_set_option | 46 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 1 |
| Com_show_create | 0 |
| Com_show_databases | 1 |
| Com_show_fields | 0 |
| Com_show_grants | 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_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 5 |
| Com_show_variables | 2 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 635 |
| Com_update_multi | 0 |
| Connections | 891 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_tables | 0 |
| Created_tmp_files | 3 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 94 |
| Handler_read_first | 20 |
| Handler_read_key | 365 |
| Handler_read_next | 5 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 16 |
| Handler_read_rnd_next | 20044543 |
| Handler_rollback | 0 |
| Handler_update | 59 |
| Handler_write | 407 |
| Key_blocks_used | 109 |
| Key_read_requests | 3089 |
| Key_reads | 107 |
| Key_write_requests | 1108 |
| Key_writes | 1118 |
| Max_used_connections | 2 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 64 |
| Open_files | 129 |
| Open_streams | 0 |
| Opened_tables | 284 |
| Questions | 3289 |
| Qcache_queries_in_cache | 43 |
| Qcache_inserts | 177 |
| Qcache_hits | 619 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 1 |
| Qcache_free_memory | 16121592 |
| Qcache_free_blocks | 3 |
| Qcache_total_blocks | 111 |
| Rpl_status | NULL |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 14 |
| Select_range_check | 0 |
| Select_scan | 25 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 0 |
| Sort_rows | 16 |
| Sort_scan | 2 |
| Table_locks_immediate | 1592 |
| Table_locks_waited | 0 |
| Threads_cached | 0 |
| Threads_created | 890 |
| Threads_connected | 1 |
| Threads_running | 1 |
| Uptime | 41074 |
+--------------------------+----------+
Uptime: 41074 Threads: 1 Questions: 3290 Slow queries: 0 Opens: 284 Flush tables: 1 Open tables: 64 Queries per second avg: 0.080
mysqladmin Ver 8.40 Distrib 4.0.24, for pc-linux-gnu on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult 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 4.0.24_Debian-10sarge2-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 11 hours 24 min 34 sec

Threads: 1 Questions: 3290 Slow queries: 0 Opens: 284 Flush tables: 1 Open tables: 64 Queries per second avg: 0.080

8) sono siti in html

9) http://ultraservers.info/info.php

10) Scrivete i seguenti dati della vostra configurazione di apache:

KeepAlive On
MaxKeepAliveRequests 200
KeepAliveTimeout 3
MinSpareServers 5
MaxSpareServers 15
StartServers 5
MaxClients 20
Maxrequestsperchild 2000

11) verificate cosa ritorna questo comando:

find: /etc/ssl/private: Permission denied
find: /root: Permission denied
find: /proc/sys/fs/quota: Permission denied
find: /proc/vz/vzaquota: Permission denied
find: /proc/1/task/1/fd: Permission denied

12) Scrivete il risultato dei seguenti 3 comandi:

uname -a

Linux server.ultraservers.info 2.6.9-023stab044.4-smp #1 SMP Mon May 28 2317 MSD 2007 i686 GNU/Linux

ulimit -aH

core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) unlimited
virtual memory (kbytes, -v) unlimited

cat /proc/cpuinfo

processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 6
model name : Intel(R) Pentium(R) D CPU 3.40GHz
stepping : 5
cpu MHz : 1696.476
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 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 mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc pni monitor ds_cpl est cid xtpr
bogomips : 6791.31

processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 6
model name : Intel(R) Pentium(R) D CPU 3.40GHz
stepping : 5
cpu MHz : 1696.476
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 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 mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc pni monitor ds_cpl est cid xtpr
bogomips : 6782.18

ringrazio in anticipo

[NikyAT1]

Se il problema è la latenza, c'è ben poco da fare. In fin dei conti c'è in mezzo un'oceano.

[WizOfOz]

portalo in europa almeno... cmq se i siti caricano lentamente non credo sia solo un problema di latenza..

[NikyAT1]

Sono d'accordo Wiz, però lui all'inizio parla di latenza di 160 ms.
Magari non ho capito una cippa. Bho?

[Mattrace]

non è la latenza secondo me

un altro problema che ho 384mb di ram e di solito i processi ne occupano 240mb

è possibile otimizzare il tutto?

[Shazan]

Se ci dai un link è più facile capire quale possa essere il problema.

[infinytech]

Tecnologia di virtualizzazione?