Re: mySQL never completes a simple query - Greg Brunet - com.mysql.lists.win32

29 messages in com.mysql.lists.win32Re: mySQL never completes a simple query

From	Sent On	Attachments
Greg Brunet	12 Jun 2000 22:06
Johnson, Gregert	13 Jun 2000 13:58
Greg Brunet	13 Jun 2000 14:46
Jeff Stuart	13 Jun 2000 15:06
Sinisa Milivojevic	14 Jun 2000 04:42
Sinisa Milivojevic	14 Jun 2000 04:48
Sinisa Milivojevic	14 Jun 2000 04:49
Greg Brunet	14 Jun 2000 08:13
Greg Brunet	14 Jun 2000 11:12
Jeff Stuart	14 Jun 2000 11:45
Jeff Stuart	14 Jun 2000 11:55
Greg Brunet	14 Jun 2000 12:22
André Temme	14 Jun 2000 14:38
Christopher Land	14 Jun 2000 15:01
Sinisa Milivojevic	15 Jun 2000 03:39
Sinisa Milivojevic	15 Jun 2000 03:41
Sinisa Milivojevic	15 Jun 2000 03:41
Sinisa Milivojevic	15 Jun 2000 03:47
Jeff Stuart	15 Jun 2000 13:41
Vince LaMonica	15 Jun 2000 13:54
Christopher R. Jones	15 Jun 2000 13:58
Jeff Stuart	15 Jun 2000 15:54
Tim Endres	15 Jun 2000 17:31
Bernardo Pita	15 Jun 2000 17:36
Sinisa Milivojevic	16 Jun 2000 03:49
Sinisa Milivojevic	16 Jun 2000 03:55
Carsten Gehling	16 Jun 2000 04:33
Jeff Stuart	16 Jun 2000 11:14
Jonah H. Harris	16 Jun 2000 13:33

Subject:	Re: mySQL never completes a simple query
From:	Greg Brunet (GBru...@SemperSoft.com)
Date:	06/14/2000 08:13:24 AM
List:	com.mysql.lists.win32

Hi Sinsia:

I built the test table as shown (5 records!) since I was having the same problem with a large (over 10000 records) table. I'll have to look into increasing the sort buffer, but since it should only have to sort 2 small records, I don't expect that should be a problem. Sorry that I left out the version - it's MySQL 3.22.33-shareware-debug. I'm evaluating the product right now, so don't have access to 3.23. Finally - I've got lot's of disk space (over 1.5 gb). Thanks for your help. I'll look into those things that you've identified.

-- Greg

On Tue, 13 Jun 2000, Greg Brunet wrote:

Hi:

I've installed mySQL on a Win 2000 Pro pc, and have tried doing some test queries. Real simple ones work fine, but when I try to do some still relatively simple ones, it goes off into never-never land. I've created a small test table called states which contains:

ID State City 1 IL Chicago 2 IL Carol Stream 3 OH Cincinnati 4 IL Carpentersville 5 OH Dayton

If I do a "Select * from State;" it works okay, but if I try:

"Select count(*) from states group by state;" or "Select distinct state from states;" or "Select state from states order by state;"

mySql never returns. I've tried running these from mySQL as well as phpMyAdmin with similar results. (Right now, a Show ProcessList tells me that the queries times are over 50000! and are still stuck in the "Sorting Result" state). BTW, when I try to KILL the process in phpMyAdmin, the process shows up as KILLED in the next Show ProcessList, but continues to rack up time! Any ideas on what's causing these problems?

Hi!

How big is that table ??

Can you try to increase sort buffer to 2 Mb ??

What MySQL version it is ??

Can you try 3.23 ??

Last but not least, check that you have not run out of disk space on tmpdir partition.

Regards,

+----------------------------------------------------------------------+ | ____ __ _____ _____ ___ == MySQL AD | | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic | | /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sin...@mysql.com | | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus | | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ | | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ | | /*/ \*\ Developers Team | +----------------------------------------------------------------------+