Strange Lag

[KingMort]

Having some weird Lag issues with the latest build...

Not sure if anyone has been having similar issues or not. But this certainly does not look normal to me..

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
2542 mysql 15 0 147m 40m 4860 S 23.9 2.0 3:47.80 mysqld
4753 eqemu 15 0 111m 16m 6856 R 20.2 0.8 4:44.73 zone
4736 eqemu 15 0 110m 16m 7316 R 15.6 0.8 1:16.14 zone
4760 eqemu 15 0 114m 20m 7796 R 6.6 1.0 1:36.44 zone
4477 eqemu 15 0 111m 19m 9072 R 4.6 0.9 1:07.92 zone
4722 eqemu 15 0 110m 14m 6256 R 4.0 0.7 2:11.32 zone
4435 eqemu 15 0 113m 36m 33m S 3.6 1.8 0:51.49 world
4489 eqemu 15 0 119m 34m 15m R 2.7 1.7 1:26.26 zone
4745 eqemu 15 0 110m 15m 6744 R 2.7 0.8 0:25.15 zone
4692 eqemu 15 0 107m 13m 6008 R 2.0 0.7 0:06.41 zone
4729 eqemu 15 0 111m 16m 6728 S 2.0 0.8 1:56.20 zone
4715 eqemu 15 0 106m 11m 6076 R 1.7 0.6 0:17.27 zone
4550 eqemu 15 0 113m 18m 5940 R 1.3 0.9 0:29.06 zone
4772 eqemu 15 0 113m 18m 6204 R 1.0 0.9 0:11.97 zone
4564 eqemu 15 0 113m 17m 4324 R 0.7 0.9 0:05.10 zone
4598 eqemu 15 0 103m 7168 3940 R 0.7 0.3 0:04.49 zone
4605 eqemu 15 0 103m 7172 3940 R 0.7 0.3 0:04.53 zone

[AndMetal]

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
2542 mysql 15 0 147m 40m 4860 S 23.9 2.0 3:47.80 mysqld
4753 eqemu 15 0 111m 16m 6856 R 20.2 0.8 4:44.73 zone
4736 eqemu 15 0 110m 16m 7316 R 15.6 0.8 1:16.14 zone
4760 eqemu 15 0 114m 20m 7796 R 6.6 1.0 1:36.44 zone
4477 eqemu 15 0 111m 19m 9072 R 4.6 0.9 1:07.92 zone
4722 eqemu 15 0 110m 14m 6256 R 4.0 0.7 2:11.32 zone
4435 eqemu 15 0 113m 36m 33m S 3.6 1.8 0:51.49 world
4489 eqemu 15 0 119m 34m 15m R 2.7 1.7 1:26.26 zone
4745 eqemu 15 0 110m 15m 6744 R 2.7 0.8 0:25.15 zone
4692 eqemu 15 0 107m 13m 6008 R 2.0 0.7 0:06.41 zone
4729 eqemu 15 0 111m 16m 6728 S 2.0 0.8 1:56.20 zone
4715 eqemu 15 0 106m 11m 6076 R 1.7 0.6 0:17.27 zone
4550 eqemu 15 0 113m 18m 5940 R 1.3 0.9 0:29.06 zone
4772 eqemu 15 0 113m 18m 6204 R 1.0 0.9 0:11.97 zone
4564 eqemu 15 0 113m 17m 4324 R 0.7 0.9 0:05.10 zone
4598 eqemu 15 0 103m 7168 3940 R 0.7 0.3 0:04.49 zone
4605 eqemu 15 0 103m 7172 3940 R 0.7 0.3 0:04.53 zone

I'm a little curious as to what's going on with the database, especially since it probably relates to the processor utilization of the zones.

What do you get from the following query when that's happening?
SHOW FULL PROCESSLIST

[KingMort]

Full Texts Id User Host db Command Time State Info
Kill 9176 kmra localhost kmra Sleep 9 [BLOB - NULL]
Kill 9177 kmra localhost kmra Sleep 6 [BLOB - NULL]
Kill 9178 kmra localhost kmra Sleep 0 [BLOB - NULL]
Kill 9179 kmra localhost kmra Sleep 0 [BLOB - NULL]
Kill 9180 kmra localhost kmra Sleep 7 [BLOB - NULL]
Kill 9182 kmra localhost kmra Sleep 3 [BLOB - NULL]
Kill 9184 kmra localhost kmra Sleep 9 [BLOB - NULL]
Kill 9185 kmra localhost kmra Sleep 1 [BLOB - NULL]
Kill 9186 kmra localhost kmra Sleep 4 [BLOB - NULL]
Kill 9187 kmra localhost kmra Sleep 1 [BLOB - NULL]
Kill 9188 kmra localhost kmra Sleep 4 [BLOB - NULL]
Kill 9189 kmra localhost kmra Sleep 2 [BLOB - NULL]
Kill 9190 kmra localhost kmra Sleep 0 [BLOB - NULL]
Kill 9191 kmra localhost kmra Sleep 1 [BLOB - NULL]
Kill 9192 kmra localhost kmra Sleep 9 [BLOB - NULL]
Kill 9193 kmra localhost kmra Sleep 6 [BLOB - NULL]
Kill 9194 kmra localhost kmra Sleep 3 [BLOB - NULL]
Kill 9195 kmra localhost kmra Sleep 10 [BLOB - NULL]
Kill 9197 kmra localhost kmra Sleep 7 [BLOB - NULL]
Kill 9198 kmra localhost kmra Sleep 4 [BLOB - NULL]
Kill 9199 kmra localhost kmra Sleep 1 [BLOB - NULL]
Kill 9201 kmra localhost kmra Sleep 7 [BLOB - NULL]
Kill 9202 kmra localhost kmra Sleep 4 [BLOB - NULL]
Kill 9203 kmra localhost kmra Sleep 10 [BLOB - NULL]
Kill 9204 kmra localhost kmra Sleep 7 [BLOB - NULL]
Kill 9205 kmra localhost kmra Sleep 4 [BLOB - NULL]
Kill 9206 kmra localhost kmra Sleep 1 [BLOB - NULL]
Kill 9207 kmra localhost kmra Sleep 7 [BLOB - NULL]
Kill 9208 kmra localhost kmra Sleep 5 [BLOB - NULL]
Kill 9209 kmra localhost kmra Sleep 8 [BLOB - NULL]
Kill 9210 kmra localhost kmra Sleep 2 [BLOB - NULL]
Kill 9211 kmra localhost kmra Sleep 10 [BLOB - NULL]
Kill 9212 kmra localhost kmra Sleep 2 [BLOB - NULL]
Kill 9213 kmra localhost kmra Sleep 6 [BLOB - NULL]
Kill 9216 kmra localhost kmra Sleep 1 [BLOB - NULL]
Kill 9217 kmra localhost kmra Sleep 4 [BLOB - NULL]
Kill 9218 kmra localhost kmra Sleep 9 [BLOB - NULL]
Kill 9220 kmra localhost kmra Sleep 8 [BLOB - NULL]
Kill 9221 kmra localhost kmra Sleep 1 [BLOB - NULL]
Kill 9222 kmra localhost kmra Sleep 7 [BLOB - NULL]
Kill 11286 root localhost kmra Query 0 NULL [BLOB - 21 B]

[KingMort]

Well , I updated to the latest Opcodes.. and took out the special opcodes designed by derision out from old ones for the bazaar stuff and put into the new ones.. So far no lag.. but have only reached 35 or so players online Sundays are usually slow.... Time will tell as to how it works out..

King

[KingMort]

Ok well scratch that 2 or 3 days into it being 100% lag free I am now getting these crazy spikes again...

top - 10:58:45 up 2 days, 19:59, 1 user, load average: 49.37, 51.41, 47.03
Tasks: 114 total, 39 running, 75 sleeping, 0 stopped, 0 zombie
Cpu(s): 88.1%us, 9.9%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 2.0%si, 0.0%st
Mem: 2074304k total, 2018448k used, 55856k free, 110732k buffers
Swap: 2096472k total, 60124k used, 2036348k free, 810032k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11908 eqemu 15 0 145m 57m 13m R 22.2 2.8 24:43.57 zone
11834 eqemu 15 0 117m 27m 11m R 16.6 1.4 18:13.98 zone
11879 eqemu 15 0 122m 35m 13m S 8.0 1.7 13:56.51 zone
11871 eqemu 15 0 115m 22m 7948 R 7.0 1.1 52:20.36 zone
11636 eqemu 15 0 124m 42m 19m R 5.6 2.1 40:40.27 zone
11643 eqemu 15 0 125m 40m 16m R 5.0 2.0 39:56.91 zone
11856 eqemu 15 0 493m 404m 12m R 4.6 19.9 29:08.55 zone
11813 eqemu 15 0 132m 41m 9952 R 3.7 2.0 7:53.93 zone
11671 eqemu 15 0 109m 18m 9712 R 3.3 0.9 16:02.54 zone
11678 eqemu 15 0 109m 16m 8468 R 3.3 0.8 15:19.08 zone
11612 eqemu 15 0 194m 37m 33m S 2.7 1.8 22:42.31 world
2198 mysql 18 0 148m 28m 4300 S 2.3 1.4 180:10.77 mysqld
11886 eqemu 15 0 121m 34m 13m R 2.0 1.7 23:18.00 zone
11827 eqemu 15 0 116m 27m 11m R 1.7 1.3 17:37.33 zone
11842 eqemu 15 0 121m 31m 11m S 1.7 1.6 14:37.55 zone
11849 eqemu 15 0 118m 29m 12m R 1.7 1.4 8:39.47 zone

And the process list...

Kill 11455 kmra localhost kmra Sleep 3 [BLOB - NULL]
Kill 11458 kmra localhost kmra Sleep 9 [BLOB - NULL]
Kill 11461 kmra localhost kmra Sleep 1 [BLOB - NULL]
Kill 11462 kmra localhost kmra Sleep 2 [BLOB - NULL]
Kill 11463 kmra localhost kmra Sleep 4 [BLOB - NULL]
Kill 11464 kmra localhost kmra Sleep 7 [BLOB - NULL]
Kill 11465 kmra localhost kmra Sleep 8 [BLOB - NULL]
Kill 11466 kmra localhost kmra Sleep 7 [BLOB - NULL]
Kill 11467 kmra localhost kmra Sleep 6 [BLOB - NULL]
Kill 11468 kmra localhost kmra Sleep 6 [BLOB - NULL]
Kill 11469 kmra localhost kmra Sleep 3 [BLOB - NULL]
Kill 11470 kmra localhost kmra Sleep 8 [BLOB - NULL]
Kill 11471 kmra localhost kmra Sleep 6 [BLOB - NULL]
Kill 11472 kmra localhost kmra Sleep 6 [BLOB - NULL]
Kill 11473 kmra localhost kmra Sleep 4 [BLOB - NULL]
Kill 11474 kmra localhost kmra Sleep 10 [BLOB - NULL]
Kill 11475 kmra localhost kmra Sleep 9 [BLOB - NULL]
Kill 11476 kmra localhost kmra Sleep 5 [BLOB - NULL]
Kill 11477 kmra localhost kmra Sleep 10 [BLOB - NULL]
Kill 11479 kmra localhost kmra Sleep 9 [BLOB - NULL]
Kill 11480 kmra localhost kmra Sleep 6 [BLOB - NULL]
Kill 11481 kmra localhost kmra Sleep 9 [BLOB - NULL]
Kill 11482 kmra localhost kmra Sleep 10 [BLOB - NULL]
Kill 11483 kmra localhost kmra Sleep 7 [BLOB - NULL]
Kill 11484 kmra localhost kmra Sleep 4 [BLOB - NULL]
Kill 11485 kmra localhost kmra Sleep 7 [BLOB - NULL]
Kill 11486 kmra localhost kmra Sleep 7 [BLOB - NULL]
Kill 11487 kmra localhost kmra Query 0 Locked [BLOB - 54 B]
Kill 11488 kmra localhost kmra Sleep 4 [BLOB - NULL]
Kill 11489 kmra localhost kmra Sleep 9 [BLOB - NULL]
Kill 11490 kmra localhost kmra Sleep 2 [BLOB - NULL]
Kill 11492 kmra localhost kmra Sleep 1 [BLOB - NULL]
Kill 11493 kmra localhost kmra Sleep 1 [BLOB - NULL]
Kill 11494 kmra localhost kmra Sleep 0 [BLOB - NULL]
Kill 11495 kmra localhost kmra Sleep 3 [BLOB - NULL]
Kill 11496 kmra localhost kmra Sleep 7 [BLOB - NULL]
Kill 11498 kmra localhost kmra Sleep 4 [BLOB - NULL]
Kill 11499 kmra localhost kmra Sleep 7 [BLOB - NULL]
Kill 11500 kmra localhost kmra Sleep 3 [BLOB - NULL]
Kill 11503 kmra localhost kmra Sleep 6 [BLOB - NULL]
Kill 13157 root localhost kmra Query 0 NULL [BLOB - 21 B]