Slow update - ON DUPLICATE KEY UPDATE

Hello,

I have an INSERT query that uses the ON DUPLICATE KEY UPDATE clause.
The problem is that while inserts are done instantly, updates take up
to 5-10 minutes before taking effect!

Version: MySQL 5.0.37-LOG (Hosted server, so update not possible)
Table: InnoDB, currently sized at 138 rows/ 32kb.

Query Sample:
INSERT INTO armory_ranking
(character_hash,character_name,character_gamelevel ,character_region,character_realm,character_race,c haracter_class,character_faction,character_guild,c haracter_build,character_level,character_average)
values ('Bollebob-EU-
Magtheridon','Bollebob','70','EU','Magtheridon','U ndead','Rogue','Horde','Nihilum','','2292','134.82 ')
ON DUPLICATE KEY UPDATE character_level = '2292', character_average =
'134.82',character_guild = 'Nihilum',character_class = 'Rogue'

It's all very strange to me, I've heard people saying that this is
caused by write locks, but is there any way to speed these up?

Regards.
Brian

On 2 Jul, 10:39, Thuman <bri...@thumann.dk> wrote:
> Hello,
>
> I have an INSERT query that uses the ON DUPLICATE KEY UPDATE clause.
> The problem is that while inserts are done instantly, updates take up
> to 5-10 minutes before taking effect!
>
> Version: MySQL 5.0.37-LOG (Hosted server, so update not possible)
> Table: InnoDB, currently sized at 138 rows/ 32kb.
>
> Query Sample:
> INSERT INTO armory_ranking
> (character_hash,character_name,character_gamelevel ,character_region,charact*er_realm,character_race, character_class,character_faction,character_guild, c*haracter_build,character_level,character_average )
> values ('Bollebob-EU-
> Magtheridon','Bollebob','70','EU','Magtheridon','U ndead','Rogue','Horde','N*ihilum','','2292','134.8 2')
> ON DUPLICATE KEY UPDATE character_level = '2292', character_average =
> '134.82',character_guild = 'Nihilum',character_class = 'Rogue'
>
> It's all very strange to me, I've heard people saying that this is
> caused by write locks, but is there any way to speed these up?
>
> Regards.
> Brian

I have to say that I've never come across this problem, but here's a
hint to make the construction of the query a bit easier. Use the
VALUES() function to save having to code the literals twice thus:

INSERT INTO armory_ranking
(character_hash,character_name,character_gamelevel ,character_region,charact*
er_realm,character_race,character_class,character_ faction,character_guild,c*
haracter_build,character_level,character_average)
values ('Bollebob-EU-
Magtheridon','Bollebob','70','EU','Magtheridon','U ndead','Rogue','Horde','N*
ihilum','','2292','134.82')
ON DUPLICATE KEY UPDATE
character_level = VALUES(character_level),
character_average = VALUES(character_average),
character_guild = VALUES(character_guild),
character_class = VALUES(character_class)