MySQL Forums
Forum List  »  Newbie

Re: Database tuning
Posted by: Chung
Date: September 01, 2004 08:40PM

Hi. Thanx for the reply. I still have some question about MySQL database performance and the explain statement here:

1) After running the explain command on one of the select statement i get the result where the field was null. It only state that type is 'All', row is '474619' and the extra is 'Using where' ...... does this indicate that the select statement is having problem??
My select statement has the following structure:

SELECT <some column> FROM <TABLE> WHERE <special column> LIKE '%<number>%'

2) Is there certain function or command in the sql statement that would slow down the process speed?? i mean like concate and like command..

3) I didn't use any join in my SQL there any other possibility that would result in the CPU of the database be fun at 99%???

Thanx a lot for the help!


Options: ReplyQuote

Written By
August 31, 2004 08:37PM
September 01, 2004 09:26AM
Re: Database tuning
September 01, 2004 08:40PM

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.