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",
If it persists, use vmstat 1 ~Kelly W Black -----Original Message----- From: Jeremy Zawodny [mailto:Jeremy@;Zawodny.com] Sent: Tuesday, November 12, 2002 2:31 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: delayed inserts and messages in the <host>.err log On Tue, Nov 12, 2002 at 02:18:44PM -0800, [EMAIL PROTECTED] wrote: > This is just a "should I be concerned" question. I am getting a few > messages in the mysql error log about delayed inserts and the database not > being able to obtain a lock. The database is averaging about 250 queries > per second. We are using delayed inserts for most every insert and the data > is "read" about every 5 seconds or so. I am not getting that many errors > considering the amount of inserts taking place (very heavy on the inserts), > I think, I'm just not sure what this really means... is data being lost? > I've looked at the data and it doesn't appear to be *losing* it. [snip] > 021112 15:32:12 mysqld started > /usr/local/mysql-3.23.51-sun-solaris2.8-sparc/bin/mysqld: ready for > connections > 021112 16:04:31 Delayed insert thread couldn't get requested lock for table > app_nc_snmppoll That's odd. There seem to be two places in the code where MySQL generates that error. One is preceded by this comment: /* This should never happen */ And the other by this one: /* This can only happen if thread is killed by shutdown */ So I'm a bit suspicious. In one of those cases, it jumps to error handler that flushes the delayed inert queue for that table, so you'd lose data. In the other, it does not. Hmm. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 98 days, processed 2,070,154,310 queries (242/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
