إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...

انضم الينا
استراحات زايد الصفحة الرئيسية


إضافة رد
 
LinkBack أدوات الموضوع انواع عرض الموضوع
  #1  
قديم 08-07-2009, 09:40 AM
عضو ماسي
بيانات محروم.كوم
 رقم العضوية : 503
 تاريخ التسجيل : Dec 2007
الجنس : female
علم الدوله :
 المشاركات : 2,100,610
عدد الـنقاط :3341
 تقييم المستوى : 2139

when i update counters i see this message Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 24470366 bytes)

1. Server: Dedicated Server.
2. server specs
CPUs: 2 x Intel \ 2.0 GHz 1333FSB - Clovertown \ Xeon 5335 (Quad Core)
Memory: 8 GB
Hard Drives: 2 \ 300GB:SAS:10K RPM \ 300GB:SAS:10K RPM
Webserver: Apache/2.2.11 (Unix)
MySQL Version 5.0.81-community
PHP 5.2.10
3. vB version: 3.8.3
4. Tables types: Only MyISAM tables.
5. mySQL installation type: Unknown.

6- top

PHP Code:
top - 14:35:11 up 5 days, 8:10, 1 user, load average: 1.08, 1.08, 1.09
Tasks
: 221 total, 4 running, 215 sleeping, 0 stopped, 2 zombie
Cpu0
: 13.1%us, 1.3%sy, 0.0%ni, 84.7%id, 0.0%wa, 0.0%hi, 0.9%si, 0.0%st
Cpu1
: 12.0%us, 2.0%sy, 0.0%ni, 86.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2
: 8.8%us, 1.1%sy, 0.0%ni, 90.2%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3
: 7.7%us, 1.8%sy, 0.0%ni, 90.6%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu4
: 19.2%us, 2.6%sy, 0.0%ni, 77.9%id, 0.0%wa, 0.0%hi, 0.2%si, 0.0%st
Cpu5
: 10.5%us, 2.4%sy, 0.0%ni, 87.1%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu6
: 21.1%us, 2.8%sy, 0.0%ni, 76.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu7
: 18.6%us, 2.2%sy, 0.0%ni, 79.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem
: 8311260k total, 8121464k used, 189796k free, 414856k buffers
Swap
: 2096472k total, 23852k used, 2072620k free, 6766632k cached
PID USER PR NI VIRT RES SHR S
%CPU %MEM TIME+ COMMAND
5430 mysql 15 0 873m 352m 3572 S 10.7 4.3 38
:45.67 mysqld
20066 swalif 17 0 0 0 0 Z 10.7 0.0 0
:00.23 php
20069 swalif 17 0 34016 20m 5808 R 8.4 0.3 0:00.18 php
20068 swalif 17 0 0 0 0 Z 5.6 0.0 0
:00.12 php
18714 nobody 15 0 12796 4832 1636 S 1.4 0.1 0:00.25 httpd
19723 nobody 15 0 12796 4796 1608 S 1.4 0.1 0
:00.12 httpd
16232 nobody 15 0 12800 4856 1644 S 0.9 0.1 0
:00.69 httpd
17766 nobody 15 0 13068 5192 1780 S 0.9 0.1 0
:00.36 httpd
17825 nobody 15 0 12796 4856 1644 S 0.9 0.1 0
:00.22 httpd
20070 swalif 21 0 22032 7660 4540 R 0.9 0.1 0
:00.02 php


7- MySQL Variables

PHP Code:
<span style="color: #000000">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 20
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
<span style="color: #007700">+ ->Aborted_clients 114
Aborted_connects 0
Binlog_cache_disk_use 0
Binlog_cache_use 0
Bytes_received 394059196
Bytes_sent 2932931311
Com_admin_commands 44957
Com_alter_db 0
Com_alter_table 2
Com_analyze 0

Com_backup_table 0
Com_begin 0
Com_call_procedure 0
Com_change_db 90285
Com_change_master 0
Com_check 2
Com_checksum 0
Com_commit 0
Com_create_db 0
Com_create_function 0
Com_create_index 0
Com_create_table 34
Com_create_user 0
Com_dealloc_sql 0
Com_delete 5515
Com_delete_multi 4
Com_do 0
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 34
Com_drop_user 0
Com_execute_sql 0
Com_flush 6
Com_grant 124
Com_ha_close 0
Com_ha_open 0
Com_ha_read 0
Com_help 0
Com_insert 47022
Com_insert_select 35
Com_kill 0
Com_load 0
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 22574
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 2
Com_replace 6081
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 348942
Com_set_option 878
Com_show_binlog_events 0
Com_show_binlogs 4
Com_show_charsets 43
Com_show_collations 43
Com_show_column_types 0
Com_show_create_db 0
Com_show_create_table 3
Com_show_databases 46
Com_show_errors 0
Com_show_fields 516
Com_show_grants 23
Com_show_innodb_status 0
Com_show_keys 337
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 162
Com_show_slave_hosts 0
Com_show_slave_status 0
Com_show_status 269
Com_show_storage_engines 0
Com_show_tables 165
Com_show_triggers 0
Com_show_variables 191
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 41
Com_unlock_tables 22574
Com_update 85479
Com_update_multi 316
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 45229
Created_tmp_disk_tables 5731
Created_tmp_files 12
Created_tmp_tables 14790
Delayed_errors 0
Delayed_insert_threads 0
Delayed_writes 0
Flush_commands 1
Handler_commit 0
Handler_delete 15978

Handler_discover 0
Handler_prepare 0
Handler_read_first 13206
Handler_read_key 38252989
Handler_read_next 56548814
Handler_read_prev 469487
Handler_read_rnd 25668424
Handler_read_rnd_next 268625212
Handler_rollback 0
Handler_savepoint 0
Handler_savepoint_rollback 0
Handler_update 2834948
Handler_write 2628493
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 330726
Key_blocks_used 210523
Key_read_requests 118342939
Key_reads 304060
Key_write_requests 482223
Key_writes 165352
Last_query_cost 0.000000
Max_used_connections 31
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 1852
Open_streams 0
Open_tables 992
Opened_tables 1830
Prepared_stmt_count 0
Qcache_free_blocks 3714
Qcache_free_memory 16318776
Qcache_hits 548713
Qcache_inserts 341464
Qcache_lowmem_prunes 0
Qcache_not_cached 10507
Qcache_queries_in_cache 15828
Qcache_total_blocks 36736
Queries 1229056
Questions 1229056
Rpl_status NULL
Select_full_join 86
Select_full_range_join 0
Select_range 81246
Select_range_check 0
Select_scan 57547
Slave_open_temp_tables 0
Slave_retried_transactions 0
Slave_running OFF
Slow_launch_threads 0
Slow_queries 2
Sort_merge_passes 0
Sort_range 101289
Sort_rows 48208091
Sort_scan 19259
Table_locks_immediate 982046
Table_locks_waited 1709
Tc_log_max_pages_used 0
Tc_log_page_size 0
Tc_log_page_waits 0
Threads_cached 29
Threads_connected 2
Threads_created 31
Threads_running 1
Uptime 16329
Uptime_since_flush_status 1229056


9.
there are games,directory and phpnuke scripts utily less than 5 MB of mysql
the forum About 2000,000 posts in total. Database Usage: ~1.7 GB. Attachment Usage: ~ 11.5 GB (in file system).

10. average and max concurrent users on my vB forum : 6000-9000
cookie timeout : 60 minutes
11.phpinfo.php

http://krwetatnt.net/phpinfo.php

12. Apache Values
i found only
MaxClients 512

13. Files greater than 2GB? No

14. uname -a

PHP Code:
Linux xxxx.xxxx.com 2.6.18-128.2.1.el5PAE #1 SMP Tue Jul 14 07:15:01 EDT 2009 i686 i686 i386 GNU/Linux


ulimit -aH

PHP Code:
core file size (blocks, -c) 1000000
data seg size
(kbytes, -d) unlimited
scheduling priority
(-e) 0
file size
(blocks, -f) unlimited
pending signals
(-i) 143360
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
real
-time priority (-r) 0
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

PHP Code:
processor : 0
vendor_id
: GenuineIntel
cpu family
: 6
model
: 15
model name
: Intel(R) Xeon(R) CPU E5335 @ 2.00GHz
stepping
: 11
cpu MHz
: 1995.173
cache size
: 4096 KB
physical id
: 0
siblings
: 4
core id
: 0
cpu cores
: 4
apicid
: 0
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 vmx tm2 cx16 xtpr lahf_lm
bogomips
: 3992.31
processor
: 1
vendor_id
: GenuineIntel
cpu family
: 6
model
: 15
model name
: Intel(R) Xeon(R) CPU E5335 @ 2.00GHz
stepping
: 11
cpu MHz
: 1995.173
cache size
: 4096 KB
physical id
: 0
siblings
: 4
core id
: 1
cpu cores
: 4
apicid
: 1
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 vmx tm2 cx16 xtpr lahf_lm
bogomips
: 3990.00
processor
: 2
vendor_id
: GenuineIntel
cpu family
: 6
model
: 15
model name
: Intel(R) Xeon(R) CPU E5335 @ 2.00GHz
stepping
: 11
cpu MHz
: 1995.173
cache size
: 4096 KB
physical id
: 0
siblings
: 4
core id
: 2
cpu cores
: 4
apicid
: 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 vmx tm2 cx16 xtpr lahf_lm
bogomips
: 3990.03
processor
: 3
vendor_id
: GenuineIntel
cpu family
: 6
model
: 15
model name
: Intel(R) Xeon(R) CPU E5335 @ 2.00GHz
stepping
: 11
cpu MHz
: 1995.173
cache size
: 4096 KB
physical id
: 0
siblings
: 4
core id
: 3
cpu cores
: 4
apicid
: 3
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 vmx tm2 cx16 xtpr lahf_lm
bogomips
: 3990.02
processor
: 4
vendor_id
: GenuineIntel
cpu family
: 6
model
: 15
model name
: Intel(R) Xeon(R) CPU E5335 @ 2.00GHz
stepping
: 11
cpu MHz
: 1995.173
cache size
: 4096 KB
physical id
: 1
siblings
: 4
core id
: 0
cpu cores
: 4
apicid
: 4
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 vmx tm2 cx16 xtpr lahf_lm
bogomips
: 3990.03
processor
: 5
vendor_id
: GenuineIntel
cpu family
: 6
model
: 15
model name
: Intel(R) Xeon(R) CPU E5335 @ 2.00GHz
stepping
: 11
cpu MHz
: 1995.173
cache size
: 4096 KB
physical id
: 1
siblings
: 4
core id
: 1
cpu cores
: 4
apicid
: 5
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 vmx tm2 cx16 xtpr lahf_lm
bogomips
: 3990.03
processor
: 6
vendor_id
: GenuineIntel
cpu family
: 6
model
: 15
model name
: Intel(R) Xeon(R) CPU E5335 @ 2.00GHz
stepping
: 11
cpu MHz
: 1995.173
cache size
: 4096 KB
physical id
: 1
siblings
: 4
core id
: 2
cpu cores
: 4
apicid
: 6
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 vmx tm2 cx16 xtpr lahf_lm
bogomips
: 3990.03
processor
: 7
vendor_id
: GenuineIntel
cpu family
: 6
model
: 15
model name
: Intel(R) Xeon(R) CPU E5335 @ 2.00GHz
stepping
: 11
cpu MHz
: 1995.173
cache size
: 4096 KB
physical id
: 1
siblings
: 4
core id
: 3
cpu cores
: 4
apicid
: 7
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 vmx tm2 cx16 xtpr lahf_lm
bogomips
: 3990.04
__DEFINE_LIKE_SHARE__
رد مع اقتباس
إضافة رد

مواقع النشر (المفضلة)

أدوات الموضوع
انواع عرض الموضوع

تعليمات المشاركة
لا تستطيع إضافة مواضيع جديدة
لا تستطيع الرد على المواضيع
لا تستطيع إرفاق ملفات
لا تستطيع تعديل مشاركاتك

BB code is متاحة
كود [IMG] متاحة
كود HTML معطلة
Trackbacks are متاحة
Pingbacks are متاحة
Refbacks are متاحة


المواضيع المتشابهه
الموضوع كاتب الموضوع المنتدى مشاركات آخر مشاركة
Server Optimizing Request محروم.كوم منتدى أخبار المواقع والمنتديات العربية والأجنبية 0 05-20-2009 11:50 PM
Server Optimizing Request محروم.كوم منتدى أخبار المواقع والمنتديات العربية والأجنبية 0 05-14-2009 01:30 PM
Server Optimizing Request محروم.كوم منتدى أخبار المواقع والمنتديات العربية والأجنبية 0 05-11-2009 01:30 AM
Server Optimizing Request محروم.كوم منتدى أخبار المواقع والمنتديات العربية والأجنبية 0 05-02-2009 11:10 AM
Server Optimizing Request محروم.كوم منتدى أخبار المواقع والمنتديات العربية والأجنبية 0 05-01-2009 03:00 PM


الساعة الآن 03:54 PM


Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By Almuhajir

RSS RSS 2.0 XML MAP HTML