Si effettivamente.. Ho ridotto il numero di processi, da 25 a 16, facendo una media della RAM occupata da ognuno (31*17= 527)...
Altri suggerimenti?
LinkBack URL
About LinkBacks
Piccola precisazione per dare un aiuto più preciso. Il processore in realtà è un xeon DP, cosa che se messa in "monoprocessore" xen 2.x vede come pentium IV (la frequenza la vee giusta). Con xen 3.x invece ho notato che vede correttamente la diceria xeon. Quindi per consigliare la configurazione fate riferimento per quel tipo di processore e non per un pIV (anche se quei xeon sono dei semplici pIV modificati).
Salve a tutti....ho bisogno di una mano. In pratica uso un server per mysql, per effettuare calcoli in php per la tesi. Sto trasferendo tutti i dati da windows access a linux ubuntu server - mysql.
I database sono molto grandi, arrivando anche a oltre 70.000.000 di record. In pratica stavo cercando di spostare una tabella da un database ad un altro con phpmyadmin quando ho ricevuto un errore:
In pratica credo di aver capito che il problema è in innodb_buffer_pool_size...il problema è che nel mio my.cnf non c'e nessuno voce del genere....??Codice:Errore query SQL:INSERT INTO `commodities`.`CommoditiesPrezziGiornalieri` SELECT * FROM `commoditiesprezzi1`.`CommoditiesPrezziGiornalieri` Messaggio di MySQL:
#1206 - The total number of locks exceeds the lock table size
Cmq vi riporto tutto come richiesto:
1) TIPO DI SERVER --> dedicato a database mysql e calcoli in php
2) velocità cpu / singolo o multiprocessore: QUADCORE 2,66 Ghz
Ram: 8 GB 800 Mhz
Tipo HD/configurazione: 1 HD 300 GB
Sistema Operativo: Linux Ubuntu Server 2.6.28-13-server
apache/IIS version: apache2 ?
PHP version: php 5
MySQL version:MySQL 5.0.75-0ubuntu10.2
3) Tutte le tabelle sono Innodb
4) Come è stato installato Mysql? (compilato a mano o precompilato)
PRECOMPILATO
5) Esecuzione di TOP
6) File my.cnfCodice:top - 16:56:41 up 2:55, 2 users, load average: 0.09, 0.54, 0.69 Tasks: 154 total, 2 running, 152 sleeping, 0 stopped, 0 zombie Cpu(s): 0.0%us, 2.1%sy, 0.0%ni, 97.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 8077884k total, 3121152k used, 4956732k free, 61180k buffers Swap: 8522440k total, 0k used, 8522440k free, 2361316k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 8955 condor 20 0 19116 1360 988 R 57 0.0 0:00.61 top 1 root 20 0 4104 924 632 S 0 0.0 0:01.28 init 2 root 15 -5 0 0 0 S 0 0.0 0:00.00 kthreadd 3 root RT -5 0 0 0 S 0 0.0 0:00.00 migration/0 4 root 15 -5 0 0 0 S 0 0.0 0:00.12 ksoftirqd/0 5 root RT -5 0 0 0 S 0 0.0 0:00.00 watchdog/0 6 root RT -5 0 0 0 S 0 0.0 0:00.02 migration/1 7 root 15 -5 0 0 0 S 0 0.0 0:00.03 ksoftirqd/1 8 root RT -5 0 0 0 S 0 0.0 0:00.00 watchdog/1 9 root RT -5 0 0 0 S 0 0.0 0:00.00 migration/2 10 root 15 -5 0 0 0 S 0 0.0 0:00.01 ksoftirqd/2 11 root RT -5 0 0 0 S 0 0.0 0:00.00 watchdog/2 12 root RT -5 0 0 0 S 0 0.0 0:00.02 migration/3 13 root 15 -5 0 0 0 S 0 0.0 0:00.00 ksoftirqd/3 14 root RT -5 0 0 0 S 0 0.0 0:00.00 watchdog/3 15 root 15 -5 0 0 0 S 0 0.0 0:00.04 events/0 16 root 15 -5 0 0 0 S 0 0.0 0:00.00 events/1 17 root 15 -5 0 0 0 S 0 0.0 0:00.00 events/2 18 root 15 -5 0 0 0 S 0 0.0 0:00.01 events/3 19 root 15 -5 0 0 0 S 0 0.0 0:00.00 khelper 20 root RT -5 0 0 0 S 0 0.0 0:00.00 kstop/0 21 root RT -5 0 0 0 S 0 0.0 0:00.00 kstop/1 22 root RT -5 0 0 0 S 0 0.0 0:00.00 kstop/2 23 root RT -5 0 0 0 S 0 0.0 0:00.00 kstop/3 24 root 15 -5 0 0 0 S 0 0.0 0:00.00 kintegrityd/0 25 root 15 -5 0 0 0 S 0 0.0 0:00.00 kintegrityd/1 26 root 15 -5 0 0 0 S 0 0.0 0:00.00 kintegrityd/2 27 root 15 -5 0 0 0 S 0 0.0 0:00.00 kintegrityd/3 28 root 15 -5 0 0 0 S 0 0.0 0:00.01 kblockd/0 29 root 15 -5 0 0 0 S 0 0.0 0:00.00 kblockd/1 30 root 15 -5 0 0 0 S 0 0.0 0:00.00 kblockd/2 31 root 15 -5 0 0 0 S 0 0.0 0:00.00 kblockd/3 32 root 15 -5 0 0 0 S 0 0.0 0:00.00 kacpid 33 root 15 -5 0 0 0 S 0 0.0 0:00.00 kacpi_notify 34 root 15 -5 0 0 0 S 0 0.0 0:00.00 cqueue 35 root 15 -5 0 0 0 S 0 0.0 0:03.21 ata/0 36 root 15 -5 0 0 0 S 0 0.0 0:00.01 ata/1 37 root 15 -5 0 0 0 S 0 0.0 0:00.01 ata/2 38 root 15 -5 0 0 0 S 0 0.0 0:00.00 ata/3 39 root 15 -5 0 0 0 S 0 0.0 0:00.00 ata_aux 40 root 15 -5 0 0 0 S 0 0.0 0:00.00 ksuspend_usbd 41 root 15 -5 0 0 0 S 0 0.0 0:00.01 khubd 42 root 15 -5 0 0 0 S 0 0.0 0:00.00 kseriod 43 root 15 -5 0 0 0 S 0 0.0 0:00.00 kmmcd 44 root 15 -5 0 0 0 S 0 0.0 0:00.00 btaddconn 45 root 15 -5 0 0 0 S 0 0.0 0:00.00 btdelconn 46 root 20 0 0 0 0 S 0 0.0 0:00.00 pdflush 47 root 20 0 0 0 0 S 0 0.0 0:00.04 pdflush 48 root 15 -5 0 0 0 S 0 0.0 0:00.00 kswapd0 49 root 15 -5 0 0 0 S 0 0.0 0:00.00 aio/0 50 root 15 -5 0 0 0 S 0 0.0 0:00.00 aio/1 51 root 15 -5 0 0 0 S 0 0.0 0:00.00 aio/2 52 root 15 -5 0 0 0 S 0 0.0 0:00.00 aio/3 53 root 15 -5 0 0 0 S 0 0.0 0:00.00 ecryptfs-kthrea 56 root 15 -5 0 0 0 S 0 0.0 0:00.00 scsi_eh_0 57 root 15 -5 0 0 0 S 0 0.0 0:00.00 scsi_eh_1 58 root 15 -5 0 0 0 S 0 0.0 0:00.01 scsi_eh_2 top - 16:58:06 up 2:57, 2 users, load average: 0.25, 0.46, 0.64 Tasks: 154 total, 1 running, 153 sleeping, 0 stopped, 0 zombie Cpu(s): 1.0%us, 0.5%sy, 0.0%ni, 98.5%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 8077884k total, 3122144k used, 4955740k free, 61180k buffers Swap: 8522440k total, 0k used, 8522440k free, 2361380k cached
7)Codice:# # The MySQL database server configuration file. # # You can copy this to one of: # - "/etc/mysql/my.cnf" to set global options, # - "~/.my.cnf" to set user-specific options. # # One can use all long options that the program supports. # Run program with --help to get a list of available options and with # --print-defaults to see which it would actually understand and use. # # For explanations see # http://dev.mysql.com/doc/mysql/en/server-system-variables.html # This will be passed to all mysql clients # It has been reported that passwords should be enclosed with ticks/quotes # escpecially if they contain "#" chars... # Remember to edit /etc/mysql/debian.cnf when changing the socket location. [client] port = 3306 socket = /var/run/mysqld/mysqld.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram # This was formally known as [safe_mysqld]. Both versions are currently parsed. [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] # # * Basic Settings # # # * IMPORTANT # If you make changes to these settings and your system uses apparmor, you may # also need to also adjust /etc/apparmor.d/usr.sbin.mysqld. # 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 skip-external-locking # # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. bind-address = 127.0.0.1 # # * Fine Tuning # key_buffer = 16M max_allowed_packet = 16M thread_stack = 128K thread_cache_size = 8 # This replaces the startup script and checks MyISAM tables if needed # the first time they are touched myisam-recover = BACKUP #max_connections = 100 #table_cache = 64 #thread_concurrency = 10 # # * Query Cache Configuration # query_cache_limit = 1M query_cache_size = 16M # # * Logging and Replication # # Both location gets rotated by the cronjob. # Be aware that this log type is a performance killer. #log = /var/log/mysql/mysql.log # # Error logging goes to syslog. This is a Debian improvement :) # # Here you can see queries with especially long duration #log_slow_queries = /var/log/mysql/mysql-slow.log #long_query_time = 2 #log-queries-not-using-indexes # # The following can be used as easy to replay backup logs or for replication. # note: if you are setting up a replication slave, see README.Debian about # other settings you may need to change. #server-id = 1 #log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M #binlog_do_db = include_database_name #binlog_ignore_db = include_database_name # # * InnoDB # # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. # Read the manual for more InnoDB related options. There are many! # You might want to disable InnoDB to shrink the mysqld process by circa 100MB. #skip-innodb # # * Federated # # The FEDERATED storage engine is disabled since 5.0.67 by default in the .cnf files # shipped with MySQL distributions (my-huge.cnf, my-medium.cnf, and so forth). # skip-federated # # * Security Features # # Read the manual, too, if you want chroot! # chroot = /var/lib/mysql/ # # For generating SSL certificates I recommend the OpenSSL GUI "tinyca". # # ssl-ca=/etc/mysql/cacert.pem # ssl-cert=/etc/mysql/server-cert.pem # ssl-key=/etc/mysql/server-key.pem [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] key_buffer = 16M # # * NDB Cluster # # See /usr/share/doc/mysql-server-*/README.Debian for more information. # # The following configuration is read by the NDB Data Nodes (ndbd processes) # not from the NDB Management Nodes (ndb_mgmd processes). # # [MYSQL_CLUSTER] # ndb-connectstring=127.0.0.1 # # * IMPORTANT: Additional settings that can override those from this file! # The files must end with '.cnf', otherwise they'll be ignored. # !includedir /etc/mysql/conf.d/
Grazie in anticipo, mi basterebbe risolvere quell' errore, se poi riuscite a darmi anche qualche dritta su come ottimizzare mysql per quello che devo fare ve ne sarei grato!!!Codice:| Variable_name | Value | +---------------------------------+-----------------------------+ | auto_increment_increment | 1 | | auto_increment_offset | 1 | | automatic_sp_privileges | ON | | back_log | 50 | | basedir | /usr/ | | 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/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 | /var/lib/mysql/ | | 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 | | keep_files_on_create | OFF | | engine_condition_pushdown | OFF | | expire_logs_days | 10 | | 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 | YES | | have_compress | YES | | have_crypt | YES | | have_csv | YES | | have_dynamic_loading | YES | | have_example_engine | NO | | have_federated_engine | DISABLED | | have_geometry | YES | | have_innodb | YES | | have_isam | NO | | have_merge_engine | YES | | have_ndbcluster | DISABLED | | have_openssl | DISABLED | | have_ssl | DISABLED | | have_query_cache | YES | | have_raid | NO | | have_rtree_keys | YES | | have_symlink | YES | | hostname | Server0 | | 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 | ibdata1:10M:autoextend | | innodb_data_home_dir | | | innodb_adaptive_hash_index | ON | | 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_rollback_on_timeout | OFF | | innodb_support_xa | ON | | innodb_sync_spin_loops | 20 | | innodb_table_locks | ON | | innodb_thread_concurrency | 8 | | innodb_thread_sleep_delay | 10000 | | interactive_timeout | 28800 | | join_buffer_size | 131072 | | key_buffer_size | 16777216 | | key_cache_age_threshold | 300 | | key_cache_block_size | 1024 | | key_cache_division_limit | 100 | | language | /usr/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 | 16777216 | | max_binlog_cache_size | 18446744073709547520 | | max_binlog_size | 104857600 | | 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 | 18446744073709551615 | | max_length_for_sort_data | 1024 | | max_prepared_stmt_count | 16382 | | max_relay_log_size | 0 | | max_seeks_for_key | 18446744073709551615 | | max_sort_length | 1024 | | max_sp_recursion_depth | 0 | | max_tmp_tables | 32 | | max_user_connections | 0 | | max_write_lock_count | 18446744073709551615 | | multi_range_count | 256 | | myisam_data_pointer_size | 6 | | myisam_max_sort_file_size | 9223372036853727232 | | myisam_recover_options | BACKUP | | myisam_repair_threads | 1 | | myisam_sort_buffer_size | 8388608 | | myisam_stats_method | nulls_unequal | | ndb_autoincrement_prefetch_sz | 1 | | ndb_force_send | ON | | ndb_use_exact_count | ON | | ndb_use_transactions | ON | | ndb_cache_check_time | 0 | | ndb_connectstring | | | 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 | | optimizer_prune_level | 1 | | optimizer_search_depth | 62 | | pid_file | /var/run/mysqld/mysqld.pid | | plugin_dir | | | port | 3306 | | preload_buffer_size | 32768 | | profiling | OFF | | profiling_history_size | 15 | | protocol_version | 10 | | query_alloc_block_size | 8192 | | query_cache_limit | 1048576 | | query_cache_min_res_unit | 4096 | | query_cache_size | 16777216 | | query_cache_type | ON | | query_cache_wlock_invalidate | OFF | | query_prealloc_size | 8192 | | range_alloc_block_size | 4096 | | read_buffer_size | 131072 | | read_only | OFF | | read_rnd_buffer_size | 262144 | | relay_log | | | relay_log_index | | | relay_log_info_file | relay-log.info | | relay_log_purge | ON | | relay_log_space_limit | 0 | | rpl_recovery_rank | 0 | | secure_auth | OFF | | secure_file_priv | | | server_id | 0 | | 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 | /var/run/mysqld/mysqld.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 | 64 | | table_lock_wait_timeout | 50 | | table_type | MyISAM | | thread_cache_size | 8 | | thread_stack | 131072 | | 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.75-0ubuntu10.2 | | version_comment | (Ubuntu) | | version_compile_machine | x86_64 | | version_compile_os | debian-linux-gnu | | wait_timeout | 28800 | +---------------------------------+-----------------------------+ +-----------------------------------+-------------+ | Variable_name | Value | +-----------------------------------+-------------+ | Aborted_clients | 1 | | Aborted_connects | 6 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 0 | | Bytes_received | 47815 | | Bytes_sent | 164744 | | Com_admin_commands | 0 | | Com_alter_db | 0 | | Com_alter_table | 0 | | Com_analyze | 0 | | Com_backup_table | 0 | | Com_begin | 0 | | Com_call_procedure | 0 | | Com_change_db | 69 | | 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 | 3 | | Com_create_user | 0 | | Com_dealloc_sql | 0 | | Com_delete | 6 | | Com_delete_multi | 0 | | Com_do | 0 | | Com_drop_db | 0 | | Com_drop_function | 0 | | Com_drop_index | 0 | | Com_drop_table | 2 | | 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 | 8 | | Com_insert_select | 2 | | 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 | 0 | | 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 | 53 | | Com_set_option | 71 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 18 | | Com_show_charsets | 1 | | Com_show_collations | 1 | | Com_show_column_types | 0 | | Com_show_create_db | 0 | | Com_show_create_table | 9 | | Com_show_databases | 35 | | Com_show_errors | 0 | | Com_show_fields | 11 | | Com_show_grants | 1 | | Com_show_innodb_status | 0 | | Com_show_keys | 5 | | 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 | 1 | | Com_show_storage_engines | 3 | | Com_show_tables | 221 | | Com_show_triggers | 0 | | Com_show_variables | 31 | | 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 | 0 | | Com_unlock_tables | 0 | | Com_update | 0 | | Com_update_multi | 0 | | 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 | 75 | | Created_tmp_disk_tables | 22 | | Created_tmp_files | 5 | | Created_tmp_tables | 369 | | Delayed_errors | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Flush_commands | 1 | | Handler_commit | 0 | | Handler_delete | 0 | | Handler_discover | 0 | | Handler_prepare | 0 | | Handler_read_first | 35 | | Handler_read_key | 18 | | Handler_read_next | 6325 | | Handler_read_prev | 0 | | Handler_read_rnd | 0 | | Handler_read_rnd_next | 51185331 | | Handler_rollback | 3 | | Handler_savepoint | 0 | | Handler_savepoint_rollback | 0 | | Handler_update | 0 | | Handler_write | 51185006 | | Innodb_buffer_pool_pages_data | 164 | | Innodb_buffer_pool_pages_dirty | 0 | | Innodb_buffer_pool_pages_flushed | 288162 | | Innodb_buffer_pool_pages_free | 347 | | Innodb_buffer_pool_pages_misc | 1 | | Innodb_buffer_pool_pages_total | 512 | | Innodb_buffer_pool_read_ahead_rnd | 20 | | Innodb_buffer_pool_read_ahead_seq | 15234 | | Innodb_buffer_pool_read_requests | 491324720 | | Innodb_buffer_pool_reads | 39256 | | Innodb_buffer_pool_wait_free | 0 | | Innodb_buffer_pool_write_requests | 170510952 | | Innodb_data_fsyncs | 13025 | | Innodb_data_pending_fsyncs | 0 | | Innodb_data_pending_reads | 0 | | Innodb_data_pending_writes | 0 | | Innodb_data_read | 4639608832 | | Innodb_data_reads | 54588 | | Innodb_data_writes | 46180 | | Innodb_data_written | 13094121472 | | Innodb_dblwr_pages_written | 288162 | | Innodb_dblwr_writes | 3645 | | Innodb_log_waits | 1 | | Innodb_log_write_requests | 7440391 | | Innodb_log_writes | 11528 | | Innodb_os_log_fsyncs | 5757 | | Innodb_os_log_pending_fsyncs | 0 | | Innodb_os_log_pending_writes | 0 | | Innodb_os_log_written | 3651241984 | | Innodb_page_size | 16384 | | Innodb_pages_created | 132952 | | Innodb_pages_read | 283046 | | Innodb_pages_written | 288162 | | 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 | 34121850 | | Innodb_rows_read | 51189133 | | Innodb_rows_updated | 0 | | Key_blocks_not_flushed | 0 | | Key_blocks_unused | 13392 | | Key_blocks_used | 4 | | Key_read_requests | 32 | | Key_reads | 4 | | Key_write_requests | 32 | | Key_writes | 32 | | Last_query_cost | 0.000000 | | Max_used_connections | 2 | | Ndb_cluster_node_id | 0 | | Ndb_config_from_host | | | Ndb_config_from_port | 0 | | Ndb_number_of_data_nodes | 0 | | Not_flushed_delayed_rows | 0 | | Open_files | 30 | | Open_streams | 0 | | Open_tables | 24 | | Opened_tables | 35 | | Prepared_stmt_count | 0 | | Qcache_free_blocks | 1 | | Qcache_free_memory | 16736928 | | Qcache_hits | 58 | | Qcache_inserts | 18 | | Qcache_lowmem_prunes | 0 | | Qcache_not_cached | 380 | | Qcache_queries_in_cache | 17 | | Qcache_total_blocks | 43 | | Questions | 714 | | Rpl_status | NULL | | Select_full_join | 0 | | Select_full_range_join | 0 | | Select_range | 0 | | Select_range_check | 0 | | Select_scan | 375 | | Slave_open_temp_tables | 0 | | Slave_retried_transactions | 0 | | Slave_running | OFF | | Slow_launch_threads | 0 | | Slow_queries | 3 | | Sort_merge_passes | 0 | | Sort_range | 0 | | Sort_rows | 0 | | Sort_scan | 0 | | 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 | 62 | | Table_locks_waited | 0 | | Tc_log_max_pages_used | 0 | | Tc_log_page_size | 0 | | Tc_log_page_waits | 0 | | Threads_cached | 0 | | Threads_connected | 2 | | Threads_created | 2 | | Threads_running | 1 | | Uptime | 10795 | | Uptime_since_flush_status | 10795 | +-----------------------------------+-------------+ Uptime: 10795 Threads: 2 Questions: 715 Slow queries: 3 Opens: 35 Flush tables: 1 Open tables: 24 Queries per second avg: 0.066 mysqladmin Ver 8.41 Distrib 5.0.75, for debian-linux-gnu on x86_64 Copyright (C) 2000-2006 MySQL 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.75-0ubuntu10.2 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 2 hours 59 min 55 sec Threads: 2 Questions: 715 Slow queries: 3 Opens: 35 Flush tables: 1 Open tables: 24 Queries per second avg: 0.066
aggiungi
innodb_buffer_pool_size = 256M
sotto
#skip-innodb
Il miglior sito italiano su winning eleven e pro evolution soccer
Ubuntu è una antica parola africana che significa: "Non so installare Debian"
Allora intanto grazie....
A dir la verità nel mentre ho aggiunto dentro sotto [mysqld]
innodb_buffer_pool_size = 6400M
...e tutto ha funzionato!
Pensi che siano troppi 6400M ? Perchè ho letto sulla documentazione di Mysql che se il server è dedicato gli si dovrebbe dare l' 80% della memoria fisica....?? cosa ne pensi?
se fa solo mysql puoi dargli anche quella cifra lì
Il miglior sito italiano su winning eleven e pro evolution soccer
Ubuntu è una antica parola africana che significa: "Non so installare Debian"
Una cosa però....
adesso tutto funziona ma in pratica la RAM rimane sempre caricata...ovvero dopo aver fatto lo spostamento della I tabella la RAM era salita a 5,9 GB, successivamente ho spostato un' altra tabella e la RAM è andata a 7,4 GB poi ho rinominato il database e adesso da system monitor vedo che la RAM è a 7,4 GB e lo swap a 190 MB ....è normale? Non c'è un modo per dirgli di svuotare la RAM quando ha finito?
Ciao, mi interesserebbe esclusivamente la configurazione del my.cnf
Potresti dirmi quali valori fondamentali modificare rispetto a quelli di default
Grazie mille
1) tipo di server: vps
c'è un solo sito con vbulletin, ma con molto carico
2) Specifiche del server
velocità cpu multiprocessore: core duo 2.40 GHz
Ram: 2048MB burstable RAM, 1024MB guaranteed RAM
Sistema Operativo: linux centos 5
Webserver: lighttpd
PHP version: 5.2.6 (php-cgi)
MySQLi version: 5
3) no InnoDB
4) precompilato
5) eseguire "top" e scrivere il risultato
6) Copiare il file di configurazione my.cnf (o my.ini) escludendo eventuali passwordtop - 1840 up 20 min, 0 users, load average: 8.66, 6.82, 4.27
Tasks: 109 total, 3 running, 106 sleeping, 0 stopped, 0 zombie
Cpu(s): 63.5%us, 5.8%sy, 0.0%ni, 29.7%id, 1.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 2097152k total, 996884k used, 1100268k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1416 mysql 15 0 149m 35m 4904 S 15.0 1.7 5:36.40 mysqld
23796 admin 16 0 45148 22m 12m S 12.6 1.1 0:15.28 php-cgi
23758 admin 16 0 40200 14m 9180 S 10.3 0.7 0:12.09 php-cgi
23780 admin 18 0 52120 27m 11m R 10.0 1.4 0:17.58 php-cgi
23784 admin 15 0 47276 26m 13m S 9.3 1.3 0:21.83 php-cgi
23767 admin 17 0 44448 23m 13m S 8.7 1.1 0:21.80 php-cgi
23778 admin 16 0 40812 17m 10m S 8.7 0.8 0:17.91 php-cgi
23835 admin 16 0 45396 23m 12m S 8.3 1.1 0:18.89 php-cgi
23776 admin 15 0 44556 20m 11m S 6.7 1.0 0:16.62 php-cgi
23792 admin 16 0 48160 23m 10m S 6.7 1.1 0:16.94 php-cgi
23795 admin 16 0 51896 26m 9m R 6.0 1.3 0:13.27 php-cgi
23832 admin 16 0 44308 19m 9728 S 5.0 0.9 0:17.45 php-cgi
23782 admin 16 0 44304 20m 11m S 4.3 1.0 0:18.05 php-cgi
23777 admin 15 0 44164 21m 11m S 1.7 1.0 0:14.59 php-cgi
23743 apache 15 0 11880 7568 900 S 1.3 0.4 0:15.98 lighttpd
23842 admin 15 0 47992 25m 12m S 1.3 1.2 0:16.89 php-cgi
23769 admin 15 0 44116 20m 11m S 1.0 1.0 0:16.96 php-cgi
Attualmente tutti i valori sono di default, prima c'era questo... considera che con i valori di default va meglio che con il vecchio my.cnf
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
#skip-name-resolve
safe-show-database
#old_passwords
back_log = 50
skip-innodb
max_connections = 500
max_used_connections= 100
myisam_sort_buffer_size = 64M
key_buffer_size = 128M
join_buffer_size = 4M
read_buffer_size = 4M
sort_buffer_size = 4M
table_cache = 3600
thread_cache_size = 1024
wait_timeout = 40
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
concurrent_insert = 2
table_lock_wait_timeout = 30
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 16M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 65536
query_alloc_block_size = 32768
transaction_alloc_block_size = 4096
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_write_lock_count = 16
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 32M
[myisamchk]
key_buffer = 128M
sort_buffer = 128M
read_buffer = 32M
write_buffer = 32M
Ciao a tutti, sul piccolo vps aruba ho problemi con numfile (principalmente) e kmemsize che vanno in zona gialla e poi nera; non ho trovato grandi soluzioni in giro; ho apportato qualche piccola modifica ma, con pochi siti praticamente non visitati già si presenta il problema ...
1)
vps aruba con 6 siti tutti wordpress
2)
velocità cpu / singolo o multiprocessore: GenuineIntel, Intel(R) Xeon(R)CPU E5405 @ 2.00GHz
Ram: 16 GB condivisa totale; i 140MB di aruba
Tipo HD/configurazione: 3.71 Gb
Sistema Operativo: centos-5-x86
apache/IIS version: Apache 2.2.3
PHP version: 5.1.6
MySQL version: 5.0.22
Plesk 9.2.1
3) No InnoDb, penso, io non le uso, wordpress nemmeno, forse plesk sì
4) Non lo so ... era già presente
5)
6)Codice:top - 17:34:43 up 1:48, 1 user, load average: 0.00, 0.00, 0.00 Tasks: 46 total, 1 running, 45 sleeping, 0 stopped, 0 zombie Cpu(s): 0.0% us, 0.0% sy, 0.0% ni, 100.0% id, 0.0% wa, 0.0% hi, 0.0% si Mem: 16393452k total, 16326680k used, 66772k free, 260364k buffers Swap: 16771852k total, 78408k used, 16693444k free, 2887004k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 1 root 16 0 1964 652 564 S 0 0.0 0:00.01 init 16056 root 16 0 1628 576 484 S 0 0.0 0:00.00 syslogd 16090 sw-cp-se 16 0 5504 1532 800 S 0 0.0 0:00.01 sw-cp-serverd 16115 root 16 0 6072 1032 668 S 0 0.0 0:00.00 sshd 16133 root 18 0 2604 860 696 S 0 0.0 0:00.00 xinetd 16173 root 21 0 5748 812 556 S 0 0.0 0:00.00 couriertcpd 16176 root 18 0 4592 1004 784 S 0 0.0 0:00.00 courierlogger 16189 root 20 0 5748 812 556 S 0 0.0 0:00.00 couriertcpd 16191 root 18 0 4592 1004 784 S 0 0.0 0:00.00 courierlogger 16199 root 21 0 5748 812 556 S 0 0.0 0:00.00 couriertcpd 16201 root 18 0 4592 1004 784 S 0 0.0 0:00.00 courierlogger 16226 root 18 0 5748 812 556 S 0 0.0 0:00.00 couriertcpd 16229 root 18 0 4592 1004 784 S 0 0.0 0:00.00 courierlogger 16263 qmails 16 0 1608 388 316 S 0 0.0 0:00.00 qmail-send 16265 qmaill 16 0 1560 464 400 S 0 0.0 0:00.00 splogger 16266 root 18 0 1588 352 268 S 0 0.0 0:00.00 qmail-lspawn 16267 qmailr 18 0 1584 348 264 S 0 0.0 0:00.00 qmail-rspawn 16268 qmailq 18 0 1552 332 276 S 0 0.0 0:00.00 qmail-clean 16311 root 16 0 35560 14m 8104 S 0 0.1 0:00.20 httpd 16325 apache 16 0 22640 4216 632 S 0 0.0 0:00.00 httpd 16382 named 21 0 107m 3044 1792 S 0 0.0 0:00.00 named 17518 apache 16 0 35692 9076 2060 S 0 0.1 0:00.00 httpd 17520 root 17 0 2340 1120 964 S 0 0.0 0:00.00 mysqld_safe 17581 mysql 15 0 108m 12m 4752 S 0 0.1 0:00.24 mysqld 17674 postgres 16 0 18800 3208 2744 S 0 0.0 0:00.49 postmaster 17721 postgres 16 0 8580 788 320 S 0 0.0 0:00.00 postmaster 17724 postgres 16 0 18800 1048 576 S 0 0.0 0:00.00 postmaster 17725 postgres 16 0 9580 772 304 S 0 0.0 0:00.00 postmaster 17726 postgres 18 0 8808 960 376 S 0 0.0 0:00.00 postmaster 17778 root 16 0 29184 26m 2272 S 0 0.2 0:00.48 spamd 17781 popuser 16 0 29184 24m 932 S 0 0.2 0:00.00 spamd 17998 root 16 0 3184 1104 576 S 0 0.0 0:00.00 crond 18014 root 18 0 5360 700 436 S 0 0.0 0:00.00 saslauthd 18015 root 18 0 5360 428 164 S 0 0.0 0:00.00 saslauthd 31937 root 16 0 10856 2988 2364 S 0 0.0 0:00.06 sshd 32039 root 16 0 2352 1308 1088 S 0 0.0 0:00.02 bash 9605 apache 15 0 35696 9140 2060 S 0 0.1 0:00.00 httpd
7) non trovo i risultati o non mi fa accedereCodice:[mysqld] set-variable=local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=x skip-bdb set-variable = innodb_buffer_pool_size=2M set-variable = innodb_additional_mem_pool_size=500K set-variable = innodb_log_buffer_size=500K set-variable = innodb_thread_concurrency=2 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid skip-bdb set-variable = innodb_buffer_pool_size=2M set-variable = innodb_additional_mem_pool_size=500K set-variable = innodb_log_buffer_size=500K set-variable = innodb_thread_concurrency=2
8) wordpress
9) phpinfo()
10) Qui ho apportato alcune modifiche rispetto a quanto preimpostato
11)Codice:KeepAlive Off MaxKeepAliveRequests 100 KeepAliveTimeout 15 MinSpareServers 3 MaxSpareServers 10 StartServers 3 MaxClients 50 Maxrequestsperchild 2000
12)Codice:[root@62 /]# find / -size +2000000k find: WARNING: Hard link count is wrong for /var/named/run-root/proc/vz/vzaquota: this may be a bug in your filesystem driver. Automatically turning on find's -noleaf option. Earlier results may have failed to include directories that should have been searched. find: /var/named/run-root/proc/15539/task/15539/fd/4: No such file or directory find: /var/named/run-root/proc/15539/fd/4: No such file or directory find: /proc/15539/task/15539/fd/4: No such file or directory find: /proc/15539/fd/4: No such file or directory
Codice:uname-a) Linux 62.149.163.58 2.6.9-023stab051.2-smp #1 SMP Thu Sep 24 22:32:27 MSD 2009 i686 i686 i386 GNU/LinuxCodice:[root@62 ~]# ulimit -aH core file size (blocks, -c) unlimited data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited pending signals (-i) 1024 max locked memory (kbytes, -l) 32 max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 stack size (kbytes, -s) unlimited cpu time (seconds, -t) unlimited max user processes (-u) 139264 virtual memory (kbytes, -v) unlimited file locks (-x) unlimitedGrazie per l'aiuto ed i consigliCodice:cat /proc/cpuinfo parte da processor 0 fino a processor 7 più o meno sempre con i dati che riporto per processor 1 processor : 1 vendor_id : GenuineIntel cpu family : 6 model : 23 model name : Intel(R) Xeon(R) CPU E5405 @ 2.00GHz stepping : 6 cpu MHz : 1995.005 cache size : 6144 KB physical id : 1 siblings : 4 core id : 4 cpu cores : 4 fpu : yes fpu_exception : yes cpuid level : 10 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl tm2 cx16 xtpr lahf_lm bogomips : 3990.02 clflush size : 64 cache_alignment : 64 address sizes : 38 bits physical, 48 bits virtual power management:
le configurazioni per i vps di aruba, sia basic che professional sono già presenti sul thread ... usa il search
Il miglior sito italiano su winning eleven e pro evolution soccer
Ubuntu è una antica parola africana che significa: "Non so installare Debian"
Ciao Alex,
grazie per la risposta; ho già spulciato nel forum ... ma evidentemente non abbastanza ... quindi continuerò a cercare anche se, leggendo attentamente alcuni thread ho capito che nessuna configurazione è uguale ad un'altra (ed io da incompetente ci ho piazzato su plesk 9.2) quindi, se qualcuno vorrà dare uno sguardo alla mia lasciandomi dei consigli
Da quel che ho appreso finora, tra il forum e altre mie ricerche emerge che:
- la ram di un vps basic di aruba è comunque troppo poca, sopratutto se abbinata a plesk
- non bisogna mai aggiornare plesk rispetto alla configurazione base fornita da aruba per evitare risposte dall'assistenza del tipo "lei ha modifcato la configurazione originale quindi ..."
- Ho provato il vps con l'intento di testarlo per poi spostarci su un sito che inizia a passare i 1000 unici giornalieri ma mi sembra inutile portarlo su una macchina con poca ram e dove girano altri 5/6000 siti altri (se i risultati trovati online non dicono minchiate).
- numfile crea problemi non risolti a molta gente; penso che la soluzione sia su numfile issue - Parallels Forums ... ma per chi è su aruba ed ha fatto l'aggiornamento di plesk alla 9.2... l'unica soluzione è quella di farsi reinstallare la configurazione base (sulla quale però non son riuscito a far girare wordpress).
Salve,
Mi pare strano che , relativamente alle VPS, su di un Server siano installate 5/6000 macchine virtuali ... un conto è lo Shared Hosting, un conto sono le VPS ... ancorchè di tipologia Basic ...Ho provato il vps con l'intento di testarlo per poi spostarci su un sito che inizia a passare i 1000 unici giornalieri ma mi sembra inutile portarlo su una macchina con poca ram e dove girano altri 5/6000 siti altri (se i risultati trovati online non dicono minchiate).
Ciao !!
Site Admin http://www.pctrio.com
1) Tipo di server: VPS.net (2 nodi) CentOS 5.4 x64 with cPanel and WHM
2) Specifiche del server:
velocità cpu / singolo o multiprocessore: 1.2GHz / multicore
Ram: 752MB
Tipo HD/configurazione: 20GB
Sistema Operativo: CentOS 5.4 x64
apache/IIS version: Non uso Apache ma LiteSpeed V5.3 (posso anche switchare su Apache 2.0.63 ma voglio usare LiteSpeed)
PHP version: 5.3.2
MySQL version: 5.0.90
3) Se si usa mysql > 4.* specificare se sono presenti database o tabelle che usano InnoDB
No, uso solo WordPress su MySQL.
4) Come è stato installato Mysql? (compilato a mano o precompilato)
Mi è stato configurato (da Nick Nelson di VPS.net) quindi non saprei dire di preciso.
5) Eseguire "top" e scrivere il risultato:
6) Copiare il file di configurazione my.cnf (o my.ini) escludendo eventuali passwordCodice:top - 09:55:26 up 19:24, 1 user, load average: 0.29, 0.13, 0.10 Tasks: 71 total, 2 running, 69 sleeping, 0 stopped, 0 zombie Cpu(s): 0.3%us, 0.7%sy, 0.0%ni, 98.7%id, 0.2%wa, 0.0%hi, 0.2%si, 0.0%st Mem: 770048k total, 603988k used, 166060k free, 71504k buffers Swap: 1048568k total, 48k used, 1048520k free, 325792k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 25979 nobody 0 -19 22000 5980 476 S 0.3 0.8 0:00.07 lshttpd 1 root 15 0 10348 700 592 S 0.0 0.1 0:00.01 init 2 root RT -5 0 0 0 S 0.0 0.0 0:00.03 migration/0 3 root 34 19 0 0 0 S 0.0 0.0 0:00.01 ksoftirqd/0 4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0 5 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/0 6 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 khelper 7 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kthread 9 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 xenwatch 10 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 xenbus 15 root RT -5 0 0 0 S 0.0 0.0 0:00.04 migration/1 16 root 34 19 0 0 0 S 0.0 0.0 0:00.01 ksoftirqd/1 17 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/1 18 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/1 21 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kblockd/0 22 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kblockd/1 23 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/0 24 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 cqueue/1 28 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 khubd 30 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kseriod 97 root 25 0 0 0 0 S 0.0 0.0 0:00.00 pdflush 98 root 15 0 0 0 0 S 0.0 0.0 0:00.01 pdflush 99 root 10 -5 0 0 0 S 0.0 0.0 0:00.06 kswapd0 100 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 aio/0 101 root 20 -5 0 0 0 S 0.0 0.0 0:00.00 aio/1 231 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 kpsmoused 259 root 15 -5 0 0 0 S 0.0 0.0 0:00.00 kstriped 272 root 10 -5 0 0 0 S 0.0 0.0 0:00.30 kjournald 294 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 kauditd 322 root 15 -4 12604 704 388 S 0.0 0.1 0:00.09 udevd 655 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 kmpathd/0 656 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 kmpathd/1 657 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 kmpath_handlerd 794 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 loop0 795 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kjournald 1020 root 15 0 5908 624 500 S 0.0 0.1 0:00.05 syslogd 1023 root 15 0 3804 440 352 S 0.0 0.1 0:00.00 klogd 1057 named 18 0 6552 720 516 S 0.0 0.1 0:00.00 nsd 1061 named 24 0 13416 596 176 S 0.0 0.1 0:00.00 nsd 1064 named 24 0 6684 392 100 S 0.0 0.1 0:00.00 nsd 1068 dbus 21 0 21264 724 516 S 0.0 0.1 0:00.00 dbus-daemon 1097 root 15 0 62632 1212 652 S 0.0 0.2 0:00.00 sshd 1109 root 25 0 65912 1276 1068 S 0.0 0.2 0:00.01 mysqld_safe 1133 mysql 15 0 115m 10m 3484 S 0.0 1.4 8:19.85 mysqld 1502 mailnull 15 0 64332 2060 1588 S 0.0 0.3 0:00.10 exim 1539 root 15 0 12408 648 452 S 0.0 0.1 0:00.14 dovecot
/etc/my.cnf
/usr/local/cpanel/whostmgr/my.cnfCodice:[mysqld] skip-innodb
7) il risultato di questo :Codice:[mysqld] set-variable = max_connections=500 safe-show-database
mysqlreport --all -tab /statistics.txt
Ho fatto anche una ricerca del file, "find / -name statistics.txt" con nessun risultato, quindi non c'è.Codice:-bash: mysqlreport: command not found
o alternativamente di:
mysqladmin -u root -p var ext stat ver
Se più comodo, ho caricato il risultato qui www.ofertebebe.ro/stats.txt8) che tipologia di siti ci sono sul server?Codice:+-----------------------------------------+----------------------------------------------+ | Variable_name | Value | +-----------------------------------------+----------------------------------------------+ | auto_increment_increment | 1 | | auto_increment_offset | 1 | | automatic_sp_privileges | ON | | back_log | 50 | | basedir | / | | 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/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 | /var/lib/mysql/ | | 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 | | keep_files_on_create | OFF | | 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 | YES | | have_compress | YES | | have_community_features | NO | | have_profiling | NO | | have_crypt | YES | | have_csv | YES | | have_dynamic_loading | YES | | have_example_engine | YES | | have_federated_engine | YES | | have_geometry | YES | | have_innodb | DISABLED | | have_isam | NO | | have_merge_engine | YES | | have_ndbcluster | NO | | have_openssl | NO | | have_ssl | NO | | have_query_cache | YES | | have_raid | NO | | have_rtree_keys | YES | | have_symlink | YES | | hostname | webserver.MioDOMINIO.it | | 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_adaptive_hash_index | ON | | 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_rollback_on_timeout | OFF | | innodb_support_xa | ON | | innodb_sync_spin_loops | 20 | | innodb_table_locks | ON | | innodb_thread_concurrency | 8 | | innodb_thread_sleep_delay | 10000 | | innodb_use_legacy_cardinality_algorithm | ON | | interactive_timeout | 28800 | | join_buffer_size | 131072 | | key_buffer_size | 8384512 | | key_cache_age_threshold | 300 | | key_cache_block_size | 1024 | | key_cache_division_limit | 100 | | language | /usr/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 | 1048576 | | max_binlog_cache_size | 18446744073709547520 | | 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 | 18446744073709551615 | | max_length_for_sort_data | 1024 | | max_prepared_stmt_count | 16382 | | max_relay_log_size | 0 | | max_seeks_for_key | 18446744073709551615 | | max_sort_length | 1024 | | max_sp_recursion_depth | 0 | | max_tmp_tables | 32 | | max_user_connections | 0 | | max_write_lock_count | 18446744073709551615 | | multi_range_count | 256 | | myisam_data_pointer_size | 6 | | myisam_max_sort_file_size | 9223372036853727232 | | myisam_mmap_size | 18446744073709551615 | | myisam_recover_options | OFF | | myisam_repair_threads | 1 | | myisam_sort_buffer_size | 8388608 | | 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 | 1024 | | optimizer_prune_level | 1 | | optimizer_search_depth | 62 | | pid_file | /var/lib/mysql/webserver.MioDOMINIO.it.pid | | plugin_dir | | | 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 | 4096 | | read_buffer_size | 131072 | | read_only | OFF | | read_rnd_buffer_size | 262144 | | relay_log | | | relay_log_index | | | relay_log_info_file | relay-log.info | | relay_log_purge | ON | | relay_log_space_limit | 0 | | rpl_recovery_rank | 0 | | secure_auth | OFF | | secure_file_priv | | | server_id | 0 | | 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 | /var/lib/mysql/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 | 64 | | table_lock_wait_timeout | 50 | | table_type | MyISAM | | thread_cache_size | 0 | | thread_stack | 262144 | | 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.90-community | | version_comment | MySQL Community Edition (GPL) | | version_compile_machine | x86_64 | | version_compile_os | unknown-linux-gnu | | wait_timeout | 28800 | +-----------------------------------------+----------------------------------------------+ +-----------------------------------+------------+ | Variable_name | Value | +-----------------------------------+------------+ | Aborted_clients | 58 | | Aborted_connects | 7 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 0 | | Bytes_received | 152337328 | | Bytes_sent | 1945406561 | | Com_admin_commands | 115 | | Com_alter_db | 0 | | Com_alter_table | 0 | | Com_analyze | 0 | | Com_backup_table | 0 | | Com_begin | 0 | | Com_call_procedure | 0 | | Com_change_db | 5476 | | 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 | 0 | | Com_create_user | 0 | | Com_dealloc_sql | 0 | | Com_delete | 736 | | Com_delete_multi | 0 | | Com_do | 0 | | Com_drop_db | 0 | | Com_drop_function | 0 | | Com_drop_index | 0 | | Com_drop_table | 0 | | Com_drop_user | 0 | | Com_execute_sql | 0 | | Com_flush | 1 | | Com_grant | 0 | | Com_ha_close | 0 | | Com_ha_open | 0 | | Com_ha_read | 0 | | Com_help | 0 | | Com_insert | 738 | | Com_insert_select | 196 | | Com_kill | 0 | | Com_load | 0 | | Com_load_master_data | 0 | | Com_load_master_table | 0 | | Com_lock_tables | 175 | | Com_optimize | 2 | | 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 | 0 | | 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 | 377626 | | Com_set_option | 11682 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 1 | | Com_show_charsets | 1 | | Com_show_collations | 1 | | Com_show_column_types | 0 | | Com_show_create_db | 0 | | Com_show_create_table | 32 | | Com_show_databases | 11 | | Com_show_errors | 0 | | Com_show_fields | 32 | | Com_show_grants | 1 | | Com_show_innodb_status | 0 | | Com_show_keys | 14 | | 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 | 260 | | Com_show_slave_hosts | 0 | | Com_show_slave_status | 0 | | Com_show_status | 10 | | Com_show_storage_engines | 0 | | Com_show_tables | 27 | | Com_show_triggers | 32 | | Com_show_variables | 8 | | 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 | 0 | | Com_unlock_tables | 175 | | Com_update | 19281 | | Com_update_multi | 22 | | 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 | 6458 | | Created_tmp_disk_tables | 98481 | | Created_tmp_files | 0 | | Created_tmp_tables | 100465 | | Delayed_errors | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Flush_commands | 1 | | Handler_commit | 0 | | Handler_delete | 1206 | | Handler_discover | 0 | | Handler_prepare | 0 | | Handler_read_first | 967 | | Handler_read_key | 161685667 | | Handler_read_next | 155970918 | | Handler_read_prev | 578180 | | Handler_read_rnd | 3466140 | | Handler_read_rnd_next | 10153032 | | Handler_rollback | 0 | | Handler_savepoint | 0 | | Handler_savepoint_rollback | 0 | | Handler_update | 15064 | | Handler_write | 6198390 | | 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_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 | 5088 | | Key_blocks_used | 1606 | | Key_read_requests | 493131185 | | Key_reads | 3263 | | Key_write_requests | 5301 | | Key_writes | 2619 | | Last_query_cost | 0.000000 | | Max_used_connections | 6 | | Not_flushed_delayed_rows | 0 | | Open_files | 114 | | Open_streams | 0 | | Open_tables | 64 | | Opened_tables | 609 | | Prepared_stmt_count | 0 | | 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 | | Queries | 422956 | | Questions | 422956 | | Rpl_status | NULL | | Select_full_join | 0 | | Select_full_range_join | 0 | | Select_range | 58466 | | Select_range_check | 0 | | Select_scan | 8823 | | Slave_open_temp_tables | 0 | | Slave_retried_transactions | 0 | | Slave_running | OFF | | Slow_launch_threads | 0 | | Slow_queries | 4 | | Sort_merge_passes | 0 | | Sort_range | 49807 | | Sort_rows | 6469866 | | Sort_scan | 101888 | | Table_locks_immediate | 492539 | | Table_locks_waited | 53 | | Tc_log_max_pages_used | 0 | | Tc_log_page_size | 0 | | Tc_log_page_waits | 0 | | Threads_cached | 0 | | Threads_connected | 2 | | Threads_created | 6457 | | Threads_running | 1 | | Uptime | 77499 | +-----------------------------------+------------+ Uptime: 77499 Threads: 2 Questions: 422957 Slow queries: 4 Opens: 609 Flush tables: 1 Open tables: 64 Queries per second avg: 5.458 mysqladmin Ver 8.41 Distrib 5.0.90, for unknown-linux-gnu on x86_64 Copyright (C) 2000-2006 MySQL 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.90-community Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 21 hours 31 min 39 sec Threads: 2 Questions: 422957 Slow queries: 4 Opens: 609 Flush tables: 1 Open tables: 64 Queries per second avg: 5.458
2 siti WordPress, uno per vendere che poi è un dominio rumeno (come si vedrà anche sotto
9) linkate una pagina phpinfo
phpinfo()
10) Scrivete i seguenti dati della vostra configurazione di apache:
Non uso Apache.
11) verificate cosa ritorna questo comando:
find / -size +2000000k
12) Scrivete il risultato dei seguenti 3 comandi:Codice:find: /proc/32531/task/32531/fd/4: No such file or directory find: /proc/32531/fd/4: No such file or directory
uname -a
ulimit -aHCodice:Linux webserver.MioDOMINIO.it 2.6.18-164.15.1.el5xen #1 SMP Wed Mar 17 12:04:23 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
cat /proc/cpuinfoCodice:core file size (blocks, -c) unlimited data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 6080 max locked memory (kbytes, -l) 32 max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) unlimited cpu time (seconds, -t) unlimited max user processes (-u) 6080 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited
ps. grazie milleCodice:processor : 0 vendor_id : GenuineIntel cpu family : 6 model : 26 model name : Intel(R) Xeon(R) CPU E5504 @ 2.00GHz stepping : 4 cpu MHz : 2000.070 cache size : 4096 KB physical id : 0 siblings : 1 core id : 0 cpu cores : 1 fpu : yes fpu_exception : yes cpuid level : 11 wp : yes flags : fpu tsc msr pae mce cx8 apic mca cmov pat pse36 clflush dts ac pi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm bogomips : 5007.14 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: processor : 1 vendor_id : GenuineIntel cpu family : 6 model : 26 model name : Intel(R) Xeon(R) CPU E5504 @ 2.00GHz stepping : 4 cpu MHz : 2000.070 cache size : 4096 KB physical id : 1 siblings : 1 core id : 0 cpu cores : 1 fpu : yes fpu_exception : yes cpuid level : 11 wp : yes flags : fpu tsc msr pae mce cx8 apic mca cmov pat pse36 clflush dts ac pi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm bogomips : 5007.14 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management:
ps2. ho anche questo problema qui http://www.litespeedtech.com/support...ad.php?p=19504 che penso sia legato alla configurazione del server :S
Ci sono attualmente 1 utenti che stanno visualizzando questa discussione. (0 utenti e 1 ospiti)
Permessi di Scrittura
© 2006 - 2011 WeTalk Group di Vasini Luca e Bellasio Stefano s.n.c. - P.iva 03958550406
E' vietata la riproduzione anche parziale dei contenuti
Rispondi Citando
Segnalibri