WS Oh, I see, you would like to connect this information with the
WS pid, right? I wouldn't know how to do that. How do you get a pid?
WS Is this something MySQL could provide?
No, not with the pid.
With the number of places from where sql queries are executed and
the number on different queries, it's not always easy to find from
where a query, which is for example locking Mysql, as been executed.
Where do you find this locking query?
I have seen a mysql process staying for a long time and wondered
what this might be. In this case I only have the pid and no idea
which domain and program may have started this.
It would really help here to be able to track the process down,
as I have no means to find out what that thing does.
If I know a query, I search for the query string. If this string
is not generated, I have good chances to find it in the code. If
mysql reports an error, I send myself an email with the error
code.
Example:
Sender: [EMAIL PROTECTED]
Errno: 1030, Error: Got error 127 from table handler,
query:
Invalid SQL: SELECT * FROM sessData
WHERE sid = '5235';
URI:
REFERER:
This is no problem and built into the class. So I can search for
this string in my code. I never had a case where I could not find
the appropriate code piece.
BTW, I am struggling with this kind of error quite a lot. As a
rule, the index got wrong. So I stop writing session data, repair
the table, check that it is ok and reenable session writing.
After some time, I get this error again.
I tried INSERT DELAYED to cope with this, but this doesn't work
for sessions, as session data has to be there instantly.
--
Herzlich
Werner Stuerenburg
_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
