0

I'm using Percona Server with XtraDB, but in Workbench I see the storage engine of the tables is InnoDB.

How can I configure the server to use XtraDB?

Roshana Pitigala
  • 8,437
  • 8
  • 49
  • 80
mneu
  • 427
  • 3
  • 14
  • Percona Server is just a fork/drop in replacement off MySQL i believe so i guess this will help https://dev.mysql.com/doc/refman/8.0/en/storage-engine-setting.html Otherwise https://learn.percona.com/download-percona-server-5-7-manual – Raymond Nijland May 30 '18 at 19:26
  • Technically, Percona Server is not a fork; it is a rebase. MariaDB is a fork. – utdrmac Jul 29 '18 at 03:17

1 Answers1

1

That answer my question:

https://www.percona.com/doc/percona-server/LATEST/diagnostics/show_engines.html

Storage engine name is InnoDB, but in Comment column I can see "Percona-XtraDB, Supports transactions, row-level locking, and foreign keys"

mneu
  • 427
  • 3
  • 14
  • 1
    In Percona Server, you cannot use XtraDB and InnoDB at the same time. Creating with ENGINE=InnoDB or ENGINE=XtraDB will always result in XtraDB when running Percona. Additionally, Percona reports the engine name as InnoDB to maintain 'drop-in' and 'drop-out' compatibility. – utdrmac Jul 29 '18 at 03:19