Re: [Maria-discuss] 5.5.38: compiler warnings

2014-08-05 Thread Sergei Golubchik
Hi, Reindl! On Jul 25, Reindl Harald wrote: maybe worth a look /mariadb-5.5.38/strings/decimal.c:2139:55: warning: array subscript is below array bounds [-Warray-bounds] /mariadb-5.5.38/strings/decimal.c:2139:59: warning: array subscript is below array bounds [-Warray-bounds]

Re: [Maria-discuss] Aria engine

2014-07-22 Thread Sergei Golubchik
Hi, Roberto! On Jul 21, Roberto Spadim wrote: Sergei :) how much time to a engine become production ready? could we/I increase aria test? There is no formal policy for this. Aria was changed to gamma just recently, in a few months it can be promoted to stable (presuming the bug inflow won't

Re: [Maria-discuss] Aria engine

2014-07-21 Thread Sergei Golubchik
Hi, Roberto! On Jul 17, Roberto Spadim wrote: Hi guys Why aria engine is a beta/alpha engine? A plugin must be beta for some time and then depending on the bug inflow, on the usage, code stability, etc, it's promoted to gamma and then to stable. Aria engine is used less that XtraDB or MyISAM,

Re: [Maria-discuss] Lost connection to MySQL server at, 'reading authorization packet', system error: 104 (or 0)

2014-06-19 Thread Sergei Golubchik
Hi, Tanstaafl! On Jun 18, Tanstaafl wrote: Hi all, I'm very inexperienced mariadb/mysql/sql user/admin, but not totally clueless, been maintaining a tiny mysql DB for postfixadmin for years, then converted it to mariadb. We recently started using SOGo (groupware). I hired the SOGo guys

Re: [Maria-discuss] Building MariaDB audit plugin for Percona 5.5.37-rel35

2014-06-16 Thread Sergei Golubchik
Hi, Nick! On Jun 16, Nick Urbanik wrote: Dear Folks, The documentation at says, The MariaDB Audit Plugin works for MariaDB, MySQL and Percona Server. So: 1. Which version of the MariaDB audit plugin should I use for Percona 5.5.37-rel35? Any one, the latest should be preferrable,

Re: [Maria-discuss] How to download source code of MariaDB audit plugin only?

2014-06-16 Thread Sergei Golubchik
Hi, Nick! On Jun 16, Nick Urbanik wrote: Dear Folks, I am attempting to download the source code of the audit plugin only, which I want to use with Percona 5.5.37-rel35. I am still waiting for bzr to finish downloading the entire MariaDB source. Can you point me to how to download the

Re: [Maria-discuss] ncurses and mysql

2014-06-11 Thread Sergei Golubchik
Hi, Roberto! On Jun 10, Roberto Spadim wrote: Hi guys, i'm running slackware 14.1, i upgrade to slackware-current, and downloaded the mariadb-10.0.11 x64 with glibc 2.19 the point is... whern i run mysql, it requires a 'deprecated' library, libtinfo.so.5, this one was replaced by

Re: [Maria-discuss] PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12)

2014-06-03 Thread Sergei Golubchik
Hi, Roberto! On Jun 03, Roberto Spadim wrote: i only use it at development, at production it's not used And what performance-schema related options do you have in your development my.cnf file? Is it only performance-schema=1 or something more involved? Recently there was chat about how

Re: [Maria-discuss] PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12)

2014-06-03 Thread Sergei Golubchik
Hi, Pavel! On Jun 03, Pavel Ivanov wrote: I personally would prefer if MariaDB had performance schema not compiled in by default. Then we wouldn't be frustrated every time we upgrade and find out that the tarball doesn't compile without performance schema (yes, 10.0.11 doesn't compile). This

Re: [Maria-discuss] EXPLAIN and CONNECT

2014-05-26 Thread Sergei Golubchik
Hi, Federico! On May 12, Federico Razzoli wrote: Hi Sergej, Thank you for this update. I'm still curious: does CONNECT read the rows several times? If so, is there a way to avoid this until the bug is solved? I suppose you've seen the answer in the bug report. But just for the sake of

Re: [Maria-discuss] EXPLAIN and CONNECT

2014-05-26 Thread Sergei Golubchik
Hi, Roberto! On May 26, Roberto Spadim wrote: maybe include at extra estimative rows count just to understand what happened Row count in the EXPLAIN output is *always* an estimation, there is no need to specify it explicitly because it is always the case. I suppose you've seen the answer in

Re: [Maria-discuss] Role template

2014-05-22 Thread Sergei Golubchik
Hi, Jimmy! On May 18, Jimmy Thrasibule wrote: Hi, Roles have been introduced with MariaDB 10.0.5. This feature is very interesting to group and standardize grants in one place. However roles are static, meaning that it is not possible to create a template to apply later on another

Re: [Maria-discuss] EXPLAIN and CONNECT

2014-05-12 Thread Sergei Golubchik
Hi, Federico! On Mar 27, Federico Razzoli wrote: Hi Sergei You can repeat this very easily: MariaDB [test] CREATE TABLE t_connect (c INT PRIMARY KEY) ENGINE=CONNECT TABLE_TYPE=CSV; Query OK, 0 rows affected, 1 warning (0.11 sec) Warning (Code 1105): No file name. Table will use

Re: [Maria-discuss] Heartbleed (OpenSSL) -bug and MariaDB

2014-04-10 Thread Sergei Golubchik
Hi, Peter! On Apr 09, Peter Laursen wrote: I think at least on Windows OpenSSL is statically linked? If so, all available versions have an afftected OpenSLL inside. In Windows builds we use YaSSL. So far I haven't heard that YaSSL is affected by this issue, I believe that it is not. Regards,

Re: [Maria-discuss] bugs in the testsuite

2014-03-30 Thread Sergei Golubchik
Hi, Reindl! On Mar 05, Reindl Harald wrote: hi, i see the errors below for a longer time and thought i should mention them - in case of running the test-suite completly alone i would not expect that /usr/bin/su -c 'cd /usr/share/mysql-test; ./mysql-test-run.pl --default-myisam --parallel=1

Re: [Maria-discuss] Index bug in aria engine?

2014-03-06 Thread Sergei Golubchik
Hi, pslawek83! On Feb 17, pslawek83 wrote: Hi Guys, any comments on this issue? It seems that partial unique indexes can't be used in joins. https://mariadb.atlassian.net/browse/MDEV-5663 Please, show EXPLAIN EXTENDED (and SHOW WARNINGS after it) for this query of yours. * Why the server

Re: [Maria-discuss] Index bug in aria engine?

2014-03-06 Thread Sergei Golubchik
Hi, Roberto! On Mar 06, Roberto Spadim wrote: Hello! Only btree, no hash indexes? Aria? Yes. b-tree and r-tree, no hash indexes. Aria only supports BTREE indexes anyway. Regards, Sergei ___ Mailing list: https://launchpad.net/~maria-discuss Post

Re: [Maria-discuss] MySQL 5.6 optimizer trace functionality in MariaDB 10?

2014-02-17 Thread Sergei Golubchik
Hi, Tim! On Feb 14, Tim Callaghan wrote: Is this feature or something similar already in MariaDB 10? If not, is it on the roadmap? http://dev.mysql.com/doc/internals/en/optimizer-tracing.html No, it is not in MariaDB 10.0. We've considered it, but other features, most requested by our

Re: [Maria-discuss] Very slow insert with load data infile

2014-02-12 Thread Sergei Golubchik
Hi, Pierre! Okay, there were quite a few replies already here. I'll chime in, but only to confirm that there's no easy solution, unfortunately :( On Feb 10, Pierre wrote: Hello, Mariadb is getting slower and slower when I'm inserting a massive amout of data. I'm trying to insert 166 507 066

Re: [Maria-discuss] Codership's Galera patch part of standard MariaDB

2014-02-12 Thread Sergei Golubchik
Hi, Honza! On Feb 11, Honza Horak wrote: Hi guys, my Google-foo is poor today and I can't find any discussion about inclusion of Codership's Galera patch to standard code-source of MariaDB. I'd like to see that one could just use the wresp plugin and have a working Galera cluster (even

Re: [Maria-discuss] Very slow insert with load data infile

2014-02-12 Thread Sergei Golubchik
Hi, Sergey! On Feb 12, Sergey Vojtovich wrote: This is used when you insert data into the empty table. Or when you add an index to the existing table. Or when you enable indexes. That is: 1. LOAD DATA INFILE 'everything, not in chunks' (a convenient way would be to load from a

Re: [Maria-discuss] why are ipv6 tests not simply skipped?

2014-02-11 Thread Sergei Golubchik
Hi, Reindl! On Feb 11, Reindl Harald wrote: these tests should be skipped in case the machine has no ipv6 config instead fired up and failing I think it depends on ho exactly your machine has no ipv6 config. When I added a check for missing ipv6, my box had no ipv6 at all, not compiled into

Re: [Maria-discuss] xtradb in 10.0

2014-02-10 Thread Sergei Golubchik
Hi, Laurynas! On Feb 10, Laurynas Biveinis wrote: Sergei - XtraDB simply does not compile on all our builders - Percona has introduced patches that use CPU atomic ops and didn't implement a fallback for setups where they are not available (like all the rest of the code does,

Re: [Maria-discuss] xtradb in 10.0

2014-02-05 Thread Sergei Golubchik
Hi, Federico! On Feb 05, Federico Razzoli wrote: I just read this news from SkySQL: http://www.skysql.com/blogs/chriscalender/mariadb-1007-overview-and-highlights XtraDB storage engine was upgraded to the 5.6 version. Now one can use XtraDB with MariaDB 10.0. Unlike MariaDB 5.5, in 10.0

Re: [Maria-discuss] Statistics/Counters for number SHOW INDEX FROM queries

2014-01-21 Thread Sergei Golubchik
Hi, Markus! On Jan 21, Markus Uckelmann wrote: Hi all, We have a lot of SHOW INDEX FROM queries coming from our ORM layer. Usually there is a mechanism to prevent this but it doesn't seem to work at the moment. To better analyze the problem it would be helpful if we could see how many such

Re: [Maria-discuss] mysqld-wait-ready - Re: start mariadb randomly fails or answers with wrong response to systemd

2014-01-20 Thread Sergei Golubchik
Hi, Reindl! On Jan 20, Reindl Harald wrote: there are no time-consuming operations in-between is not enough in case of systemd and as-soon-as-possible parallel startup Okay, I suppose we can change that and start accepting connections before reporting ready... in fact systemd calls

Re: [Maria-discuss] warning 1292

2013-12-11 Thread Sergei Golubchik
Hi, Federico! On Dec 11, Federico Razzoli wrote: Hi! MySQL 5.6 returns a warning for wrong datatypes, with any SQL_MODE: mysql CREATE TABLE t (c TIMESTAMP) ENGINE=InnoDB; Query OK, 0 rows affected (0,31 sec) mysql SELECT c FROM t WHERE c = 1; Empty set, 1 warning (0,00 sec) Warning

Re: [Maria-discuss] plans for MDL

2013-11-28 Thread Sergei Golubchik
Hi, Mark! On Nov 27, MARK CALLAGHAN wrote: Do you have any plans for MDL in MariaDB 10+ that might do something better for workloads that need to do some DDL concurrent with some long-running SELECT statements? https://www.facebook.com/MySQLatFacebook/posts/10151939557456696 No immediate

Re: [Maria-discuss] Table Change notification to all Clients?

2013-11-19 Thread Sergei Golubchik
Hi, SARTrack! You might want to look at Q4M storage engine, http://q4m.github.io/ perhaps it'll help. Or you can emulate the notification with locks or replication. But directly - no, there are no plans at the moment to implement the notifications like this. Of course, plans might change... On

Re: [Maria-discuss] Parallel build support for v10?

2013-10-24 Thread Sergei Golubchik
Hi, Jen! On Oct 24, jen...@promessage.com wrote: Hi, I build MariaDB v10 from src on linux/64. If, after `cmake` configure I attempt a parallel build, make -j4 VERBOSE=1 I get numerous/sequential build failures. ALL of the related failures vanish if I simple single-thread the

Re: [Maria-discuss] Galera cluster

2013-09-19 Thread Sergei Golubchik
Hi, Roberto! On Sep 19, Roberto Spadim wrote: Hi guys, the galera cluster code is inside default mariadb-10.0.4 code? or there's a different branch for galera cluster? Different branch. There is mariadb-5.5-galera tree. It was merged into 10.0, but as far as I know, the merge is not quite

Re: [Maria-discuss] Benchmark with jemalloc

2013-09-18 Thread Sergei Golubchik
Hi, Roberto! On Sep 18, Roberto Spadim wrote: Hi Sergei! I was reading the patch, in messages inside lauchpad there's a benchmark showing a better performace with version 3.1 of jemalloc, but at mariadb 5.5 we are using 3.3 (if i'm not wrong) I know it's a fresh new release of mariadb, we

Re: [Maria-discuss] Benchmark with jemalloc

2013-09-18 Thread Sergei Golubchik
Hi, Reindl! On Sep 18, Reindl Harald wrote: Anyway, jemalloc is bundled with the mariadb sources and is linked in statically: $ ldd sql/mysqld|grep jemalloc $ grep jemalloc sql/mysqld Binary file sql/mysqld matches oh no - please no static libraries that is a very bad style and

Re: [Maria-discuss] CREATE PROCEDURE clauses

2013-09-03 Thread Sergei Golubchik
Hi, Federico! On Sep 02, Federico Razzoli wrote: Ciao, I wanted to add some info in the CREATE PROCEDURE page in the KB, but I think that some info about CREATE PROCEDURE clauses miss both in the kb and in the MySQL manual. * [NOT] DETERMINISTIC. From MySQL docs: A routine is considered

Re: [Maria-discuss] NoSQL at mysql client

2013-08-17 Thread Sergei Golubchik
Hi, Roberto! On Aug 16, Roberto Spadim wrote: Hi guys, i was reading some time ago about memcache (i use it for a long time ~5years or more) and the handler socket plugin Why we don't implement it at mariadb client? instead of a second library to add nosql, why not implement a built in lib?

Re: [Maria-discuss] [Certification] Oracle MySQL exams horribly outdated. Are there MariaDB exams in planning?

2013-03-26 Thread Sergei Golubchik
Hi, Lukas! On Mar 26, Lukas Lehner wrote: Oracle MySQL exams are horribly outdated. Are there MariaDB exams in planning? None that I've heard of. But there might be MariaDB specific training courses, at least. Regards, Sergei ___ Mailing list:

Re: [Maria-discuss] unexpected index growth

2013-03-11 Thread Sergei Golubchik
Hi, Said! On Mar 06, Said Ramirez wrote: We have noticed a very strange index growth with one of our tables. The data in the table is currently ~ 42GB and has been growing at a rate of about 1 GB per day for the week. Inserts/Updates on the tables are done with statements like: insert

Re: [Maria-discuss] unexpected index growth

2013-03-11 Thread Sergei Golubchik
Hi, Said! On Mar 11, Said Ramirez wrote: Sergei, The longest transaction I currently see is ~ 3.5 hours. Which is a long time, and I can look into to that. I haven't seen transactions last days yet. Would having a transaction last hours not cause the old rows from being purged once those

Re: [Maria-discuss] Contact Form: Ruslan Kutliakhmetov

2012-11-17 Thread Sergei Golubchik
Hi, Ruslan! First, please use email for questions of this kind. We have a mailing list maria-discuss@lists.launchpad.net - it's much easier to follow the discussion there, and many more people will see your question, so you'll have a better chance of getting a fast and helpful reply. On Nov 17,

Re: [Maria-discuss] mDB logs off when there are several ssh under same user

2012-11-15 Thread Sergei Golubchik
Hi, klrumpf! On Nov 15, klrumpf wrote: MariaDB [bodywrappers] show processlist; +--+-+-+--+-+--+---+--+--+ | Id   | User    | Host    | db   | Command | Time | State | Info |

Re: [Maria-discuss] TRUNCATE TABLE becomes hang sometimes

2012-11-10 Thread Sergei Golubchik
Hi, Haseena! On Nov 05, Haseena L. wrote: Hi, Now Iam trying to migrate from MySQL to MariaDB. Why does the TRUNCATE TABLE statement hang sometimes? What are the reasons for this type of issue? This problem doesn't happen with MySQL, only with MariaDB. The hanging statement is simply:

Re: [Maria-discuss] can I expect deb files of mariadb-galera soon?

2012-10-12 Thread Sergei Golubchik
Hi, Jan! On Oct 12, Jan Kirchhoff wrote: Sergei, thanks for the update. Can you post here once you have any further news on this? Better subscribe to https://mariadb.atlassian.net/browse/MDEV-507 (well, not subscribe, in jira it's called watch). And you'll be notified of all updates of this

Re: [Maria-discuss] MariaDB 5.5 compile error

2012-08-07 Thread Sergei Golubchik
Hi, Brian! I've created a ticket for it: https://mariadb.atlassian.net/browse/MDEV-439 Should be fixed in the next release. Thanks! Regards, Sergei On Aug 06, Brian Evans wrote: On 8/6/2012 12:27 PM, Brian Evans wrote: On 8/4/2012 5:56 AM, Sergei Golubchik wrote: Building

Re: [Maria-discuss] MariaDB 5.5 compile error

2012-08-04 Thread Sergei Golubchik
Hi, Brian! On Aug 03, Brian Evans wrote: Hi, I would like some assistance in figuring out a compile error in MariaDB 5.5 series (tested on 5.5.25). I'm trying to create a minimal (client only) build of 5.5.25. This is the cmake configure command used: ... However, if i build the full

Re: [Maria-discuss] Did we drop source for IBMDB2I?

2012-07-28 Thread Sergei Golubchik
Hi, Colin! On Jul 23, Colin Charles wrote: Hi! Reading: http://kb.askmonty.org/en/mariadb-versus-mysql-features/ IBMDB2I. Oracle removed this in MySQL 5.1.55 but we have kept the code in MariaDB until the version 5.5. I'm not so sure. I looked for this engine in a 5.5.25 tarball in

Re: [Maria-discuss] auth_pam does not compile on OSX

2012-01-03 Thread Sergei Golubchik
Hi, Terin! On Dec 20, Terin Stock wrote: The 5.2.10 version of MariaDB is not compiling for me (using homebrew) on OSX. The error and other information, is as follows. I've resolved the issue for now by passing in --without-plugin-auth_pam to configure. libtool: compile:

Re: [Maria-discuss] [Maria-developers] Microseconds support inMariaDB 5.3.

2011-09-21 Thread Sergei Golubchik
Hi, Peter! On Sep 21, Peter Laursen wrote: @Philip .. I have one more question. Can libmysql as distributed by Oracle handle those extended precision DATE(TIME)STAMPs - or will only the one distributed with MariaDB do properly?? It should work just fine. We have not changed the API. Thanks

Re: [Maria-discuss] failed to initialize plugins error

2011-09-10 Thread Sergei Golubchik
Hi, Patrick! On Sep 09, Patrick Galbraith wrote: Hi all! Moin moin, Privet! I have the latest 5.3 compiled as well as a client's own storage engine. The compile, link, all went well. I do notice they only compile their engine statically, but see symbols for it in mysqld: ..

Re: [Maria-discuss] Help with RPM src build

2011-07-20 Thread Sergei Golubchik
Hi, bwellsnc! On Jul 19, bwellsnc wrote: I have gone over every document concerning building mariadb using src rpm. I am trying to build mariadb against RHEL 6. I have run rpmbuild against the src rpm and I get this error everytime: error: configure: error: C compiler cannot create

Re: [Maria-discuss] Help with RPM src build

2011-07-20 Thread Sergei Golubchik
at 9:43 AM, Sergei Golubchik s...@askmonty.org wrote: On Wed, Jul 20, 2011 at 5:58 AM, Sergei Golubchik s...@askmonty.org wrote: On Jul 19, bwellsnc wrote: I have gone over every document concerning building mariadb using src rpm. I am trying to build mariadb against RHEL 6. I have

Re: [Maria-discuss] Does server reads /root/.my.cnf

2011-04-04 Thread Sergei Golubchik
Hi. # less .my.cnf [mysqld_safe] log-error=/var/log/mysql/error.log [mysqld] log-error=/var/log/mysql/error.log Also i have disabled syslog. But after restarting the server no errol.log is created. So does mysqld reads /root/.my.cnf ? Alexandros Run mysqld --help

Re: [Maria-discuss] client library shared library version changed in 5.5.10

2011-03-28 Thread Sergei Golubchik
Hi, Vladislav! The main source of the breakage is migration to CMake: making libmysqlclient.so in 5.5 cmake builds don't use version script, and don't use -Wl,--whole-archive. Yep, version script is likely a factor. Well spotted, thanks! I've run the gcc -shared line manually in 5.5

<    1   2   3   4