PDA

View Full Version : DBI->connect(db1:a3.com) failed: Lost connection to MySQL server during query at mod


mario
Sat 9th Jun '01, 7:19pm
I frequently get this message. Even in telnet when using the mysql command.

I don't think that the mysql server is hopelessly overloaded. It usually uses between 20% and 70% of cpu, but not much else runs on the server, server load is around 1

Should I change some timeout variables? What could be the reason??

fastforward
Sun 10th Jun '01, 6:45pm
Originally posted by mario
I frequently get this message. Even in telnet when using the mysql command.

I don't think that the mysql server is hopelessly overloaded. It usually uses between 20% and 70% of cpu, but not much else runs on the server, server load is around 1

Should I change some timeout variables? What could be the reason??
DBI is a Perl module used for database connectivity. There is no way this error would appear when using the normal mysql monitor that was ditributed with mysql. Is it some kind of Perl wrapper that you are using?

mario
Sun 10th Jun '01, 9:29pm
Of course in telnet it does not say DBI. It just says something like "lost connection to mysql server". very strange, as the server is on the very same computer.

I think it might be a timeout problem, some timeout set way too short ........ So if there is a little load on the mysql, and there is a few milliseconds wait, it does not connect correctly.

How can I tweak this variable? or what else could be the problem? Mysql has too much load, but certainly not totally swamped and totally overloaded. it is mo own server, and it has 20-70% of cpu load