MySQL Forums :: PHP :: get info about a mysql call


Advanced Search

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 Audric Dhoest 04/22/2011 11:48AM
Re: get info about a mysql call Rick James 04/23/2011 01:00PM
Re: get info about a mysql call Barry Galbraith 04/24/2011 06:23AM
Re: get info about a mysql call swarupa paruchuri 04/24/2011 07:57AM
Re: get info about a mysql call Mat Benfield 04/24/2011 12:14PM


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.