Hello.
Does the problem remains if you're executing the query just after the 'FLUSH TABLES' statement. "Jon Wagoner" <[EMAIL PROTECTED]> wrote: > Recently I've been getting error 1041 at times, which gives the message > to update the ulimit or add swap space. =20 > > This is a dedicated MySQL server, so I have no ulimit set for MySQL. > According to /proc/meminfo I have over 1GB of swap free. > Mem: 2118533120 2067628032 50905088 0 19677184 1659768832 > Swap: 1998733312 686882816 1311850496 > MemTotal: 2068880 kB > MemFree: 49712 kB > MemShared: 0 kB > Buffers: 19216 kB > Cached: 1320684 kB > SwapCached: 300184 kB > Active: 943996 kB > Inactive: 1008424 kB > HighTotal: 1179484 kB > HighFree: 2044 kB > LowTotal: 889396 kB > LowFree: 47668 kB > SwapTotal: 1951888 kB > SwapFree: 1281104 kB > > The mysqld section of my.cnf contains the following: > > log-bin > server-id =3D 106 > basedir =3D /usr > datadir =3D /var/lib/mysql > tmpdir =3D /tmp > language =3D /usr/share/mysql/english > skip-locking > set-variable =3D key_buffer=3D512M > set-variable =3D max_allowed_packet=3D1G > set-variable =3D table_cache=3D3072 > set-variable =3D sort_buffer=3D2M > set-variable =3D record_buffer=3D2M > set-variable =3D thread_cache=3D8 > set-variable =3D thread_concurrency=3D8 > set-variable =3D myisam_sort_buffer_size=3D64M > set-variable =3D thread_stack=3D128K > set-variable =3D open_files_limit=3D8192 > set-variable =3D tmp_table_size=3D50M > max_tmp_tables =3D 100 > innodb_data_home_dir =3D /var/lib/mysql/ > innodb_data_file_path =3D ibdata1:10M:autoextend > innodb_log_group_home_dir =3D /var/lib/mysql/ > innodb_log_arch_dir =3D /var/lib/mysql/ > set-variable =3D innodb_buffer_pool_size=3D384M > set-variable =3D innodb_additional_mem_pool_size=3D20M > set-variable =3D innodb_log_file_size=3D5M > set-variable =3D innodb_log_buffer_size=3D8M > innodb_flush_log_at_trx_commit=3D1 > set-variable =3D innodb_lock_wait_timeout=3D50 > > long_query_time=3D30 > query_cache_limit=3D1M > query_cache_size=3D64M > query_cache_type=3D1 > max_connections=3D200 > > Does anyone have any suggestions as to why I'm getting out of memory > errors? Do I have some of the settings wrong? > If it matters, I have about 50GB worth of data, split between InnoDB and > MyISAM tables. I last got the error updating records in one of the > MyISAM tables which was about 1MB in size. > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]