ciao alex
ti lascio i dati
1. TIPO SERVER: vps vmware
2. RAM 384mb
CPU AMD Athlon(tm) 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.
Codice:
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.
Codice:
#
# 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 = 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
# 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 = 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.
Codice:
| 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
LinkBack URL
About LinkBacks
Rispondi Citando
Originariamente Scritto da TheVice
Segnalibri