MySQL Shell, opening session in a wrong way

This topic is about general usage for MySQL Shell and X-Plugin. The most important thing, i think we should keep in mind that, the X-Plugin will listen not MySQL’s port, but it’s own 33060 port as shown from log: 2016-07-15T07:21:09.454761Z 200 [Note] Plugin mysqlx reported: ‘X plugin tcp connection enable at port 33060.’ 2016-07-15T07:21:09.454959Z 200… Read More » cannot open shared object file with MariaDB Galera

After getting some errors: 160707 13:23:05 [Note] /home/sh/mariadb-galera-10.0.26-linux-x86_64/bin/mysqld (mysqld 10.0.26-MariaDB-wsrep) starting as process 3132 … 160707 13:23:05 [Note] WSREP: Read nil XID from storage engines, skipping position init 160707 13:23:05 [Note] WSREP: wsrep_load(): loading provider library ‘/home/sh/mariadb-galera-10.0.26-linux-x86_64/lib/’ 160707 13:23:05 [ERROR] WSREP: wsrep_load(): dlopen(): cannot open shared object file: No such file or directory 160707… Read More »

Azerbaijan MySQL User Group in EMEA User Group Leaders summit

I would like to share my trip to Romania/Bucharest for User Group Leaders summit. It was really great meeting. Great people, talks, discussions, food and etc. I want to create same atmosphere in Azerbaijan/Baku next year 😛 Here are some of the photos:

MySQL Document Store versus Bug hunter

Oh, there is a cool new feature added? And you are going to implement and use it? Well, the brain of Bug lover is not working in that way, for me new feature is cool in terms of playing. It is a new place where hunt season is opened suddenly 😀 Currently I am in… Read More »

Interesting actions on MySQL’s storage engines :)

Did you ever think about altering MyISAM table to use Innodb tablespace? Well that’s weird but you can run those alter statement without any error: Sample table: mysql> show create table sbtest1; | sbtest1 | CREATE TABLE `sbtest1` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `k` int(10) unsigned NOT NULL DEFAULT ‘0’, `c` char(120) NOT… Read More »

Table rebuild with alter compression=’none’

As doc states: To disable page compression, set COMPRESSION=None using ALTER TABLE. Writes to the tablespace that occur after setting COMPRESSION=None no longer use page compression. To uncompress existing pages, you must rebuild the table using OPTIMIZE TABLE after setting COMPRESSION=None. ALTER TABLE t1 COMPRESSION=”None”; OPTIMZE TABLE t1; With regular table there is no… Read More »

Azerbaijan MUG 11 March 2016 meetup with IT girls

Azerbaijan MySQL User Group next meeting was with IT girls from “WoWoman” division in Baku. We have talked about Linux and MySQL. There was a hands-on lab about installing Ubuntu, working with basic Linux commands. I would like to share some photos from this event 🙂

How to get rid of orphaned tables in MySQL?

This post is about situation where comments in BUG reports are really valuable in term of learning and getting some internal view of going process. Let’s take a look at -> The report is about how you can not drop general tablespace if it was a crash of MySQL instant while running alter statement.… Read More »

Azerbaijan MUG 27 FEB 2016 meetup

Great to have some meetups locally, to spread MySQL love among people. On 27 FEB 2016 we have some talk about MySQL backup and recovery, available tools, what we are doing to secure our data and etc. There were too much Oracle DB users where we have interesting discussions. How features are differ, how MySQL… Read More »