"A. Brandic" wrote:
> How can I check if my database is busy (ie. if someone is writting to a
> table from which I only want to read, I want a message on the screen
> saying "Try Later").
> thanx, Ajdin
The only solution at the moment is to use "mysqladmin processlist" and parsing the result
But this is very difficult, so I would say it is impossible.
You can however use an GET_LOCK(...) in all applications using the table in question to
check if someone is currently working with it.
But this rely's on your applications, not on the mysql DBMS.