On Tue, Oct 14, 2003 at 10:49:16AM -0700, Dathan Vance Pattishall wrote:
> I wrote a quick PERL script to give me the status of a table of a
> particular database or queries in general on a db server.
>
> 71 | 2958 | System lock | e115 | messages |
> REPLACE INTO antispam (code) values ('521.25624894_50628.1066152283')
>
> For 71 seconds show full processlist is reporting that the database
> messages and table antispam has a system lock for 71 seconds YET
> skip-external-locking is on in my my.cnf file and the command "show
> variables" shows that skip external locking is on.
>
> | skip_external_locking | ON
What makes you think those are related?
External locking is that which allows seprate MySQL servers to share a
data directory.
> What is going on?
Lock contention, I'd guess. But having only seen one particular
thread, it's hard to know.
> This same behavior has not been observed in 3.23.57. Unfortunately
> it's not easy to downgrade a mysql server as I have it setup in this
> environment. So, maybe this can be a fix forward with some simple
> setting.
What do the Table_locks_* values in SHOW STATUS look like?
> I also notice some long waiting for tables even though the table with
> this status is not being flushed, altered etc.
Is the CPU busy? Or the disks?
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 31 days, processed 1,184,112,694 queries (431/sec. avg)
