|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
Hi guys. I'd very much appreciate it if you can help me here. I have asked my host to pinpoint the cause/source of the error, but they haven't been able to do so. At least once a week I am getting this error, mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' I have to restart the MySQL service from WHM/CPanel whenever this happens. I am getting literally hundreds of emails sent to my inbox telling me "VBulletin Database Error!". I have read this: http://www.vbulletin.com/docs/html/cantconnect ... but I am not an expert in computers so I don't really understand it. I only have a thousand members, and on average, the number of active/current users online at any given time is usually around ten to twenty. I have researched dozens of forums and websites to see what I can do to resolve this, changing my settings in my.cnf, I even upgraded my VPS, but still the errors keep coming. I am at a loss as to how I am getting these errors when I hardly have any users, yet I'm on a (relatively) powerful VPS. Here are my stats that are needed: 1. VPS. I am the only one on this server. ------------------------------------------------- 2. Dual Xeon, 2Gb RAM, 80Gb Hard Drive, Apache version - 2.2.9 (Unix), PHP version 5.2.6, MySQL version 5.0.67-community, Architecture i686, Operating system - Linux. ------------------------------------------------- 3. vBulletin 3.8.1 (Patch Level 1) ------------------------------------------------- 4. ------------------------------------------------- 5. ------------------------------------------------- 6. Top Stats: top - 1054 up 119 days, 9:59, 1 user, load average: 0.36, 0.32, 0.28 Tasks: 134 total, 1 running, 133 sleeping, 0 stopped, 0 zombie Cpu0 : 10.3% us, 5.0% sy, 0.0% ni, 84.7% id, 0.0% wa, 0.0% hi, 0.0% si Cpu1 : 3.7% us, 3.0% sy, 0.0% ni, 93.4% id, 0.0% wa, 0.0% hi, 0.0% si Cpu2 : 0.3% us, 0.7% sy, 0.0% ni, 99.0% id, 0.0% wa, 0.0% hi, 0.0% si Cpu3 : 0.0% us, 0.3% sy, 0.0% ni, 99.7% id, 0.0% wa, 0.0% hi, 0.0% si Cpu4 : 0.0% us, 0.0% sy, 0.0% ni, 100.0% id, 0.0% wa, 0.0% hi, 0.0% si Cpu5 : 1.4% us, 1.4% sy, 0.0% ni, 97.2% id, 0.0% wa, 0.0% hi, 0.0% si Cpu6 : 0.9% us, 0.9% sy, 0.0% ni, 98.1% id, 0.0% wa, 0.0% hi, 0.0% si Cpu7 : 0.0% us, 0.5% sy, 0.0% ni, 99.5% id, 0.0% wa, 0.0% hi, 0.0% si Mem: 2097152k total, 121832k used, 1975320k free, 0k buffers Swap: 0k total, 0k used, 0k free, 0k cached ------------------------------------------------- 7. my.cnf: [mysqld] skip-bdb skip-innodb set-variable = max_user_connections=2000 set-variable = max_connections=1000 safe-show-database set-variable = table_cache=1024 set-variable = sort_buffer_size=16M set-variable = read_buffer_size=16M set-variable = read_rnd_buffer_size=64M set-variable = thread_cache_size=128 log-slow-queries long_query_time = 1 #256M set-variable = query_cache_size=32M #512M #set-variable = query_cache_size=64M #1024M #set-variable = query_cache_size=128M ------------------------------------------------- 8. MySQL 5.0.67-community- uptime 0 2:34:11 Thu Apr 9 1026 2009 __ Key __________________________________________________ _______________ Buffer used 1.39M of 8.00M %Used: 17.35 Current 2.31M %Usage: 28.87 Write hit 64.35% Read hit 99.50% __ Questions __________________________________________________ _________ Total 34.70k 3.8/s Com_ 13.32k 1.4/s %Total: 38.39 DMS 9.56k 1.0/s 27.56 COM_QUIT 6.25k 0.7/s 18.03 QC Hits 5.67k 0.6/s 16.34 -Unknown 110 0.0/s 0.32 Slow 1 s 51 0.0/s 0.15 %DMS: 0.53 Log: ON DMS 9.56k 1.0/s 27.56 INSERT 5.17k 0.6/s 14.92 54.12 SELECT 3.05k 0.3/s 8.78 31.86 UPDATE 1.13k 0.1/s 3.25 11.80 REPLACE 133 0.0/s 0.38 1.39 DELETE 80 0.0/s 0.23 0.84 Com_ 13.32k 1.4/s 38.39 change_db 7.82k 0.8/s 22.54 set_option 5.12k 0.6/s 14.76 check 42 0.0/s 0.12 __ SELECT and Sort __________________________________________________ ___ Scan 363 0.0/s %SELECT: 11.92 Range 586 0.1/s 19.24 Full join 0 0/s 0.00 Range check 0 0/s 0.00 Full rng join 0 0/s 0.00 Sort scan 132 0.0/s Sort range 177 0.0/s Sort mrg pass 0 0/s __ Query Cache __________________________________________________ _______ Memory usage 3.89M of 32.00M %Used: 12.15 Block Fragmnt 7.65% Hits 5.67k 0.6/s Inserts 2.90k 0.3/s Insrt:Prune 2.90k:1 0.3/s Hit:Insert 1.96:1 __ Table Locks __________________________________________________ _______ Waited 67 0.0/s %Total: 0.53 Immediate 12.52k 1.4/s __ Tables __________________________________________________ ____________ Open 463 of 1024 %Cache: 45.21 Opened 579 0.1/s __ Connections __________________________________________________ _______ Max used 5 of 1000 %Max: 0.50 Total 6.26k 0.7/s __ Created Temp __________________________________________________ ______ Disk table 22 0.0/s Table 186 0.0/s Size: 32.0M File 0 0/s __ Threads __________________________________________________ ___________ Running 1 of 1 Cached 4 of 128 %Hit: 99.92 Created 5 0.0/s Slow 0 0/s __ Aborted __________________________________________________ ___________ Clients 0 0/s Connects 2 0.0/s __ Bytes __________________________________________________ _____________ Sent 211.31M 22.8k/s Received 12.00M 1.3k/s __ InnoDB Buffer Pool __________________________________________________ Usage 0 of 0 %Used: 0.00 Read hit 0.00% Pages Free 0 %Total: 0.00 Data 0 0.00 %Drty: 0.00 Misc 0 0.00 Latched 0 0.00 Reads 0 0/s From file 0 0/s 0.00 Ahead Rnd 0 0/s Ahead Sql 0 0/s Writes 0 0/s Flushes 0 0/s Wait Free 0 0/s __ InnoDB Lock __________________________________________________ _______ Waits 0 0/s Current 0 Time acquiring Total 0 ms Average 0 ms Max 0 ms __ InnoDB Data, Pages, Rows ____________________________________________ Data Reads 0 0/s Writes 0 0/s fsync 0 0/s Pending Reads 0 Writes 0 fsync 0 Pages Created 0 0/s Read 0 0/s Written 0 0/s Rows Deleted 0 0/s Inserted 0 0/s Read 0 0/s Updated 0 0/s ------------------------------------------------- 9. Just vB. ------------------------------------------------- 10. Don't know. ------------------------------------------------- 11. Don't know. ------------------------------------------------- 12. I opened httpd.conf but it doesn't have the parameters mentioned. ------------------------------------------------- 13. Nothing found from that command. ------------------------------------------------- 14. Linux vps2392.inmotionhosting.com 2.6.9-023stab048.4-enterprise #1 SMP Fri Jul 11 18:31:01 MSD 2008 i686 i686 i386 GNU/Linux ================================================ 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) 139264 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited ================================================ processor : 0 vendor_id : GenuineIntel cpu family : 6 model : 7 model name : Intel(R) Xeon(R) CPU E5430 @ 2.66GHz stepping : 6 cpu MHz : 2660.193 cache size : 6144 KB physical id : 0 siblings : 4 core id : 0 cpu cores : 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 pni monitor ds_cpl est tm2 xtpr bogomips : 5323.07 processor : 1 vendor_id : GenuineIntel cpu family : 6 model : 7 model name : Intel(R) Xeon(R) CPU E5430 @ 2.66GHz stepping : 6 cpu MHz : 2660.193 cache size : 6144 KB physical id : 0 siblings : 4 core id : 1 cpu cores : 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 pni monitor ds_cpl est tm2 xtpr bogomips : 5319.93 processor : 2 vendor_id : GenuineIntel cpu family : 6 model : 7 model name : Intel(R) Xeon(R) CPU E5430 @ 2.66GHz stepping : 6 cpu MHz : 2660.193 cache size : 6144 KB physical id : 0 siblings : 4 core id : 2 cpu cores : 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 pni monitor ds_cpl est tm2 xtpr bogomips : 5320.03 processor : 3 vendor_id : GenuineIntel cpu family : 6 model : 7 model name : Intel(R) Xeon(R) CPU E5430 @ 2.66GHz stepping : 6 cpu MHz : 2660.193 cache size : 6144 KB physical id : 0 siblings : 4 core id : 3 cpu cores : 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 pni monitor ds_cpl est tm2 xtpr bogomips : 5319.99 processor : 4 vendor_id : GenuineIntel cpu family : 6 model : 7 model name : Intel(R) Xeon(R) CPU E5430 @ 2.66GHz stepping : 6 cpu MHz : 2660.193 cache size : 6144 KB physical id : 1 siblings : 4 core id : 4 cpu cores : 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 pni monitor ds_cpl est tm2 xtpr bogomips : 5320.02 processor : 5 vendor_id : GenuineIntel cpu family : 6 model : 7 model name : Intel(R) Xeon(R) CPU E5430 @ 2.66GHz stepping : 6 cpu MHz : 2660.193 cache size : 6144 KB physical id : 1 siblings : 4 core id : 5 cpu cores : 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 pni monitor ds_cpl est tm2 xtpr bogomips : 5320.07 processor : 6 vendor_id : GenuineIntel cpu family : 6 model : 7 model name : Intel(R) Xeon(R) CPU E5430 @ 2.66GHz stepping : 6 cpu MHz : 2660.193 cache size : 6144 KB physical id : 1 siblings : 4 core id : 6 cpu cores : 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 pni monitor ds_cpl est tm2 xtpr bogomips : 5320.11 processor : 7 vendor_id : GenuineIntel cpu family : 6 model : 7 model name : Intel(R) Xeon(R) CPU E5430 @ 2.66GHz stepping : 6 cpu MHz : 2660.193 cache size : 6144 KB physical id : 1 siblings : 4 core id : 7 cpu cores : 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 pni monitor ds_cpl est tm2 xtpr bogomips : 5319.98 __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
Forum Stuck on Step 2: Connection to DataBase | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 05-25-2010 06:51 AM |
Problem with database connection | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 03-10-2010 04:30 PM |
Database error ... Lost connection everyday | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 10-25-2009 04:50 PM |
Firefox 3.5 loses connection | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 07-16-2009 04:20 AM |
Help In Wireless Connection | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 04-15-2009 02:10 AM |