Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
    
Which version of MySQL you are using on MAC? –  Abdulrehman May 3 '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 3 '12 at 11:24
1  
Any my.cnf differences between staging and live MySQL environments? –  Janne Pikkarainen May 3 '12 at 12:56
    
none that i can see. the my.cnf is the same. –  bitboxer May 4 '12 at 9:24
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.