Re: mysql performance issue. pls help..

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--

mysql performance issue. pls help..

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 myi

Re: Techniques for queries on a series?

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! Yo

Re: Techniques for queries on a series?

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

Techniques for queries on a series?

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 cal

Re: Query!

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

Re: Query!

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 dat

How NDBCluster cleans Local checkpoint

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

Query!

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);