Author Topic: Migrating the forum  (Read 778 times)

0 Members and 1 Guest are viewing this topic.

Offline Gryzor

  • Administrator
  • 6128 Plus
  • *****
  • Posts: 14.388
  • Country: gr
  • CPC-Wiki maintainer
    • CPCWiki
  • Liked: 2595
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
  • CPC664
  • *
  • Posts: 144
  • Country: de
  • Liked: 67
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 • Schneider CTM 644 • X-MEM • X-MASS 128MB — Schneider CPC 6128 • OSSC • MiniBooster

Offline Gryzor

  • Administrator
  • 6128 Plus
  • *****
  • Posts: 14.388
  • Country: gr
  • CPC-Wiki maintainer
    • CPCWiki
  • Liked: 2595
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.