From: maria-discuss-bounces+wlad=montyprogram.com@lists.launchpad.net [mailto:maria-discuss-bounces+wlad=montyprogram.com@lists.launchpad.net] On Behalf Of Jake Drew
Sent: Montag, 23. Mai 2011 18:34
To: maria-discuss@lists.launchpad.net
Subject: [Maria-discuss] XtraDB using the Windows Installer

I have a couple of questions regarding XtraDB.

1. I am curious, if XtraDB is turned on / installed by default when MariaDB is installed using the windows installer on a Windows 2008 R2 server?  

If you left „Optimize for transactions“ checkbox “on” during the UI installation, then yes, it is installed and turned on by default (it adds default-storage-engine=innodb to my.ini, which means xtradb)

2. Is this default behavior the same in 5.1.53 and 5.2.6? 

5.1.53 installer did not create a runnable instance. If you used mysqld –install to create the instance, the behavior would be different (MyISAM would be default storage engine)

3. How can I tell if XtraDB is currently installed on any given MariaDB install? i.e. Is there a SHOW or other similar command I can run to confirm that XtraDB is

innodb in maria it normally means xtradb, it is the “compiled-in” innodb.

“show engines” will confirm that – ‘comment’ column has “XtraDB engine based on InnoDB plugin.”