Help MariaDB gather some statistics!

MariaDB logoI was browsing around the Internet (don’t remember what for) and I accidentally found one cool aspect of MariaDB. There is a feedback plugin and this short post is meant to encourage you to use it!

Ok, so what it does and why should you opt-in to be spied on :-) It takes some information about your MariaDB server including it’s usage and it will send it to the MariaDB folks. It doesn’t send private data from your database. It sends stuff like what OS are you running, what version of various plugins, how did you tweaked the default settings and also how big and how busy is your server. Now a short list of why I turned this on:

  • Why not? Doesn’t cost me anything, nothing from the data I send is secret.
  • When I develop an application, I’m always happy when somebody uses it. This is an easy way how to tell developers, that they have here one happy user :-)
  • Easy way to contribute. It’s really simple to turn it on, it will help MariaDB folks make better database and doesn’t require much effort from my side.
  • Selfish reason – if they see that plenty of people use MariaDB the same way I do, they will focus more on my use case :-)

But all these data are not only available to them, they are also making some nice graphs out of it. That way, I can find out that there is at least another 27 guys running latest 10.0.10. Also I found out that there is not many reports from openSUSE folks. And that is one of the reasons to write this blog. If you are running MariaDB on openSUSE, please turn feedback plugin on to show that we have plenty of people using MariaDB :-)

How can you turn it on? Simple, login to your database and activate the plugin using following command:

INSTALL PLUGIN feedback SONAME 'feedback';

Now just wait till your reports will show up in statistics. If I got you interested, you can read more about the plugin on MariDB website (it can report to any url, not only MariaDB one, you can use it for monitoring). While waiting, browsing already collected statistics is also interesting 😉


My Jolla applications

One of the things, that I really like about Jolla is the technology to write applications. C++ is my favorite programing language and I always admired Qt. At least big parts of it. So when I got my Jolla, I started playing with SDK and writing some simple applications. It was kinda harder than I expected, but I’ll write about there in separate blog post. This one is dedicated to the applications I wrote and to show what do they do. And if you have a Jolla, maybe get you interested in those 😉 Both of them are available via OpenRepos and Harbour.

Hunger Meter

This was the first application I wrote. I was wondering how power hungry are various applications. On Android I used to have CPU usage monitor and I know that surprisingly many applications take advantage of CPU to the full extend which affects a battery life. Since I was writing the application I decided not to go for CPU usage but directly for what I was interested in – battery usage. First version was really simple, it just showed two numbers – current consumption and average (over ten seconds) one. But that already helped me to find out, that if you want to drain your battery fast, use Angry Birds :-)

I haven’t stopped developing after first version and continued extending functionality. Currently time intervals are configurable, it displays semi-nice graph for the longer interval, displays some basic information about battery and collects long time (day and more) statistics. These are not plotted yet, that is part of my TODO.

If you are interested, you can get this application from OpenRepos where is the last development version or from Harbour where is the last stable version (one that was successfully tested in OpenRepos). Sources are available on GitHub and here are few screenshots :-)

HungerMeter - CoverHungerMeter - Settings

HungerMeter - GraphHungerMeter - Battery


My second application is also simple. It’s top-like application. Shows processes, how much memory (RSS) and CPU they use, allows you to sort them, filter for GUI applications only and most importantly – allows you to kill processes you don’t like. Not much more to write about in regards to this. Just a set of links to OpenRepos and GitHub and few screenshots.

CrestCrest - kill

End note

I wrote some applications when I was using Palm OS. When I switched to Android, I never forced myself to cope with Java thingy. Although there are some nuisances in developing for Sailfish OS (more about them next time), I’m happily developing applications for my PDA/CellPhone again :-) So if you have Jolla and like my ideas for applications, try them. You can report bugs/feature requests via issues page on GitHub, maybe I’ll respond. If you submit the patch, chances that I’ll respond are much higher :-)


Cool Live flash GSoC idea

openSUSE Flash drive

openSUSE Flash drive

I have this idea nagging me for a while about how to make our ambassadors live (and mine) easier. From time to time you need a flash drive with Live version of our favorite openSUSE to show it to people. Currently it is really simple to create one using dd. But once you do it, you cannot use flash drive for “normal” purposes. People somehow doesn’t appreciate flash drive that doesn’t contain vfat. So this project is about redoing openSUSE flash drive to make it way cooler and more usable.

There are two projects out there that inspired me (or that I want to copy). It’s Slax live distribution and SystemRescueCD. Both are great and I would like to pinpoint some of the goals that project should reach.

First of all, whole flash drive should contain vfat or ntfs or some commonly supported dumb filesystem. Nothing fancy. And everything should be just a file on that flash drive. If you need to transfer quite some data, you simple delete few directories, use flash drive as a storage and then copy those directories back.

Other feature that should be implemented is to make it easily possible for flash drive to contain multiple flavors of distribution at the same time. So during the boot, you will be able to select whether you want to show Gnome or KDE. Adding new flavor should be easy – copying files with new flavor to the flash drive. Same to get rid of it – just delete Gnome flavor files and Gnome version is gone from flash drive. This is what Slax manages to do really well, although they try to combine everything into one distribution. I wouldn’t go that deep in regards to modularity for this project, but selecting which live version do you want to boot sounds like a good idea. It should be also possible to decide whether changes you make while running this Live distribution are stored permanently or lost after reboot.

Now how to make it cool for Ambassadors? I think we are not rich enough to give everybody his flash drive during conference. There are two options that I would like to see integrated in this flash drive project. First, it should be possible to boot from flash drive and load everything into memory. So people can come to the booth, use flash drive to boot openSUSE, leave and play with it till reboot and we can reuse the flash drive to boot another computer. Other cool option to have would be to make it possible to to distribute this Live version over PXE, so we can have just a few ethernet cables on our booth where people can connect to boot openSUSE.

Personally I would love to have something like this. And few students already shown some interest in this idea, so it might even happen. If you just decided to apply as well, feel free to submit your proposal to the melange and I have a simple homework for you (can be sent during reviewing process). My friend tried to run Live KDE over PXE few weeks ago and run into trouble that NetworkManager was messing up with network and thus his NFS root was having some serious troubles. Your homework is to solve this issue :-) Take an initrd from openSUSE 13.1 Live KDE and modify it so when you are booting vith NFS root, it will disable NetworkManager. Send me the result (either description or initrd or both) and the best solution (from maintainability and robustness point of view) wins.


Importing SMS from Android to Jolla

This is just a little note related to my last blog about Jolla. I wrote that I’m pretty fine with messaging application although I don’t have many SMS yet in my phone. Well, I fixed that :-) I imported all my SMS messages from the backup of my Andriod phone.

I searched around and I found really interesting thread on talk.maemo.org that describes how to import SMS from n900. As they are doing it via csv, it was easy to put together a simple one-liner that would produce the csv from my SMS database. Now how to do it…

My database used to be at /data/data/com.android.providers.telephony/databases/mmssms.db. You can get it from your phone to your PC for example with

adb pull \

Now download the script and get your csv

curl http://susepaste.org/view/raw/49179811 > sms_export
sh ./sms_export mmssms.db > sms.csv

What is left is to fix all the extra newlines in SMS. But without fixing them, the import program just imports messages without newlines which was good enough for me as most people don’t use new lines in SMS.

Now time to play with Jolla and that part is simple thanks to Merlin1991 who wrote importer application. I will assume that your are sshed on your Jolla and and you copied your csv file over to the current directory. Now what is left on device is following:

curl http://cdnm.at/~christian/Harmattan-SMS-Boat/jollaImport \
   > jollaImport
chmod a+rx jollaImport
./jollaImport -s sms.csv

And SMSes are transfered from Android to Jolla :-) Many thanks to Merlin1991.


Communicating with Jolla

On Monday I wrote about my new amazing cellphone – Jolla – and one of the comments/complains I got was that I haven’t said anything about how you actually use the phone to communicate. Well, I don’t use cellphone to make calls or send SMS most of the time, but since I was asked about it and I already have phone for almost two weeks, I gathered few SMS and calls. So today it will be about communicating using Jolla :-)


Contacts are synced from the accounts you entered in settings. Supported so far are Google, Facebook and XMPP. No CardDAV yet. Disadvantage I encountered so far is that all of them are synced. What is wrong with that? Well, I added one of my jabber accounts… So now I have in people application several bots and transports. I also have all the people that I for whatever reason added on G+. In the end, my contact list is almost total mess. And to make it harder, there are no groups and UI is done in a way that you have to pick a letter from the first name (you cannot select to sort them according to the surname) and it will show you contacts only afterwards. What saves this application from being unusable is that you can search for people and favorite them. Then you will have them on top as small pictures.

Application also shows people you recently communicated with, which is actually really useful and it is how I use contact lists everywhere. Even on desktop, I don’t have a fixed contact list, I just have mail addresses of people I communicated with in last month and pick recipients from that. It’s good enough approximation. As for Jolla, I’m currently stuck with this workflow. Not that I mind much, but it’s a shame that application managing your contacts is quite unfriendly at the first sight.

Calendar e-mail


Calendar application is pretty simple with only month view and showing events for selected day. Synchronization is supported only for Google calendar so far and only one way. You can create your events online and they will get synced to your phone, but edits in your phone will not get back. At least till next OS update. Support for syncing with own CalDAV is not implemented yet.


Phone application will take you to the list of last calls (made/missed/received). Unfortunately every person is there just once. So if you missed a call and returned it later, you’ll find there only the most recent event – you making a call. Not a really big deal, but having a full call history would be nice. If you try to call somebody, you’ll end up in people application I spoke about before. I’m not a big fan of that one. What I really like is answering phone. Pull down to answer, push up to cancel. What is unfortunate though is that to end call, you have to press a button on screen, not use gesture as for answering :-(

Calls messages e-mail


The important part about messages is that on Jolla your messages get mixed up together, similarly as contacts does (but this time it’s not that bad). You have one messaging application and that one stores both SMS and IM messages. It tells you which one is which, but tries not to make a distinction between them so obvious. As for IM, it’s deeply integrated. In notifications, you set your global presence and from that moment, you’ll start getting messages via XMPP. As for starting conversation, you would have to go to the people app and find your bot you want to message according to his name (I have bots in separate group on jabber, but as people application doesn’t handle groups…). In general, I think, messaging application is quite usable, except for the part when you have to interact with people application. Sometimes I would appreciate classic IM client with roster and groups and not mixing my jabber with my people by default (nice to have when I choose to, but sometimes I prefer to have them separated).


This is the functionality I use probably the most on cellphone. Keeping up with my mailboxes. Jolla has a nice mail application to do that. At least I consider it nice. I was using K-9 on Android and found it a little bit confusing. On the other hand, it could do many things Jollas mail client can’t do yet. I have multiple e-mail accounts configured on my phone. First screen I enter when I open the application is some kind of unified inbox. All unread mails from all accounts at one place. Realy useful. And it also shows all my e-mail accounts. Whenever I tap on account, it opens full inbox (including read mails) for that particular account. What is still missing though is notifications for subfolders (only inbox gets synchronized automatically) and no support for flagging e-mails. Also there is no threading support yet. But I can live without threading especially as I have e-mail conferences filtered into subfolders and thus not directly at tips of my fingers, but few gestures away, which is too far to bother 😀

Overall, Jolla phone capabilities are good enough for me, but might not be the case for you. Especially if you still use your phone mainly for making calls and have quite some people. The weakest point I see is the people application. But as things are getting fixed and people are developing like crazy, I hope we will get fixes for issues that I mentioned here soon or somebody will implement alternative people application :-) This time, it doesn’t sound so positive overall, but I still like my phone and as making calls is not a use case I’m most concerned about in my cell phone, I have no problem waiting for Jolla to polish this part.

Older posts «

» Newer posts