Database connection help if possible

محروم.كوم · #1 04-09-2009, 10:10 PM

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