Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I have 8 gb RAM on mysql server but i'm still getting out of memory exception while selecting large data from tables.I looked into the memory consumed by mysql , its around 1 gb only.Any clue on y getting this error?? My config file is as below:

    default-storage-engine=MyISAM
    max_connections=500
    query_cache_type = 2
    query_cache_size=512M
    query_cache_limit = 512M
    table_cache=128
    tmp_table_size=512M
    thread_cache_size=8
    myisam_max_sort_file_size=1024M
    myisam_sort_buffer_size=126M
    key_buffer_size=512M
    read_rnd_buffer_size=64M
    sort_buffer_size=512M
    innodb_log_file_size=256M
    innodb_buffer_pool_size=700M
    innodb_additional_mem_pool_size=20M
    innodb_flush_log_at_trx_commit=2
    innodb_buffer_pool_size=700M
    myisam_max_extra_sort_file_size=512M

And no i'm not using any text.long text or blob though i'm using varchar in many fields.

share|improve this question
1  
Please post the exact error messages. your current my.cnf, and tell us which storage engine your database is using. – RolandoMySQLDBA Jun 22 '12 at 15:53
Two questions: 1) Are you using TEXT, LONGTEXT, or BLOB fields in any of your tables ? 2) What is max_allowed_packet currently set to ? – RolandoMySQLDBA Jun 22 '12 at 18:06
@RolandoMySQLDBA hi i have updated my question above with re3quired details. – Jay Jun 26 '12 at 6:34
Can you post the error message which you get and the query u try to execute? – Kürşad DARA Jun 26 '12 at 11:31
@KürşadDARA Please don't post comments as answers. Even if you don't have enough reputation to post a comment yet, that does not make commenting in an answer acceptable. – JNK♦ Jun 26 '12 at 12:15

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

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.