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?

Happened here a few times last week and has happened a bit tonight (including when I was trying to open your post ironically)

I got the same a couple hours ago

Yeh I'm getting the same tonight.

Yes, this has been happening to me too! Exactly the same message.

Regards
Jon

Perhaps we all need to give Chris some more pennies, for more servers.
Oo, wonder if my mate has any?

same here too

Yep been getting that message. It went away after I logged off then back on again.

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

Yep, i've been getting that a lot recently.... Guess we all need to chip in some more

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

---

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

---

Chris,

If you're looking at scalability for mySQL systems, these guys are worth a chat.

www.clustrix.com

S

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.

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

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?

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

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

---

I'll be the 3rd person to put in a tenner

Donation sent.

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]

If we got you the money? would you have time to do both????

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

Ive had no errors? Is this something that would onjly effect some users?

It only happens at peak times when the number of pages being requested simultaneously exceeds the maximum number of database threads available.

Chris