[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? 2. Is this default behavior the same in 5.1.53 and 5.2.6? 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 installed?
I am curious, if XtraDB is turned on / installed by default when MariaDB is
I'm inclince to believe it ships with the Windows version by default although you need to be explicit when creating your tables/databases which engine you want to use with the ENGINE= clause.
Please see the release notes:
http://kb.askmonty.org/v/mariadb-5153-release-notes
http://kb.askmonty.org/v/mariadb-526-release-notes
Is this default behavior the same in 5.1.53 and 5.2.6?
Not certain but I'm inclined to say "yes" because of the release notes.
How can I tell if XtraDB is currently installed on any given MariaDB
show engines;
HTH
-Adam
SHOW ENGINES;
or
SELECT * FROM information_schema.ENGINES;
You will see "YES" in the 'support' column of the output for 'InnoDB. It is actually XtraDB, but it identifies itself as InnoDB (for portability and compability reasons).
Peter
On Mon, May 23, 2011 at 18:46, Adam M. Dutko dutko.adam@gmail.com wrote:
I am curious, if XtraDB is turned on / installed by default when MariaDB is
I'm inclince to believe it ships with the Windows version by default although you need to be explicit when creating your tables/databases which engine you want to use with the ENGINE= clause.
Please see the release notes:
http://kb.askmonty.org/v/mariadb-5153-release-notes
http://kb.askmonty.org/v/mariadb-526-release-notes
Is this default behavior the same in 5.1.53 and 5.2.6?
Not certain but I'm inclined to say "yes" because of the release notes.
How can I tell if XtraDB is currently installed on any given MariaDB
show engines;
HTH
-Adam
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Hi!
"Peter" == Peter Laursen peter_laursen@webyog.com writes:
Peter> SHOW ENGINES; Peter> or
Peter> SELECT * FROM information_schema.ENGINES;
Peter> You will see "YES" in the 'support' column of the output for 'InnoDB. It is Peter> actually XtraDB, but it identifies itself as InnoDB (for portability and Peter> compability reasons).
If you 'do show engines' you will see:
| InnoDB | YES | XtraDB engine based on InnoDB plugin. Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
Regards, Monty
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."
participants (5)
-
Adam M. Dutko -
Jake Drew -
Michael Widenius -
Peter Laursen -
Vladislav Vaintroub