MySQL Forums
Forum List  »  Quality Assurance

Advanced Search
New Topic

really weird situation. count() is not working when i high read_buffer_size
Posted by: Ulas Ahmet
Date: March 16, 2012 02:03AM

Hi all,

I have a weird problem. I have a myisam table with about 30.000 rows.
When i set read_buffer_size=400M it works but really slow. When i set it read_buffer_size=4G it is really fast but count() function gives null.
Also select * from table gives null but if i limit it such as "select * from table limit 0,100" it is ok.

What can i do?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
really weird situation. count() is not working when i high read_buffer_size
2434
Ulas Ahmet
March 16, 2012 02:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.