Bug Slooooow Queries

[Jester]

Hello, is there anything you can do to help me squash these SLOW log entries?

# Time: 140114 18:57:14
# User@Host: W101CDB[W101CDB] @  [x.x.x.x]
# Thread_id: 3741  Schema: wizard  QC_hit: No
# Query_time: 13.801944  Lock_time: 0.000050  Rows_sent: 0  Rows_examined: 751190
use wizard;
SET timestamp=1389743834;
SELECT * FROM credits_pending WHERE checkstamp <= 1389743819 AND userid = 136471 ORDER BY checkstamp ASC LIMIT 1;
# Time: 140114 18:57:16
# User@Host: W101CDB[W101CDB] @  [x.x.x.x]
# Thread_id: 3753  Schema: wizard  QC_hit: No
# Query_time: 13.718970  Lock_time: 0.000064  Rows_sent: 1  Rows_examined: 695240
SET timestamp=1389743836;
SELECT * FROM credits_pending WHERE checkstamp <= 1389743822 AND userid = 136100 ORDER BY checkstamp ASC LIMIT 1;

 

[Fillip H.]

You may need to prune your credits_pending table. I don't think that normally has over 750k rows.

Unless you use a feature that specifically depend on it, you should consider deleting older entries.

 

[Jester]

I can do that - how much should I prune and is it supposed to be doing that on it's own?

 

[Jester]

What would emptying it do?

Showing rows 0 - 29 ( ~411,121 total

, Query took 0.0007 sec)
SELECT *
FROM credits_pending
LIMIT 0 , 30

 

[Fillip H.]

Sorry for the delay in getting back to you on this, this slipped my mind.

I'm not really sure what exactly the credits_pending table is used for in the vB4 version, so I would advise you to take a complete backup of the table before pruning it.

 

[Jester]

Hi there, I ended up changing the way pending credits were processed - I basically forced them all through right away instead of trickling.

 

[DragonByte Technologies]

Hello @Jester,

We hope your ticket regarding vBCredits II Deluxe has been addressed to your satisfaction. This ticket has now been scheduled to be closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.

 

[DragonByte Technologies]

Hello @Jester,

As we have not heard back from you, your ticket regarding vBCredits II Deluxe has now been closed.

If your ticket has not been resolved, please feel free to start a new support ticket and link back to this ticket.

Thank you.


- DragonByte Technologies, Ltd.