- Top Stats

Top Posters Top Topic Starters Top Topics
Gryzor 2591
AMSDOS 554
Bryce 457
Devilmarku... 340
TFM 308
Gryzor 209
Ygdrazil 21
Devilmarku... 20
CPCLER 14
arnoldemu 14
CPCWiki forum ... - 167810 Views Octoate 15:29, 06 April 10
Amstrad Action... - 43282 Views CPCIak 10:56, 03 January 10
Have your say ... - 16765 Views gryzor 10:18, 22 September 15
Donations to t... - 14836 Views gryzor 17:54, 22 January 12
Forum installa... - 14489 Views gryzor 14:08, 20 September 16


Author Topic: Migrating the forum  (Read 1242 times)

0 Members and 1 Guest are viewing this topic.

Offline Gryzor

  • Administrator
  • 6128 Plus
  • *****
  • Posts: 14.837
  • Country: gr
  • CPC-Wiki maintainer
    • CPCWiki
  • Liked: 2856
Re: Migrating the forum
« Reply #25 on: 18: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...

Offline Poliander

  • Supporter
  • CPC6128
  • *
  • Posts: 160
  • Country: de
  • Liked: 78
Re: Migrating the forum
« Reply #26 on: 19:03, 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 • X-MASS • CTM 644 • DMP 2160 — Schneider CPC 6128 • M4 Board • Z-MEM • OSSC

Offline Gryzor

  • Administrator
  • 6128 Plus
  • *****
  • Posts: 14.837
  • Country: gr
  • CPC-Wiki maintainer
    • CPCWiki
  • Liked: 2856
Re: Migrating the forum
« Reply #27 on: 19:56, 10 June 18 »
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.