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
