News:

Printed Amstrad Addict magazine announced, check it out here!

Main Menu
avatar_Gryzor

Migrating the forum

Started by Gryzor, 11:53, 08 June 18

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Gryzor

As I said above (I think), looks like SQL is having trouble with some queries, no matter how much allowance it is given. Slow queries are different every time and there's no discernable pattern...

Poliander

Quote from: Gryzor on 16:49, 10 June 18
As I said above (I think), looks like SQL is having trouble with some queries, no matter how much allowance it is given. Slow queries are different every time and there's no discernable pattern...
Enable logging dead locks and slow queries
Schneider CPC 664 • X-MEM • Vortex F1-X Drive • CTM 644 • DMP 2160
Schneider CPC 6128 • Z-MEM • M4 Board • MultiPlay + Amiga Mouse • OSSC

Gryzor

Logging slow queries led to the non-conclusion described above ;)


As for deadlocks, I think I had at some time or another and found nothing of use. But they should be taken care of if and when we move over to innodb - which is a whole different chapter that kinda scares me.

Powered by SMFPacks Menu Editor Mod