jacki
Mon 25th Jun '07, 4:57am
1- Dedicated Server
2- Dual xeon 2.8 / 2048 MB Ram / 2 x 160 sata disk , apache 2 , centos 4.4, php 4.4.4 ,mysql 4.1.20
3- 3.6.7
4- Yes, plesk uses innodb tables for its own database..
5- With rpm
6- Top output :
top - 12:54:07 up 20 days, 6:34, 1 user, load average: 1.03, 1.03, 1.05
Tasks: 112 total, 2 running, 110 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.1% us, 1.9% sy, 28.4% ni, 69.6% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 2074384k total, 2045856k used, 28528k free, 92036k buffers
Swap: 2096472k total, 49840k used, 2046632k free, 1382052k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
17611 mysql 21 6 426m 284m 4556 S 49 14.1 6096:53 mysqld
21873 apache 19 4 34788 15m 3396 S 18 0.7 0:08.79 httpd
21932 apache 19 4 33788 14m 3392 S 14 0.7 0:07.14 httpd
21589 apache 19 4 37660 18m 4340 S 9 0.9 0:13.53 httpd
21947 apache 20 4 34568 14m 3280 S 9 0.7 0:01.98 httpd
21954 apache 20 4 34768 14m 3264 S 7 0.7 0:01.02 httpd
21960 apache 19 4 37236 18m 4224 S 6 0.9 0:01.70 httpd
21959 apache 20 4 33924 14m 3252 R 5 0.7 0:00.30 httpd
21858 apache 20 4 35892 16m 3428 S 1 0.8 0:14.14 httpd
21556 apache 19 4 37444 18m 4444 S 0 0.9 0:14.85 httpd
21862 apache 19 4 36028 17m 4292 S 0 0.8 0:14.99 httpd
21893 apache 19 4 36380 16m 3568 S 0 0.8 0:07.08 httpd
21956 apache 19 4 33804 14m 3372 S 0 0.7 0:01.52 httpd
7- Mysql configuration (/etc/my.cnf)
[mysqld]
safe-show-database
innodb_data_file_path=ibdata1:10M:autoextend
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
default-storage-engine=MyISAM
init-connect="SET NAMES latin5"
max_allowed_packet = 16M
max_connections = 500
max_connect_errors = 10
wait_timeout=100
connect_timeout = 10
interactive_timeout=100
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
table_cache = 1024
thread_concurrency=2
key_buffer=150M
join_buffer_size = 1M
record_buffer=1M
read_buffer_size = 1M
sort_buffer_size = 1M
read_rnd_buffer_size = 1M
myisam_sort_buffer_size=64M
#thread_cache_size = 256
thread_cache_size = 128
#default_character_set=latin5
#character_set_client=latin5
old_passwords=1
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
default-character-set=latin5
open_files_limit = 8192
[mysql.server]
user=mysql
basedir=/var/lib
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
8- Mysql stats with command = mysqladmin -u root -p var ext stat ver
[root@server psa]# mysqladmin -u admin -p var ext stat ver
Enter password:
+---------------------------------+--------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+--------------------------------------------------------+
| back_log | 50 |
| basedir | /usr/ |
| bdb_cache_size | 8388600 |
| bdb_home | /var/lib/mysql/ |
| bdb_log_buffer_size | 524288 |
| bdb_logdir | |
| bdb_max_lock | 10000 |
| bdb_shared_data | OFF |
| bdb_tmpdir | /tmp/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 10 |
| datadir | /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 |
| 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 | NO |
| have_bdb | YES |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | YES |
| have_ndbcluster | NO |
| have_openssl | YES |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | SET NAMES latin5 |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 100 |
| join_buffer_size | 1044480 |
| key_buffer_size | 157286400 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 500 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 67108864 |
| 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 | ON |
| open_files_limit | 2558 |
| pid_file | /var/run/mysqld/mysqld.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 33554432 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 1044480 |
| 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_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 1048568 |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | ON |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| system_time_zone | CDT |
| table_cache | 1024 |
| table_type | MyISAM |
| thread_cache_size | 128 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 33554432 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.20 |
| version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (May 24, 2006) |
| version_comment | Source distribution |
| version_compile_machine | i686 |
| version_compile_os | redhat-linux-gnu |
| wait_timeout | 100 |
+---------------------------------+--------------------------------------------------------+
+--------------------------------+------------+
| Variable_name | Value |
+--------------------------------+------------+
| Aborted_clients | 330 |
| Aborted_connects | 1514 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 2224327654 |
| Bytes_sent | 806070707 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 19646 |
| Com_change_db | 6587880 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 19646 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 627 |
| Com_dealloc_sql | 0 |
| Com_delete | 332071 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 627 |
| 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 | 1328063 |
| Com_insert_select | 627 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 39 |
| 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 | 159591 |
| Com_replace_select | 13 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 14427165 |
| Com_set_option | 6906631 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 39 |
| Com_show_create_table | 1521 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 1524 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 3 |
| 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 | 0 |
| Com_show_tables | 1599 |
| Com_show_variables | 135 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 631 |
| Com_unlock_tables | 39 |
| Com_update | 2553626 |
| Com_update_multi | 627 |
| Connections | 3650822 |
| Created_tmp_disk_tables | 4498 |
| Created_tmp_files | 474028 |
| Created_tmp_tables | 967690 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 19685 |
| Handler_delete | 465067 |
| Handler_discover | 0 |
| Handler_read_first | 225009 |
| Handler_read_key | 1021704208 |
| Handler_read_next | 1494131953 |
| Handler_read_prev | 344767712 |
| Handler_read_rnd | 538734825 |
| Handler_read_rnd_next | 1146876512 |
| Handler_rollback | 11371 |
| Handler_update | 84275810 |
| Handler_write | 2379102646 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 0 |
| Key_blocks_used | 136079 |
| Key_read_requests | 3254376208 |
| Key_reads | 2359252 |
| Key_write_requests | 10637049 |
| Key_writes | 9239945 |
| Max_used_connections | 160 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 982 |
| Open_streams | 0 |
| Open_tables | 1016 |
| Opened_tables | 13726 |
| Qcache_free_blocks | 1203 |
| Qcache_free_memory | 15492376 |
| Qcache_hits | 16889999 |
| Qcache_inserts | 13986074 |
| Qcache_lowmem_prunes | 350461 |
| Qcache_not_cached | 439658 |
| Qcache_queries_in_cache | 2370 |
| Qcache_total_blocks | 6594 |
| Questions | 52890338 |
| Rpl_status | NULL |
| Select_full_join | 723 |
| Select_full_range_join | 0 |
| Select_range | 1891614 |
| Select_range_check | 0 |
| Select_scan | 4439375 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 6 |
| Slow_queries | 2572 |
| Sort_merge_passes | 237292 |
| Sort_range | 2157066 |
| Sort_rows | 654211665 |
| Sort_scan | 1628318 |
| 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 | 32392009 |
| Table_locks_waited | 374369 |
| Threads_cached | 127 |
| Threads_connected | 1 |
| Threads_created | 696 |
| Threads_running | 1 |
| Uptime | 1125296 |
+--------------------------------+------------+
Uptime: 1125299 Threads: 3 Questions: 52890556 Slow queries: 2572 Opens: 13726 Flush tables: 1 Open tables: 1016 Queries per second avg: 47.001
mysqladmin Ver 8.41 Distrib 4.1.20, for redhat-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.1.20
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 13 days 35 min 0 sec
Threads: 3 Questions: 52890579 Slow queries: 2572 Opens: 13726 Flush tables: 1 Open tables: 1016 Queries per second avg: 47.001
[root@server psa]#
9- Two more sites having a low rate of visitors.
10- Cookie Timeout : 900 sec. Normal times: 500-800 visitors Max Times: 1200-2200 visitors
11- http://www.yorumla.net/info.php is the PHP info addresss
12- KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 15
StartServers 3
MaxClients 150
AND Maxrequestsperchild value = 5000
13- Command Output:
[root@server conf]# find / -size +2000000k
find: /proc/22315/task/22315/fd/4: No such file or directory
/var/log/httpd/access_log.1
14- Commands Outputs:
[root@server conf]# uname -a
Linux server.yorumla.net 2.6.9-55.ELsmp #1 SMP Wed May 2 14:28:44 EDT 2007 i686 i686 i386 GNU/Linux
[root@server conf]# 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) 32759
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
[root@server conf]#
[root@server conf]# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 10
cpu MHz : 2800.894
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 cid xtpr
bogomips : 5603.89
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 10
cpu MHz : 2800.894
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 cid xtpr
bogomips : 5699.74
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 10
cpu MHz : 2800.894
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 3
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 cid xtpr
bogomips : 5599.58
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 10
cpu MHz : 2800.894
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 3
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 cid xtpr
bogomips : 5599.56
[root@server conf]#
Members : 100,176
Threads : 234,513
Post : 1,292,980
(My principal problem is that when a certain number of visitors is reached, "Page Not Found" message appears.)
2- Dual xeon 2.8 / 2048 MB Ram / 2 x 160 sata disk , apache 2 , centos 4.4, php 4.4.4 ,mysql 4.1.20
3- 3.6.7
4- Yes, plesk uses innodb tables for its own database..
5- With rpm
6- Top output :
top - 12:54:07 up 20 days, 6:34, 1 user, load average: 1.03, 1.03, 1.05
Tasks: 112 total, 2 running, 110 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.1% us, 1.9% sy, 28.4% ni, 69.6% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 2074384k total, 2045856k used, 28528k free, 92036k buffers
Swap: 2096472k total, 49840k used, 2046632k free, 1382052k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
17611 mysql 21 6 426m 284m 4556 S 49 14.1 6096:53 mysqld
21873 apache 19 4 34788 15m 3396 S 18 0.7 0:08.79 httpd
21932 apache 19 4 33788 14m 3392 S 14 0.7 0:07.14 httpd
21589 apache 19 4 37660 18m 4340 S 9 0.9 0:13.53 httpd
21947 apache 20 4 34568 14m 3280 S 9 0.7 0:01.98 httpd
21954 apache 20 4 34768 14m 3264 S 7 0.7 0:01.02 httpd
21960 apache 19 4 37236 18m 4224 S 6 0.9 0:01.70 httpd
21959 apache 20 4 33924 14m 3252 R 5 0.7 0:00.30 httpd
21858 apache 20 4 35892 16m 3428 S 1 0.8 0:14.14 httpd
21556 apache 19 4 37444 18m 4444 S 0 0.9 0:14.85 httpd
21862 apache 19 4 36028 17m 4292 S 0 0.8 0:14.99 httpd
21893 apache 19 4 36380 16m 3568 S 0 0.8 0:07.08 httpd
21956 apache 19 4 33804 14m 3372 S 0 0.7 0:01.52 httpd
7- Mysql configuration (/etc/my.cnf)
[mysqld]
safe-show-database
innodb_data_file_path=ibdata1:10M:autoextend
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
default-storage-engine=MyISAM
init-connect="SET NAMES latin5"
max_allowed_packet = 16M
max_connections = 500
max_connect_errors = 10
wait_timeout=100
connect_timeout = 10
interactive_timeout=100
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
table_cache = 1024
thread_concurrency=2
key_buffer=150M
join_buffer_size = 1M
record_buffer=1M
read_buffer_size = 1M
sort_buffer_size = 1M
read_rnd_buffer_size = 1M
myisam_sort_buffer_size=64M
#thread_cache_size = 256
thread_cache_size = 128
#default_character_set=latin5
#character_set_client=latin5
old_passwords=1
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
default-character-set=latin5
open_files_limit = 8192
[mysql.server]
user=mysql
basedir=/var/lib
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
8- Mysql stats with command = mysqladmin -u root -p var ext stat ver
[root@server psa]# mysqladmin -u admin -p var ext stat ver
Enter password:
+---------------------------------+--------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+--------------------------------------------------------+
| back_log | 50 |
| basedir | /usr/ |
| bdb_cache_size | 8388600 |
| bdb_home | /var/lib/mysql/ |
| bdb_log_buffer_size | 524288 |
| bdb_logdir | |
| bdb_max_lock | 10000 |
| bdb_shared_data | OFF |
| bdb_tmpdir | /tmp/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 10 |
| datadir | /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 |
| 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 | NO |
| have_bdb | YES |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | YES |
| have_ndbcluster | NO |
| have_openssl | YES |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | SET NAMES latin5 |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 100 |
| join_buffer_size | 1044480 |
| key_buffer_size | 157286400 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 500 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 67108864 |
| 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 | ON |
| open_files_limit | 2558 |
| pid_file | /var/run/mysqld/mysqld.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 33554432 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 1044480 |
| 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_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 1048568 |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | ON |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| system_time_zone | CDT |
| table_cache | 1024 |
| table_type | MyISAM |
| thread_cache_size | 128 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 33554432 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.20 |
| version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (May 24, 2006) |
| version_comment | Source distribution |
| version_compile_machine | i686 |
| version_compile_os | redhat-linux-gnu |
| wait_timeout | 100 |
+---------------------------------+--------------------------------------------------------+
+--------------------------------+------------+
| Variable_name | Value |
+--------------------------------+------------+
| Aborted_clients | 330 |
| Aborted_connects | 1514 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 2224327654 |
| Bytes_sent | 806070707 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 19646 |
| Com_change_db | 6587880 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 19646 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 627 |
| Com_dealloc_sql | 0 |
| Com_delete | 332071 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 627 |
| 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 | 1328063 |
| Com_insert_select | 627 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 39 |
| 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 | 159591 |
| Com_replace_select | 13 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 14427165 |
| Com_set_option | 6906631 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 39 |
| Com_show_create_table | 1521 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 1524 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 3 |
| 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 | 0 |
| Com_show_tables | 1599 |
| Com_show_variables | 135 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 631 |
| Com_unlock_tables | 39 |
| Com_update | 2553626 |
| Com_update_multi | 627 |
| Connections | 3650822 |
| Created_tmp_disk_tables | 4498 |
| Created_tmp_files | 474028 |
| Created_tmp_tables | 967690 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 19685 |
| Handler_delete | 465067 |
| Handler_discover | 0 |
| Handler_read_first | 225009 |
| Handler_read_key | 1021704208 |
| Handler_read_next | 1494131953 |
| Handler_read_prev | 344767712 |
| Handler_read_rnd | 538734825 |
| Handler_read_rnd_next | 1146876512 |
| Handler_rollback | 11371 |
| Handler_update | 84275810 |
| Handler_write | 2379102646 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 0 |
| Key_blocks_used | 136079 |
| Key_read_requests | 3254376208 |
| Key_reads | 2359252 |
| Key_write_requests | 10637049 |
| Key_writes | 9239945 |
| Max_used_connections | 160 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 982 |
| Open_streams | 0 |
| Open_tables | 1016 |
| Opened_tables | 13726 |
| Qcache_free_blocks | 1203 |
| Qcache_free_memory | 15492376 |
| Qcache_hits | 16889999 |
| Qcache_inserts | 13986074 |
| Qcache_lowmem_prunes | 350461 |
| Qcache_not_cached | 439658 |
| Qcache_queries_in_cache | 2370 |
| Qcache_total_blocks | 6594 |
| Questions | 52890338 |
| Rpl_status | NULL |
| Select_full_join | 723 |
| Select_full_range_join | 0 |
| Select_range | 1891614 |
| Select_range_check | 0 |
| Select_scan | 4439375 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 6 |
| Slow_queries | 2572 |
| Sort_merge_passes | 237292 |
| Sort_range | 2157066 |
| Sort_rows | 654211665 |
| Sort_scan | 1628318 |
| 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 | 32392009 |
| Table_locks_waited | 374369 |
| Threads_cached | 127 |
| Threads_connected | 1 |
| Threads_created | 696 |
| Threads_running | 1 |
| Uptime | 1125296 |
+--------------------------------+------------+
Uptime: 1125299 Threads: 3 Questions: 52890556 Slow queries: 2572 Opens: 13726 Flush tables: 1 Open tables: 1016 Queries per second avg: 47.001
mysqladmin Ver 8.41 Distrib 4.1.20, for redhat-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.1.20
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 13 days 35 min 0 sec
Threads: 3 Questions: 52890579 Slow queries: 2572 Opens: 13726 Flush tables: 1 Open tables: 1016 Queries per second avg: 47.001
[root@server psa]#
9- Two more sites having a low rate of visitors.
10- Cookie Timeout : 900 sec. Normal times: 500-800 visitors Max Times: 1200-2200 visitors
11- http://www.yorumla.net/info.php is the PHP info addresss
12- KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 15
StartServers 3
MaxClients 150
AND Maxrequestsperchild value = 5000
13- Command Output:
[root@server conf]# find / -size +2000000k
find: /proc/22315/task/22315/fd/4: No such file or directory
/var/log/httpd/access_log.1
14- Commands Outputs:
[root@server conf]# uname -a
Linux server.yorumla.net 2.6.9-55.ELsmp #1 SMP Wed May 2 14:28:44 EDT 2007 i686 i686 i386 GNU/Linux
[root@server conf]# 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) 32759
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
[root@server conf]#
[root@server conf]# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 10
cpu MHz : 2800.894
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 cid xtpr
bogomips : 5603.89
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 10
cpu MHz : 2800.894
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 cid xtpr
bogomips : 5699.74
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 10
cpu MHz : 2800.894
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 3
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 cid xtpr
bogomips : 5599.58
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 10
cpu MHz : 2800.894
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 3
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 cid xtpr
bogomips : 5599.56
[root@server conf]#
Members : 100,176
Threads : 234,513
Post : 1,292,980
(My principal problem is that when a certain number of visitors is reached, "Page Not Found" message appears.)