Originariamente Scritto da
pchs
Allora, vediamo un pò...
1) tipo di server: vps con solo il mio sito sopra
2) Specifiche del server
Ram: 512MB
Tipo HD/configurazione: 20GB
Sistema Operativo: Linux Debian 3.1
apache/IIS version: 1.3.37
PHP version: 5.xx
MySQL version: 5.xx
3) Non utilizzo tabelle InnoDB
4) MySQL è stato compilato a mano
5) Risultato di top:
Codice:
Tasks: 110 total, 2 running, 108 sleeping, 0 stopped, 0 zombie
Cpu(s): 12.2% us, 0.7% sy, 0.0% ni, 86.8% id, 0.3% wa, 0.0% hi, 0.0% si
Mem: 514600k total, 507608k used, 6992k free, 20380k buffers
Swap: 1609720k total, 184k used, 1609536k free, 157388k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
6617 apache 15 0 32356 24m 9840 S 5.6 5.0 0:32.13 httpd
6848 apache 16 0 31832 24m 9832 S 2.3 4.9 0:16.77 httpd
6616 apache 16 0 34304 27m 9988 S 2.0 5.4 0:27.39 httpd
6766 apache 16 0 31348 23m 9804 S 1.3 4.8 0:19.31 httpd
6847 apache 15 0 30812 23m 9792 S 1.0 4.7 0:13.71 httpd
710 mysql 15 0 68492 52m 2500 S 0.3 10.4 0:39.22 mysqld
764 mysql 15 0 68492 52m 2500 S 0.3 10.4 0:36.66 mysqld
1 root 16 0 1576 508 448 S 0.0 0.1 0:00.17 init
2 root 34 19 0 0 0 S 0.0 0.0 0:02.68 ksoftirqd/0
3 root 10 -5 0 0 0 S 0.0 0.0 0:00.02 events/0
4 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 khelper
9 root 20 -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.02 kblockd/0
52 root 15 0 0 0 0 S 0.0 0.0 0:00.07 pdflush
53 root 15 0 0 0 0 S 0.0 0.0 0:00.06 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.50 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.02 xfsbufd
107 root 15 0 0 0 0 S 0.0 0.0 0:02.36 kjournald
232 root 0 -20 0 0 0 S 0.0 0.0 0:00.09 loop0
349 root 16 0 1616 588 492 S 0.0 0.1 0:01.71 syslogd
352 root 16 0 1576 468 408 S 0.0 0.1 0:00.00 klogd
359 bind 18 0 11356 2476 1800 S 0.0 0.5 0:00.00 named
360 bind 16 0 11356 2476 1800 S 0.0 0.5 0:00.07 named
362 bind 16 0 11356 2476 1800 S 0.0 0.5 0:01.79 named
363 bind 16 0 11356 2476 1800 S 0.0 0.5 0:00.01 named
364 bind 15 0 11356 2476 1800 S 0.0 0.5 0:00.39 named
379 mail 15 0 5852 1176 1012 S 0.0 0.2 0:00.05 exim
396 root 18 0 2572 1240 1028 S 0.0 0.2 0:00.00 mysqld_safe
400 ftp 16 0 2388 1188 832 S 0.0 0.2 0:00.07 proftpd
438 root 16 0 3800 1440 1272 S 0.0 0.3 0:01.52 sshd
473 mysql 15 0 68492 52m 2500 S 0.0 10.4 0:14.32 mysqld
509 root 15 0 1944 612 536 S 0.0 0.1 0:00.29 vm-pop3d
528 root 18 0 2228 820 704 S 0.0 0.2 0:00.00 xinetd
530 daemon 16 0 1756 640 560 S 0.0 0.1 0:00.00 atd
533 root 16 0 1812 812 672 S 0.0 0.2 0:01.00 cron
606 mysql 16 0 68492 52m 2500 S 0.0 10.4 0:00.13 mysqld
607 mysql 15 0 68492 52m 2500 S 0.0 10.4 0:25.82 mysqld
643 root 17 0 1572 480 420 S 0.0 0.1 0:00.00 getty
644 root 16 0 1572 480 420 S 0.0 0.1 0:00.00 getty
645 root 16 0 1572 480 420 S 0.0 0.1 0:00.01 getty
646 root 16 0 1572 480 420 S 0.0 0.1 0:00.00 getty
647 root 16 0 1572 480 420 S 0.0 0.1 0:00.00 getty
648 root 16 0 1572 480 420 S 0.0 0.1 0:00.00 getty
649 mysql 15 0 68492 52m 2500 S 0.0 10.4 0:36.69 mysqld
650 mysql 17 0 68492 52m 2500 S 0.0 10.4 0:35.66 mysqld
708 mysql 15 0 68492 52m 2500 S 0.0 10.4 0:39.79 mysqld
709 mysql 16 0 68492 52m 2500 S 0.0 10.4 0:35.70 mysqld
Non so se continuava, ma non riesco ad inviarmelo tramite email...
6) File my.cnf:
Codice:
[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) Risultato di
mysqladmin -u root -p var ext stat ver
Codice:
+---------------------------------+-------------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+-------------------------------------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | /usr/local/mysql-standard-5.0.27-linux-i686/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql-standard-5.0.27-linux-i686/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| completion_type | 0 |
| concurrent_insert | 1 |
| 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 |
| div_precision_increment | 4 |
| engine_condition_pushdown | OFF |
| 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_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_dynamic_loading | NO |
| have_example_engine | NO |
| have_federated_engine | NO |
| have_geometry | YES |
| have_innodb | DISABLED |
| have_isam | NO |
| have_merge_engine | YES |
| have_ndbcluster | NO |
| have_openssl | DISABLED |
| 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_checksums | ON |
| innodb_commit_concurrency | 0 |
| innodb_concurrency_tickets | 500 |
| innodb_data_file_path | |
| innodb_data_home_dir | |
| innodb_doublewrite | ON |
| innodb_fast_shutdown | 1 |
| 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_support_xa | ON |
| innodb_sync_spin_loops | 20 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| innodb_thread_sleep_delay | 10000 |
| 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-5.0.27-linux-i686/share/mysql/english/ |
| large_files_support | ON |
| large_page_size | 0 |
| large_pages | OFF |
| lc_time_names | en_US |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_bin_trust_function_creators | OFF |
| log_error | |
| log_queries_not_using_indexes | OFF |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 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 | 18446744073709551615 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_sp_recursion_depth | 0 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| multi_range_count | 256 |
| myisam_data_pointer_size | 6 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 67108864 |
| myisam_stats_method | nulls_unequal |
| 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 |
| optimizer_prune_level | 1 |
| optimizer_search_depth | 62 |
| pid_file | /usr/local/mysql/data/vps.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| 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 |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 1 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_compressed_protocol | OFF |
| slave_load_tmpdir | /tmp/ |
| slave_net_timeout | 3600 |
| slave_skip_errors | OFF |
| slave_transaction_retries | 10 |
| slow_launch_time | 2 |
| socket | /tmp/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_big_selects | ON |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | OFF |
| ssl_ca | |
| ssl_capath | |
| ssl_cert | |
| ssl_cipher | |
| ssl_key | |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| system_time_zone | CEST |
| table_cache | 1024 |
| table_lock_wait_timeout | 50 |
| table_type | MyISAM |
| thread_cache_size | 128 |
| thread_stack | 126976 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| timed_mutexes | OFF |
| tmp_table_size | 33554432 |
| tmpdir | /tmp/ |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| updatable_views_with_limit | YES |
| version | 5.0.27-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 | 310 |
| Aborted_connects | 5 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 561899456 |
| Bytes_sent | 718489889 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 83 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 1557 |
| Com_change_db | 218164 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 1325 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 201 |
| Com_dealloc_sql | 0 |
| Com_delete | 3461 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 159 |
| 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 | 24890 |
| Com_insert_select | 395 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 67596 |
| 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 | 590438 |
| Com_set_option | 1130 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 6 |
| Com_show_charsets | 50 |
| Com_show_collations | 50 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 282 |
| Com_show_databases | 40 |
| Com_show_errors | 0 |
| Com_show_fields | 32 |
| Com_show_grants | 19 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 24 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 4 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 59 |
| Com_show_triggers | 0 |
| Com_show_variables | 188 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 171 |
| Com_unlock_tables | 0 |
| Com_update | 174855 |
| Com_update_multi | 156 |
| Com_xa_commit | 0 |
| Com_xa_end | 0 |
| Com_xa_prepare | 0 |
| Com_xa_recover | 0 |
| Com_xa_rollback | 0 |
| Com_xa_start | 0 |
| Compression | OFF |
| Connections | 213297 |
| Created_tmp_disk_tables | 2221 |
| Created_tmp_files | 18 |
| Created_tmp_tables | 45490 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 46560 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 37784 |
| Handler_read_key | 5991715 |
| Handler_read_next | 11784051 |
| Handler_read_prev | 2125873 |
| Handler_read_rnd | 1357202 |
| Handler_read_rnd_next | 88504947 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 2801540 |
| Handler_write | 909442 |
| Innodb_buffer_pool_pages_data | 0 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 0 |
| Innodb_buffer_pool_pages_free | 0 |
| Innodb_buffer_pool_pages_latched | 0 |
| Innodb_buffer_pool_pages_misc | 0 |
| Innodb_buffer_pool_pages_total | 0 |
| Innodb_buffer_pool_read_ahead_rnd | 0 |
| Innodb_buffer_pool_read_ahead_seq | 0 |
| Innodb_buffer_pool_read_requests | 0 |
| Innodb_buffer_pool_reads | 0 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 0 |
| Innodb_data_fsyncs | 0 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 0 |
| Innodb_data_reads | 0 |
| Innodb_data_writes | 0 |
| Innodb_data_written | 0 |
| Innodb_dblwr_pages_written | 0 |
| Innodb_dblwr_writes | 0 |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 0 |
| Innodb_log_writes | 0 |
| Innodb_os_log_fsyncs | 0 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 0 |
| Innodb_page_size | 0 |
| Innodb_pages_created | 0 |
| Innodb_pages_read | 0 |
| Innodb_pages_written | 0 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 0 |
| Innodb_row_lock_time_avg | 0 |
| Innodb_row_lock_time_max | 0 |
| Innodb_row_lock_waits | 0 |
| Innodb_rows_deleted | 0 |
| Innodb_rows_inserted | 0 |
| Innodb_rows_read | 0 |
| Innodb_rows_updated | 0 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 5568 |
| Key_blocks_used | 8931 |
| Key_read_requests | 14675723 |
| Key_reads | 9546 |
| Key_write_requests | 576573 |
| Key_writes | 176979 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 26 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 733 |
| Open_streams | 0 |
| Open_tables | 390 |
| Opened_tables | 1182 |
| Qcache_free_blocks | 3377 |
| Qcache_free_memory | 12850528 |
| Qcache_hits | 1360983 |
| Qcache_inserts | 585746 |
| Qcache_lowmem_prunes | 1969 |
| Qcache_not_cached | 5381 |
| Qcache_queries_in_cache | 7621 |
| Qcache_total_blocks | 19289 |
| Questions | 2659810 |
| Rpl_status | NULL |
| Select_full_join | 88 |
| Select_full_range_join | 0 |
| Select_range | 88173 |
| Select_range_check | 0 |
| Select_scan | 219920 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 1 |
| Slow_queries | 1 |
| Sort_merge_passes | 9 |
| Sort_range | 62699 |
| Sort_rows | 8769826 |
| Sort_scan | 89537 |
| Ssl_accept_renegotiates | 0 |
| Ssl_accepts | 0 |
| Ssl_callback_cache_hits | 0 |
| Ssl_cipher | |
| Ssl_cipher_list | |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_ctx_verify_depth | 0 |
| Ssl_ctx_verify_mode | 0 |
| Ssl_default_timeout | 0 |
| Ssl_finished_accepts | 0 |
| Ssl_finished_connects | 0 |
| Ssl_session_cache_hits | 0 |
| Ssl_session_cache_misses | 0 |
| Ssl_session_cache_mode | NONE |
| Ssl_session_cache_overflows | 0 |
| Ssl_session_cache_size | 0 |
| Ssl_session_cache_timeouts | 0 |
| Ssl_sessions_reused | 0 |
| Ssl_used_session_cache_entries | 0 |
| Ssl_verify_depth | 0 |
| Ssl_verify_mode | 0 |
| Ssl_version | |
| Table_locks_immediate | 1270661 |
| Table_locks_waited | 45 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 25 |
| Threads_connected | 1 |
| Threads_created | 26 |
| Threads_running | 1 |
| Uptime | 488577 |
+-----------------------------------+-----------+
Uptime: 488577 Threads: 1 Questions: 2659811 Slow queries: 1 Opens: 1182 Flush tables: 1 Open tables: 390 Queries per second avg: 5.444 mysqladmin Ver 8.41 Distrib 5.0.27, 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 5.0.27-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 5 days 15 hours 42 min 57 sec
Threads: 1 Questions: 2659811 Slow queries: 1 Opens: 1182 Flush tables: 1 Open tables: 390 Queries per second avg: 5.444
8) Sul server c'è solo il mio sito che utilizza mkportal + vbulletin +
vbseo + mod_rewrite
9) Pagina phpinfo:
http://www.pchs.it/info.php
10) Timeout 300
KeepAlive On
MaxKeepAliveRequests 500
KeepAliveTimeout 5
MinSpareServers 5
MaxSpareServers 20
StartServers 8
MaxClients 450
MaxRequestsPerChild 1000
11)Questo comando
find / -size +2000000k dopo un pò di tempo ritorna:
Codice:
vps:/etc# find / -size +2000000k
find: /proc/7320/task/7320/fd/4: No such file or directory
find: /tmp/.X11-unix: Input/output error
12) uname -a
Codice:
Linux vps.phcs.it 2.6.11-VPS-cube2 #1 Sat Dec 17 07:06:47 CST 2005 i686 GNU/Linux
ulimit -aH
Codice:
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
Codice:
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) 4 CPU 3.40GHz
stepping : 3
cpu MHz : 3400.243
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 : 3348.88
Dimmi se ti serve altro e grazie per la tua cortese attenzione!
LinkBack URL
About LinkBacks
poi non lamentarti se la ram è satura però
Permessi di Scrittura
Rispondi Citando
Segnalibri