Hi all, I am facing a big problem and see if anyone know how to solve it. I am using freebsd 4.4 with mysql-4.0.12. The database server has 2G RAM in it. Here is the content of my.cnf.
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock port=3306 set-variable = thread_cache_size=550 set-variable = table_cache=4200 set-variable = key_buffer_size=500M set-variable = record_buffer=100000 set-variable = max_connect_errors=9999999999 set-variable = max_connections=750 set-variable = tmp_table_size=10M transaction-isolation = READ-UNCOMMITTED skip-name-resolve skip-locking skip-innodb set-variable = query_cache_type=1 set-variable = query_cache_size=52428800 log-slow-queries memlock set-variable = max_binlog_size=10M log-bin=/var/lib/mysql/auth1-1-log-bin log-bin-index=/var/lib/mysql/auth1-1-log-bin.index server-id=1 [mysql.server] user=mysql [safe_mysqld] err-log=/var/lib/mysql/mysqld.log pid-file=/var/lib/mysql/mysqld.pid The server is running completely fine before. Today I found that one table is corrupted without any reason. MySQL cannot show the table when I use that database. Then I ran myisamchk on that table. Here is my command. myisamchk -f -o -v -q -O key_buffer_size=800M -O sort_buffer_size=800M -O read_buffer_size=80M -O write_buffer_size=80M kaming_table.* The table 'kaming_table' has 1G MYD data file and 300M MYI index file. Then after the checking, the table seems being fixed and then I start the MySQL again. I can run query in that table after that. Then suddenly I saw this error message keeps coming in the mysqld.log Error Message: Out of memory; Check if mysqld or some other process uses all available memory. If not you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space I use 'top' to see how many RAM the mysql using. Just about 500M memory to using at that time and I still have at least 1G RAM in inactive. I have no idea what problem is. And I didn't see any error message from the system.... I couldn't login to mysql. I just saw that it use a lot of CPU time and so I strace the mysql process and I found that the mysql process kept output "Cannot allocate memory"..... At last, I tried to upgrade the mysql software to 4.0.13 and the problem still exist... Do anyone have idea about that. Really need help. Thanks a lot. Kaming. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
