Database cpu problem

07/31/2011 12:53 kaderebak#1
dbo.item is using my cpu %100

What is the source of problem and how can ı fix that ?

[Only registered and activated users can see links. Click Here To Register...]


[Only registered and activated users can see links. Click Here To Register...]
07/31/2011 13:01 TRmuratTR#2
Yeniden editle dbo.itemi
07/31/2011 14:40 TheSuperKiller#3
cleanup items . by

DELETE FROM [Telecaster].[dbo].[Item]
WHERE owner_id=0

and also clear buffs .

DELETE FROM [Telecaster].[dbo].[State]

GO
07/31/2011 17:22 kaderebak#4
if ı delete dbo.item players lose their items ?
07/31/2011 20:15 Cieldaron#5
WHERE owner_id=0 means "only" items which aren't used and from the warehouse will be deleted.

It's your decision.
07/31/2011 20:59 kaderebak#6
Quote:
Originally Posted by Cieldaron View Post
WHERE owner_id=0 means "only" items which aren't used and from the warehouse will be deleted.

It's your decision.
I'm sorry but I do not understand anything :(

Can you picture expression.
07/31/2011 23:42 Cieldaron#7
Code:
DELETE FROM [Telecaster].[dbo].[Item]
WHERE owner_id=0
The part "WHERE owner_id=0" means that every item from the warehouse of every single player will be deleted as the database marks items which aren't in the inventory with owner_id = 0.

Got it now? (:

It also deletes items which aren't in use by any player (dropped items etc.).
08/01/2011 00:13 kaderebak#8
Quote:
Originally Posted by Cieldaron View Post
Code:
DELETE FROM [Telecaster].[dbo].[Item]
WHERE owner_id=0
The part "WHERE owner_id=0" means that every item from the warehouse of every single player will be deleted as the database marks items which aren't in the inventory with owner_id = 0.

Got it now? (:

It also deletes items which aren't in use by any player (dropped items etc.).
Is not this just a temporary solution ?
08/01/2011 02:43 Cieldaron#9
I didn't suggest it.

I just wanted to clarify that this query will probably delete everything from your warehouse.
08/01/2011 03:26 RoflcopterGoesSoiSoiSoi#10
It's been a while since I looked in the database, but I'm pretty sure it deletes some auction-related information. I forget how the AH works, but I swear I remember it setting owner_id to 0.

This will horribly destroy your database if tamed creatures are inside the warehouse.