|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
1. Is this on dedicated or shared virual server. If shared, how many sites share this server (ask web host if needed) Dedicated 2. your server specs. For example: cpu speed/type single or dual cpus): dual AMD Opteron 246 processors how much memory installed: 4Gig RAM hard drive type/configuration: 36GB SCSI non raid linux distributor or windows version: Red Hat Enterprise Linux ES 4 apache/IIS version: Apache v2.0.52 PHP version: php 5.2.9 MySQL version: mysql 5.0.81 3. what version of vB are you running ? 3.7.6 4. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ? -------- 5. if possible how mysql was compiled/installed from the actual mysql.org 6. your top stats. So log into your server via ssh telnet as root user and type the command in bold - top Code: top - 10:56:16 up 9:45, 2 users, load average: 24.49, 24.18, 20.91 Tasks: 128 total, 37 running, 90 sleeping, 1 stopped, 0 zombie Cpu(s): 61.2% us, 7.4% sy, 0.0% ni, 26.4% id, 5.0% wa, 0.0% hi, 0.0% si Mem: 4091464k total, 3832100k used, 259364k free, 330856k buffers Swap: 1052248k total, 0k used, 1052248k free, 2848900k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 3008 mysql 5 -10 592m 220m 4432 S 34.2 5.5 35:06.54 mysqld 13030 apache 16 0 32544 10m 4196 R 3.2 0.3 0:06.25 httpd 13187 apache 16 0 36312 16m 5476 R 2.9 0.4 0:05.01 httpd 13188 apache 16 0 36708 16m 5132 R 2.9 0.4 0:04.92 httpd 13277 apache 16 0 36444 15m 4120 R 2.9 0.4 0:02.21 httpd 13283 apache 16 0 31768 10m 4144 R 2.9 0.3 0:02.71 httpd 13305 apache 16 0 36540 16m 4792 R 2.9 0.4 0:03.31 httpd 13326 apache 16 0 31776 10m 4140 R 2.9 0.3 0:01.46 httpd 13042 apache 16 0 37264 16m 4148 R 2.6 0.4 0:10.71 httpd 13243 apache 16 0 36552 15m 4268 R 2.6 0.4 0:05.21 httpd 13315 apache 15 0 31516 10m 4188 S 2.6 0.3 0:03.07 httpd 13359 apache 15 0 31172 10m 4088 S 2.6 0.3 0:01.29 httpd 13246 apache 16 0 36772 16m 5272 R 2.3 0.4 0:05.05 httpd 13281 apache 16 0 37008 16m 4168 R 2.3 0.4 0:04.32 httpd 13339 apache 17 0 35984 14m 4180 R 2.3 0.4 0:01.71 httpd 13350 apache 17 0 35896 15m 4168 R 2.3 0.4 0:00.99 httpd 13274 apache 16 0 35024 14m 5232 R 1.9 0.4 0:03.26 httpd 13244 apache 16 0 33956 12m 4172 R 1.6 0.3 0:04.21 httpd 13266 apache 16 0 35260 14m 4188 R 1.6 0.4 0:05.61 httpd 13062 apache 16 0 31792 10m 4180 R 1.3 0.3 0:07.27 httpd 13251 apache 16 0 33240 12m 4196 R 1.3 0.3 0:03.11 httpd 13272 apache 16 0 34960 13m 4164 R 1.3 0.3 0:03.80 httpd 13279 apache 16 0 35488 14m 4168 R 1.3 0.4 0:03.30 httpd 13362 apache 16 0 32472 11m 4088 R 1.3 0.3 0:01.06 httpd 13363 apache 16 0 35180 14m 5052 R 1.3 0.4 0:01.41 httpd 13348 apache 16 0 32648 11m 4112 R 1.0 0.3 0:01.12 httpd 13352 apache 16 0 32808 11m 4116 R 1.0 0.3 0:01.36 httpd 13365 apache 17 0 32272 11m 4052 R 1.0 0.3 0:00.95 httpd 13370 apache 16 0 36168 15m 4096 R 1.0 0.4 0:01.03 httpd 13066 apache 16 0 31560 10m 4228 S 0.6 0.3 0:06.84 httpd 13069 apache 16 0 32068 11m 4236 R 0.6 0.3 0:07.81 httpd 13171 apache 16 0 36604 17m 6196 R 0.6 0.4 0:06.33 httpd 13343 apache 16 0 36228 15m 4024 R 0.6 0.4 0:01.33 httpd 13374 apache 17 0 35868 14m 3596 R 0.6 0.4 0:00.11 httpd 446 root 15 0 0 0 0 S 0.3 0.0 0:03.30 kjournald 3171 root 15 0 3568 660 556 S 0.3 0.0 0:17.36 portsentry 13252 apache 15 0 31540 10m 4220 S 0.3 0.3 0:03.18 httpd 13296 apache 15 0 31276 10m 4232 S 0.3 0.3 0:03.52 httpd 1 root 16 0 2236 608 524 S 0.0 0.0 0:00.39 init 2 root 34 19 0 0 0 R 0.0 0.0 0:00.11 ksoftirqd/0 3 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/0 4 root 5 -10 0 0 0 S 0.0 0.0 0:00.01 khelper 5 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 kacpid 35 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kblockd/0 36 root 15 0 0 0 0 S 0.0 0.0 0:00.01 khubd 53 root 20 0 0 0 0 S 0.0 0.0 0:00.00 pdflush 54 root 15 0 0 0 0 S 0.0 0.0 0:00.25 pdflush 55 root 16 0 0 0 0 S 0.0 0.0 0:02.04 kswapd0 56 root 12 -10 0 0 0 S 0.0 0.0 0:00.00 aio/0 200 root 25 0 0 0 0 S 0.0 0.0 0:00.00 kseriod 422 root 15 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0 440 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1 1063 root 6 -10 0 0 0 S 0.0 0.0 0:00.00 kauditd 1798 root 6 -10 3492 536 448 S 0.0 0.0 0:00.08 udevd 1830 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kedac 2138 root 19 0 0 0 0 S 0.0 0.0 0:00.00 kjournald 2139 root 15 0 0 0 0 S 0.0 0.0 0:00.10 kjournald 2140 root 15 0 0 0 0 S 0.0 0.0 0:00.72 kjournald after hitting 1 Code: top - 10:57:50 up 9:47, 2 users, load average: 29.86, 27.39, 22.45 Tasks: 144 total, 26 running, 117 sleeping, 1 stopped, 0 zombie Cpu0 : 71.8% us, 28.2% sy, 0.0% ni, 0.0% id, 0.0% wa, 0.0% hi, 0.0% si Mem: 4091464k total, 3873132k used, 218332k free, 331080k buffers Swap: 1052248k total, 0k used, 1052248k free, 2864604k cached 7. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf or my.ini so post the contents inside of my.cnf (minus any passwords of course). Code: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock safe-show-database old_passwords back_log = 75 skip-innodb max_connections = 500 key_buffer = 256M myisam_sort_buffer_size = 128M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 4000 thread_cache_size = 384 wait_timeout = 20 connect_timeout = 10 tmp_table_size = 256M max_allowed_packet = 64M max_connect_errors = 10 read_rnd_buffer_size = 786432 bulk_insert_buffer_size = 8M thread_concurrency = 4 query_cache_limit = 6M query_cache_size = 256M query_cache_type = 1 query_prealloc_size = 262144 query_alloc_block_size = 65536 default-storage-engine = MyISAM log-slow-queries long_query_time=5 concurrent_insert = 2 max_heap_table_size = 256M max_write_lock_count = 16 net_buffer_length = 16384 table_lock_wait_timeout = 30 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid open_files_limit = 8192 nice = -10 [mysqldump] quick max_allowed_packet = 64M [myisamchk] key_buffer = 384M sort_buffer = 384M read_buffer = 256M write_buffer = 256M 8. MySQL stats from ssh telnet as root user type:(I'll update this answer ASAP) Quote: mysqladmin -u root -p var ext stat ver proc copy and paste output here Also if you want to better see what's going on install mysqlreport at http://www.vbulletin.com/forum/showthread.php?t=175177 and run it by typing Quote: ./mysqlreport -r 10 > /statistics.txt in ssh telnet and then copy and paste the output you see or look into statistics.txt file located at root directory / Example below 9. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql? One install of wordpress, one install of mediawiki, and one install of vbulletin + vb blogs 10. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ? Currently (which is average): 639 (305 members & 334 guests & 144 logged out & 16 bots) Cookie Timeout - 2200 11. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site. Please url link only - DO NOT copy and paste entire phpinfo.php page's contents to the thread! http://www.actuarialoutpost.com/actu...um/phpinfo.php 12. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following : Apache 2 users: If you can't find these values in httpd.conf it's because they have moved. You may find the values in /usr/local/apache/conf/extra for http-mpm.conf and http-default.conf PHP Code: KeepAlive ON MaxKeepAliveRequests 100 KeepAliveTimeout 4 MinSpareServers 5 MaxSpareServers 20 StartServers 8 MaxClients 256 Maxrequestsperchild value = 1000 13. check to see if any files i.e. apache log files are hitting 2GB or 4GB max file size limits i.e. see if you have max file size exceeded messages in apache error log I have some db dumps that exceed 2 gigs, but that's it. 14. Post output from these 3 commands uname -a: Code: Linux 76934-db.actuarialoutpost.com 2.6.9-78.0.22.EL #1 Fri Apr 24 12:35:12 EDT 2009 i686 athlon i386 GNU/Linux ulimit -aH: Code: 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) 64511 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited cat /proc/cpuinfo: Code: processor : 0 vendor_id : AuthenticAMD cpu family : 15 model : 5 model name : AMD Opteron(tm) Processor 246 stepping : 10 cpu MHz : 2000.000 cache size : 1024 KB fdiv_bug : no hlt_bug : no f00f_bug : no coma_bug : no fpu : yes fpu_exception : yes cpuid level : 1 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 pni syscall nx mmxext lm 3dnowext 3dnow bogomips : 3989.24 For FreeBSD: dmesg | grep -i CPU: Code: WARNING: NR_CPUS limit of 1 reached. Processor ignored. Initializing CPU#0 CPU 0 irqstacks, hard=c0418000 soft=c0417000 CPU: After generic identify, caps: 078bfbff e1d3fbff 00000000 00000000 CPU: After vendor identify, caps: 078bfbff e1d3fbff 00000000 00000000 CPU: L1 I Cache: 64K (64 bytes/line), D cache 64K (64 bytes/line) CPU: L2 Cache: 1024K (64 bytes/line) CPU: After all inits, caps: 078bf3ff e1d3fbff 00000000 00000410 Intel machine check reporting enabled on CPU#0. CPU: AMD Opteron(tm) Processor 246 stepping 0a ACPI: Processor [CPU1] (supports C1, 8 throttling states) powernow-k8: Found AMD Opteron(tm) Processor 246 single processor(1 cpu cores) (version 2.00.00-rhel4) Do you think it would be best to upgrade to a 64 bit OS and upgrade to 8 gigs of ram? Do you have any other suggestions that I could do with my server, OR is there a completely different setup that you think might work better for my forum? Memcached? __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
Forum Your request timed out. Please retry the request. | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 07-13-2010 01:10 AM |
Server Optimizing Request after server upgrade | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 08-07-2009 09:40 AM |
I'm after a server format, Server optimisation request. | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 07-10-2009 06:10 PM |
Request for a vbulletin manual (2nd request after few years) | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 06-06-2009 01:40 AM |
Server Optimization Request - Please help! Server loads way too high! | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 05-05-2009 02:00 AM |