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
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.
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.
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
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
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
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
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
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
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
Hi All,
I am usingINNODB.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
11 matches
Mail list logo