Jump to content
Sign in to follow this  
Alex

Configurazioni ottimali VPS

Recommended Posts

4) mysql Ver 14.7 Distrib 4.1.10, for pc-linux-gnu (i686)

6) /etc/my.cnf non c`e` il file

7)

+---------------------------------+--------------------------------------------------------------------------+
| Variable_name                   | Value                                                                    |
+---------------------------------+--------------------------------------------------------------------------+
| back_log                        | 50                                                                       |
| basedir                         | /usr/local/mysql-standard-4.1.10-pc-linux-gnu-i686/                      |
| binlog_cache_size               | 32768                                                                    |
| bulk_insert_buffer_size         | 8388608                                                                  |
| character_set_client            | latin1                                                                   |
| character_set_connection        | latin1                                                                   |
| character_set_database          | latin1                                                                   |
| character_set_results           | latin1                                                                   |
| character_set_server            | latin1                                                                   |
| character_set_system            | utf8                                                                     |
| character_sets_dir              | /usr/local/mysql-standard-4.1.10-pc-linux-gnu-i686/share/mysql/charsets/ |
| collation_connection            | latin1_swedish_ci                                                        |
| collation_database              | latin1_swedish_ci                                                        |
| collation_server                | latin1_swedish_ci                                                        |
| concurrent_insert               | ON                                                                       |
| connect_timeout                 | 5                                                                        |
| datadir                         | /usr/local/mysql/data/                                                   |
| date_format                     | %Y-%m-%d                                                                 |
| datetime_format                 | %Y-%m-%d %H:%i:%s                                                        |
| default_week_format             | 0                                                                        |
| delay_key_write                 | ON                                                                       |
| delayed_insert_limit            | 100                                                                      |
| delayed_insert_timeout          | 300                                                                      |
| delayed_queue_size              | 1000                                                                     |
| expire_logs_days                | 0                                                                        |
| flush                           | OFF                                                                      |
| flush_time                      | 0                                                                        |
| ft_boolean_syntax               | + -><()~*:""&|                                                           |
| ft_max_word_len                 | 84                                                                       |
| ft_min_word_len                 | 4                                                                        |
| ft_query_expansion_limit        | 20                                                                       |
| ft_stopword_file                | (built-in)                                                               |
| group_concat_max_len            | 1024                                                                     |
| have_archive                    | YES                                                                      |
| have_bdb                        | NO                                                                       |
| have_compress                   | YES                                                                      |
| have_crypt                      | YES                                                                      |
| have_csv                        | NO                                                                       |
| have_example_engine             | NO                                                                       |
| have_geometry                   | YES                                                                      |
| have_innodb                     | YES                                                                      |
| have_isam                       | NO                                                                       |
| have_ndbcluster                 | NO                                                                       |
| have_openssl                    | NO                                                                       |
| have_query_cache                | YES                                                                      |
| have_raid                       | NO                                                                       |
| have_rtree_keys                 | YES                                                                      |
| have_symlink                    | YES                                                                      |
| init_connect                    |                                                                          |
| init_file                       |                                                                          |
| init_slave                      |                                                                          |
| innodb_additional_mem_pool_size | 1048576                                                                  |
| innodb_autoextend_increment     | 8                                                                        |
| innodb_buffer_pool_awe_mem_mb   | 0                                                                        |
| innodb_buffer_pool_size         | 8388608                                                                  |
| innodb_data_file_path           | ibdata1:10M:autoextend                                                   |
| innodb_data_home_dir            |                                                                          |
| innodb_fast_shutdown            | ON                                                                       |
| innodb_file_io_threads          | 4                                                                        |
| innodb_file_per_table           | OFF                                                                      |
| innodb_flush_log_at_trx_commit  | 1                                                                        |
| innodb_flush_method             |                                                                          |
| innodb_force_recovery           | 0                                                                        |
| innodb_lock_wait_timeout        | 50                                                                       |
| innodb_locks_unsafe_for_binlog  | OFF                                                                      |
| 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_max_dirty_pages_pct      | 90                                                                       |
| innodb_max_purge_lag            | 0                                                                        |
| innodb_mirrored_log_groups      | 1                                                                        |
| innodb_open_files               | 300                                                                      |
| innodb_table_locks              | ON                                                                       |
| innodb_thread_concurrency       | 8                                                                        |
| interactive_timeout             | 28800                                                                    |
| join_buffer_size                | 131072                                                                   |
| key_buffer_size                 | 8388600                                                                  |
| key_cache_age_threshold         | 300                                                                      |
| key_cache_block_size            | 1024                                                                     |
| key_cache_division_limit        | 100                                                                      |
| language                        | /usr/local/mysql-standard-4.1.10-pc-linux-gnu-i686/share/mysql/english/  |
| large_files_support             | ON                                                                       |
| license                         | GPL                                                                      |
| local_infile                    | ON                                                                       |
| locked_in_memory                | OFF                                                                      |
| log                             | OFF                                                                      |
| log_bin                         | OFF                                                                      |
| log_error                       |                                                                          |
| log_slave_updates               | OFF                                                                      |
| log_slow_queries                | OFF                                                                      |
| log_update                      | 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              | 1048576                                                                  |
| max_binlog_cache_size           | 4294967295                                                               |
| max_binlog_size                 | 1073741824                                                               |
| max_connect_errors              | 10                                                                       |
| max_connections                 | 100                                                                      |
| max_delayed_threads             | 20                                                                       |
| max_error_count                 | 64                                                                       |
| max_heap_table_size             | 16777216                                                                 |
| max_insert_delayed_threads      | 20                                                                       |
| max_join_size                   | 4294967295                                                               |
| max_length_for_sort_data        | 1024                                                                     |
| max_relay_log_size              | 0                                                                        |
| max_seeks_for_key               | 4294967295                                                               |
| max_sort_length                 | 1024                                                                     |
| max_tmp_tables                  | 32                                                                       |
| max_user_connections            | 0                                                                        |
| max_write_lock_count            | 4294967295                                                               |
| myisam_data_pointer_size        | 4                                                                        |
| myisam_max_extra_sort_file_size | 2147483648                                                               |
| myisam_max_sort_file_size       | 2147483647                                                               |
| myisam_recover_options          | OFF                                                                      |
| myisam_repair_threads           | 1                                                                        |
| myisam_sort_buffer_size         | 8388608                                                                  |
| net_buffer_length               | 16384                                                                    |
| net_read_timeout                | 30                                                                       |
| net_retry_count                 | 10                                                                       |
| net_write_timeout               | 60                                                                       |
| new                             | OFF                                                                      |
| old_passwords                   | OFF                                                                      |
| open_files_limit                | 1024                                                                     |
| pid_file                        | /usr/local/mysql/data/vps-006.pid                                        |
| port                            | 3306                                                                     |
| preload_buffer_size             | 32768                                                                    |
| protocol_version                | 10                                                                       |
| query_alloc_block_size          | 8192                                                                     |
| query_cache_limit               | 1048576                                                                  |
| 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                | 131072                                                                   |
| read_only                       | OFF                                                                      |
| read_rnd_buffer_size            | 262144                                                                   |
| relay_log_purge                 | ON                                                                       |
| 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                                                                     |
| slow_launch_time                | 2                                                                        |
| socket                          | /tmp/mysql.sock                                                          |
| sort_buffer_size                | 2097144                                                                  |
| sql_mode                        |                                                                          |
| storage_engine                  | MyISAM                                                                   |
| sync_binlog                     | 0                                                                        |
| sync_replication                | 0                                                                        |
| sync_replication_slave_id       | 0                                                                        |
| sync_replication_timeout        | 0                                                                        |
| sync_frm                        | ON                                                                       |
| system_time_zone                | CET                                                                      |
| table_cache                     | 64                                                                       |
| table_type                      | MyISAM                                                                   |
| thread_cache_size               | 0                                                                        |
| 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.10-standard                                                          |
| version_comment                 | MySQL Community Edition - Standard (GPL)                                 |
| version_compile_machine         | i686                                                                     |
| version_compile_os              | pc-linux-gnu                                                             |
| wait_timeout                    | 28800                                                                    |
+---------------------------------+--------------------------------------------------------------------------+
+--------------------------+------------+
| Variable_name            | Value      |
+--------------------------+------------+
| Aborted_clients          | 6          |
| Aborted_connects         | 15         |
| Binlog_cache_disk_use    | 0          |
| Binlog_cache_use         | 0          |
| Bytes_received           | 349397849  |
| Bytes_sent               | 1450299856 |
| Com_admin_commands       | 1          |
| Com_alter_db             | 0          |
| Com_alter_table          | 34         |
| Com_analyze              | 0          |
| Com_backup_table         | 0          |
| Com_begin                | 0          |
| Com_change_db            | 85403      |
| Com_change_master        | 0          |
| Com_check                | 0          |
| Com_checksum             | 0          |
| Com_commit               | 0          |
| Com_create_db            | 0          |
| Com_create_function      | 0          |
| Com_create_index         | 0          |
| Com_create_table         | 12         |
| Com_dealloc_sql          | 0          |
| Com_delete               | 234401     |
| Com_delete_multi         | 0          |
| Com_do                   | 0          |
| Com_drop_db              | 0          |
| Com_drop_function        | 0          |
| Com_drop_index           | 0          |
| Com_drop_table           | 1          |
| Com_drop_user            | 0          |
| Com_execute_sql          | 0          |
| Com_flush                | 0          |
| Com_grant                | 0          |
| Com_ha_close             | 0          |
| Com_ha_open              | 0          |
| Com_ha_read              | 0          |
| Com_help                 | 0          |
| Com_insert               | 29817      |
| 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             | 41         |
| Com_preload_keys         | 0          |
| Com_prepare_sql          | 0          |
| Com_purge                | 0          |
| Com_purge_before_date    | 0          |
| Com_rename_table         | 0          |
| Com_repair               | 1          |
| Com_replace              | 58         |
| 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               | 1892072    |
| Com_set_option           | 990        |
| Com_show_binlog_events   | 0          |
| Com_show_binlogs         | 15         |
| Com_show_charsets        | 78         |
| Com_show_collations      | 78         |
| Com_show_column_types    | 0          |
| Com_show_create_db       | 0          |
| Com_show_create_table    | 48         |
| Com_show_databases       | 157        |
| Com_show_errors          | 0          |
| Com_show_fields          | 75         |
| Com_show_grants          | 25         |
| Com_show_innodb_status   | 0          |
| Com_show_keys            | 15         |
| 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     | 4          |
| Com_show_slave_hosts     | 0          |
| Com_show_slave_status    | 0          |
| Com_show_status          | 14         |
| Com_show_storage_engines | 2          |
| Com_show_tables          | 197        |
| Com_show_variables       | 193        |
| Com_show_warnings        | 0          |
| Com_slave_start          | 0          |
| Com_slave_stop           | 0          |
| Com_truncate             | 6          |
| Com_unlock_tables        | 0          |
| Com_update               | 106848     |
| Com_update_multi         | 0          |
| Connections              | 81027      |
| Created_tmp_disk_tables  | 11678      |
| Created_tmp_files        | 4          |
| Created_tmp_tables       | 20900      |
| Delayed_errors           | 0          |
| Delayed_insert_threads   | 0          |
| Delayed_writes           | 0          |
| Flush_commands           | 1          |
| Handler_commit           | 0          |
| Handler_delete           | 28632      |
| Handler_discover         | 0          |
| Handler_read_first       | 312167     |
| Handler_read_key         | 7334139    |
| Handler_read_next        | 140394912  |
| Handler_read_prev        | 2750309    |
| Handler_read_rnd         | 10970285   |
| Handler_read_rnd_next    | 129870402  |
| Handler_rollback         | 0          |
| Handler_update           | 2400889    |
| Handler_write            | 17241574   |
| Key_blocks_not_flushed   | 0          |
| Key_blocks_unused        | 6967       |
| Key_blocks_used          | 344        |
| Key_read_requests        | 64979461   |
| Key_reads                | 4476       |
| Key_write_requests       | 128159     |
| Key_writes               | 102658     |
| Max_used_connections     | 17         |
| Not_flushed_delayed_rows | 0          |
| Open_files               | 106        |
| Open_streams             | 0          |
| Open_tables              | 64         |
| Opened_tables            | 4097       |
| 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                | 2431629    |
| Rpl_status               | NULL       |
| Select_full_join         | 609        |
| Select_full_range_join   | 0          |
| Select_range             | 59741      |
| Select_range_check       | 624        |
| Select_scan              | 324798     |
| Slave_open_temp_tables   | 0          |
| Slave_running            | OFF        |
| Slow_launch_threads      | 391        |
| Slow_queries             | 35         |
| Sort_merge_passes        | 0          |
| Sort_range               | 175577     |
| Sort_rows                | 10980440   |
| Sort_scan                | 28711      |
| Table_locks_immediate    | 2445806    |
| Table_locks_waited       | 1746       |
| Threads_cached           | 0          |
| Threads_connected        | 4          |
| Threads_created          | 81026      |
| Threads_running          | 1          |
| Uptime                   | 1092390    |
+--------------------------+------------+
Uptime: 1092390  Threads: 4  Questions: 2431630  Slow queries: 35  Opens: 4097  Flush tables: 1  Open tables: 64  Queries per second avg: 2.226
mysqladmin  Ver 8.41 Distrib 4.1.10, for pc-linux-gnu on i686
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.1.10-standard
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /tmp/mysql.sock
Uptime:                 12 days 15 hours 26 min 30 sec

Threads: 4  Questions: 2431630  Slow queries: 35  Opens: 4097  Flush tables: 1  Open tables: 64  Queries per second avg: 2.226

Grazie mille ancora :)

Share this post


Link to post
Share on other sites

httpd.conf

 

KeepAlive - On

MaxKeepAliveRequests - 100

KeepAliveTimeout - 5

MinSpareServers - 5

MaxSpareServers - 10

StartServers - 5

MaxClients - 150

 

e poi configurare mysql copia questo in /etc/my.cnf (crealo ex novo)

[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 500
key_buffer = 32M
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 = 25
connect_timeout = 10
tmp_table_size = 64M
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 = 2M
query_cache_size = 32M
query_cache_type = 1
query_prealloc_size = 163840
query_alloc_block_size = 32768
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

nota servirà sostituire PASSWORD con la pass dell'utente root di mysql

e restartare apache e mysql

Share this post


Link to post
Share on other sites

1) tipo di server:

 

dedicato

 

numero di siti ospitati sul server:

 

attualmente 4 tutti dinamici :blog FlatPress (database solo su files) su http://server.clans.it , joomla su www.samyweb.it , sito pesante http://www.damage-inc.it (joomla con virtuemart).

In esecuzione server teamspeak http://ts.clans.it con massimo una decina di persone collegate, rarissimamente più di 10.

In via di trasferimento un sito molto pesante (SMF, Coppermine e scripts hand-made su MySQL : http://daoc.clans.it)

 

2) Specifiche del server

 

Netdirekt - pagina del prodotto

PIII 733Mhz

256 MB

HD 10 GB

Linux Debian Sarge

apache2_2.0.54-5sarge1_i386

PHP 5.2.1-0.dotdeb.1 with Suhosin-Patch 0.9.6.2 (cli)

MySQL 5.0.32-Dotdeb_1.dotdeb.1-log

(mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i386) using readline 4.3)

 

3)niente InnoDB

 

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

 

5) top"

top - 04:19:39 up 15 days, 22:18,  1 user,  load average: 0.13, 0.08, 0.07
Tasks:  90 total,   1 running,  89 sleeping,   0 stopped,   0 zombie
Cpu(s):  0.3% us,  0.3% sy,  0.0% ni, 99.0% id,  0.0% wa,  0.0% hi,  0.3% si
Mem:    255380k total,   216796k used,    38584k free,     5452k buffers
Swap:  2096472k total,    77404k used,  2019068k free,    64320k cached

 PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
11260 samyweb8  16   0 14616 1936 5824 S  0.3  0.8   0:03.75 sshd
18589 root      16   0  2064 1068 1852 R  0.3  0.4   0:00.05 top
   1 root      16   0  1504  460 1352 S  0.0  0.2   0:01.10 init
   2 root      RT   0     0    0    0 S  0.0  0.0   0:00.00 migration/0
   3 root      34  19     0    0    0 S  0.0  0.0   0:00.13 ksoftirqd/0
   4 root       5 -10     0    0    0 S  0.0  0.0   0:03.77 events/0
   5 root       6 -10     0    0    0 S  0.0  0.0   0:00.00 khelper
  24 root       5 -10     0    0    0 S  0.0  0.0   0:03.96 kblockd/0
  44 root      15   0     0    0    0 S  0.0  0.0   0:04.07 pdflush
  47 root       5 -10     0    0    0 S  0.0  0.0   0:00.00 aio/0
  46 root      15   0     0    0    0 S  0.0  0.0   0:21.48 kswapd0
 183 root      25   0     0    0    0 S  0.0  0.0   0:00.00 kseriod
 312 root      15   0     0    0    0 S  0.0  0.0   0:29.18 kjournald
1039 root      15   0     0    0    0 S  0.0  0.0   0:00.00 khubd
2113 root      16   0  2260  788 2092 S  0.0  0.3   0:06.38 syslogd
2116 root      16   0  2384  504 1344 S  0.0  0.2   0:00.18 klogd
2151 amavis    16   0 36912 4220 5308 S  0.0  1.7   0:01.21 amavisd-new
2176 root      16   0  2512 1020 2380 S  0.0  0.4   0:00.03 mysqld_safe
2286 postgrey  18   0 10724 1964 5240 S  0.0  0.8   0:00.03 postgrey
2306 root      19   0 27808 2436 4952 S  0.0  1.0   0:01.21 spamd
2437 root      25   0  2476  620 2164 S  0.0  0.2   0:00.00 couriertcpd
2440 root      25   0  1544  240 1360 S  0.0  0.1   0:00.00 courierlogger
2458 root      17   0  2476  620 2164 S  0.0  0.2   0:00.00 couriertcpd
2460 root      17   0  1540  240 1360 S  0.0  0.1   0:00.00 courierlogger
2463 root      16   0 26340  740 2024 S  0.0  0.3   0:00.04 dccifd
2472 root      19   0  1496  376 1344 S  0.0  0.1   0:00.00 inetd
2474 root      16   0 27808 2436 4952 S  0.0  1.0   0:00.00 spamd
2475 root      16   0 27808 2436 4952 S  0.0  1.0   0:00.00 spamd
2476 root      19   0 27808 2436 4952 S  0.0  1.0   0:00.00 spamd
2477 root      19   0 27808 2436 4952 S  0.0  1.0   0:00.00 spamd
2480 root      19   0 27808 2436 4952 S  0.0  1.0   0:00.00 spamd
2611 root      16   0  3468 1004 3092 S  0.0  0.4   0:01.89 sshd
2623 nobody    16   0  5292 1320 4588 S  0.0  0.5   0:00.56 proftpd
2626 daemon    16   0  1684  556 1520 S  0.0  0.2   0:00.00 atd
2629 root      16   0  1764  772 1576 S  0.0  0.3   0:00.45 cron
2736 root      17   0  1500  412 1336 S  0.0  0.2   0:00.00 getty
2739 root      16   0  1500  412 1336 S  0.0  0.2   0:00.00 getty
2740 root      16   0  1500  412 1336 S  0.0  0.2   0:00.00 getty
2741 root      16   0  1500  412 1336 S  0.0  0.2   0:00.00 getty
2742 root      16   0  1500  412 1336 S  0.0  0.2   0:00.00 getty
2743 root      16   0  1500  412 1336 S  0.0  0.2   0:00.00 getty
3547 teamspea  34  19 21492 2300 2972 S  0.0  0.9   0:04.51 server_linux
3548 teamspea  16   0 21492 2300 2972 S  0.0  0.9   0:02.64 server_linux
3549 teamspea  15   0 21492 2300 2972 S  0.0  0.9   6:09.03 server_linux
3550 teamspea  15   0 21492 2300 2972 S  0.0  0.9  27:48.67 server_linux
3551 teamspea  15   0 21492 2300 2972 S  0.0  0.9  20:54.67 server_linux
3555 teamspea  16   0 21492 2300 2972 S  0.0  0.9   0:00.01 server_linux
3556 teamspea  15   0 21492 2300 2972 S  0.0  0.9   0:00.25 server_linux
3557 teamspea  15   0 21492 2300 2972 S  0.0  0.9   0:01.61 server_linux
3558 teamspea  15   0 21492 2300 2972 S  0.0  0.9   8:27.95 server_linux
4503 mysql     16   0 49448 9408 9344 S  0.0  3.7   0:01.29 mysqld
4504 root      15   0  1488  436 1332 S  0.0  0.2   0:00.00 logger
24258 root      16   0  3888 1664 2888 S  0.0  0.7   0:00.78 sshblackv28.pl

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

 

http://server.clans.it/my.cnf.txt

 

 

7) mysqlreport --all -tab /statistics.txt

 

http://server.clans.it/stats.txt

 

8) che tipologia di siti ci sono sul server? vedi sopra :)

 

9) linkate una pagina phpinfo

 

http://server.clans.it/phpinfo.php

 

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

 

 KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 15
StartServers         5
MinSpareServers      5
MaxSpareServers     10
MaxClients          20
MaxRequestsPerChild  0

11) find / -size +2000000k

 

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

12) Scrivete il risultato dei seguenti 3 comandi:

 

uname -a

Linux 89-149-209-205.internetserviceteam.com 2.6.8-2-686-smp #1 SMP Tue Aug 16 12:08:30 UTC 2005 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      : 6
model           : 8
model name      : Pentium III (Coppermine)
stepping        : 6
cpu MHz         : 797.393
cache size      : 256 KB
fdiv_bug        : no
hlt_bug         : no
f00f_bug        : no
coma_bug        : no
fpu             : yes
fpu_exception   : yes
cpuid level     : 2
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 mmx fxsr sse
bogomips        : 1572.86

 

/proc/meminfo

MemTotal:       255380 kB
MemFree:         42480 kB
Buffers:         31932 kB
Cached:          23148 kB
SwapCached:       9316 kB
Active:         127012 kB
Inactive:        33688 kB
HighTotal:           0 kB
HighFree:            0 kB
LowTotal:       255380 kB
LowFree:         42480 kB
SwapTotal:     2096472 kB
SwapFree:      2019088 kB
Dirty:              68 kB
Writeback:           0 kB
Mapped:         121996 kB
Slab:            46544 kB
Committed_AS:   459532 kB
PageTables:       1416 kB
VmallocTotal:   770040 kB
VmallocUsed:      4096 kB
VmallocChunk:   765768 kB

 

 

Grazie :zizi:

Share this post


Link to post
Share on other sites

allora my.cnf

[client]
port        = 3306
socket        = /var/run/mysqld/mysqld.sock

[mysqld]
old_passwords = false # inserted by debconf
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
skip-networking

safe-show-database
skip-bdb
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

log_bin            = /var/log/mysql/mysql-bin.log
expire_logs_days    = 10
max_binlog_size         = 100M

[mysqld_safe]
socket        = /var/run/mysqld/mysqld.sock
nice        = 0
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk] 
key_buffer = 64M 
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

[isamchk]
key_buffer        = 64M

[mysqlhotcopy]
interactive-timeout

 

apache

KeepAlive - On
MaxKeepAliveRequests - 100
KeepAliveTimeout - 5
MinSpareServers - 10
MaxSpareServers - 20
StartServers - 10
MaxClients - 256

Maxrequestsperchild value = 1000

 

 

ti consiglio fortemente di installare anche Zend Optimizer+eaccelerator (quest'ultimo NON come zend_extension)

Share this post


Link to post
Share on other sites

1) vps

2)

Processori: 1
Modello: Intel(R) Pentium(R) 4 CPU 3.00GHz
MHz del Chip: 3 GHz
Dimensione Cache: 2.00 MB
Bogomips del Sistema: 5963.77
Ram: 376mb
OS: Debian 3.1
MySQL: 4.1.10
Apache: 1.3.37

 

4) precompilato

5)

top - 15:11:05 up 1 day, 16:43,  1 user,  load average: 0.30, 0.41, 0.43
Tasks: 104 total,   2 running, 102 sleeping,   0 stopped,   0 zombie
Cpu(s): 21.0% us,  1.0% sy,  0.0% ni, 78.0% id,  0.0% wa,  0.0% hi,  0.0% si
Mem:    385224k total,   369800k used,    15424k free,    11480k buffers
Swap:  1049592k total,        0k used,  1049592k free,   120688k cached

 PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
19124 apache    15   0 21600  16m 8860 S 13.7  4.4   0:56.79 httpd
19169 apache    16   0 21844  16m 8860 S  4.3  4.4   0:57.93 httpd
19119 apache    15   0 21692  16m 8916 S  1.7  4.4   0:55.82 httpd
19138 apache    15   0 21536  16m 8876 S  1.7  4.4   0:55.81 httpd
12962 mysql     15   0 70012  55m 1960 S  0.3 14.8   0:19.74 mysqld
12963 mysql     16   0 70012  55m 1960 S  0.3 14.8   1:18.33 mysqld
   1 root      16   0  1584  512  452 S  0.0  0.1   0:05.37 init
   2 root      34  19     0    0    0 S  0.0  0.0   0:01.02 ksoftirqd/0
   3 root      10  -5     0    0    0 S  0.0  0.0   0:00.03 events/0
   4 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 khelper
   9 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 kthread
  12 root      10  -5     0    0    0 S  0.0  0.0   0:00.38 kblockd/0
  52 root      15   0     0    0    0 S  0.0  0.0   0:00.18 pdflush
  55 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 aio/0
  54 root      15   0     0    0    0 S  0.0  0.0   0:00.75 kswapd0
  56 root      25   0     0    0    0 S  0.0  0.0   0:00.00 jfsIO
  57 root      25   0     0    0    0 S  0.0  0.0   0:00.00 jfsCommit
  58 root      25   0     0    0    0 S  0.0  0.0   0:00.00 jfsSync
  59 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 xfslogd/0
  60 root      20  -5     0    0    0 S  0.0  0.0   0:00.00 xfsdatad/0
  61 root      15   0     0    0    0 S  0.0  0.0   0:00.00 xfsbufd
 107 root      15   0     0    0    0 S  0.0  0.0   0:01.89 kjournald
 232 root       0 -20     0    0    0 S  0.0  0.0   0:00.02 loop0
 358 root      16   0  1628  592  496 S  0.0  0.2   0:00.42 syslogd
 361 root      15   0  1584  472  408 S  0.0  0.1   0:00.01 klogd
 368 bind      18   0 30696 3040 2092 S  0.0  0.8   0:16.23 named
 374 root      16   0  2784 1004  900 S  0.0  0.3   0:00.02 da-popb4smtp
 420 root      20   0  2576 1228 1016 S  0.0  0.3   0:00.01 mysqld_safe
 470 mysql     15   0 70012  55m 1960 S  0.0 14.8   0:04.61 mysqld
 473 root      16   0  3544 1504 1264 S  0.0  0.4   0:00.46 sshd
 513 root      16   0  1952  612  532 S  0.0  0.2   0:00.12 vm-pop3d
 532 root      18   0  2240  832  712 S  0.0  0.2   0:00.00 xinetd
 534 daemon    16   0  1764  628  548 S  0.0  0.2   0:00.00 atd
 539 root      16   0  1820  824  680 S  0.0  0.2   0:00.10 cron
 545 root      17   0  1580  484  424 S  0.0  0.1   0:00.00 getty
 546 root      16   0  1580  484  424 S  0.0  0.1   0:00.00 getty
 547 root      16   0  1580  484  424 S  0.0  0.1   0:00.00 getty
 548 root      17   0  1580  484  424 S  0.0  0.1   0:00.01 getty

6)

[mysqld]
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
# Prova numero di CPU's*2 per thread_concurrency
thread_concurrency=2
myisam_sort_buffer_size=64M
server-id=1

[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192

[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

 

7)

+---------------------------------+--------------------------------------------------------------------------+
| Variable_name                   | Value                                                                    |
+---------------------------------+--------------------------------------------------------------------------+
| back_log                        | 50                                                                       |
| basedir                         | /usr/local/mysql-standard-4.1.10-pc-linux-gnu-i686/                      |
| binlog_cache_size               | 32768                                                                    |
| bulk_insert_buffer_size         | 8388608                                                                  |
| character_set_client            | latin1                                                                   |
| character_set_connection        | latin1                                                                   |
| character_set_database          | latin1                                                                   |
| character_set_results           | latin1                                                                   |
| character_set_server            | latin1                                                                   |
| character_set_system            | utf8                                                                     |
| character_sets_dir              | /usr/local/mysql-standard-4.1.10-pc-linux-gnu-i686/share/mysql/charsets/ |
| collation_connection            | latin1_swedish_ci                                                        |
| collation_database              | latin1_swedish_ci                                                        |
| collation_server                | latin1_swedish_ci                                                        |
| concurrent_insert               | ON                                                                       |
| connect_timeout                 | 10                                                                       |
| datadir                         | /usr/local/mysql/data/                                                   |
| date_format                     | %Y-%m-%d                                                                 |
| datetime_format                 | %Y-%m-%d %H:%i:%s                                                        |
| default_week_format             | 0                                                                        |
| delay_key_write                 | ON                                                                       |
| delayed_insert_limit            | 100                                                                      |
| delayed_insert_timeout          | 300                                                                      |
| delayed_queue_size              | 1000                                                                     |
| expire_logs_days                | 0                                                                        |
| flush                           | OFF                                                                      |
| flush_time                      | 0                                                                        |
| ft_boolean_syntax               | + -><()~*:""&|                                                           |
| ft_max_word_len                 | 84                                                                       |
| ft_min_word_len                 | 4                                                                        |
| ft_query_expansion_limit        | 20                                                                       |
| ft_stopword_file                | (built-in)                                                               |
| group_concat_max_len            | 1024                                                                     |
| have_archive                    | YES                                                                      |
| have_bdb                        | NO                                                                       |
| have_compress                   | YES                                                                      |
| have_crypt                      | YES                                                                      |
| have_csv                        | NO                                                                       |
| have_example_engine             | NO                                                                       |
| have_geometry                   | YES                                                                      |
| have_innodb                     | DISABLED                                                                 |
| have_isam                       | NO                                                                       |
| have_ndbcluster                 | NO                                                                       |
| have_openssl                    | NO                                                                       |
| have_query_cache                | YES                                                                      |
| have_raid                       | NO                                                                       |
| have_rtree_keys                 | YES                                                                      |
| have_symlink                    | YES                                                                      |
| init_connect                    |                                                                          |
| init_file                       |                                                                          |
| init_slave                      |                                                                          |
| innodb_additional_mem_pool_size | 1048576                                                                  |
| innodb_autoextend_increment     | 8                                                                        |
| innodb_buffer_pool_awe_mem_mb   | 0                                                                        |
| innodb_buffer_pool_size         | 8388608                                                                  |
| innodb_data_file_path           |                                                                          |
| innodb_data_home_dir            |                                                                          |
| innodb_fast_shutdown            | ON                                                                       |
| innodb_file_io_threads          | 4                                                                        |
| innodb_file_per_table           | OFF                                                                      |
| innodb_flush_log_at_trx_commit  | 1                                                                        |
| innodb_flush_method             |                                                                          |
| innodb_force_recovery           | 0                                                                        |
| innodb_lock_wait_timeout        | 50                                                                       |
| innodb_locks_unsafe_for_binlog  | OFF                                                                      |
| 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_max_dirty_pages_pct      | 90                                                                       |
| innodb_max_purge_lag            | 0                                                                        |
| innodb_mirrored_log_groups      | 1                                                                        |
| innodb_open_files               | 300                                                                      |
| innodb_table_locks              | ON                                                                       |
| innodb_thread_concurrency       | 8                                                                        |
| interactive_timeout             | 100                                                                      |
| join_buffer_size                | 1044480                                                                  |
| key_buffer_size                 | 16777216                                                                 |
| key_cache_age_threshold         | 300                                                                      |
| key_cache_block_size            | 1024                                                                     |
| key_cache_division_limit        | 100                                                                      |
| language                        | /usr/local/mysql-standard-4.1.10-pc-linux-gnu-i686/share/mysql/english/  |
| large_files_support             | ON                                                                       |
| license                         | GPL                                                                      |
| local_infile                    | ON                                                                       |
| locked_in_memory                | OFF                                                                      |
| log                             | OFF                                                                      |
| log_bin                         | OFF                                                                      |
| log_error                       |                                                                          |
| log_slave_updates               | OFF                                                                      |
| log_slow_queries                | OFF                                                                      |
| log_update                      | 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                 | 1073741824                                                               |
| max_connect_errors              | 10                                                                       |
| max_connections                 | 500                                                                      |
| max_delayed_threads             | 20                                                                       |
| max_error_count                 | 64                                                                       |
| max_heap_table_size             | 16777216                                                                 |
| max_insert_delayed_threads      | 20                                                                       |
| max_join_size                   | 4294967295                                                               |
| max_length_for_sort_data        | 1024                                                                     |
| max_relay_log_size              | 0                                                                        |
| max_seeks_for_key               | 4294967295                                                               |
| max_sort_length                 | 1024                                                                     |
| max_tmp_tables                  | 32                                                                       |
| max_user_connections            | 0                                                                        |
| max_write_lock_count            | 4294967295                                                               |
| myisam_data_pointer_size        | 4                                                                        |
| myisam_max_extra_sort_file_size | 2147483648                                                               |
| myisam_max_sort_file_size       | 2147483647                                                               |
| myisam_recover_options          | OFF                                                                      |
| myisam_repair_threads           | 1                                                                        |
| myisam_sort_buffer_size         | 67108864                                                                 |
| net_buffer_length               | 16384                                                                    |
| net_read_timeout                | 30                                                                       |
| net_retry_count                 | 10                                                                       |
| net_write_timeout               | 60                                                                       |
| new                             | OFF                                                                      |
| old_passwords                   | OFF                                                                      |
| open_files_limit                | 2558                                                                     |
| pid_file                        | /usr/local/mysql/data/s1.pid                                             |
| port                            | 3306                                                                     |
| preload_buffer_size             | 32768                                                                    |
| protocol_version                | 10                                                                       |
| query_alloc_block_size          | 8192                                                                     |
| query_cache_limit               | 1048576                                                                  |
| query_cache_min_res_unit        | 4096                                                                     |
| query_cache_size                | 33554432                                                                 |
| query_cache_type                | ON                                                                       |
| query_cache_wlock_invalidate    | OFF                                                                      |
| query_prealloc_size             | 8192                                                                     |
| range_alloc_block_size          | 2048                                                                     |
| read_buffer_size                | 2093056                                                                  |
| read_only                       | OFF                                                                      |
| read_rnd_buffer_size            | 262144                                                                   |
| relay_log_purge                 | ON                                                                       |
| rpl_recovery_rank               | 0                                                                        |
| secure_auth                     | OFF                                                                      |
| server_id                       | 1                                                                        |
| skip_external_locking           | ON                                                                       |
| skip_networking                 | OFF                                                                      |
| skip_show_database              | OFF                                                                      |
| slave_net_timeout               | 3600                                                                     |
| slow_launch_time                | 2                                                                        |
| socket                          | /tmp/mysql.sock                                                          |
| sort_buffer_size                | 2097144                                                                  |
| sql_mode                        |                                                                          |
| storage_engine                  | MyISAM                                                                   |
| sync_binlog                     | 0                                                                        |
| sync_replication                | 0                                                                        |
| sync_replication_slave_id       | 0                                                                        |
| sync_replication_timeout        | 0                                                                        |
| sync_frm                        | ON                                                                       |
| system_time_zone                | CDT                                                                      |
| table_cache                     | 1024                                                                     |
| table_type                      | MyISAM                                                                   |
| thread_cache_size               | 128                                                                      |
| 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.10-standard                                                          |
| version_comment                 | MySQL Community Edition - Standard (GPL)                                 |
| version_compile_machine         | i686                                                                     |
| version_compile_os              | pc-linux-gnu                                                             |
| wait_timeout                    | 100                                                                      |
+---------------------------------+--------------------------------------------------------------------------+
+--------------------------+------------+
| Variable_name            | Value      |
+--------------------------+------------+
| Aborted_clients          | 52         |
| Aborted_connects         | 4          |
| Binlog_cache_disk_use    | 0          |
| Binlog_cache_use         | 0          |
| Bytes_received           | 202029642  |
| Bytes_sent               | 4014585790 |
| Com_admin_commands       | 0          |
| Com_alter_db             | 0          |
| Com_alter_table          | 4679       |
| Com_analyze              | 0          |
| Com_backup_table         | 0          |
| Com_begin                | 826        |
| Com_change_db            | 68296      |
| Com_change_master        | 0          |
| Com_check                | 0          |
| Com_checksum             | 0          |
| Com_commit               | 825        |
| Com_create_db            | 2          |
| Com_create_function      | 0          |
| Com_create_index         | 0          |
| Com_create_table         | 2401       |
| Com_dealloc_sql          | 0          |
| Com_delete               | 5940       |
| Com_delete_multi         | 0          |
| Com_do                   | 0          |
| Com_drop_db              | 0          |
| Com_drop_function        | 0          |
| Com_drop_index           | 0          |
| Com_drop_table           | 2341       |
| Com_drop_user            | 0          |
| Com_execute_sql          | 0          |
| Com_flush                | 2          |
| Com_grant                | 4          |
| Com_ha_close             | 0          |
| Com_ha_open              | 0          |
| Com_ha_read              | 0          |
| Com_help                 | 0          |
| Com_insert               | 22218      |
| Com_insert_select        | 832        |
| Com_kill                 | 0          |
| Com_load                 | 0          |
| Com_load_master_data     | 0          |
| Com_load_master_table    | 0          |
| Com_lock_tables          | 2342       |
| 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               | 2398       |
| Com_replace              | 0          |
| Com_replace_select       | 0          |
| Com_reset                | 0          |
| Com_restore_table        | 0          |
| Com_revoke               | 0          |
| Com_revoke_all           | 0          |
| Com_rollback             | 1          |
| Com_savepoint            | 0          |
| Com_select               | 143374     |
| Com_set_option           | 444        |
| Com_show_binlog_events   | 0          |
| Com_show_binlogs         | 5          |
| Com_show_charsets        | 44         |
| Com_show_collations      | 44         |
| Com_show_column_types    | 0          |
| Com_show_create_db       | 0          |
| Com_show_create_table    | 220        |
| Com_show_databases       | 80         |
| Com_show_errors          | 0          |
| Com_show_fields          | 231        |
| Com_show_grants          | 17         |
| Com_show_innodb_status   | 0          |
| Com_show_keys            | 10         |
| 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     | 0          |
| Com_show_slave_hosts     | 0          |
| Com_show_slave_status    | 0          |
| Com_show_status          | 7          |
| Com_show_storage_engines | 1          |
| Com_show_tables          | 326        |
| Com_show_variables       | 105        |
| Com_show_warnings        | 0          |
| Com_slave_start          | 0          |
| Com_slave_stop           | 0          |
| Com_truncate             | 1          |
| Com_unlock_tables        | 2342       |
| Com_update               | 62310      |
| Com_update_multi         | 0          |
| Connections              | 64598      |
| Created_tmp_disk_tables  | 2438       |
| Created_tmp_files        | 5          |
| Created_tmp_tables       | 26478      |
| Delayed_errors           | 0          |
| Delayed_insert_threads   | 0          |
| Delayed_writes           | 0          |
| Flush_commands           | 1          |
| Handler_commit           | 0          |
| Handler_delete           | 20294      |
| Handler_discover         | 0          |
| Handler_read_first       | 8541       |
| Handler_read_key         | 51335766   |
| Handler_read_next        | 61010582   |
| Handler_read_prev        | 20         |
| Handler_read_rnd         | 775153     |
| Handler_read_rnd_next    | 65061757   |
| Handler_rollback         | 0          |
| Handler_update           | 41181800   |
| Handler_write            | 3749020    |
| Key_blocks_not_flushed   | 0          |
| Key_blocks_unused        | 0          |
| Key_blocks_used          | 14497      |
| Key_read_requests        | 34064396   |
| Key_reads                | 147794     |
| Key_write_requests       | 1569961    |
| Key_writes               | 137633     |
| Max_used_connections     | 29         |
| Not_flushed_delayed_rows | 0          |
| Open_files               | 1826       |
| Open_streams             | 0          |
| Open_tables              | 964        |
| Opened_tables            | 19671      |
| Qcache_free_blocks       | 2907       |
| Qcache_free_memory       | 16550752   |
| Qcache_hits              | 360879     |
| Qcache_inserts           | 142840     |
| Qcache_lowmem_prunes     | 0          |
| Qcache_not_cached        | 338        |
| Qcache_queries_in_cache  | 10907      |
| Qcache_total_blocks      | 26787      |
| Questions                | 748112     |
| Rpl_status               | NULL       |
| Select_full_join         | 2817       |
| Select_full_range_join   | 0          |
| Select_range             | 8000       |
| Select_range_check       | 0          |
| Select_scan              | 55411      |
| Slave_open_temp_tables   | 0          |
| Slave_running            | OFF        |
| Slow_launch_threads      | 19         |
| Slow_queries             | 4          |
| Sort_merge_passes        | 0          |
| Sort_range               | 20981      |
| Sort_rows                | 16544435   |
| Sort_scan                | 32047      |
| Table_locks_immediate    | 404972     |
| Table_locks_waited       | 75         |
| Threads_cached           | 28         |
| Threads_connected        | 1          |
| Threads_created          | 29         |
| Threads_running          | 1          |
| Uptime                   | 150513     |
+--------------------------+------------+
Uptime: 150513  Threads: 1  Questions: 748113  Slow queries: 4  Opens: 19671  Flush tables: 1  Open tables: 964  Queries per second avg: 8.970
mysqladmin  Ver 8.41 Distrib 4.1.10, for pc-linux-gnu on i686
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.1.10-standard
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/tmp/mysql.sock
Uptime:			1 day 17 hours 48 min 33 sec

Threads: 1  Questions: 748113  Slow queries: 4  Opens: 19671  Flush tables: 1  Open tables: 964  Queries per second avg: 8.970

 

8) 1 sito con tantissimi forum phpbb 2

10)

Timeout 300
KeepAlive On
MaxKeepAliveRequests 500
KeepAliveTimeout 5
MinSpareServers 5
MaxSpareServers 20
StartServers 8
MaxClients 450
MaxRequestsPerChild 1000

11) find: /proc/20114/task/20114/fd/4: No such file or directory

12)

Linux vps.miosito.com 2.6.11-VPS-cube2 #1 Sat Dec 17 07:06:47 CST 2005 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       : GenuineIntel
cpu family      : 15
model           : 4
model name      : Intel(R) Pentium(R) 4 CPU 3.00GHz
stepping        : 3
cpu MHz         : 3000.239
cache size      : 2048 KB
fdiv_bug        : no
hlt_bug         : yes
f00f_bug        : no
coma_bug        : no
fpu             : yes
fpu_exception   : yes
cpuid level     : 5
wp              : yes
flags           : fpu tsc msr pae mce cx8 apic mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm pni monitor ds_cpl est cid cx16 xtpr
bogomips        : 5963.77

 

Grazie in anticipo :emoticons_dent2020:

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  

×