Re: [Maria-discuss] MariaDB-10.2.11 Long Time To Start

2018-01-08 Thread Marko Mäkelä
Michael, Sorry, I now realize that you must likely have used a stripped executable, and therefore the symbols for the InnoDB functions are missing (displayed as ?? in the stack trace output from gdb). As far as I understand, gdb should be able to resolve the symbols if you install the separate deb

[Maria-discuss] Submitting talks for Percona Live Santa Clara?

2018-01-08 Thread Colin Charles
Hi all, As part of the program committee, I’m writing in to say we’ve seen only a handful of talks mention MariaDB Server out of the several hundred submissions so far. With all the amazing use cases of MariaDB Server out there, I would expect a lot more. The CFP ends January 12 2018, so please

[Maria-discuss] Problem with bit operations in certain expressions

2018-01-08 Thread Mats Eklund
Hi, Need some help here. I have the following expression: SELECT IF(1=1, 0x2, 0x4) | 0x1 which in MySQL evaluates to: 3 but in MariaDB it evaluates to: 1 MySQL's result seems correct to me. Would appreciate any advice on this. Many thanks! Mats ___

Re: [Maria-discuss] MariaDB-10.2.11 Long Time To Start

2018-01-08 Thread Michael Caplan
Here you go! Thanks, Mike On 2018-01-08 12:38 PM, Marko Mäkelä wrote: Hi Michael, OK, all the interesting functions (InnoDB functions) are displayed as ??. In the "perf top" it would have helped to drill into the mysqld executable, and only show its top functions. Apparently a lot of pages

Re: [Maria-discuss] MariaDB-10.2.11 Long Time To Start

2018-01-08 Thread Marko Mäkelä
Hi Michael, OK, all the interesting functions (InnoDB functions) are displayed as ??. In the "perf top" it would have helped to drill into the mysqld executable, and only show its top functions. Apparently a lot of pages are being read; that is all that I can tell from the screenshots. Can you t

Re: [Maria-discuss] MariaDB-10.2.11 Long Time To Start

2018-01-08 Thread Michael Caplan
Hi Marko, I can reproduce this reliably with every start up. Poor man's profiler output: 84    ../sysdeps/unix/syscall-template.S: No such file or directory. 10 ??,??,??,??,??,??,start_thread,clone   5 at,??,??,start_thread,clone   1 pread64,??,??,??,??,??,??,??,??,??,??,??,ha_ini

Re: [Maria-discuss] MariaDB-10.2.11 Long Time To Start

2018-01-08 Thread Marko Mäkelä
Hi Michael, > 2018-01-07 9:38:18 139980432365760 [Note] InnoDB: Highest supported file > format is Barracuda. > 2018-01-07 10:11:48 139980432365760 [Note] InnoDB: 128 out of 128 rollback > segments are active. > This is really unacceptable behaviour. It looks like you have encountered https://jir

Re: [Maria-discuss] mariadb-connector-c mariadb_config: Faulty output with static gssapi plugin

2018-01-08 Thread Stefan Scherfke
> Am 2018-01-08 um 14:02 schrieb Sergei Golubchik : > > Hi, Stefan! > > Thanks! Reported as https://jira.mariadb.org/browse/CONC-303 > and fixed at once This is my favourite reaction to issues in OSS. Thank you very, very much! :-) Stefan > > On Jan 05, Stefan Scherfke wrote: >> Hi all, >>

Re: [Maria-discuss] MariaDB-10.2.11 Long Time To Start

2018-01-08 Thread Michael Caplan
Actually, Was just reviewing the startup time for MySQL 5.6.  I'm at 5 minutes there, not 10.  Both these physical machines are running the same hardware, with the exception of the new slave having 64GB RAM (32GB on the master).  Master is running Ubuntu Precise, slave Ubuntu Xenial. Anyone

[Maria-discuss] MariaDB-10.2.11 Long Time To Start

2018-01-08 Thread Michael Caplan
Hi, I'm setting up a replication slave based off of MySQL 5.6.  There are a large number of tables (400K).  The MySQL 5.6 master takes around 10 minutes to start up, where the new MariaDB 10.2 slave takes close to 30 minutes.  What is making the startup take soo long? In the below mysql log,

Re: [Maria-discuss] mariadb-connector-c mariadb_config: Faulty output with static gssapi plugin

2018-01-08 Thread Sergei Golubchik
Hi, Stefan! Thanks! Reported as https://jira.mariadb.org/browse/CONC-303 and fixed at once On Jan 05, Stefan Scherfke wrote: > Hi all, > > the output of "mariadb_config --libs[_r]" is faulty if the AUTH_GSSAPI > plugin is configured as static: > > I built mariadb-connector-c 3.0.2 on Fedora 26