Author Topic: .  (Read 418 times)

stinga

  • New User

  • Offline
  • *
  • 13
    • CoastFM
.
« on: August 11, 2018, 01:32:24 PM »
.
Helps run CoastFM in Penzance UK
Running 4 x 1.8.2.0
mariaDB and tracks on a central server.

plauri

  • Hero Member

  • Offline
  • *****
  • 1264
    • Funky Corner Radio
Re: Convert tables from MyISAM to InnoDB
« Reply #1 on: October 08, 2018, 12:27:06 PM »
Either...
1 - nobody has done this
2 - nobody knows what I am asking.... :-)

number 2  :bash:  :D
Funky Corner Radio
http://www.funkycorner.it
http://www.radiofunkycorner.com

Calypso

  • Sr. Member

  • Offline
  • ****
  • 377
Re: Convert tables from MyISAM to InnoDB
« Reply #2 on: October 12, 2018, 06:02:51 PM »
Thought so! :-)

None of both; it's option 3 (I'll explain later).

At least I know what you're talking about, and I've done it; my databases are InnoDB. Also because I have the database running on a stretched Percona cluster, so you can't put it into ISAM.

The reason it's not done regularly is that most users of RadioDJ use the database as a local install on their playout system, and the benefits of InnoDB are on systems with the surplus on capacity that normal computers have these days not really notable.

However, it differs a fraction, and if you're in for it, you can use it.