Sql optimization

Hi All,   I am using INNODB.I have a delete quetry something like this :   delete from modnaptrrecord_zone where modnaptrrecord_zone.modnaptrrecord_id in (593536 ,593537 ,593538 ,593539 ,593540 ) and modnaptrrecord_zone.modnaptrrecord_id not in (593536 )   This is

problem with InnoDB

Hi , select count(*) is painfully slow in case of innoDB when the number of records are around 1 million. Ths select count(*) query in myISAM takes 0.01 secs and the same query in InnoDB takes around 20.15 secs. Can anybody suggest me how to speed up this query ? Thanks Prasad The informatio

RE: problem with InnoDB

Hi, There is a problem with CPU utlization when using INNODB. The CPU utilization goes to 100% in a dual processor solaris box. With the same setup, myISAM uses only 60% of the CPU. Could someone please let me know what could be the problem. There are some other processes running on the same b

RE: problem with InnoDB

Hi, There is a problem with CPU utlization when using INNODB. The CPU utilization goes to 100% in a dual processor solaris box. With the same setup, myISAM uses only 60% of the CPU. Could someone please let me know what could be the problem. There are some other processes running on the same b

Problem with INNODB transactions

Hi, I am facing a strange problem with INNODB. My application communicates with mysql server using JDBC. I am using mysql 5.1 version. Even after issuing connection.commit() / connection.rollback() commands, still on the sql side the transactions are not getting closed properly. In our applic

RE: Problem with INNODB transactions

Hi, We maintain a pool ..it is just a collection, where we maintain a list of connections. Regards prasad -Original Message- From: Robert DiFalco [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 23, 2006 11:41 PM To: Prasad Ramisetti (WT01 - Broadband Networks); mysql@lists.mysql.com S

RE: problem with InnoDB

Hi Chris, Thanks for your response. Actually there is some requirement, where I need to know the number of rows that I will get for my queries before actually executing the query. Could you please suggest some way for this. Thanks Prasad -Original Message- From: Chris [mailto:[EMAIL PR

RE: problem with InnoDB

Hi Dan, Thanks for yur response. Does it makes sense to create an index on a primary key ..as that is my smallest field ? Regards Prasad -Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED] Sent: Monday, September 04, 2006 9:53 AM To: Prasad Ramisetti (WT01 - Broadband Networks

RE: problem with InnoDB

Hi Douglas, I need to know the number of rows that a query will return before actually executing the query. So I am sending select count(*) before sending select *. Actually I need to reject queries if the number of records that it will return is huge, to avoid my server running out of memory. My

RE: problem with InnoDB

Hi Douglas, I need to know the number of rows that a query will return before actually executing the query. So I am sending select count(*) before sending select *. Actually I need to reject queries if the number of records that it will return is huge, to avoid my server running out of memory. M

INNODB my.cnf

Hi All, I need some inputs regarding my.cnf : We are using INNODB in our application.We have around 10 million records in the database. This will size up to around 10GB of data. Could you please suggest a sample my.cnf for this configuration. Machine used : Sun netra 240 , dual processor mac