Re: very strange slow plain select

At 03:49 PM 2/7/2008, [EMAIL PROTECTED] wrote: Thanks very much. The default mysql behavior is a little unusual. What is the parameter in my.cnf to control the cache size before forcing a flush. I waited for 2 mininutes second before the output came out without the -q option. My server is fast e

Re: very strange slow plain select

Thanks very much. The default mysql behavior is a little unusual. What is the parameter in my.cnf to control the cache size before forcing a flush. I waited for 2 mininutes second before the output came out without the -q option. My server is fast enough to read in more than 2 GB data during this

Re: very strange slow plain select

In the last episode (Feb 07), [EMAIL PROTECTED] said: > I just stumbled on this hard to explain problem. Below > > select * from BigTable  (BigTable has 5 million rows) > > takes forever to even print out the first row. as you could see from > the sql, it is supposed to print out some rows ri

very strange slow plain select

Hello: I just stumbled on this hard to explain problem. Below select * from BigTable  (BigTable has 5 million rows) takes forever to even print out the first row. as you could see from the sql, it is supposed to print out some rows right away regardless of server config in my.cnf.   What is