|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
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
__DEFINE_LIKE_SHARE__
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 |
مواقع النشر (المفضلة) |
أدوات الموضوع | |
انواع عرض الموضوع | |
| |
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
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 |