Re: Database tuning

[Chung]

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 statement....is there any other possibility that would result in the CPU of the database be fun at 99%???

Thanx a lot for the help!

fLy