problem with mysqld process

--001517577484b994530483c43dc2
Content-Type: text/plain; charset=ISO-8859-1

Hi *

mysqld process consuming more 100% of cpu usage and execution time also very
high.

1. how to reduce CPU?
2. why mysqld process consuming high cpu utilization?
3. Wether need to fine tune sql application. then how to use plan table in
mysql?
4. which storage engine is better for transaction? innodb or myisam. my
current production, some tables are in myisam and some tables are in innodb.
is there any changes required here...
5. what is the use of left outer join. this will downgrade the db
performance..

please proived the answer. my current db give more performance related
issue. i was increase the instance memory but still problem not solved. i
don't have much idea in mysql..

thank in advance..

Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com

--001517577484b994530483c43dc2--