--0015175dda48bf4221047cdecee1
Content-Type: text/plain; charset=ISO-8859-1
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
--0015175dda48bf4221047cdecee1--
--00504502b443efaa0b047cdf96f3
Content-Type: text/plain; charset=ISO-8859-1
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
> 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
>
--00504502b443efaa0b047cdf96f3--
--002354471dd8d5ffcf047ce00197
Content-Type: text/plain; charset=ISO-8859-1
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
> 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
>
>> 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
>>
>
>
--002354471dd8d5ffcf047ce00197--
--00504502cc73573d06047ce09087
Content-Type: text/plain; charset=ISO-8859-1
looks like u have not setup slow query log parameter.
If this is a non-production db, shut it down and add this parameter, unser
[mysqld]
log-slow-queries =
Or execute
SHOW ENGINE STATUS\G;
You will get to know what all activities are going on ur db and check if
there is any IO contention happening
On Mon, Jan 11, 2010 at 2:47 PM, F.A.I.Z.A.L
> 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
>
>> 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
>>
>>> 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
>>>
>>
>>
>
--00504502cc73573d06047ce09087--
--0015175ce09427b073047ce0ae73
Content-Type: text/plain; charset=ISO-8859-1
i try this
mysql> SHOW ENGINE STATUS\G;
ERROR 1286 (42000): Unknown table engine 'STATUS'
ERROR:
No query specified
after setting the parameter in my.cnf which u provided. it is not showing
mysql> show engine status;
ERROR 1286 (42000): Unknown table engine 'status'
what i have to do now?
Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Mon, Jan 11, 2010 at 3:27 PM, Ananda Kumar
> looks like u have not setup slow query log parameter.
>
> If this is a non-production db, shut it down and add this parameter, unser
> [mysqld]
>
> log-slow-queries =
>
> Or execute
> SHOW ENGINE STATUS\G;
> You will get to know what all activities are going on ur db and check if
> there is any IO contention happening
>
>
>
>
> On Mon, Jan 11, 2010 at 2:47 PM, F.A.I.Z.A.L
>
>> 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
>>
>>> 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
>>>
>>>> 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
>>>>
>>>
>>>
>>
>
--0015175ce09427b073047ce0ae73--
--001636ed6870451c16047ce0b6f9
Content-Type: text/plain; charset=ISO-8859-1
SHOW ENGINE innodb STATUS\G
On Mon, Jan 11, 2010 at 3:35 PM, F.A.I.Z.A.L
> i try this
> mysql> SHOW ENGINE STATUS\G;
> ERROR 1286 (42000): Unknown table engine 'STATUS'
> ERROR:
> No query specified
>
> after setting the parameter in my.cnf which u provided. it is not showing
>
> mysql> show engine status;
> ERROR 1286 (42000): Unknown table engine 'status'
>
> what i have to do now?
>
>
> Cheers
> Faizal S
> GSM : 9840118673
> Blog: http://oradbapro.blogspot.com
>
>
> On Mon, Jan 11, 2010 at 3:27 PM, Ananda Kumar
>
>> looks like u have not setup slow query log parameter.
>>
>> If this is a non-production db, shut it down and add this parameter, unser
>> [mysqld]
>>
>> log-slow-queries =
>>
>> Or execute
>> SHOW ENGINE STATUS\G;
>> You will get to know what all activities are going on ur db and check if
>> there is any IO contention happening
>>
>>
>>
>>
>> On Mon, Jan 11, 2010 at 2:47 PM, F.A.I.Z.A.L
>>
>>> 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
>>>
>>>> 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
>>>>
>>>>> 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
>>>>>
>>>>
>>>>
>>>
>>
>
--001636ed6870451c16047ce0b6f9--
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
>-----Original Message-----
>From: F.A.I.Z.A.L [mailto:sac.faizal@gmail.com]
>Sent: Monday, January 11, 2010 2:51 AM
>To: mysql@lists.mysql.com
>Subject: mysqld occupies 100$ cpu
>
>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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org