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]

Reply via email to