gt;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?
>
&g
SHOW ENGINE innodb STATUS\G
On Mon, Jan 11, 2010 at 3:35 PM, F.A.I.Z.A.L wrote:
> 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> s
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?
Cheer
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 = wrote:
> 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
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 th
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 wrote:
> Hi
>
> mysqld process taking high cpu utilization (100%), how to reduce the cup
> utilization
>
> it is running under so
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