How to diasble Birthday Event it flood my database
Posted: Sat Jan 26, 2013 1:08 pm
If you want to receive support we need this info to help you properly.
ยป Find Revision
L2J Revision Number: 15M
L2JDP Revision Number: 8696
How to diasble or remove Birthday Event it flood my database
so it send many mail
mysql has cpu running 100%
I has check from slowquery.log
# Query_time: 1.875000 Lock_time: 0.046875 Rows_sent: 0 Rows_examined: 2270
SET timestamp=1359156611;
SELECT object_id, item_id, count, enchant_level, loc, loc_data, custom_type1, custom_type2, mana_left, time FROM items WHERE owner_id=-1 AND loc='MAIL' AND loc_data=282137320;
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 1.875000 Lock_time: 0.031250 Rows_sent: 0 Rows_examined: 2270
SET timestamp=1359156611;
SELECT object_id, item_id, count, enchant_level, loc, loc_data, custom_type1, custom_type2, mana_left, time FROM items WHERE owner_id=-1 AND loc='MAIL' AND loc_data=282137323;
# Time: 130126 12:52:11
ยป Find Revision
L2J Revision Number: 15M
L2JDP Revision Number: 8696
How to diasble or remove Birthday Event it flood my database
so it send many mail
mysql has cpu running 100%
I has check from slowquery.log
# Query_time: 1.875000 Lock_time: 0.046875 Rows_sent: 0 Rows_examined: 2270
SET timestamp=1359156611;
SELECT object_id, item_id, count, enchant_level, loc, loc_data, custom_type1, custom_type2, mana_left, time FROM items WHERE owner_id=-1 AND loc='MAIL' AND loc_data=282137320;
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 1.875000 Lock_time: 0.031250 Rows_sent: 0 Rows_examined: 2270
SET timestamp=1359156611;
SELECT object_id, item_id, count, enchant_level, loc, loc_data, custom_type1, custom_type2, mana_left, time FROM items WHERE owner_id=-1 AND loc='MAIL' AND loc_data=282137323;
# Time: 130126 12:52:11