Mysql client hangs when returning large result sets

Asked May 03 '12 at 09:35

Active May 03 '12 at 11:21

Viewed 122 times

I have a strange problem on one Mac: when doing selects that return large result sets (> 10.000 rows), the sql client on that machine hangs. It does not return anything and just waits. All other machines can run the query without any problem. Even more strange: that Mac can do that query on the staging mysql without any problems. It only has problems with the live mysql server instance.

Is there any advice what I should check? The my.cnf is the same as the config on the other macs.

asked May 03 '12 at 09:35

bitboxer

1

Any my.cnf differences between staging and live MySQL environments? – Janne Pikkarainen May 03 '12 at 12:56
Which version of MySQL you are using on MAC? – Abdulrehman May 03 '12 at 11:21
I tried a few versions. The current installed is "mysql Ver 14.14 Distrib 5.5.20, for osx10.7 (i386) using readline 5.1", installed with homebrew. – bitboxer May 03 '12 at 11:24
none that i can see. the my.cnf is the same. – bitboxer May 04 '12 at 09:24

Mysql client hangs when returning large result sets

0 Answers0