Large Scale Central

So, uh, what's up, Bob?

General Discussion
#1

Been several LONG periods of MySQL cannot connect…too many connections…

Problems?

#2

Dave;

Bobby is away on a camping trip, and probably doesn’t know about the server problems…

#3

Sounds like another dos attack…:frowning:

#4
Warren Mumpower said:
Sounds like another dos attack..:(
Yep, if you go to the main page, you get to look at the latest connections that came up as failures. Sure looks fishy to me!
#5

One of the worst nightmares for a DBA is managing connections. Ever notice how, if you shut down without logging off, you come up as logged on next time you enter LSC?

#6

Whaddaya mean shut down??? What is this ‘log off’ of which you speak???

#7
Dave Healy said:
One of the worst nightmares for a DBA is managing connections. Ever notice how, if you shut down without logging off, you come up as logged on next time you enter LSC?
Wouldn't that occur because you've got "remember me" or some such thing clicked that automatically reestablishes your connection every time you navigate to the site?

Later,

K

#8

Whatever the cause, the board is sure acting weird right now…very slooooooow!

#9
Warren Mumpower said:
....very slooooooow!
Hey, I resemble that remark ... I might even resent it, but it'd take me too long to work up a head of steam ...
#10
Warren Mumpower said:
Whatever the cause, the board is sure acting weird right now....very slooooooow!
Same way it did not long ago during the DoS
#11
Warren Mumpower said:
Whatever the cause, the board is sure acting weird right now....very slooooooow!
Must be a Spokanian thang...I got connected up in 0.013sec...usually do something like that, and I'm on the slowest broadband it's possible to imagine, slower even than Mr Slow, the winner of the international slow persons' slow race on Planet Slow.

Tokyo was a hoot in contrast - there I had fibre-optic permanent connection at 56Mb. By the time I go back in november it will be 96Mb…

tac

#12

Tac, you are watching Black Adder re-runs again, I can tell.

As surely as Mr Sure when he is surer than a sure person who has just one the surest person of the dacade copetition…

F’ sure

#13

TAC, it isn’t so much the time it takes to get connected to the site, but the speed (or lack thereof) of getting from one page to another.

Currently it’s working great. So the DoS attack must be under control.

#14

Yup, even my 16.8 baud is acceptable, as long as I have a fresh cup of coffee. We get our internet by Pony Express out here in beautiful Deer Park.

#15
Dave Healy said:
One of the worst nightmares for a DBA is managing connections. Ever notice how, if you shut down without logging off, you come up as logged on next time you enter LSC?
"Log off" means clicking on the "Click here to log out" link at the top of the forum page.

“Shut down” means turning off your PC.

Yes, it is possible there’s something called a cookie on your PC that indicates whether or not you’re logged on. Think of a cookie as a small file stored on a PC.

“Connection” means a string of text that describes how you’ve connected to a database. It sets things like how long your PC will keep trying to connect to the database before it gives up, whether or not what you send to the database is encrypted - things like that.

A connection can be open and closed. While it is open, a connection consumes resources on a database server. Too many open connections can be a reason why no new connections are allowed. It isn’t the only reason, but it is a common one.