masood_y
Sun 4th Nov '07, 4:21pm
1- server is dedicated
2- cpu speed: Dual Intel(R) Xeon(R) CPU 3060 @ 2.40GHz with 4096 KB cache
ram: 3gb
h.d.d: 250gb sata2
linux os: centos 4
apache version: 2.2.6
php version: 5.2.4
mysql version: 5.0.27-standard
3- 3.6.8
5- with easyapache
6- top stats:
top - 00:00:26 up 2 days, 21:53, 1 user, load average: 1.44, 1.06, 1.56
Tasks: 370 total, 4 running, 331 sleeping, 0 stopped, 35 zombie
Cpu(s): 43.6% us, 9.0% sy, 0.0% ni, 36.1% id, 11.3% wa, 0.0% hi, 0.0% si
Mem: 3114144k total, 2945912k used, 168232k free, 101016k buffers
Swap: 2096440k total, 278844k used, 1817596k free, 1668708k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
19627 mysql 11 -5 750m 528m 3764 S 36 17.4 42:46.26 mysqld
6811 parsdvb 24 0 0 0 0 Z 35 0.0 0:01.04 php <defunct>
6820 sat4u 17 0 0 0 0 Z 8 0.0 0:00.24 php <defunct>
6822 parsdvb 19 0 29980 16m 5020 R 5 0.5 0:00.15 php
6818 sat4u 18 0 0 0 0 Z 2 0.0 0:00.07 php <defunct>
3945 nobody 16 0 33604 16m 2120 S 1 0.5 0:00.14 httpd
6490 nobody 15 0 33552 16m 1976 S 1 0.5 0:00.03 httpd
2640 nobody 15 0 33676 16m 2156 S 0 0.6 0:00.17 httpd
3943 nobody 16 0 33608 16m 2076 S 0 0.5 0:00.04 httpd
4832 nobody 16 0 33624 16m 1984 S 0 0.5 0:00.07 httpd
5274 nobody 15 0 33496 16m 1968 S 0 0.5 0:00.02 httpd
6372 nobody 16 0 33476 16m 2008 S 0 0.5 0:00.03 httpd
6744 root 16 0 2612 1156 764 R 0 0.0 0:00.08 top
1 root 16 0 3076 544 468 S 0 0.0 0:03.30 init
2 root RT 0 0 0 0 S 0 0.0 0:01.78 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:00.98 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.67 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.75 ksoftirqd/1
6 root 5 -10 0 0 0 S 0 0.0 0:01.66 events/0
7 root 5 -10 0 0 0 S 0 0.0 0:00.56 events/1
8 root 8 -10 0 0 0 S 0 0.0 0:00.00 khelper
9 root 6 -10 0 0 0 S 0 0.0 0:00.00 kacpid
34 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/0
35 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/1
36 root 15 0 0 0 0 S 0 0.0 0:00.00 khubd
55 root 15 0 0 0 0 S 0 0.0 1:26.87 kswapd0
56 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/0
57 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/1
201 root 25 0 0 0 0 S 0 0.0 0:00.00 kseriod
434 root 5 -10 0 0 0 S 0 0.0 0:00.00 ata/0
435 root 5 -10 0 0 0 S 0 0.0 0:00.00 ata/1
436 root 8 -10 0 0 0 S 0 0.0 0:00.00 ata_aux
440 root 16 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_0
441 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_1
462 root 15 0 0 0 0 S 0 0.0 0:08.49 kjournald
945 root 16 0 6672 5068 2844 S 0 0.2 0:00.19 authProg
1151 root 16 0 6672 3568 2844 S 0 0.1 0:01.29 authProg
1589 root 6 -10 2276 396 360 S 0 0.0 0:00.00 udevd
1596 p30plan 16 0 7804 976 780 S 0 0.0 0:00.01 pure-ftpd
7- mysql configuration:
[mysqld]
#old_passwords
back_log = 50
skip-locking
skip-innodb
safe-show-database
max_connections = 500
key_buffer = 256M
myisam_sort_buffer_size = 64M
join_buffer_size = 4M
read_buffer_size = 4M
sort_buffer_size = 4M
table_cache = 16384
thread_cache_size = 128
wait_timeout = 45
connect_timeout = 10
tmp_table_size = 268435456
max_heap_table_size = 268435456
max_allowed_packet = 32M
max_connect_errors = 10
thread_concurrency = 4
concurrent_insert = 2
table_lock_wait_timeout = 35
read_rnd_buffer_size = 4M
bulk_insert_buffer_size = 8M
query_cache_limit = 32M
query_cache_size = 256M
query_cache_type = 1
query_prealloc_size = 131072
query_alloc_block_size = 65536
default-storage-engine = MyISAM
[mysqld_safe]
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
8- mysql stat:
+---------------------------------+------------------------------------------+
| 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 | 2 |
| 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 |
| 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 | YES |
| 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 | 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_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 | 28800 |
| join_buffer_size | 4190208 |
| key_buffer_size | 268435456 |
| 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 | 33553408 |
| 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 | 268434432 |
| 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 | 33278 |
| optimizer_prune_level | 1 |
| optimizer_search_depth | 62 |
| pid_file | /var/lib/mysql/linux1.worldbus.us.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 65536 |
| query_cache_limit | 33554432 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 268435456 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 131072 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 4190208 |
| read_only | OFF |
| read_rnd_buffer_size | 4190208 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| 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 | 4194296 |
| 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 | GST |
| table_cache | 16384 |
| table_lock_wait_timeout | 35 |
| table_type | MyISAM |
| thread_cache_size | 128 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| timed_mutexes | OFF |
| tmp_table_size | 268435456 |
| 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 | 45 |
+---------------------------------+------------------------------------------+
+-----------------------------------+------------+
| Variable_name | Value |
+-----------------------------------+------------+
| Aborted_clients | 1120 |
| Aborted_connects | 1056 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 614804291 |
| Bytes_sent | 2695311844 |
| Com_admin_commands | 49 |
| Com_alter_db | 0 |
| Com_alter_table | 2 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 18 |
| Com_change_db | 173381 |
| Com_change_master | 0 |
| Com_check | 709 |
| Com_checksum | 0 |
| Com_commit | 18 |
| Com_create_db | 5 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 7132 |
| Com_dealloc_sql | 0 |
| Com_delete | 52472 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 4 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 185 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 214 |
| Com_grant | 105 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 86023 |
| Com_insert_select | 544 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 2340 |
| Com_optimize | 647 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 167 |
| Com_replace | 10324 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 5 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 664000 |
| Com_set_option | 37558 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 14 |
| Com_show_charsets | 109 |
| Com_show_collations | 109 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 1089 |
| Com_show_databases | 277 |
| Com_show_errors | 0 |
| Com_show_fields | 1879 |
| Com_show_grants | 172 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 2448 |
| 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 | 135 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 4 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 741 |
| Com_show_triggers | 1068 |
| Com_show_variables | 543 |
| 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 | 260 |
| Com_unlock_tables | 2346 |
| Com_update | 177075 |
| Com_update_multi | 728 |
| 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 | 143700 |
| Created_tmp_disk_tables | 10435 |
| Created_tmp_files | 8701 |
| Created_tmp_tables | 56062 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 37871 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 97125 |
| Handler_read_key | 22949202 |
| Handler_read_next | 109084908 |
| Handler_read_prev | 1857068 |
| Handler_read_rnd | 6281503 |
| Handler_read_rnd_next | 693797043 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 12139916 |
| Handler_write | 7539933 |
| 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 | 130144 |
| Key_blocks_used | 155339 |
| Key_read_requests | 55472361 |
| Key_reads | 312235 |
| Key_write_requests | 593988 |
| Key_writes | 312413 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 156 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 10848 |
| Open_streams | 0 |
| Open_tables | 6062 |
| Opened_tables | 8135 |
| Qcache_free_blocks | 18858 |
| Qcache_free_memory | 66176680 |
| Qcache_hits | 2590659 |
| Qcache_inserts | 635707 |
| Qcache_lowmem_prunes | 18509 |
| Qcache_not_cached | 28946 |
| Qcache_queries_in_cache | 49281 |
| Qcache_total_blocks | 123703 |
| Questions | 3961066 |
| Rpl_status | NULL |
| Select_full_join | 612 |
| Select_full_range_join | 2 |
| Select_range | 84317 |
| Select_range_check | 0 |
| Select_scan | 188161 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 1217 |
| Sort_merge_passes | 4350 |
| Sort_range | 96550 |
| Sort_rows | 52110515 |
| Sort_scan | 69737 |
| Table_locks_immediate | 1378745 |
| Table_locks_waited | 1045 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 126 |
| Threads_connected | 2 |
| Threads_created | 156 |
| Threads_running | 1 |
| Uptime | 40695 |
+-----------------------------------+------------+
Uptime: 40767 Threads: 8 Questions: 3967428 Slow queries: 1217 Opens: 8135 Flush tables: 1 Open tables: 6062 Queries per second avg: 97.320
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 /var/lib/mysql/mysql.sock
Uptime: 11 hours 19 min 27 sec
Threads: 8 Questions: 3967428 Slow queries: 1217 Opens: 8135 Flush tables: 1 Open tables: 6062 Queries per second avg: 97.320
command: No such file or directory
9- with vBSEO
10- 1000-2000 user
11- http://parsdvb.com/phpinfo.php
12- KeepAlive : N/A in httpd.conf
MaxKeepAliveRequests : N/A in httpd.conf
KeepAliveTimeout : N/A in httpd.conf
MinSpareServers : N/A in httpd.conf
MaxSpareServers : N/A in httpd.conf
StartServers : N/A in httpd.conf
MaxClients : 300
Maxrequestsperchild value : N/A in httpd.conf
13- [root@linux1 public_html]# find / -size +2000000k
find: /proc/6958/task: No such file or directory
find: /proc/17267: No such file or directory
find: /proc/17532/task: No such file or directory
find: /proc/17658/task: No such file or directory
find: /proc/17717/task: No such file or directory
find: /proc/17970/task: No such file or directory
find: /proc/18199/task: No such file or directory
find: /proc/18273/task: No such file or directory
find: /proc/18440/task: No such file or directory
find: /proc/18528/task: No such file or directory
find: /proc/18559/task: No such file or directory
find: /proc/18636/task: No such file or directory
find: /proc/18667/task: No such file or directory
find: /proc/18835/task/18835/fd/4: No such file or directory
find: /proc/18838/task: No such file or directory
find: /proc/18839/task: No such file or directory
find: /proc/18913/task: No such file or directory
find: /proc/18921/task: No such file or directory
find: /proc/18941/task: No such file or directory
find: /proc/18949/task: No such file or directory
find: /proc/19023/task: No such file or directory
find: /proc/19063/task: No such file or directory
find: /proc/19071/task: No such file or directory
find: /proc/19076: No such file or directory
find: /proc/19077: No such file or directory
find: /proc/19078/task: No such file or directory
find: /proc/19080: No such file or directory
find: /proc/19090/task: No such file or directory
find: /proc/19094/task: No such file or directory
find: /proc/19097/task: No such file or directory
find: /proc/19103: No such file or directory
/root/irantk.tar.gz
14- uname -a:
Linux linux1.worldbus.us 2.6.9-55.0.2.ELsmp #1 SMP Tue Jun 12 17:59:08 EDT 2007 i686 i686 i386 GNU/Linux
ulimit -aH
core file size (blocks, -c) 1000000
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) 4096
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
cat /proc/cpuinfo:
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU 3060 @ 2.40GHz
stepping : 6
cpu MHz : 2394.782
cache size : 4096 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
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 pbe nx lm constant_tsc pni monitor ds_cpl est tm2 xtpr
bogomips : 4791.30
processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU 3060 @ 2.40GHz
stepping : 6
cpu MHz : 2394.782
cache size : 4096 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
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 pbe nx lm constant_tsc pni monitor ds_cpl est tm2 xtpr
bogomips : 4787.37
2- cpu speed: Dual Intel(R) Xeon(R) CPU 3060 @ 2.40GHz with 4096 KB cache
ram: 3gb
h.d.d: 250gb sata2
linux os: centos 4
apache version: 2.2.6
php version: 5.2.4
mysql version: 5.0.27-standard
3- 3.6.8
5- with easyapache
6- top stats:
top - 00:00:26 up 2 days, 21:53, 1 user, load average: 1.44, 1.06, 1.56
Tasks: 370 total, 4 running, 331 sleeping, 0 stopped, 35 zombie
Cpu(s): 43.6% us, 9.0% sy, 0.0% ni, 36.1% id, 11.3% wa, 0.0% hi, 0.0% si
Mem: 3114144k total, 2945912k used, 168232k free, 101016k buffers
Swap: 2096440k total, 278844k used, 1817596k free, 1668708k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
19627 mysql 11 -5 750m 528m 3764 S 36 17.4 42:46.26 mysqld
6811 parsdvb 24 0 0 0 0 Z 35 0.0 0:01.04 php <defunct>
6820 sat4u 17 0 0 0 0 Z 8 0.0 0:00.24 php <defunct>
6822 parsdvb 19 0 29980 16m 5020 R 5 0.5 0:00.15 php
6818 sat4u 18 0 0 0 0 Z 2 0.0 0:00.07 php <defunct>
3945 nobody 16 0 33604 16m 2120 S 1 0.5 0:00.14 httpd
6490 nobody 15 0 33552 16m 1976 S 1 0.5 0:00.03 httpd
2640 nobody 15 0 33676 16m 2156 S 0 0.6 0:00.17 httpd
3943 nobody 16 0 33608 16m 2076 S 0 0.5 0:00.04 httpd
4832 nobody 16 0 33624 16m 1984 S 0 0.5 0:00.07 httpd
5274 nobody 15 0 33496 16m 1968 S 0 0.5 0:00.02 httpd
6372 nobody 16 0 33476 16m 2008 S 0 0.5 0:00.03 httpd
6744 root 16 0 2612 1156 764 R 0 0.0 0:00.08 top
1 root 16 0 3076 544 468 S 0 0.0 0:03.30 init
2 root RT 0 0 0 0 S 0 0.0 0:01.78 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:00.98 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.67 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.75 ksoftirqd/1
6 root 5 -10 0 0 0 S 0 0.0 0:01.66 events/0
7 root 5 -10 0 0 0 S 0 0.0 0:00.56 events/1
8 root 8 -10 0 0 0 S 0 0.0 0:00.00 khelper
9 root 6 -10 0 0 0 S 0 0.0 0:00.00 kacpid
34 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/0
35 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/1
36 root 15 0 0 0 0 S 0 0.0 0:00.00 khubd
55 root 15 0 0 0 0 S 0 0.0 1:26.87 kswapd0
56 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/0
57 root 6 -10 0 0 0 S 0 0.0 0:00.00 aio/1
201 root 25 0 0 0 0 S 0 0.0 0:00.00 kseriod
434 root 5 -10 0 0 0 S 0 0.0 0:00.00 ata/0
435 root 5 -10 0 0 0 S 0 0.0 0:00.00 ata/1
436 root 8 -10 0 0 0 S 0 0.0 0:00.00 ata_aux
440 root 16 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_0
441 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_1
462 root 15 0 0 0 0 S 0 0.0 0:08.49 kjournald
945 root 16 0 6672 5068 2844 S 0 0.2 0:00.19 authProg
1151 root 16 0 6672 3568 2844 S 0 0.1 0:01.29 authProg
1589 root 6 -10 2276 396 360 S 0 0.0 0:00.00 udevd
1596 p30plan 16 0 7804 976 780 S 0 0.0 0:00.01 pure-ftpd
7- mysql configuration:
[mysqld]
#old_passwords
back_log = 50
skip-locking
skip-innodb
safe-show-database
max_connections = 500
key_buffer = 256M
myisam_sort_buffer_size = 64M
join_buffer_size = 4M
read_buffer_size = 4M
sort_buffer_size = 4M
table_cache = 16384
thread_cache_size = 128
wait_timeout = 45
connect_timeout = 10
tmp_table_size = 268435456
max_heap_table_size = 268435456
max_allowed_packet = 32M
max_connect_errors = 10
thread_concurrency = 4
concurrent_insert = 2
table_lock_wait_timeout = 35
read_rnd_buffer_size = 4M
bulk_insert_buffer_size = 8M
query_cache_limit = 32M
query_cache_size = 256M
query_cache_type = 1
query_prealloc_size = 131072
query_alloc_block_size = 65536
default-storage-engine = MyISAM
[mysqld_safe]
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
8- mysql stat:
+---------------------------------+------------------------------------------+
| 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 | 2 |
| 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 |
| 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 | YES |
| 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 | 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_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 | 28800 |
| join_buffer_size | 4190208 |
| key_buffer_size | 268435456 |
| 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 | 33553408 |
| 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 | 268434432 |
| 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 | 33278 |
| optimizer_prune_level | 1 |
| optimizer_search_depth | 62 |
| pid_file | /var/lib/mysql/linux1.worldbus.us.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 65536 |
| query_cache_limit | 33554432 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 268435456 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 131072 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 4190208 |
| read_only | OFF |
| read_rnd_buffer_size | 4190208 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| 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 | 4194296 |
| 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 | GST |
| table_cache | 16384 |
| table_lock_wait_timeout | 35 |
| table_type | MyISAM |
| thread_cache_size | 128 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| timed_mutexes | OFF |
| tmp_table_size | 268435456 |
| 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 | 45 |
+---------------------------------+------------------------------------------+
+-----------------------------------+------------+
| Variable_name | Value |
+-----------------------------------+------------+
| Aborted_clients | 1120 |
| Aborted_connects | 1056 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 614804291 |
| Bytes_sent | 2695311844 |
| Com_admin_commands | 49 |
| Com_alter_db | 0 |
| Com_alter_table | 2 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 18 |
| Com_change_db | 173381 |
| Com_change_master | 0 |
| Com_check | 709 |
| Com_checksum | 0 |
| Com_commit | 18 |
| Com_create_db | 5 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 7132 |
| Com_dealloc_sql | 0 |
| Com_delete | 52472 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 4 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 185 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 214 |
| Com_grant | 105 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 86023 |
| Com_insert_select | 544 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 2340 |
| Com_optimize | 647 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 167 |
| Com_replace | 10324 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 5 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 664000 |
| Com_set_option | 37558 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 14 |
| Com_show_charsets | 109 |
| Com_show_collations | 109 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 1089 |
| Com_show_databases | 277 |
| Com_show_errors | 0 |
| Com_show_fields | 1879 |
| Com_show_grants | 172 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 2448 |
| 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 | 135 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 4 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 741 |
| Com_show_triggers | 1068 |
| Com_show_variables | 543 |
| 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 | 260 |
| Com_unlock_tables | 2346 |
| Com_update | 177075 |
| Com_update_multi | 728 |
| 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 | 143700 |
| Created_tmp_disk_tables | 10435 |
| Created_tmp_files | 8701 |
| Created_tmp_tables | 56062 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 37871 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 97125 |
| Handler_read_key | 22949202 |
| Handler_read_next | 109084908 |
| Handler_read_prev | 1857068 |
| Handler_read_rnd | 6281503 |
| Handler_read_rnd_next | 693797043 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 12139916 |
| Handler_write | 7539933 |
| 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 | 130144 |
| Key_blocks_used | 155339 |
| Key_read_requests | 55472361 |
| Key_reads | 312235 |
| Key_write_requests | 593988 |
| Key_writes | 312413 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 156 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 10848 |
| Open_streams | 0 |
| Open_tables | 6062 |
| Opened_tables | 8135 |
| Qcache_free_blocks | 18858 |
| Qcache_free_memory | 66176680 |
| Qcache_hits | 2590659 |
| Qcache_inserts | 635707 |
| Qcache_lowmem_prunes | 18509 |
| Qcache_not_cached | 28946 |
| Qcache_queries_in_cache | 49281 |
| Qcache_total_blocks | 123703 |
| Questions | 3961066 |
| Rpl_status | NULL |
| Select_full_join | 612 |
| Select_full_range_join | 2 |
| Select_range | 84317 |
| Select_range_check | 0 |
| Select_scan | 188161 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 1217 |
| Sort_merge_passes | 4350 |
| Sort_range | 96550 |
| Sort_rows | 52110515 |
| Sort_scan | 69737 |
| Table_locks_immediate | 1378745 |
| Table_locks_waited | 1045 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 126 |
| Threads_connected | 2 |
| Threads_created | 156 |
| Threads_running | 1 |
| Uptime | 40695 |
+-----------------------------------+------------+
Uptime: 40767 Threads: 8 Questions: 3967428 Slow queries: 1217 Opens: 8135 Flush tables: 1 Open tables: 6062 Queries per second avg: 97.320
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 /var/lib/mysql/mysql.sock
Uptime: 11 hours 19 min 27 sec
Threads: 8 Questions: 3967428 Slow queries: 1217 Opens: 8135 Flush tables: 1 Open tables: 6062 Queries per second avg: 97.320
command: No such file or directory
9- with vBSEO
10- 1000-2000 user
11- http://parsdvb.com/phpinfo.php
12- KeepAlive : N/A in httpd.conf
MaxKeepAliveRequests : N/A in httpd.conf
KeepAliveTimeout : N/A in httpd.conf
MinSpareServers : N/A in httpd.conf
MaxSpareServers : N/A in httpd.conf
StartServers : N/A in httpd.conf
MaxClients : 300
Maxrequestsperchild value : N/A in httpd.conf
13- [root@linux1 public_html]# find / -size +2000000k
find: /proc/6958/task: No such file or directory
find: /proc/17267: No such file or directory
find: /proc/17532/task: No such file or directory
find: /proc/17658/task: No such file or directory
find: /proc/17717/task: No such file or directory
find: /proc/17970/task: No such file or directory
find: /proc/18199/task: No such file or directory
find: /proc/18273/task: No such file or directory
find: /proc/18440/task: No such file or directory
find: /proc/18528/task: No such file or directory
find: /proc/18559/task: No such file or directory
find: /proc/18636/task: No such file or directory
find: /proc/18667/task: No such file or directory
find: /proc/18835/task/18835/fd/4: No such file or directory
find: /proc/18838/task: No such file or directory
find: /proc/18839/task: No such file or directory
find: /proc/18913/task: No such file or directory
find: /proc/18921/task: No such file or directory
find: /proc/18941/task: No such file or directory
find: /proc/18949/task: No such file or directory
find: /proc/19023/task: No such file or directory
find: /proc/19063/task: No such file or directory
find: /proc/19071/task: No such file or directory
find: /proc/19076: No such file or directory
find: /proc/19077: No such file or directory
find: /proc/19078/task: No such file or directory
find: /proc/19080: No such file or directory
find: /proc/19090/task: No such file or directory
find: /proc/19094/task: No such file or directory
find: /proc/19097/task: No such file or directory
find: /proc/19103: No such file or directory
/root/irantk.tar.gz
14- uname -a:
Linux linux1.worldbus.us 2.6.9-55.0.2.ELsmp #1 SMP Tue Jun 12 17:59:08 EDT 2007 i686 i686 i386 GNU/Linux
ulimit -aH
core file size (blocks, -c) 1000000
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) 4096
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
cat /proc/cpuinfo:
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU 3060 @ 2.40GHz
stepping : 6
cpu MHz : 2394.782
cache size : 4096 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
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 pbe nx lm constant_tsc pni monitor ds_cpl est tm2 xtpr
bogomips : 4791.30
processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU 3060 @ 2.40GHz
stepping : 6
cpu MHz : 2394.782
cache size : 4096 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
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 pbe nx lm constant_tsc pni monitor ds_cpl est tm2 xtpr
bogomips : 4787.37