Re: mysqld occupies 100$ cpu
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
Re: mysqld occupies 100$ cpu
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
Re: mysqld occupies 100$ cpu
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 = /var/lib/slowqueries.log. 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 sac.fai...@gmail.com 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 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.comwrote: 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
Re: mysqld occupies 100$ cpu
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 anan...@gmail.com wrote: 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 = /var/lib/slowqueries.log. 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 sac.fai...@gmail.com 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 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.comwrote: 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.comwrote: 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
Re: mysqld occupies 100$ cpu
SHOW ENGINE innodb STATUS\G On Mon, Jan 11, 2010 at 3:35 PM, F.A.I.Z.A.L sac.fai...@gmail.com 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 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 anan...@gmail.com wrote: 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 = /var/lib/slowqueries.log. 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 sac.fai...@gmail.comwrote: 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.comwrote: 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.comwrote: 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
RE: mysqld occupies 100$ cpu
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@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=arch...@jab.org
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