Hi Kumar, thanks for your reply.. here is my my.cnf file. i don't see anything here. what is this slowquery.log?, where it will be? --- [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1
[mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid ----- Cheers Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com On Mon, Jan 11, 2010 at 2:17 PM, Ananda Kumar <anan...@gmail.com> wrote: > what is your my.cnf setting. > Also did u check slowquery.log for any sql's not using index or not using > the right index. > > > > On Mon, Jan 11, 2010 at 1:21 PM, F.A.I.Z.A.L <sac.fai...@gmail.com> wrote: > >> Hi >> >> mysqld process taking high cpu utilization (100%), how to reduce the cup >> utilization >> >> it is running under solaris 8 with 16GB ram and 1 multicore cpu (2 core) >> >> anyone help please? >> >> Cheers >> Faizal S >> GSM : 9840118673 >> Blog: http://oradbapro.blogspot.com >> > >