Weird, intermittent behavior: "SHOW FIELDS" queries taking 2 seconds!

2008-06-28 Thread Ben Sprecher
Hi folks - I've searched the web in vain to try to find anyone else with this problem. My computer will intermittently start having all "SHOW FIELDS" queries take 2 seconds. Not 1. Not 3. Always 2. The problem appears suddenly for no apparent reason - sometimes immediately after restarting the com

Re: Slow Query

2008-06-28 Thread Darryl Steyn
Hi Ananda, At the moment the explain for the entire month will look the same as the one I first gave as the database currently only has test data for the start of the month. I will populate the database with more info on Monday, but I have managed to get it to return only the rows where the minut

agquarx wants to keep up with you on Twitter

2008-06-28 Thread agquarx
To find out more about Twitter, visit the link below: http://twitter.com/i/429c961b36cd7c31a28772a32e82bb19f302ebaf Thanks, -The Twitter Team About Twitter Twitter is a unique approach to communication and networking based on the simple concept of status. What are you doing? What are your frie

Re: mysql - load data file question..

2008-06-28 Thread Ananda Kumar
can u please show use the content of the test.csv file. Also is "comapny name" a single column or two different columns If its two different columns than try this load data file '/foo/test.csv' into table abc.test fields terminated by ',' (company,name)"; On 6/28/08, bruce <[EMAIL PROTECTED]> w