PDA

View Full Version : more Db problems



orphan
Sun 13th Aug '06, 2:49pm
My forum is now running 3.6.0 and most of the time it works fine

But from time to time it throws me this error



mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Lost connection to MySQL server during query /home/e/eu-chron/www/forum/includes/class_core.php on line 271


It dosent seem load related cause i have had it when being alone on the site, neither is it persistent it comes when least expected

any ideas?

Steve Machol
Sun 13th Aug '06, 2:50pm
This is a server issue. You need to contact your host about this. See this post for the possible causes of a lost connection error:

http://www.vbulletin.com/forum/showthread.php?s=&postid=310265#post310265

orphan
Mon 14th Aug '06, 3:06am
Hi Steve
Well i've been over that page and checked all my settings

What i find thou is a lot of warnings in my phpadmin that my db is poorly indexed and alot of memory is used for table scans!
"Handler_read_rnd_next" is 372 M and that seems high for a non-busy forum

I might add im running "MySQL - 5.0.24-standard" & PHP 5.1.4
I also use vBa CMPS 2.2.0

orphan
Tue 15th Aug '06, 10:18am
Changing to mysqli seems to have solved the problems