List:General Discussion« Previous MessageNext Message »
From:F.A.I.Z.A.L Date:January 11 2010 9:17am
Subject:Re: mysqld occupies 100$ cpu
View as plain text  
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 <anandkl@stripped> 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.faizal@stripped> 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
>>
>
>

Thread
mysqld occupies 100$ cpuF.A.I.Z.A.L11 Jan
  • Re: mysqld occupies 100$ cpuAnanda Kumar11 Jan
    • Re: mysqld occupies 100$ cpuF.A.I.Z.A.L11 Jan
      • Re: mysqld occupies 100$ cpuAnanda Kumar11 Jan
        • Re: mysqld occupies 100$ cpuF.A.I.Z.A.L11 Jan
          • Re: mysqld occupies 100$ cpuAnanda Kumar11 Jan
  • RE: mysqld occupies 100$ cpuJerry Schwartz11 Jan