Jump to content
Sign in to follow this  
Alex

Configurazioni ottimali VPS

Recommended Posts

Per ottenere una configurazione ottimale per il vostro server è importante fornire i seguenti dati:

 

1) tipo di server: dedicato, vps, shared hosting e numero di siti ospitati sul server

 

2) Specifiche del server

 

velocità cpu / singolo o multiprocessore:

Ram:

Tipo HD/configurazione:

Sistema Operativo:

apache/IIS version:

PHP version:

MySQL version:

 

3) Se si usa mysql > 4.* specificare se sono presenti database o tabelle che usano InnoDB

 

4) Come è stato installato Mysql? (compilato a mano o precompilato)

 

5) eseguire "top" e scrivere il risultato

 

6) Copiare il file di configurazione my.cnf (o my.ini) escludendo eventuali password

 

7) il risultato di questo :

mysqlreport --all -tab /statistics.txt

entrare ssh e copiare il file statistics.txt

o alternativamente di:

mysqladmin -u root -p var ext stat ver

 

8) che tipologia di siti ci sono sul server?

 

9) linkate una pagina phpinfo

<?
phpinfo();
?>

 

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

 

KeepAlive

MaxKeepAliveRequests

KeepAliveTimeout

MinSpareServers

MaxSpareServers

StartServers

MaxClients

Maxrequestsperchild

 

11) verificate cosa ritorna questo comando:

find / -size +2000000k

12) Scrivete il risultato dei seguenti 3 comandi:

 

uname -a

 

ulimit -aH

 

cat /proc/cpuinfo

Share this post


Link to post
Share on other sites

ciao alex

 

ti lascio i dati

 

 

1. TIPO SERVER: vps vmware

 

2. RAM 384mb

CPU AMD Athlon 64 Processor 3400+

HD 20GB

APACHE 2.0.54

PHP 4.3.10-18

MYSQL 4.0.24_Debian-10sarge2-log

 

3.no non sono presenti le tabelle che usano innodb

 

4.installato tramite apt-get install mysql...

 

5.

top - 13:04:56 up 16:20, 2 users, load average: 0.00, 0.02, 0.00
Tasks: 101 total, 1 running, 99 sleeping, 1 stopped, 0 zombie
Cpu(s): 0.3% user, 14.2% system, 0.0% nice, 85.4% idle
Mem: 386700k total, 219496k used, 167204k free, 43300k buffers
Swap: 883532k total, 0k used, 883532k free, 110172k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
19046 root 19 0 1088 1088 848 R 0.7 0.3 0:00.18 top
1 root 8 0 504 504 448 S 0.0 0.1 0:00.16 init
2 root 8 0 0 0 0 S 0.0 0.0 0:00.01 keventd
3 root 19 19 0 0 0 S 0.0 0.0 0:00.03 ksoftirqd_CPU0
4 root 9 0 0 0 0 S 0.0 0.0 0:00.00 kswapd
5 root 9 0 0 0 0 S 0.0 0.0 0:00.00 bdflush
6 root 9 0 0 0 0 S 0.0 0.0 0:01.39 kupdated
47 root 9 0 0 0 0 S 0.0 0.0 0:05.53 kjournald
488 root 9 0 0 0 0 S 0.0 0.0 0:00.00 khubd
579 daemon 9 0 452 452 384 S 0.0 0.1 0:00.02 portmap
742 root 9 0 812 812 704 S 0.0 0.2 0:00.75 syslogd
745 root 9 0 1392 1388 480 S 0.0 0.4 0:00.19 klogd
796 lp 9 0 864 864 752 S 0.0 0.2 0:00.02 lpd
811 root 9 0 1236 1236 1148 S 0.0 0.3 0:00.02 mysqld_safe
847 root 9 0 1244 1244 1152 S 0.0 0.3 0:00.00 mysqld_safe
848 mysql 9 0 16428 16m 3544 S 0.0 4.2 0:00.38 mysqld
849 root 9 0 488 484 432 S 0.0 0.1 0:00.00 logger
850 mysql 9 0 16428 16m 3544 S 0.0 4.2 0:00.17 mysqld
851 mysql 9 0 16428 16m 3544 S 0.0 4.2 0:00.00 mysqld
852 mysql 9 0 16428 16m 3544 S 0.0 4.2 0:00.00 mysqld
853 mysql 9 0 16428 16m 3544 S 0.0 4.2 0:00.00 mysqld
854 mysql 9 0 16428 16m 3544 S 0.0 4.2 0:00.00 mysqld
857 mysql 9 0 16428 16m 3544 S 0.0 4.2 0:00.55 mysqld
858 mysql 9 0 16428 16m 3544 S 0.0 4.2 0:00.45 mysqld
859 mysql 9 0 16428 16m 3544 S 0.0 4.2 0:00.00 mysqld
860 mysql 9 0 16428 16m 3544 S 0.0 4.2 0:00.18 mysqld
895 root 8 0 788 788 704 S 0.0 0.2 0:00.02 inetd
1005 root 9 0 1524 1520 1376 S 0.0 0.4 0:00.20 sshd
1009 root 8 0 472 468 420 S 0.0 0.1 0:00.00 vhcs2_daemon
1013 root 9 0 932 932 836 S 0.0 0.2 0:00.03 rpc.statd
1020 nobody 9 0 2476 2476 1784 S 0.0 0.6 0:00.12 proftpd
1023 daemon 9 0 636 636 560 S 0.0 0.2 0:00.00 atd
1026 root 8 0 808 808 672 S 0.0 0.2 0:00.13 cron
1042 root 9 0 472 472 420 S 0.0 0.1 0:00.02 getty
1043 root 9 0 472 472 420 S 0.0 0.1 0:00.01 getty
1044 root 9 0 472 472 420 S 0.0 0.1 0:00.00 getty
1045 root 9 0 472 472 420 S 0.0 0.1 0:00.02 getty
1046 root 9 0 472 472 420 S 0.0 0.1 0:00.00 getty
1047 root 9 0 472 472 420 S 0.0 0.1 0:00.01 getty

 

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
# [url]http://dev.mysql.com/doc/mysql/en/server-system-variables.html[/url]
# 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 = 1048576
query_cache_size = 16777216
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 = 16M
vps223:~#
vps223:~# cat /etc/mysql/my.cnf
#
# 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
# [url]http://dev.mysql.com/doc/mysql/en/server-system-variables.html[/url]
# 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 = 1048576
query_cache_size = 16777216
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 = 16M

 

 

7.

 

| 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 | CST |
| 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 | 10 |
| Aborted_connects | 6 |
| Bytes_received | 732876 |
| Bytes_sent | 1736311 |
| Com_admin_commands | 126 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 158 |
| Com_change_master | 0 |
| Com_check | 60 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_delete | 105 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 1 |
| Com_flush | 1 |
| Com_grant | 1 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 384 |
| 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 | 2 |
| 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 | 2 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 1050 |
| Com_set_option | 122 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 16 |
| Com_show_create | 47 |
| Com_show_databases | 14 |
| Com_show_fields | 6 |
| Com_show_grants | 13 |
| Com_show_keys | 4 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 54 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 58 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 140 |
| Com_show_variables | 14 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 990 |
| Com_update_multi | 0 |
| Connections | 246 |
| Created_tmp_disk_tables | 2 |
| Created_tmp_tables | 16 |
| Created_tmp_files | 3 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 19 |
| Handler_read_first | 141 |
| Handler_read_key | 187 |
| Handler_read_next | 135 |
| Handler_read_prev | 4 |
| Handler_read_rnd | 178 |
| Handler_read_rnd_next | 886955 |
| Handler_rollback | 0 |
| Handler_update | 111 |
| Handler_write | 476 |
| Key_blocks_used | 308 |
| Key_read_requests | 1342 |
| Key_reads | 302 |
| Key_write_requests | 406 |
| Key_writes | 387 |
| Max_used_connections | 3 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 53 |
| Open_files | 108 |
| Open_streams | 0 |
| Opened_tables | 115 |
| Questions | 8422 |
| Qcache_queries_in_cache | 516 |
| Qcache_inserts | 858 |
| Qcache_hits | 4949 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 140 |
| Qcache_free_memory | 15579360 |
| Qcache_free_blocks | 16 |
| Qcache_total_blocks | 1093 |
| Rpl_status | NULL |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 0 |
| Select_range_check | 0 |
| Select_scan | 594 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 2 |
| Sort_rows | 178 |
| Sort_scan | 36 |
| Table_locks_immediate | 2948 |
| Table_locks_waited | 0 |
| Threads_cached | 0 |
| Threads_created | 245 |
| Threads_connected | 2 |
| Threads_running | 1 |
| Uptime | 58939 |
+--------------------------+----------+
Uptime: 58939 Threads: 2 Questions: 8423 Slow queries: 0 Opens: 115 Flush tables: 1 Open tables: 53 Queries per second avg: 0.143
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: 16 hours 22 min 19 sec
Threads: 2 Questions: 8423 Slow queries: 0 Opens: 115 Flush tables: 1 Open tables: 53 Queries per second avg: 0.143


8. sono hostati 5 siti php dinamici
9. myos.hopto.org/info.php
10.

KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 3

MinSpareServers 16
MaxSpareServers 32
StartServers 5
MaxClients 20
MaxRequestsPerChild 0


11.si torna
12.
uname -a Linux vps223 2.4.27-3-386 #1 Wed Dec 6 00:38:33 UTC 2006 i686 GNU/Linux

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


processor : 0
vendor_id : AuthenticAMD
cpu family : 15
model : 47
model name : AMD Athlon(tm) 64 Processor 3400+
stepping : 2
cpu MHz : 2210.978
cache size : 512 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 syscall mmxext lm 3dnowext 3dnow pni
bogomips : 4456.44

 

 

 

 

grazie in anticipo

Share this post


Link to post
Share on other sites

allora 1° cosa:

apt-get update
apt-get upgrade
apt-get dist-upgrade

tecnicamente dovrebbe portarti a php 4.4.* e apache 2.2.* (quest'ultimo è meno importante)

 

my.cnf puoi farlo diventare così:

[mysqld]
safe-show-database
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 = 256
wait_timeout = 120
connect_timeout = 10
tmp_table_size = 32M
max_heap_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 4M
query_cache_size = 80M
query_cache_type = 1
query_prealloc_size = 163840
query_alloc_block_size = 32768

[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

cambia i parametri di apache così:

KeepAlive - On
MaxKeepAliveRequests - 100
KeepAliveTimeout - 5
MinSpareServers - 10
MaxSpareServers - 15
StartServers - 10
MaxClients - 180

Maxrequestsperchild value = 1000

i load sono comunque bassi quindi il server già ora non è carico

ricordati di riavviare apache e mysql dopo aver editato le configurazioni

Share this post


Link to post
Share on other sites

@Alex

Curiosità: quali sono i parametri "critici" da dimensionare ad hoc in mysql, php, apache e che tipo di criterio conviene usare per determinarne il valore ?

In parole povere c'è un criterio di massima con cui poter fare un buon tuning

nelle config dei vari demoni dedicati a tener su servizi di hosting?

Share this post


Link to post
Share on other sites

tecnicamente è una cosa piuttosto empirica perchè dipende dal tipo di siti che devi tener su (da quanto sfruttano il database), da che demoni girano sulla macchina, dalle visite dei siti ecc ... non esiste una guida a una configurazione standard che vada sempre bene

Share this post


Link to post
Share on other sites

sarebbe comodo forse stendere quattro o cinque casi differenti con le relative configurazioni, anche se logicamente la cosa rimane sempre vaga, visto che non si hanno dati della macchina e dei siti che girano...però non so uno schema che calcoli i parametri per un semplice sito statico, per un sito dinamico con forum e tot consumi ecc

Share this post


Link to post
Share on other sites
@Alex

Curiosità: quali sono i parametri "critici" da dimensionare ad hoc in mysql, php, apache e che tipo di criterio conviene usare per determinarne il valore ?

In parole povere c'è un criterio di massima con cui poter fare un buon tuning

nelle config dei vari demoni dedicati a tener su servizi di hosting?

Comunque, per iniziare a smanettare con MySQL, basta scegliere il my.conf opportuno. Ce ne sono alcuni disponibili sul loro sito. Nella versione Windows sono inclusi nello zip e credo anche in quello Linux. Basta leggere i commenti in testa ed utilizzare quello che si reputa più opportuno. Tutto molto semplice e parecchio funzionale. Im MySQL lavorano bene! :approved:

Share this post


Link to post
Share on other sites

1) Vps VmWare

 

2) Specifiche del server

 

velocità cpu / singolo o multiprocessore: ***

Ram: 128 mb

Tipo HD/configurazione: ***

Sistema Operativo: Deabian Sarge

apache/IIS version: Apache 1.3.37

PHP version: 4.4.4

MySQL version: 4.1.10

 

3) Niente InnoDB

 

4) Mysql è stato installato dal mio provider, come pannello ho directadmin, non so se possa aiutare.

 

5) Come faccio a copiarlo tutto? ^^'

 

Intanto metto tutto quello che riesco a prendere con putty:

 

top - 15:35:30 up 10 days, 21:21,  1 user,  load average: 2.19, 0.81, 0.98
Tasks: 102 total,   4 running,  98 sleeping,   0 stopped,   0 zombie
Cpu(s): 16.5% us, 23.8% sy,  0.0% ni,  0.0% id, 41.8% wa,  0.0% hi, 17.9% si
Mem:    126888k total,   125472k used,     1416k free,      276k buffers
Swap:   248968k total,   133200k used,   115768k free,     6164k cached

 PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
9969 apache    18   0 21072 4316  17m R  7.4  3.4   0:00.25 httpd
2984 apache    16   0 28088 7348  17m S  6.4  5.8   2:00.88 httpd
  36 root       5 -10     0    0    0 S  6.1  0.0  55:06.91 kblockd/0
3001 apache    15   0 27776 6976  17m S  6.1  5.5   2:17.36 httpd
3149 apache    16   0 28784 6144  17m D  6.1  4.8   2:15.40 httpd
9972 apache    18   0 21488 4680  17m R  4.5  3.7   0:00.20 httpd
9973 apache    17   0 20940 4164  17m R  3.8  3.3   0:00.13 httpd
  48 root      15   0     0    0    0 S  2.6  0.0  21:26.85 kswapd0
4495 apache    15   0 28076 2992  17m S  1.0  2.4   1:52.74 httpd
9871 greys     16   0 14628 1396 5828 S  1.0  1.1   0:00.43 sshd
9970 root      17   0  2064 1080 1852 R  1.0  0.9   0:00.17 top
4498 apache    15   0 27832 7788  17m S  0.6  6.1   1:41.47 httpd
9978 mysql     16   0 42024 4164 5204 S  0.6  3.3   0:00.02 mysqld
1538 mysql     16   0 42024 4140 5204 S  0.3  3.3   1:01.04 mysqld
3153 apache    15   0 28204 6968  17m S  0.3  5.5   1:48.88 httpd
9979 mysql     16   0 42024 4164 5204 S  0.3  3.3   0:00.01 mysqld
   1 root      16   0  1504  212 1352 S  0.0  0.2   0:11.22 init
   2 root      34  19     0    0    0 S  0.0  0.0   0:00.50 ksoftirqd/0
   3 root       5 -10     0    0    0 S  0.0  0.0   0:15.89 events/0
   4 root       5 -10     0    0    0 S  0.0  0.0   0:00.02 khelper
   5 root      13 -10     0    0    0 S  0.0  0.0   0:00.00 kacpid
  49 root       5 -10     0    0    0 S  0.0  0.0   0:00.00 aio/0
 185 root      25   0     0    0    0 S  0.0  0.0   0:00.00 kseriod
 205 root      25   0     0    0    0 S  0.0  0.0   0:00.00 scsi_eh_0
 213 root      25   0     0    0    0 S  0.0  0.0   0:00.00 khubd
 276 root      24   0     0    0    0 S  0.0  0.0   0:00.00 pciehpd_event
 278 root      22   0     0    0    0 S  0.0  0.0   0:00.00 shpchpd_event
 311 root      15   0     0    0    0 D  0.0  0.0   7:01.01 kjournald
1249 daemon    15   0  1612   76 1440 S  0.0  0.1   0:00.01 portmap
1412 root      16   0  2260  300 2092 S  0.0  0.2   1:06.23 syslogd
1415 root      16   0  2444  168 1344 S  0.0  0.1   0:00.28 klogd
1422 bind      24   0 29468  352 4252 S  0.0  0.3   0:00.02 named
1448 root      16   0  2700  260 2368 S  0.0  0.2   1:12.63 da-popb4smtp
1452 nobody    17   0  5444  108 4964 S  0.0  0.1   0:01.63 directadmin
1456 mail      15   0  5816  108 4996 S  0.0  0.1   0:07.93 exim
1475 root      19   0  2504  148 2380 S  0.0  0.1   0:00.09 mysqld_safe
1483 root      23   0  2368  156 2196 S  0.0  0.1   0:00.00 inetd
1486 ftp       16   0  3052  356 2528 S  0.0  0.3   0:38.73 proftpd
1504 root      16   0  3472  268 3096 S  0.0  0.2   0:10.15 sshd
1549 root      16   0  2576  204 2256 S  0.0  0.2   0:22.05 vm-pop3d
1561 root      18   0  2376  180 2204 S  0.0  0.1   0:00.02 rpc.statd
1567 mysql     16   0 42024 4152 5204 S  0.0  3.3   1:11.96 mysqld
1568 mysql     20   0 42024 4152 5204 S  0.0  3.3   0:00.00 mysqld
1569 mysql     15   0 42024 4152 5204 S  0.0  3.3   0:00.00 mysqld
1570 mysql     16   0 42024 4152 5204 S  0.0  3.3   0:00.00 mysqld
1571 mysql     20   0 42024 4152 5204 S  0.0  3.3   0:00.00 mysqld
1573 daemon    16   0  1684  160 1520 S  0.0  0.1   0:00.45 atd
1576 root      15   0  1764  252 1576 S  0.0  0.2   0:40.81 cron
1580 mysql     16   0 42024 4152 5204 S  0.0  3.3   1:33.36 mysqld
1581 mysql     16   0 42024 4152 5204 S  0.0  3.3   2:53.12 mysqld
1582 mysql     16   0 42024 4152 5204 S  0.0  3.3   0:00.00 mysqld
1583 mysql     16   0 42024 4152 5204 S  0.0  3.3   1:06.22 mysqld
1586 root      19   0  1500  148 1336 S  0.0  0.1   0:00.32 getty
1587 root      17   0  1500  148 1336 S  0.0  0.1   0:00.02 getty
1588 root      16   0  1500  148 1336 S  0.0  0.1   0:00.01 getty

6) Il file my.cnf non lo trovo neanche dando un bel "find / -name my.cnf" quindi suppongo non ci sia

 

7) mysqladmin -u root -p var ext stat ver -----> come copio tutto il risultato? ^^'

 

8) Un paio di gallery fotografiche coppermine, il sito principale è in html con qualche pagina php generata con cutenews (www.greysanatomyitalia.com)

 

9) phpinfo: http://www.greysanatomyitalia.com/info.php

 

10)

 

KeepAlive On

MaxKeepAliveRequests 500

KeepAliveTimeout 5

MinSpareServers 5

MaxSpareServers 20

StartServers 8

MaxClients 450

MaxRequestsPerChild 1000

 

11)

vps-006:~# find / -size +2000000k

find: /proc/10189/task/10189/fd/4: No such file or directory

 

12)

 

vps-006:~# uname -a

Linux vps-006.noamweb.net 2.6.8-3-686 #1 Tue Dec 5 21:26:38 UTC 2006 i686 GNU/Linux

 

 

vps-006:~# 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

 

 

vps-006:~# cat /proc/cpuinfo

processor : 0

vendor_id : GenuineIntel

cpu family : 15

model : 4

model name : Intel® Xeon CPU 2.80GHz

stepping : 8

cpu MHz : 2800.182

cache size : 2048 KB

fdiv_bug : no

hlt_bug : no

f00f_bug : no

coma_bug : no

fpu : yes

fpu_exception : yes

cpuid level : 5

wp : yes

flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss nx pni ds_cpl

bogomips : 5439.48

 

 

Grazie mille in anticipo :)

Share this post


Link to post
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
Sign in to follow this  

×