[Openinteract-help] SPOPS MySQL Question

[Nick F. <Ni...@st...>]

Hi all,

I am working on an application that uses SPOPS and MySQL together.

Sometimes when an SQL query is executed, MySQL hangs.

This often happens when the query involves checking SPOPS_Security info =
in the spops_security table.

I have looked at the SQL query log (which shows all the queries being =
executed in MySQL) to see which SQL queries are occurring just before =
MySQL hangs. When I find them, I can copy and past them into the MySQL =
cli client and execute them. They always work fine.

So, two things occur to me:

1) The query log is showing only queries that have completed =
successfully, and not the one MySQL is hanging on...

2) There is some problem with the way the database connection is being =
setup or the SPOPS SQL execution is  taking place such that the query =
works by hand entry but not in the Perl Program.

I know there are a lot of variables and unknowns to you, the reader, but =
what I am really curious about is if anyone else ever has problems =
*like* this.

My only way of describing the hang is this: When I execute a general, =
working query, the CPU history will show 100% usage for maybe 10-30 =
seconds (depending on the query) and then MySQL will return with the =
data. In this case, CPU usage goes to 100% for some period of time, and =
then drops down to %50 and just stays there until I end the query. MySQL =
itself remains completely useable for other connections (CLI client for =
example). So MySQL doesn't die. Its almost like there is some loop that =
just keeps running and running...

I admit that I am using version .79. This is because another developer =
started the project and wrote a bunch of stuff, and then when we tried =
upgrading SPOPS, certain things stopped working. I'm not sure on =
specifics, but I do know it would be extra work to move up.

MySQL 4.0.13

Thanks or any clues.