OK! :-) I'll summarize the points as I see them. 1) document what must be removed in advance if MySQL was installed with the distro CD/DVD and/or offficial repo's of the distro. 2) figure out the problem with KDE and take a decision if this will be fixed or not (I think it will be difficult) 3) expose packages installed in "rpm -qa" command 4) support activating/deactivating and starting/stopping service from YaST "Service Management" GUI. (and please add TokuDB and InfiniDB soon. ¨'playing around' with TokuDB was my primary motivation for all this) -- Peter On Wed, Nov 26, 2014 at 9:38 AM, Sergei Golubchik wrote:

Hi, Daniel!

Perhaps we should put a note for every new platform that we add (was CentOS 7, now it's openSUSE) that this is a new platform, just added, a first release for it, so while binaries are same as everywhere and stable, the packaging (conflicts, dependencies) is new and might have some rough edges?

Peter, I've created MDEV-7211 for this issue to make sure it won't be forgotten.

Regards, Sergei

On Nov 25, Peter Laursen wrote:

...

I *CERTAINLY* think this

https://downloads.mariadb.org/mariadb/repositories/#mirror=23Media&version=10.0&distro_release=opensuse13-amd64&distro=openSUSE

...

is premature taken this discussion into account!

And I believe this "You will also be prompted about a conflict between openSUSE's own MariaDB 5.5 client package and the MariaDB client package" is wrong. It may be correct for 12.2 but 12.3 does not have the MariaDB 5.5 client package. It had 10.0.13 (and I think also some client package from Oracle - probably for some compability reason.

What about the conflicts on OpenSuSE 12.3 *1) with KDE and *2) with MariaDB 10.0.13 as installed from the distro DVD?

-- Peter

Hi, Peter! On Nov 26, Peter Laursen wrote:

(and please add TokuDB and InfiniDB soon. ¨'playing around' with TokuDB was my primary motivation for all this)

As far as I can see, tokudb is present in MariaDB-10.0.15-opensuse13_1-x86_64-server.rpm. Did you install the plugin? INSTALL SONAME 'ha_tokudb' Regards, Sergei

Please read https://en.opensuse.org/SDB:Add_package_repositories on how to add a software repository to Suse (commandline "zypper ar -f <URL> <alias>"). Updating the file /etc/zypp/repos.d/ manually may wrk - but I am not perfectly convinced that it will not cause problems if you later want to use zypper command or GUI. -- Peter On Wed, Nov 26, 2014 at 12:37 PM, Peter Laursen wrote:

NO.. I thought it would bea separate RPM (Like the OQGraph). I will check when I get time. it coudl take a day or two now. Sorry for false alarm.

ButSuSE should be listed here https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-t... then, right?

-- Peter

On Wed, Nov 26, 2014 at 12:12 PM, Sergei Golubchik wrote:

...

Hi, Peter!

On Nov 26, Peter Laursen wrote:

...

(and please add TokuDB and InfiniDB soon. ¨'playing around' with TokuDB

was

...

my primary motivation for all this)

As far as I can see, tokudb is present in MariaDB-10.0.15-opensuse13_1-x86_64-server.rpm.

Did you install the plugin?

INSTALL SONAME 'ha_tokudb'

Regards, Sergei

If TokuDB has no dependencies, that the server does not have, why is it then not available on Windows? If it is, then Windows should be listed on same page. -- Peter On Wed, Nov 26, 2014 at 1:30 PM, Sergei Golubchik wrote:

Hi, Peter!

On Nov 26, Peter Laursen wrote:

...

NO.. I thought it would bea separate RPM (Like the OQGraph). I will check when I get time. it coudl take a day or two now. Sorry for false alarm.

As a general rule we put in separage packages plugins that require additional dependencies. OQGraph requires libJudy, so if one doesn't use OQGraph, she shouldn't be required to install libJudy. CONNECT needs odbc, xml, etc. TokuDB doesn't bring in extra dependencies, so it's included into the server package.

...

ButSuSE should be listed here

https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-t...

...

then, right?

Added, thanks.

Regards, Sergei

OK .. but did the TokuDB guys ever try to figure out why? It could be a good idea to do. Because if it fails with Visual Studio, it may fail with other compilers as well. GCC is only one compiler and not the most standards-compliant as far as I understand. -- Peter On Wed, Nov 26, 2014 at 4:02 PM, Sergei Golubchik wrote:

Hi, Peter!

On Nov 26, Peter Laursen wrote:

...

If TokuDB has no dependencies, that the server does not have, why is it then not available on Windows? If it is, then Windows should be listed on same page.

It doesn't compile on Windows, as far as I understand.

Regards, Sergei

Was there some fixes to the repo? Something has improved, I think! I can now install as a GUI user would (adding the repo to Yast's GUI interface for 'software repositories' and next search the packages with Yast 'Software Management' GUI). Conflicts with native SuSE MariaDB 10.0.13 packages are now detected and resolved. Some imperfections still though: * I needed to restart the OS in order to start the server. Only after that it appears in the 'Service management' GUI (and server can be managed from there now) * Packages are still not listed by "rpm -qa" command * I could only use commandline clients as root. Only mysql:mysql had privileges to access them. Fixed by adding read privilege for all users. But most important TokuDB plugin does not load. This may because this is SuSE 12.3 (that may ship with another C-runtime etc. than what 12.1 and 12.2 did). INSTALL SONAME 'ha_tokudb'; -- Error Code: 1123 -- Can't initialize function 'TokuDB'; Plugin initialization function failed. If I add INSTALL SONAME .. to configuration the server will not start. BTW: I also had some communication on Fedora's mailinglist. They have MariaDB 10.0.14 in Fedora 21 repos. But without TokuDB. They cannot build it. They have reported to MariaDB (they say). -Peter On Wed, Nov 26, 2014 at 4:43 PM, Peter Laursen wrote:

One more thing I thought of.

I wrote ""Updating the file /etc/zypp/repos.d/ manually may work,but .. ". If SuSE runs on btrfs file system (what is default from 12.3 - and it works like a charm for me), I believe a file system snapshot will not be created if you edit the file as you describe it. Using zypper command or YaST GUI will generate a snapshot and you can revert to it with the "Snapper" application.

- Peter

On Wed, Nov 26, 2014 at 4:36 PM, Peter Laursen wrote:

...

OK .. but did the TokuDB guys ever try to figure out why?

It could be a good idea to do. Because if it fails with Visual Studio, it may fail with other compilers as well. GCC is only one compiler and not the most standards-compliant as far as I understand.

-- Peter

On Wed, Nov 26, 2014 at 4:02 PM, Sergei Golubchik wrote:

...

Hi, Peter!

On Nov 26, Peter Laursen wrote:

...

If TokuDB has no dependencies, that the server does not have, why is it then not available on Windows? If it is, then Windows should be listed on same page.

It doesn't compile on Windows, as far as I understand.

Regards, Sergei

It seems they are not yet in the RPMs of the MariaDB repo for OpenSuSE. At least they were not 5-6 hours ago. But I am not in a hurry. -- Peter On Tue, Dec 9, 2014 at 2:41 PM, Sergei Golubchik wrote:

Hi, Peter!

On Dec 09, Peter Laursen wrote:

...

But most important TokuDB plugin does not load. This may because this is SuSE 12.3 (that may ship with another C-runtime etc. than what 12.1 and 12.2 did). INSTALL SONAME 'ha_tokudb'; -- Error Code: 1123 -- Can't initialize function 'TokuDB'; Plugin initialization function failed.

See the error log, it might contain more specific error messages. One probable reason could be transparent_hugepage enabled on your computer.

...

BTW: I also had some communication on Fedora's mailinglist. They have MariaDB 10.0.14 in Fedora 21 repos. But without TokuDB. They cannot build it. They have reported to MariaDB (they say).

Yes, there were issues with TokuDB and gcc 4.9 (MDEV-6446, MDEV-6449), but they were fixed.

And there was binutils bug in Fedora (it resulted in crashes when compiling TokuDB): https://bugzilla.redhat.com/show_bug.cgi?id=1149660 As far as I understand, it's also fixed by now.

Regards, Sergei

On 12/9/2014 11:01 AM, Peter Laursen wrote:

The page https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-t...

.. should have added for SuSE "YAST2 -> Bootloader -> Kernel Parameters. Add transparent_hugepage=never to Optional Kernel Command Line Parameter at the end, like after "showopts" and press OK. And you're done. It'll take effect on the next reboot."

(according to the reply I had here https://forums.opensuse.org/showthread.php/503373-How-to-disable-Transparent... - I have not tried yet myself).

It already says: "To disable them, pass "transparent_hugepage=never" to the kernel in your bootloader (grub, lilo, etc.)." You should know how to control your bootloader. Brian

@Brian .. your reply is just *noise*. It is complete irrelevant for all the people following this maililng list what you think, I should know. But it is not irrelevant to point to a docs/wiki page that needs an update, as I did. -- Peter On Tue, Dec 9, 2014 at 5:17 PM, Ian Gilfillan wrote:

Thanks Peter, I've added this to the page.

On 12/09/2014 06:01 PM, Peter Laursen wrote:

The page https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-t...

.. should have added for SuSE "YAST2 -> Bootloader -> Kernel Parameters. Add transparent_hugepage=never to Optional Kernel Command Line Parameter at the end, like after "showopts" and press OK. And you're done. It'll take effect on the next reboot."

_______________________________________________ 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

On 12/9/2014 1:00 PM, Peter Laursen wrote:

@Brian .. your reply is just *noise*. It is complete irrelevant for all the people following this maililng list what you think, I should know. But it is not irrelevant to point to a docs/wiki page that needs an update, as I did.

-- Peter

So duplicating the info on the same page is grounds for an attack on me? Using your logic, I must go list every single possible combination of bootloaders and every OS version that is out there so no one else can complain. Should I include a tutorial on how to turn on your system? That's not written either. I'm done with this thread.

Am 09.12.2014 um 20:25 schrieb Peter Laursen:

Since the page already had specific instructions for Fedara etc., I think it should also have for SuSE.

I did not attack you. I just asked you not to spam the mailling list with comments to me personnally. You could have replied to me only. You have proved that you think that you know a lot about what other people should know. And you have also proved that you don't know how to behave on a mailing list

and you know? you decide what is noise and what not? who do *you* think you are?

I noticed in https://downloads.mariadb.org/mariadb/repositories/#mirror=ulakbim&version=10.0&distro_release=opensuse13-amd64&distro=openSUSE "After the installation finishes, start MariaDB with: sudo service mysql start" "service" is not installed on SuSE as default and even not available from SuSE repos. You have to copy it from a Redhat/Fedora system if you want it. Refer https://www.novell.com/coolsolutions/trench/15089.html (or use the 'Service Management' control from YaST GUI). -- Peter On Tue, Dec 9, 2014 at 5:17 PM, Ian Gilfillan wrote:

Thanks Peter, I've added this to the page.

On 12/09/2014 06:01 PM, Peter Laursen wrote:

The page https://mariadb.com/kb/en/mariadb/documentation/storage-engines/tokudb/how-t...

.. should have added for SuSE "YAST2 -> Bootloader -> Kernel Parameters. Add transparent_hugepage=never to Optional Kernel Command Line Parameter at the end, like after "showopts" and press OK. And you're done. It'll take effect on the next reboot."

_______________________________________________ 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! On Nov 26, Peter Laursen wrote:

OK .. but did the TokuDB guys ever try to figure out why?

It could be a good idea to do. Because if it fails with Visual Studio, it may fail with other compilers as well. GCC is only one compiler and not the most standards-compliant as far as I understand.

This is something that TokuDB developers need to do. They apparently don't build on Windows yet. If upstream will support Windows, we will most certainly include TokuDB in our Windows packages. May be if you'd ask them... :) Regards, Sergei

-- Peter

On Wed, Nov 26, 2014 at 4:02 PM, Sergei Golubchik wrote:

...

On Nov 26, Peter Laursen wrote:

...

If TokuDB has no dependencies, that the server does not have, why is it then not available on Windows? If it is, then Windows should be listed on same page.

It doesn't compile on Windows, as far as I understand.