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."