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.fai...@gmail.com]
>Sent: Monday, January 11, 2010 2:51 AM
>To: mysql@
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
