Long #repop and zone times after source upgrade

[Akkadius]

Originally Posted by Bohbo

mysqld.exe is the culprit it looks like. Still trying to write with logging disabled somehow?

If it is truly mysql, then while you repop do a:

#logs gmsay 36 1

And you can get an idea of what queries are trying to write.

You shouldn't be pushing MB/s of data on write

[Bohbo]

Originally Posted by Akkadius

If it is truly mysql, then while you repop do a:

#logs gmsay 36 1

And you can get an idea of what queries are trying to write.

You shouldn't be pushing MB/s of data on write

Not sure if this matters. But when i tried to use #logs i get the context for the command but if i do #logs gmsay 36 1 i dont get a response and the DB doesn't change. I had to manually change the DB. Any chance that might be related to the cause of problems. I will double check my perl to make sure its the one for plugins.

[Akkadius]

Originally Posted by Bohbo

Not sure if this matters. But when i tried to use #logs i get the context for the command but if i do #logs gmsay 36 1 i dont get a response and the DB doesn't change. I had to manually change the DB. Any chance that might be related to the cause of problems. I will double check my perl to make sure its the one for plugins.

I meant:

#logs set gmsay 36 1

[Bohbo]

Potential problem with Tasks?

[02-06-2015 :: 15:27:57] [MySQL Query] SELECT `taskid`, `activityid`, `completedtime` FROM `completed_tasks` WHERE `charid` = 8 ORDER BY completedtime, taskid, activityid (0 rows returned)
[02-06-2015 :: 15:27:57] [MySQL Query] SELECT `taskid` FROM character_enabledtasks WHERE `charid` = 8 AND `taskid` >0 AND `taskid` < 10000 ORDER BY `taskid` ASC (0 rows returned)
[02-06-2015 :: 15:28:06] [MySQL Query] SELECT c.id,c.name,c.class,c.level,c.last_login,c.zone_id, g.guild_id,g.rank,g.tribute_enable,g.total_tribute,g.last_tribute, g.banker,g.public_note,g.alt  FROM `character_data` AS c LEFT JOIN guild_members AS g ON c.id=g.char_id  WHERE g.guild_id=1 (6 rows returned)

EDIT:: character_enabledtasks is empty

EDIT2:: Looking at a simple repop SQL seems to be doing about 60 records a second a second on repop

[02-06-2015 :: 15:41:18] [MySQL Query] DELETE FROM respawn_times WHERE id=9900471 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900471, 1423266078, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] DELETE FROM respawn_times WHERE id=9900470 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900470, 1423266079, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] DELETE FROM respawn_times WHERE id=9900469 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900469, 1423266079, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] DELETE FROM respawn_times WHERE id=9900468 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900468, 1423266079, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] DELETE FROM respawn_times WHERE id=9900467 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900467, 1423266079, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] DELETE FROM respawn_times WHERE id=9900466 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900466, 1423266079, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] DELETE FROM respawn_times WHERE id=9900465 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900465, 1423266079, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] DELETE FROM respawn_times WHERE id=9900464 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900464, 1423266079, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] DELETE FROM respawn_times WHERE id=9900463 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900463, 1423266079, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] DELETE FROM respawn_times WHERE id=9900462 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900462, 1423266079, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] DELETE FROM respawn_times WHERE id=9900461 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900461, 1423266079, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] DELETE FROM respawn_times WHERE id=9900460 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900460, 1423266079, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] DELETE FROM respawn_times WHERE id=9900459 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900459, 1423266079, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] DELETE FROM respawn_times WHERE id=9900458 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900458, 1423266079, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] DELETE FROM respawn_times WHERE id=9900457 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900457, 1423266079, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] DELETE FROM respawn_times WHERE id=9900456 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900456, 1423266079, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] DELETE FROM respawn_times WHERE id=9900455 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900455, 1423266079, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] DELETE FROM respawn_times WHERE id=9900454 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900454, 1423266079, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] DELETE FROM respawn_times WHERE id=9900453 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900453, 1423266079, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] DELETE FROM respawn_times WHERE id=9900452 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:19] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900452, 1423266079, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:20] [MySQL Query] DELETE FROM respawn_times WHERE id=9900451 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:20] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900451, 1423266080, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:20] [MySQL Query] DELETE FROM respawn_times WHERE id=9900447 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:41:20] [MySQL Query] REPLACE INTO respawn_times (id, start, duration, instance_id) VALUES (9900447, 1423266080, 0, 0) (0 rows returned)
[02-06-2015 :: 15:41:31] [MySQL Query] SELECT hotzone FROM zone WHERE short_name = 'freeporttheater' (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT id, spawngroupID, x, y, z, heading, respawntime, variance, pathgrid, _condition, cond_value, enabled, animation FROM spawn2 WHERE zone = 'freeporttheater' AND version = 0 (45 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900447 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900451 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900452 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900453 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900454 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900455 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900456 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900457 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900458 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900459 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900460 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900461 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900462 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900463 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900464 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900465 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900466 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900467 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900468 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900469 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900470 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900471 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900472 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900473 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900474 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900475 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900476 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900478 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900480 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900526 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900593 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900594 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900595 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900596 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900597 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900598 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900599 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900600 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900601 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900602 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900603 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900604 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900605 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900606 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:20] [MySQL Query] SELECT start, duration FROM respawn_times WHERE id = 9900626 AND instance_id = 0 (1 rows returned)
[02-06-2015 :: 15:42:21] [MySQL Query] DELETE FROM respawn_times WHERE id=9900626 AND instance_id = 0 (0 rows returned)
[02-06-2015 :: 15:42:21] [MySQL Query]

EDIT3::Not sure if it matters but i did double check perl and the #logs set gmsay 36 <1/0> gives feedback for enabling or disabling but doesn't actually change the DB.