[liphp] Big MySQL problem

Wed, 4 Jun 2003 11:52:45 -0400

On 2003-06-04 11:08 -0400, Frank Imburgio <[email protected]> wrote:

> Can you tell if the date/time stamp on the MYSQL data files are touched? 

I'm not sure where they are.

[root@turing ] mysql --version
mysql  Ver 11.15 Distrib 3.23.47, for unknown-openbsd2.8 (i386)

> If they are current, this may indicate there is database access where 
> two proceses are waiting on each other -- a 'deadly embrace'. Even then, 
> you should be able to 'kill' one of the MYSQL queries through the 
> mysqladmin program.

I just tried mysql.server stop, and got the message "gave up
waiting!".  Egads.

I'm also not sure what would have caused a lock.  All I use the
database for is to store student records.

> When you telnet from the local machine to the port that MySql normally 
> runs on (telnet localhost 3306) , does it answer? This would tell you if 
> the communications portion is up or not. If not, the executable may be 
> misconfigured or corrupt.

No answer, as far as I can tell, from the Win terminal I'm at.  I'll
try later from a linux box.

> I have had instances where there is a 'hung' Mysql process that required 
> me to perform the 'cleanup' on the tables, but never one where even 
> MySQLadmin didn't answer.
> 
> Please let us know what you find out; this is a nightmare scenario.

Yes, so far it's turning out that way.  :(

-- 
[email protected]        http://turing.matcmp.ncc.edu/~cmerlo

We're sorry, but the number you have dialed is imaginary.  Please
rotate your phone ninety degrees and try again.  Thank you.