delayed inserts and messages in the .err log

[matt]

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.
some specifics:
--
the delayed_writes increases by about 200 every second or two. The delayed_errors increases about every 20 minutes or so.
| Delayed_insert_threads | 48 |
| Delayed_writes | 180619 |
| Delayed_errors | 8 |
| Not_flushed_delayed_rows | 5 |
--
I recently restarted it to get a better handle on the time frame of the errors.
Uptime: 5661 Threads: 61 Questions: 1502915 Slow queries: 56 Opens: 11009 Flush tables: 1 Open tables: 159 Queries per second avg: 265.486
--
From the <hostname>.err log after my recent restart:
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
021112 16:04:45 Delayed insert thread couldn't get requested lock for table app_sems_snmppoll
021112 16:36:01 Delayed insert thread couldn't get requested lock for table unix_ds
021112 16:52:15 Delayed insert thread couldn't get requested lock for table unix_ds
--

This is binary distribution of MySQL for Solaris and I have changed some values in the /etc/my.cnf per the mysql documentation. I am not extremely proficient with mysql and solaris. But, I did notice the log and was wondering if I should be concerned. Any input will be greatly appreciated. Thank you guys and gals :-)
matt
--
m@
"Like a cloud dropping rain, I'm discarding all thought." - Eddie Vedder

---------------------------------------------------------------------
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