Re: Large table

MERGE, and TEMPTABLE. Can you guys please advise on what is the best way to do this? Thanks Sairam On Fri, Jan 14, 2011 at 2:08 PM, Sairam Krishnamurthy kmsram...@gmail.com wrote: Yogesh, The type is MyISAM. So i guess size is not a matter for now. I am well over the limit for MyISAM. I

Re: Large table

Yogesh, The type is MyISAM. So i guess size is not a matter for now. I am well over the limit for MyISAM. I will partition the table and check. Thanks, Sairam Krishnamurthy +1 612 859 8161 On 01/14/2011 01:27 AM, Yogesh Kore wrote: What is the table type for Table? Firstly check

Large table

this. Will splitting the table and having a view from multiple table increase the performance? Thanks in advance. -- Thanks, Sairam Krishnamurthy +1 612 859 8161

Re: Loading date takes a long time after replication

Any pointers on this issue ? Thanks, Sairam Krishnamurthy +1 612 859 8161 On 01/03/2011 01:51 AM, Ananda Kumar wrote: What is the output of show full processlist On Mon, Jan 3, 2011 at 1:10 PM, Sairam Krishnamurthy kmsram...@gmail.com mailto:kmsram...@gmail.com wrote: Hi all, I

Re: Loading date takes a long time after replication

wonder why it is slow now after the master has been reset. By reset I mean, commenting out the master setup lines in the my.cnf file, removal of logs and restarting the database. Thanks in advance Thanks, Sairam Krishnamurthy +1 612 859 8161 On 12/06/2010 04:47 AM, Ananda Kumar wrote: Also

Re: Loading date takes a long time after replication

Apparently nothing. Just the Show process list query. 70100 | user | localhost | database | Query |0 | NULL | show full processlist Thanks, Sairam Krishnamurthy +1 612 859 8161 On 01/03/2011 01:51 AM, Ananda Kumar wrote: What is the output of show full processlist On Mon, Jan 3

Re: Loading date takes a long time after replication

Thanks Guys. Let me check these options and will get back with the results. Thanks again. Thanks, Sairam Krishnamurthy +1 612 859 8161 On 12/06/2010 04:47 AM, Ananda Kumar wrote: Also, make sure your /tmp folder is on a separate and fast disk. We had similar issues and we moved /tmp folder

Loading date takes a long time after replication

which will be generally done in a few minutes otherwise. Is there a workaround for this? We really don't want to wait for hours for the table to be loaded. Should we abandon replication for this? Any pointers ? -- Thanks, Sairam Krishnamurthy +1 612 859 8161

Query precision issue

querying, but I am interested in finding why an additional trailing zero returns an empty set. -- Thanks, Sairam Krishnamurthy +1 612 859 8161

Re: Query precision issue

That is exactly the problem. It is float. Thanks for your input. Thanks, Sairam Krishnamurthy +1 612 859 8161 On 10/25/2010 01:00 PM, Dan Nelson wrote: In the last episode (Oct 25), Sairam Krishnamurthy said: I have simple query like 'select * from table1 where column1=-107.689878