- discuss - lists.mariadb.org

[Maria-discuss] MariaDB 10.0.10 - InnoDB confusion?
by Charles Cazabon 08 May '14

08 May '14

Greetings, I'm not sure if I'm doing something particularly stupid, but I'm having difficulty using InnoDB (the XtraDB version) with MariaDB v.10.0.10. The engine shows as disabled in my configuration for reasons I'm unclear on. I'm using a mirror of the apt repository (from http://mariadb.org/mariadb/repositories/) on Ubuntu 14.04 server, running on x86_64. The currently installed version is 10.0.10+maria-1~trusty . My configuration includes changing the default table type: # defaults to innodb default_storage_engine = aria That works as expected. However, when I create a table specifying `ENGINE=InnoDB`, the table is actually created as an Aria table, and a warning is logged: > show warnings; +---------+------+---------------------------------+ | Level | Code | Message | +---------+------+---------------------------------+ | Warning | 1286 | Unknown storage engine 'InnoDB' | +---------+------+---------------------------------+ Sure enough, the InnoDB engine shows as not supported: > show engines; [...] | InnoDB | NO | Percona-XtraDB, Supports transactions.... | I haven't done anything specifically to disable XtraDB/InnoDB support. Looking through the documentation, knowledge basse, and mailing list archives hasn't turned up anything related. The only thing I found was this, in the documentation for the ignore_builtin_innodb variable: ignore_builtin_innodb Description: In older versions of MariaDB, setting this to 1 resulted in the built in InnoDB storage engine to be ignored. In MariaDB 5.5, InnoDB is the default and is always present, so this variable is ignored and setting it results in a warning. In MariaDB 10.0.x, this variable currently needs to be set. I'm not sure exactly what it means by saying it "needs to be set" with this version of MariaDB (doc bug?). If I add `ignore_builtin_innodb = 1` to my configuration, then the server refuses to start, complaining about unrecognized configuration options in the config, basically anything to do with innodb (innodb_file_per_table, innodb_checksum_algorithm, etc). Am I missing something? Is there a way to use Aria as the default table type while still allowing the use of XtraDB-provided InnoDB tables as well? Any assistance appreciated. Thanks, Charles -- ------------------------------------------------------------------ Charles Cazabon <charlesc-web-register-launchpad.net(a)pyropus.ca> Software, consulting, and services available at http://pyropus.ca/ ------------------------------------------------------------------

2 2

[Maria-discuss] New Question: Order of releases
by AskMonty KB 08 May '14

08 May '14

Hello, A new question has been asked in "Release Notes - MariaDB Audit Plugin" by dveeden: -------------------------------- The releases seems to be ordered by the excerpt. Because of this text based order the latest release is below the older releases. How can we force ordering on the real date or version number? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/order-of-releases/

1 0

[Maria-discuss] New Question: Unable to install TokuDB storage engine using YUM in Fedora 20 64bit? I am running MariaDB 10.0 version and Fedora 20 64bit.
by AskMonty KB 07 May '14

07 May '14

Hello, A new question has been asked in "MariaDB community" by cyberdomecyberdome: -------------------------------- I am trying to install TokuDB engine in my Fedora 64bit MariaDB 10.0 server. When I run the command " yum install MariaDB-tokudb-engine " it gives me error no package found. Have they not added tokuDB in the repository? any help is appreciated. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-install-tokudb-storage-engine-using-yum-…

1 0

[Maria-discuss] New Question: I want to help MariaDB community and execute Test Cases and provide results how can I do that?
by AskMonty KB 07 May '14

07 May '14

Hello, A new question has been asked in "MariaDB community" by cyberdomecyberdome: -------------------------------- I am a QA Analyst and I love open source. I want to gain access to MariaDB community and read the TEST PLAN and execute test cases? Where can I get this information and post my results. Are they using QTP or Quality Center or JIRA? where can I start? any help is greatly appreciated. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/i-want-to-help-mariadb-community-and-execute-test-…

1 0

[Maria-discuss] New Question: When was founded?
by AskMonty KB 06 May '14

06 May '14

Hello, A new question has been asked in "MariaDB Documentation" by lucasgoulart: -------------------------------- Hi, i'm making a school work about MariaDB. I need to know, when the DataBase was founded? Waiting for your contact. Thanks! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/when-was-founded/

1 0

[Maria-discuss] New Question: ROWID in *.dbf Files
by AskMonty KB 06 May '14

06 May '14

Hello, A new question has been asked in "CONNECT" by alfredwelzhofer: -------------------------------- Is there a way to get the recno() / ROWID as field from the *dbf File? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/rowid-in-dbf-files/

1 0

[Maria-discuss] New Question: migration from 5.5.32 into 5.5.37
by AskMonty KB 06 May '14

06 May '14

Hello, A new question has been asked in "What is in the different MariaDB releases?" by micimici: -------------------------------- Hallo All What is the step that I have do to use Migrate MariaDB 5.5.32 into MariaDB 5.5.37 ? thanks for any help, regards, mici -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/migration-from-5532-into-5537/

2 1

[Maria-discuss] New Question: what is the difference between MariaDB and Oracle?
by AskMonty KB 05 May '14

05 May '14

Hello, A new question has been asked in "MariaDB community" by cyberdomecyberdome: -------------------------------- I am new to this? I have just started to learn MariaDB and I am very impressed with MariaDB? I am just trying to understand something. I know that Oracle uses tablespaces to store their DATA. But what about MariaDB? what does MariaDB use to store DATA? What is the purpose for the BLACKHOLE storage engine? when you are writing to blackhole nothing exists. So, what is the point of having it? Any help is greatly appreciated, -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/what-is-the-difference-between-mariadb-and-oracle/

1 0

[Maria-discuss] New Question: Importar as configurações na tela inicial do HeidiSQL
by AskMonty KB 04 May '14

04 May '14

Hello, A new question has been asked in "MariaDB community" by samuelcarlos: -------------------------------- Boa tarde... De onde eu importo as configurações que é pedido na hora em que eu abro o HeidiSQL? Pelo que posso ver sem esta importação não consigo abri-lo Desde ja agradeço. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/importar-as-configuracoes-na-tela-inicial-do-heidi…

1 0

[Maria-discuss] New Question: can not find mysql_secure_installation (WinXP32)
by AskMonty KB 04 May '14

04 May '14

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by hmenges: -------------------------------- Hi Folks, I can not find the script mysql_secure_installation on my Win XP (SP3) after installation. I tried to follow the instuctions under: https://mariadb.com/kb/en/mysql_secure_installation/ but the search under windows XP does not find the script. What am I doing wrong? Thanks in advance. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/can-not-find-mysql_secure_installation-winxp32/

1 0