MakeEverything
|
| posted on 17/2/11 at 07:56 PM |
|
|
Database connection error!!!
Every few hours, im getting this but only on LCB.
"Database connection error!!!
A connection to the Database could not be established.
Please check your username, password, database name and host.
Also make sure config.php is rightly configured!
When connecting, the database returned:
Error 1040: Too many connections"
Do "We need a bigger boat" to host the forum?
Kindest Regards,
Richard.
...You can make it foolProof, but youll never make it Idiot Proof!...
|
|
|
|
|
Richard Quinn
|
| posted on 17/2/11 at 08:02 PM |
|
|
Happened here a few times last week and has happened a bit tonight (including when I was trying to open your post ironically)
|
|
|
Miks15
|
| posted on 17/2/11 at 08:03 PM |
|
|
I got the same a couple hours ago
|
|
|
skodaman
|
| posted on 17/2/11 at 08:04 PM |
|
|
Yeh I'm getting the same tonight.
Skodaman
|
|
|
slingshot2000
|
| posted on 17/2/11 at 08:04 PM |
|
|
Yes, this has been happening to me too! Exactly the same message.
Regards
Jon
|
|
|
Confused but excited.
|
| posted on 17/2/11 at 08:07 PM |
|
|
Perhaps we all need to give Chris some more pennies, for more servers.
Oo, wonder if my mate has any? 
Tell them about the bent treacle edges!
|
|
|
Stuart_B
|
| posted on 17/2/11 at 08:26 PM |
|
|
same here too
black mk indy, 1.6pinto on cbr600 bike carb's.
|
|
|
PeterV
|
| posted on 17/2/11 at 08:32 PM |
|
|
Yep been getting that message. It went away after I logged off then back on again.
|
|
|
ChrisW
|
| posted on 17/2/11 at 10:36 PM |
|
|
I need to get migrated onto the new server I bought last year. It's a RAM issue... the current box only has 2gig, new one has 8gig. I'll
try to upgrade that to 16gig before it goes live.
Had a play with one of these this week for a client: OCZ Revodrive.
Amazing bit of kit for the money - we saw an 80x (yes 80 times, not 80%) increase in performance of a database on our test bed. Really should invest
in one for this site but the one we'd need is nearly £350 with the VAT 
Chris
|
|
|
eddie99
|
| posted on 17/2/11 at 10:38 PM |
|
|
Yep, i've been getting that a lot recently.... Guess we all need to chip in some more 
http://www.elitemotorsporteng.co.uk/
Twitter: @Elitemotoreng
Facebook: http://www.facebook.com/pages/Elite-Motorsport-Engineering/153409081394323
|
NOTE:This user is registered as a LocostBuilders trader and may offer commercial services to other users
|
RazMan
|
| posted on 17/2/11 at 10:49 PM |
|
|
quote:
Originally posted by ChrisW
Had a play with one of these this week for a client: OCZ Revodrive.
Amazing bit of kit for the money - we saw an 80x (yes 80 times, not 80%) increase in performance of a database on our test bed. Really should invest
in one for this site but the one we'd need is nearly £350 with the VAT
Chris
Interesting gizmo that - it looks faster than SATA SD drives too It certainly makes the olde worlde spinning hard drive look a bit antique
Cheers,
Raz
When thinking outside the box doesn't work any more, it's time to build a new box
|
|
|
ChrisW
|
| posted on 17/2/11 at 11:54 PM |
|
|
quote:
Originally posted by RazMan
Interesting gizmo that - it looks faster than SATA SD drives too It certainly makes the olde worlde spinning hard drive look a bit antique
Indeed it is! Just dug out the data we derived from testing:
(Compared to a standard 7200rpm SATA disk, which is nasty, but typical of the application we would put it into)
RAW sequential read: Revo 400MB/sec, HDD 100MB/sec
Random read: Revo: 8,177 IOPS.......HDD......170 IOPS
For an SQL database with random reads/writes:
- 80x faster at reads
- 160x faster at writes
Shame the one we tested with belongs to a client. Got to put it into the machine we've built for them - a high capacity (8 x 2TB SATA) web
server with flash cache on the front end.
Chris
|
|
|
stevebubs
|
| posted on 18/2/11 at 04:48 AM |
|
|
Chris,
If you're looking at scalability for mySQL systems, these guys are worth a chat.
www.clustrix.com
S
|
|
|
stevebubs
|
| posted on 18/2/11 at 04:49 AM |
|
|
Just had a quick look and they don't have their UK contact details on their site. U2U me if you want them - they're not too far away from
you in Surrey.
|
|
|
ChrisW
|
| posted on 18/2/11 at 11:35 AM |
|
|
Thanks for that Steve. Scaling the platform isn't the problem, I could do that (with Luke's help in a few places) without too much
trouble. It's more about the server power to run it.
If money were no object I could throw fancy hardware at the problem, but with LB I'm trying to squeeze the best performance out of the existing
hardware to keep the running costs down. It's not just buying the kit in the first place, it's the cost to run it in power, rack space,
etc.
For a medium-sized database such as LB's running on commodity hardware the 'SSD on PCI-E' does seem to be the best solution at
present.
Chris
|
|
|
Mr Whippy
|
| posted on 18/2/11 at 11:53 AM |
|
|
maybe advice on the best way to do posts would help, I don't know very much about how these systems work and I'm sure others are the same
things like
best ways to attach pictures or should we use links to other websites pictures or do movie links hurt the system
I just don't know what is the bad way or good, I just do them as best my limited knowledge gets the results
Oh and is there a way to delete photo archive pictures as a group rather than one at a time?
Fame is when your old car is plastered all over the internet
|
|
|
mookaloid
|
| posted on 18/2/11 at 12:11 PM |
|
|
In view of the above Chris should we perhaps have a quick whip round to try and get the new box for you? I'd be happy to chuck a bit more paypal
donation your way
"That thing you're thinking - it wont be that."
|
|
|
Richard Quinn
|
| posted on 18/2/11 at 12:25 PM |
|
|
quote:
Originally posted by mookaloid
In view of the above Chris should we perhaps have a quick whip round to try and get the new box for you? I'd be happy to chuck a bit more paypal
donation your way
Would the 350 quid magic box (sorry, that's all it means to me) help? If so, it would only take 35 of us to chip in a tenner each which I would
be more than happy to do. I'm sure that there are quite a few of us that would be willing to chip in on the basis that it is now quite some time
since we originally contributed. If it is a case of cash for hardware (that's the limit of my tech speak!) let us know.
[Edited on 18/2/11 by Richard Quinn]
|
|
|
eddie99
|
| posted on 18/2/11 at 01:21 PM |
|
|
I'll be the 3rd person to put in a tenner
http://www.elitemotorsporteng.co.uk/
Twitter: @Elitemotoreng
Facebook: http://www.facebook.com/pages/Elite-Motorsport-Engineering/153409081394323
|
NOTE:This user is registered as a LocostBuilders trader and may offer commercial services to other users
|
Snuggs
|
| posted on 18/2/11 at 01:29 PM |
|
|
Donation sent.
----------------------------------------------------------------------------------------------------
http://www.topcashback.co.uk/ref/snuggstcb
Spider pig, spider pig, does whatever a spider pig does.
I doubt therefore I may be.
Luposlipophobia : Fear of being chased by wolves around a freshly waxed kitchen floor, while wearing only socks on your feet.
My mind not only wanders, sometimes it leaves completely!
http://www.venganza.org
http://www.jesusandmo.net/
http://www.snuggs.co.uk
|
|
|
ChrisW
|
| posted on 18/2/11 at 02:15 PM |
|
|
It's entirely down to you, guys. The main issue here causing the 'database connection error' is the lack of memory in the server.
I dare not run any more threads at the risk of hitting the memory limit.
I bought new server last year which I need to get around to migrating the site over to. The new box has three times the CPU power and more
importantly four times the RAM so it will better cope with the number of users as I can run more mySQL threads. Thing is, everything works reasonably
well at present, and 'if it ain't broke' etc.
The £300 'magic box' will improve the time it takes to pull data from the database, which in turn should mean each SQL process is tied up
for less time, therefore the whole server can generate more pages in the same time. It is, however, only compatible with the new server, so I'd
have to do both at the same time.
ETA: Thanks Snuggs
Chris
[Edited on 2/18/2011 by ChrisW]
|
|
|
eddie99
|
| posted on 18/2/11 at 02:17 PM |
|
|
If we got you the money? would you have time to do both????
http://www.elitemotorsporteng.co.uk/
Twitter: @Elitemotoreng
Facebook: http://www.facebook.com/pages/Elite-Motorsport-Engineering/153409081394323
|
NOTE:This user is registered as a LocostBuilders trader and may offer commercial services to other users
|
ChrisW
|
| posted on 18/2/11 at 04:47 PM |
|
|
Yes. Swapping the servers is on my list of things to do whilst the XR2 is away. Adding the SSD system wouldn't add more than an hour to the
job.
Cheers, Chris
|
|
|
loggyboy
|
| posted on 18/2/11 at 05:01 PM |
|
|
Ive had no errors? Is this something that would onjly effect some users?
|
|
|
ChrisW
|
| posted on 18/2/11 at 05:05 PM |
|
|
It only happens at peak times when the number of pages being requested simultaneously exceeds the maximum number of database threads available.
Chris
|
|
|
.jpg)
