Query!

2009-11-17 Thread Gaurav Nigam (TMP-Japan)
Can somebody please help! There are two queries - 1. How can I detect from my code whether a table has been updated in the Database manually (I am firing delete from testtable where SrNo=9; on the Database server) and not from the code itself. I am running this code - conn = mysql_init(NULL);

How NDBCluster cleans Local checkpoint

2009-11-17 Thread Manasi Save
Hi All, Can anyone provide me some input on How NDB Cluster Local CheckPoint works. Can anyone provide any good article links where how NDB generates it and how to clean these logs. The senerio I am facing is I have set DataMemory as 2G and IndexMemory as 256M. and the size of my LCP folder is

Re: Query!

2009-11-17 Thread Michael Dykman
I'm sorry, you are way off here in what this actually does. mysql_affected_rows is only going to tell you how many rows were affected by the execution of the last statement made on your current connection. It is not an interface to a magic genie maintaining watch over the state of your entire

Re: Query!

2009-11-17 Thread Peter Brawley
Gaurav, How can I detect from my code whether a table has been updated in the Database manually Have a look at Transaction Time Validity in http://www.osdbzine.net/issue6.pdf and http://www.osdbzine.net/issue7.pdf. PB - Michael Dykman wrote: I'm sorry, you are way off here in what

Techniques for queries on a series?

2009-11-17 Thread Jan Steinman
I often need a pattern where one record refers to the one before it, based on the order of some field. For example, a vehicle log, in which the field odometer is the current odometer reading upon an event, such as a trip completion, fueling, maintenance, etc. Very often one wants to

Re: Techniques for queries on a series?

2009-11-17 Thread Peter Brawley
Jan, I often need a pattern where one record refers to the one before it, based on the order of some field. Some ideas under Sequences at http://www.artfulsoftware.com/infotree/queries.php. PB Jan Steinman wrote: I often need a pattern where one record refers to the one before it,

Re: Techniques for queries on a series?

2009-11-17 Thread Jan Steinman
On 17 Nov 09, at 10:41, Peter Brawley wrote: I often need a pattern where one record refers to the one before it, based on the order of some field. Some ideas under Sequences at http://www.artfulsoftware.com/infotree/queries.php . Thanks, Peter! What a marvellous resource! You

mysql performance issue. pls help..

2009-11-17 Thread F.A.I.Z.A.L
HI experts I am facing performance issue for last couple of months. it taking more time to execute query.. developers created tables on myIsam and Innodb. i have a doubts whether we can use both storage same time.. i have 2 thinks in my minds to check this performance. 1. to check innodb and

Re: mysql performance issue. pls help..

2009-11-17 Thread F.A.I.Z.A.L
hi all this is my innodb preference. i need to change anything for increasing the db performance.. innodb_additional_mem_pool_size -- 1048576 innodb_autoextend_increment -- 8 innodb_buffer_pool_awe_mem_mb -- 0 innodb_buffer_pool_size -- 8388608 innodb_checksums-- ON