| Bug #46849 | Out of memory | ||
|---|---|---|---|
| Submitted: | 21 Aug 2009 4:43 | Modified: | 21 Aug 2009 5:10 |
| Reporter: | Ashokkumar S | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: General | Severity: | S1 (Critical) |
| Version: | 5.1.37 | OS: | Linux (Out of memory) |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
[21 Aug 2009 5:02]
Susanne Ebrecht
This is a duplicate of bug #43606
[21 Aug 2009 5:10]
Ashokkumar S
I am using 64bit machine with RHEL 5 Previously i had loaded the same data with 5.1.14. It was added properly with the same server settings. But, why this error comes in the latest version(5.1.37). What is the suggest fix for this error.
Description: I have tried to load the 185GB data to the MyISAM table, but i got the following error, #-- Query mysql --user=root --password=mysql --quick -hmysqldb0004 -P3306 -D LP -e "LOAD DATA INFILE '/mysql-backup/restore/20090731/LP/nb_structured_loan_info.txt' INTO TABLE LP.nb_structured_loan_info FIELDS TERMINATED BY '~' LINES TERMINATED BY '\n'" #-- Error Message ERROR 5 (HY000) at line 1: Out of memory (Needed 16384 bytes) Can you any one tell me the solution for this issues? Mysql Server Details: Mysql Version : 5.1.37 RAM : 8GB my.cnf settings: [mysqld] port = 3306 datadir = /mysql/data socket = /var/lib/mysql/mysql.sock skip-locking bulk_insert_buffer_size = 2G key_buffer_size = 2G max_allowed_packet = 64M table_open_cache = 512 sort_buffer_size = 512M read_buffer_size = 64M read_rnd_buffer_size = 16M myisam_sort_buffer_size = 512M thread_cache_size = 32 query_cache_size = 16M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 How to repeat: Load huge data with MyISAM tables.