MySQL Forums
Forum List  »  PHP

get info about a mysql call
Posted by: Audric Dhoest
Date: April 22, 2011 11:48AM

Hello,
I would like to know how to retrieve info of a mysql call. My website is suffering for mysql overloading, which causes crazy loading times, and even times out.

After doing some investigation, i found out its a script thats to blame. A script thats calling non existent tables.

I would like to know, first of all, if its possible, to get info about this script (i have no idea which one it is), from the info i get from the log, if theres a query, or anything else, that will tell me information about the script. Its location, what makes the call.. ANYTHING.

Heres an extract of a log:
110417 21:33:26 [ERROR] Invalid (old?) table or database name 'richdel_wrdp1-back-1300897860-back-1302813532'
110417 21:33:26 [ERROR] Invalid (old?) table or database name 'richdel_wrdp1-back-1302813530'
110417 21:33:26 [ERROR] Invalid (old?) table or database name 'sabados_nuke-back-1281284442'

Thanks in advance.

Options: ReplyQuote


Subject
Written By
Posted
get info about a mysql call
April 22, 2011 11:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.