>>>>> ">" == sinisa <sinisa@stripped> writes:
>> Andreas Vierengel writes: Hi, I'm using 3.22.27, compiled from
>> source with gcc-2.95.2 under Linux Redhat 6.1 my tables are
>> normalised. all selects use index. I have also a lot of
>> updates in one table. About 50-200 per second (depends on
>> daytime)... selects are also 50-200 per second.
>> My updates also use const index an doesn't update the keys,
>> only fields...
>> Normally they are fast as hell, but sometimes an update got
>> stuck in state "locked" (mysqladmin processlist) and stays here
>> between 30-70 seconds (!). At that time, all incoming selects
>> are also locked (they are using the same table as the updates)
>> and the number of connected threads increase to double or
>> triple ! However the "locked" update, did it after a while and
>> then all runs normal a few seconds. Then another update get
>> stuck, and the whole thing repeats.
>> Since i'm replicating my db-content in "realtime" from a master
>> server, I have the same updates and nearly the same numbers of
>> selects (due to external loadbalancing) on different machines.
>> The behaviour I described only happens on an RedHat6.1,
>> 2.2.14-SMP machine (Dual 500MHz PIII, 768 MB RAM). On my
>> single processor machines, this behaviour will NOT show up
>> (RedHat6.1, 2.2.13, 500MHz PIII, 512 MB RAM). I have nearly
>> zero disk I/O on both machines, so disk should not be the
>> all mysql-variables are the same on the single and
I have the exactly same problem.
Can anybody give me a hint more precisely?
ByoungLae Kim <pos7hink@stripped>
Technology Developement Manager of Technical Research Center.
Technophil co., LTD.
You can do everything with Linux!!