- discuss - lists.mariadb.org

[Maria-discuss] MariaDB 10.0.14 now available
by Daniel Bartholomew 26 Sep '14

26 Sep '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.14 This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.14 - Release Notes: https://mariadb.com/kb/en/mariadb-10014-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10014-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.14 About MariaDB 10.0: - https://mariadb.com/kb/en/what-is-mariadb-100/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - Building a Web Application with PHP and MariaDB: A Reference Guide is the latest MariaDB book in Packt's growing MariaDB book series. It guides you through all the steps to get your app up and running. - http://bit.ly/1qrqMQx The recently published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB 5.5 and 10.0. - http://bit.ly/WZs2Pd Another book, Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB. No prior database experience required. - http://bit.ly/MMElbQ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

2 1

[Maria-discuss] MariaDB,TokuDB and FusionIO
by Christophe Le Roux 26 Sep '14

26 Sep '14

Hello, After reading the previous discussion about Fusion IO with Torben Mathiasen contribution, I have some questions. I understand that the nvmfs is developed by FusionIO and is closed source. Can we have this module (I think it's a kernel module , right ?) if we buy a new FusionIO card (Only with Atomic Series?)? Is this module ok with "old" FusionIO card (iodrive2) ? About AtomicWrites and the NVM compression, can these features be added to the TukuDB engine ? Can the TokuDB compression and the NVM compression be working together or if we enable one, we need to disable the other ? Cordialement, http://www.claranet.fr<http://www.claranet.fr/> [Claranet]<http://www.claranet.fr/> [Linkedin]<http://www.linkedin.com/company/claranet> [Twitter]<https://twitter.com/#!/Claranet_FR> [Youtube]<http://www.youtube.com/user/ClaranetFR> [Gartner MQ]<http://www.claranet.fr/propos-de/gartner.html>

1 0

[Maria-discuss] where's mroonga?
by Federico Razzoli 26 Sep '14

26 Sep '14

Hi Is Mroonga included in any MariaDB packet? If not: 1 is it in the source, and 2 any hints for compiling it? Regards Federico

2 1

[Maria-discuss] Partitions and query cache
by Roberto Spadim 25 Sep '14

25 Sep '14

Guys new doubts about partition and query cache drop table t1; reset query cache; CREATE TABLE t1 (c DATETIME) PARTITION BY HASH ( YEAR(c) ) partitions 4; *using myisam engine insert into t1 values ('2014-01-01'),('2013-01-01'),('2012-01-01'),('2011-01-01'),('2010-01-01'); select * from t1; select * from t1 partition (p0); select * from t1 partition (p1); select * from t1 partition (p2); select * from t1 partition (p3); --- this return: || *QUERY_CACHE_ID* || *SCHEMA* || *TABLE* || || 1 || teste || t1 || || 2 || teste || t1 || || 3 || teste || t1 || || 4 || teste || t1 || || 5 || teste || t1 || --- now using innodb: --- alter table t1 engine=innodb; select * from t1; select * from t1 partition (p0); select * from t1 partition (p1); select * from t1 partition (p2); select * from t1 partition (p3); select * from information_schema.QUERY_CACHE_QUERIES_TABLES; --- this return: || *QUERY_CACHE_ID* || *SCHEMA* || *TABLE* || || 1 || teste || t1 || || 1 || teste || t1#P#p0 || || 1 || teste || t1#P#p1 || || 1 || teste || t1#P#p2 || || 1 || teste || t1#P#p3 || || 2 || teste || t1 || || 2 || teste || t1#P#p0 || || 2 || teste || t1#P#p1 || || 2 || teste || t1#P#p2 || || 2 || teste || t1#P#p3 || || 3 || teste || t1 || || 3 || teste || t1#P#p0 || || 3 || teste || t1#P#p1 || || 3 || teste || t1#P#p2 || || 3 || teste || t1#P#p3 || || 4 || teste || t1 || || 4 || teste || t1#P#p0 || || 4 || teste || t1#P#p1 || || 4 || teste || t1#P#p2 || || 4 || teste || t1#P#p3 || || 5 || teste || t1 || || 5 || teste || t1#P#p0 || || 5 || teste || t1#P#p1 || || 5 || teste || t1#P#p2 || || 5 || teste || t1#P#p3 || Now my question... Why ha_partition don't use the right partition at query cache? this give a new problem of query cache partition prune, update t1 set c='2009-01-01' where c='2012-01-01'; after this i have no query at query cache the problem is instead of remove partition #p0 (2012) and #p1 (2009), it removed all partitions from query cache that's the right thing to do? maybe we should check ha_partition and query cache? -- Roberto Spadim

1 1

[Maria-discuss] doubt about view and query cache
by Roberto Spadim 24 Sep '14

24 Sep '14

Guys i'm with doubt about view and query cache check: reset query cache; create table t (a int); insert into t values (1); insert into t values (2); create view v as select * from t; select * from teste.v; select * from information_schema.QUERY_CACHE_QUERIES; (from mdev-4682) select * from information_schema.QUERY_CACHE_QUERIES_tables; (from mdev-4682) select * from information_schema.QUERY_CACHE_tables; (from mdev-4682) at 2 last command, i got this: || *QUERY_CACHE_ID* || *SCHEMA* || *TABLE* || || 1 || teste || || || 1 || teste || t || || *TABLE_SCHEMA* || *TABLE_NAME* || *TABLE_HASHED* || *TABLE_TYPE* || *QUERIES_IN_CACHE* || || teste || t || 1 || NON_TRANSACT || 1 || || teste || || 1 || NON_TRANSACT || 1 || the table "" shouldn't be "v" view? why it's blank? -- Roberto Spadim

1 2

[Maria-discuss] OQGRAPH and query cache
by Roberto Spadim 24 Sep '14

24 Sep '14

Hi guys, i was reading docs, and found this: - The query cache needs to be disabled in order to use OQGRAPH <https://mariadb.com/kb/en/oqgraph/> and, in older versions, Galera <https://mariadb.com/kb/en/galera/>. Why query cache needs to be disabled with OQGRAPH? -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

3 5

[Maria-discuss] Spider and query cache
by Roberto Spadim 23 Sep '14

23 Sep '14

Hi guys! I'm with a doubt, spider engine don't allow query cache right? But does it use sql_cache sql_no_cache when possible? -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

5 18

[Maria-discuss] transactions and UNLOCK TABLES
by Federico Razzoli 23 Sep '14

23 Sep '14

In this MySQL manual page: http://dev.mysql.com/doc/refman/5.6/en/implicit-commit.html I read: "UNLOCK TABLES commits a transaction only if any tables currently have been locked with LOCK TABLES to acquire nontransactional table locks." However, this doesn't seem to be the case, at least with MariaDB 10.0: MariaDB [test]> CREATE OR REPLACE TABLE m (c INT) ENGINE = InnoDB; Query OK, 0 rows affected (0.39 sec) MariaDB [test]> CREATE OR REPLACE TABLE t (c INT UNIQUE) ENGINE = InnoDB; Query OK, 0 rows affected (0.54 sec) MariaDB [test]> SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; Query OK, 0 rows affected (0.00 sec) MariaDB [test]> START TRANSACTION; Query OK, 0 rows affected (0.00 sec) MariaDB [test]> INSERT INTO m VALUES (1); Query OK, 1 row affected (0.00 sec) MariaDB [test]> INSERT INTO t VALUES (1); Query OK, 1 row affected (0.00 sec) MariaDB [test]> UNLOCK TABLES; Query OK, 0 rows affected (0.00 sec) MariaDB [test]> SELECT @@in_transaction; +------------------+ | @@in_transaction | +------------------+ | 1 | +------------------+ 1 row in set (0.00 sec) -- So, could you please confirm that UNLOCK TABLES is transaction-safe? If it isn't, could someone please explain in which cases it isn't? Regards Federico

3 13

[Maria-discuss] nosql and mysql
by Roberto Spadim 21 Sep '14

21 Sep '14

Guys, today i use some others solutions like redis memcache mongo, etc they are nosql database/cache, and we have handler socket with innodb in mariadb that i use too The question is... i always have problem with security since some of them don't have login security, ssl, etc... I know that's possible, but what's the pros/cons about including others parsers/optimizer inside mariadb code? what i'm saying? something at client side like: mysql_connect() mysql_query("sql query") while(mysql_fetch()){ something... } mysql_free() but instead of sql we could execute nosql, like: mysql_connect() mysql_query("some handler socket/memcached get","parser = handler socket/memcached") or mysql_parser("handler socket/memcached") mysql_query("some handler socket/memcached get") while(mysql_fetch()){ something... } mysql_free() what i see as pros/cons; pros: only one protocol with auth/security, less cpu/memory consume? less software to take care, understand, update, easier integration between daemon plugins and mysql tools, single point of configuration cons: one single point of failure, time to develop, integrate with mysql server (since we need changes to mysql protocol) what you think? -- Roberto Spadim

1 0

[Maria-discuss] New Question: How do I connect to MongoDB with Connect engine? Could not find any doc.
by AskMonty KB 19 Sep '14

19 Sep '14

Hello, A new question has been asked in "CONNECT" by openiduser47: -------------------------------- I loaded the plugin, what's next? Could not find any docs/examples at all. Thanks in advance! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-do-i-connect-to-mongodb-with-connect-engine-co…

1 0

[Maria-discuss] New Question: Could not increase number of max_open_files to more than 1024 (request: 1835)
by AskMonty KB 17 Sep '14

17 Sep '14

Hello, A new question has been asked in "MariaDB community" by glennbaker1: -------------------------------- Hello I'm new to mariadb and currently establishing openstack. I'm investigating an issue and I'm hoping the community can help me resolve the following error. I have increased the limits.conf and restarted mariadb however it doesn't appear to have resolved the problem as suggested in various posts I have read. Error from log 40917 15:40:19 [Warning] option 'open_files_limit': unsigned value 18446744073709551615 adjusted to 4294967295 140917 15:40:19 [Warning] Could not increase number of max_open_files to more than 1024 (request: 1835) Results of clustercheck [root@servername~]# clustercheck HTTP/1.1 200 OK Content-Type: text/plain Connection: close Content-Length: 32 Galera cluster node is synced. Limits.conf cat /etc/security/limits.conf * soft nproc 65536 * hard nproc 65536 * soft nofile 1048576 * hard nofile 1048576 * soft stack 10240 [root@lservername ~]# pcs cluster status Cluster Status: Last updated: Wed Sep 17 16:08:35 2014 Last change: Wed Sep 17 16:08:14 2014 via crm_attribute on lshkvm40a Stack: corosync Current DC: servername (3) - partition with quorum Version: 1.1.10-32.el7_0-368c726 3 Nodes configured 85 Resources configured PCSD Status: 10.25.167.207: Online 10.25.167.209: Online 10.25.167.211: Online mariadb.log 140917 15:40:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140917 15:40:19 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.MVaILy' --pid-file='/var/lib/mysql/lshkvm40a-recover.pid' 140917 15:40:19 [Warning] option 'open_files_limit': unsigned value 18446744073709551615 adjusted to 4294967295 140917 15:40:19 [Warning] option 'open_files_limit': unsigned value 18446744073709551615 adjusted to 4294967295 140917 15:40:19 [Warning] Could not increase number of max_open_files to more than 1024 (request: 1835) /usr/libexec/mysqld: Query cache is disabled (resize or similar command in progress); repeat this command later 140917 15:40:21 mysqld_safe WSREP: Recovered position 87e05b4e-3437-11e4-b636-9b7b2bb055fc:1282018 140917 15:40:21 [Warning] option 'open_files_limit': unsigned value 18446744073709551615 adjusted to 4294967295 140917 15:40:21 [Warning] option 'open_files_limit': unsigned value 18446744073709551615 adjusted to 4294967295 140917 15:40:21 [Note] WSREP: wsrep_start_position var submitted: '87e05b4e-3437-11e4-b636-9b7b2bb055fc:1282018' 140917 15:40:21 [Warning] Could not increase number of max_open_files to more than 1024 (request: 1835) /usr/libexec/mysqld: Query cache is disabled (resize or similar command in progress); repeat this command later 140917 15:40:21 [Note] WSREP: Read nil XID from storage engines, skipping position init 140917 15:40:21 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so' 140917 15:40:21 [Note] WSREP: wsrep_load(): Galera 3.5(rXXXX) by Codership Oy <info(a)codership.com> loaded successfully. 140917 15:40:21 [Note] WSREP: CRC-32C: using hardware acceleration. Thanks for your time and assistance. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/could-not-increase-number-of-max_open_files-to-mor…

2 1

[Maria-discuss] .ibd files remaining after DROP TABLE
by Andrew Braithwaite 17 Sep '14

17 Sep '14

Hi, After dropping tables on my MariaDB 10.0.13 database server, the .frm files are removed but the .ibd files remain behind. Has anyone seen this before? Thanks.... Andrew mysqld Ver 10.0.13-MariaDB-1~trusty for debian-linux-gnu on x86_64 ( mariadb.org binary distribution) DISTRIB_ID=Ubuntu DISTRIB_RELEASE=14.04 DISTRIB_CODENAME=trusty DISTRIB_DESCRIPTION="Ubuntu 14.04.1 LTS" NAME="Ubuntu" VERSION="14.04.1 LTS, Trusty Tahr" ID=ubuntu ID_LIKE=debian PRETTY_NAME="Ubuntu 14.04.1 LTS" VERSION_ID="14.04" HOME_URL="http://www.ubuntu.com/" SUPPORT_URL="http://help.ubuntu.com/" BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/"

1 0

Re: [Maria-discuss] Need input on crashes on 3rd mariaDB server
by Jeroen Andriessen 17 Sep '14

17 Sep '14

Dear Jan, Thank you in advance for any time you invest in our issue. We were wondering if you had a chance to see our questions in response to your suggestions about enabling logging to further research our intermittent server crash issue? Best, Jeroen Andriessen On 27 Aug 2014, at 15:56 pm, Jeroen Andriessen <jeroen(a)lemonbit.com> wrote: > Hi Jan, > > Thank you for answering, sorry for getting back to you so late with this answer. We are a little hesitant to post full unedited error_logs to the newsgroup, because of user information sensitivity. > > Right now the problem hasn’t manifested itself for about a month. When you suggest enabling logging, I assume you are referring to the General Query Log? Or did you mean something else? As I understand it, enabling this log, with this great an interval between occurrences might mean a significant prolonged performance lag, due to the great amount of logging that wil occur. Do you think that is advisable? We wouldn’t want to run this logging for such an extended period of time. > > Thank you for your advice, > > Jeroen > > On 30 Jul 2014, at 16:53 pm, Jan Lindström <jan.lindstrom(a)skysql.com> wrote: > >> Hi, >> >> First thing is trying to identify which SQL-clause is causing this error and assertion. Could you provide us MariaDB configuration and full unedited error long from all the nodes. Furthermore, could you enable logging at least temporally adding log = log_file_name to your configuration and when/if problem repreoduces, provide the log files ? >> >> R: Jan >> >> >> On Wed, Jul 30, 2014 at 5:21 PM, Jeroen Andriessen <jeroen(a)lemonbit.com> wrote: >> Hi all, >> >> We’re currently using a system with three clustered maria-db masters. We are experiencing occasional (once every three weeks or so) crashes of one of the server, namely our third server, which we use as a dedicated donor for the other two. The crashes point to a BF-BF X lock conflict in the same table. I was wondering how to proceed with identifying and localising the problem and counteracting it. We have already tried to rebuild the database in question from an earlier mysql dump, to no effect. >> >> Any input is welcome, thanks. >> >> —— >> >> BF-BF X lock conflict >> RECORD LOCKS space id 36361 page no 10 n bits 264 index `***REDACTED***` of table `***REDACTED***`.`***REDACTED***` trx id D860A49 lock_mode X locks rec but not gap >> 140724 6:10:53 [ERROR] mysqld got signal 6 ; >> This could be because you hit a bug. It is also possible that this binary >> or one of the libraries it was linked against is corrupt, improperly built, >> or misconfigured. This error can also be caused by malfunctioning hardware. >> >> To report this bug, see http://kb.askmonty.org/en/reporting-bugs >> >> We will try our best to scrape up some info that will hopefully help >> diagnose the problem, but since we have already crashed, >> something is definitely wrong and this may fail. >> >> Server version: 5.5.38-MariaDB-wsrep-log >> key_buffer_size=134217728 >> read_buffer_size=131072 >> max_used_connections=7 >> max_threads=1002 >> thread_count=20 >> It is possible that mysqld could use up to >> key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2329723 K bytes of memory >> Hope that's ok; if not, decrease some variables in the equation. >> >> Thread pointer: 0x0x7f57b3412000 >> Attempting backtrace. You can use the following information to find out >> where mysqld died. If you see no messages after this, something went >> terribly wrong... >> stack_bottom = 0x7f5c1a16b940 thread_stack 0x48000 >> (my_addr_resolve failure: fork) >> /usr/sbin/mysqld(my_print_stacktrace+0x2b) [0xa95bab] >> /usr/sbin/mysqld(handle_fatal_signal+0x398) [0x6ebc58] >> /lib64/libpthread.so.0() [0x34e7e0f710] >> /lib64/libc.so.6(gsignal+0x35) [0x34e7632925] >> /lib64/libc.so.6(abort+0x175) [0x34e7634105] >> /usr/sbin/mysqld() [0x50e940] >> /usr/sbin/mysqld() [0x92c0ff] >> /usr/sbin/mysqld() [0x931799] >> /usr/sbin/mysqld() [0x932566] >> /usr/sbin/mysqld() [0x968a65] >> /usr/sbin/mysqld() [0x85fe3b] >> /usr/sbin/mysqld() [0x863ada] >> /usr/sbin/mysqld() [0x8642de] >> /usr/sbin/mysqld() [0x84e571] >> /usr/sbin/mysqld() [0x8337b2] >> /usr/sbin/mysqld(handler::ha_delete_row(unsigned char const*)+0xb0) [0x6f3640] >> /usr/sbin/mysqld(Delete_rows_log_event::do_exec_row(Relay_log_info const*)+0x10d) [0x7a41dd] >> /usr/sbin/mysqld(Rows_log_event::do_apply_event(Relay_log_info const*)+0x26a) [0x798e2a] >> /usr/sbin/mysqld(wsrep_apply_cb(void*, void const*, unsigned long, unsigned int, wsrep_trx_meta const*)+0x598) [0x69f988] >> /usr/lib64/galera/libgalera_smm.so(galera::TrxHandle::apply(void*, wsrep_cb_status (*)(void*, void const*, unsigned long, unsigned int, wsrep_trx_meta const*), wsrep_trx_meta const&) const+0xb1) [0x7f5c197462c1] >> /usr/lib64/galera/libgalera_smm.so(+0x1aaf95) [0x7f5c1977df95] >> /usr/lib64/galera/libgalera_smm.so(galera::ReplicatorSMM::apply_trx(void*, galera::TrxHandle*)+0x283) [0x7f5c1977ee03] >> /usr/lib64/galera/libgalera_smm.so(galera::ReplicatorSMM::process_trx(void*, galera::TrxHandle*)+0x45) [0x7f5c1977f6f5] >> /usr/lib64/galera/libgalera_smm.so(galera::GcsActionSource::dispatch(void*, gcs_action const&, bool&)+0x2c9) [0x7f5c1975c349] >> /usr/lib64/galera/libgalera_smm.so(galera::GcsActionSource::process(void*, bool&)+0x63) [0x7f5c1975c823] >> /usr/lib64/galera/libgalera_smm.so(galera::ReplicatorSMM::async_recv(void*)+0x93) [0x7f5c1977b3f3] >> /usr/lib64/galera/libgalera_smm.so(galera_recv+0x23) [0x7f5c19790743] >> /usr/sbin/mysqld() [0x6a037f] >> /usr/sbin/mysqld(start_wsrep_THD+0x365) [0x527415] >> /lib64/libpthread.so.0() [0x34e7e079d1] >> /lib64/libc.so.6(clone+0x6d) [0x34e76e8b5d] >> >> Trying to get some variables. >> Some pointers may be invalid and cause the dump to abort. >> Query (0x0): is an invalid pointer >> Connection ID (thread ID): 17 >> Status: NOT_KILLED >> >> Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off >> >> The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains >> information that should help you find out what is causing the crash. >> 140724 06:10:53 mysqld_safe Number of processes running now: 0 >> 140724 06:10:53 mysqld_safe WSREP: not restarting wsrep node automatically >> 140724 06:10:53 mysqld_safe mysqld from pid file /var/lib/mysql/***hostnameredacted***.pid ended >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : maria-discuss(a)lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> >> >> >> -- >> -- >> >> Jan Lindström, Principal Engineer >> SkySQL - The MariaDB Company >> >> >> >> skype: jan_p_lindstrom >> >> www.skysql.com >> >> >> >

1 0

[Maria-discuss] connection limit, connection drops
by Jonas Genannt 16 Sep '14

16 Sep '14

Hello, I'm using MariaDB 5.5.33a on Debian Wheezy. I have problems with connections from our PHP Application to MariaDB. Then there is high traffic the concurrent connections goes up to 1700 - 2200. If we have 1700 - 2200 concurrent connections we have sporadic connection drops like: "Can't connect to mysql ....." I have bumped the max_connection to 10000 and set some sysctl variables: echo 55536 > cat /proc/sys/net/core/somaxconn echo 10000 > /proc/sys/net/core/netdev_max_backlog echo "1024 65535" > /proc/sys/net/ipv4/ip_local_port_range echo "15"> /proc/sys/net/ipv4/tcp_fin_timeout I have also bumped up the open files for the MySQL user. The Mysql user of our application has no user connection limit in mysql.user. The error is still present, does anybody has a idea about it? Thanks! Jonas

2 3

[Maria-discuss] Galera cluster as slave: Duplicate entry errors
by Otto Berger 08 Sep '14

08 Sep '14

Hi all, i'm new to this list :) My setup: MySQL Server 5.5.37 -> Replication -> Galera 10 Cluster (currently 2 nodes) The old MySQL Master is receiving inserts to a table with a auto_increment field (primary key). The Galera Cluster is configured as classic slave to the master. From time to time i'm getting duplicate entry issues on the galera cluster: 140905 12:06:15 [ERROR] Slave SQL: Error 'Duplicate entry '16383' for key 'PRIMARY'' on query. ... 140905 12:06:15 [Warning] Slave: Duplicate entry '16383' for key 'PRIMARY' Error_code: 1062 I cannot see the problem where there could came from... My thought was if the insert (auto_increment) succeeds on the master then is must also succeed on the galera side... someone with an idea on it? BR Otto

3 3

[Maria-discuss] optimization
by Roberto Spadim 04 Sep '14

04 Sep '14

guys, i have some queries like this: SELECT doc_hash_key FROM mov_documentos WHERE doc_hash_key LIKE "j;1;$;294007/3nfe-1%" UNION SELECT doc_hash_key FROM mov_documentos WHERE doc_hash_key LIKE "j;1;%;294007/3nfe-1%" UNION SELECT doc_hash_key FROM mov_documentos WHERE doc_hash_key LIKE "j;1;%;%294007/3nfe-1%" UNION SELECT doc_hash_key FROM mov_documentos WHERE doc_hash_key LIKE "%;%;$;%294007/3nfe-1%" UNION SELECT doc_hash_key FROM mov_documentos WHERE doc_hash_key LIKE "%;%;%;294007/3nfe-1%" UNION SELECT doc_hash_key FROM mov_documentos WHERE doc_hash_key LIKE "%;%;%;%294007/3nfe-1%" LIMIT 1 it's a search about a document number, but the problem is.... the first query at first line (with % at end of the query) return really fast, but executing others queries are very slow, the question is could we optimize this kind of query, since limit=1 row? the explain of this query: idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1PRIMARY mov_documentosrangePRIMARYPRIMARY771Using where; Using index2UNION mov_documentosrangePRIMARYPRIMARY77625612Using where; Using index3UNION mov_documentosrangePRIMARYPRIMARY77625612Using where; Using index4UNION mov_documentosindexPRIMARY771798490Using where; Using index5UNION mov_documentosindexPRIMARY771798490Using where; Using index6UNION mov_documentosindexPRIMARY771798490Using where; Using indexUNION RESULT <union1,2,3,4,5,6>ALL -- Roberto Spadim

3 6

[Maria-discuss] Excluding plugins when building MariaDB 10.1
by Kolbe Kegel 04 Sep '14

04 Sep '14

Hi! I'm trying to build MariaDB 10.1 on OS X. cmake ../server/ -DBUILD_CONFIG=mysql_release -DWITH_SSL=system -DCMAKE_CXX_FLAGS:STRING='-stdlib=libstdc++' -DPLUGIN_TOKUDB=NO -DPLUGIN_OQGRAPH=NO -DWITH_EMBEDDED_SERVER:BOOL=OFF -DWITH_WSREP=OFF The build is failing on tokudb code even though I am trying to avoid building the TokuDB plugin. What gives? Linking CXX shared library libft.dylib Undefined symbols for architecture x86_64: "std::__1::__vector_base_common<true>::__throw_length_error() const", referenced from: toku::dmt<klpair_struct, klpair_struct*, toku::klpair_dmtwriter>::verify() const in bndata.cc.o "std::__1::__vector_base_common<true>::__throw_out_of_range() const", referenced from: toku::dmt<klpair_struct, klpair_struct*, toku::klpair_dmtwriter>::verify() const in bndata.cc.o toku::dmt<klpair_struct, klpair_struct*, toku::klpair_dmtwriter>::verify_internal(toku::dmt_internal::subtree const&, std::__1::vector<bool, std::__1::allocator<bool> >*) const in bndata.cc.o ld: symbol(s) not found for architecture x86_64 clang: error: linker command failed with exit code 1 (use -v to see invocation) make[2]: *** [storage/tokudb/ft-index/ft/libft.dylib] Error 1 make[1]: *** [storage/tokudb/ft-index/ft/CMakeFiles/ft.dir/all] Error 2 make: *** [all] Error 2 Kolbe -- Kolbe Kegel, Principal Support Engineer SkySQL, The MariaDB Company | http://www.skysql.com

3 4

[Maria-discuss] MariaDB Galera Cluster 10.0.13 now available
by Daniel Bartholomew 03 Sep '14

03 Sep '14

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.13 This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 10.0.13 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-10013-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-10013-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.13 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - Building a Web Application with PHP and MariaDB: A Reference Guide is the latest MariaDB book in Packt's growing MariaDB book series. It guides you through all the steps to get your app up and running. - http://bit.ly/1qrqMQx The recently published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB 5.5 and 10.0. - http://bit.ly/WZs2Pd Another book, Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB. No prior database experience required. - http://bit.ly/MMElbQ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

Re: [Maria-discuss] MariaDB Galera Cluster 10.0.13
by Cloud Foundry Services 29 Aug '14

29 Aug '14

Hello, Is MariaDB Galera Cluster 10.0.13 on track for release today? https://mariadb.atlassian.net/browse/MDEV/fixforversion/16800/ Thank you, On Mon, Aug 25, 2014 at 1:40 PM, Nirbhay Choubey <nirbhay(a)skysql.com> wrote: > Hi Shannon, > > On Mon, Aug 25, 2014 at 4:26 PM, Cloud Foundry Services < > cf-services-eng(a)pivotal.io> wrote: > >> Hi Nirbhay, >> >> We're looking forward to these fixes: >> >> https://mariadb.atlassian.net/browse/MDEV-5786 - We were previously >> running mysql_upgrade on every node and getting errors due to replication. >> We now disable replication while mysql_upgrade is running but this makes us >> vulnerable to writes while replication is disabled. We could prevent writes >> while replication is disabled, but we expect this fix will allow us to >> revert our automation around disabling replication. >> >> https://mariadb.atlassian.net/browse/MDEV-6492 - Our understanding is >> that until we receive this fix, nodes can receive writes that may not be >> replicated while in donor mode for an rsync SST. We expect this fix to >> prevent writes while in donor mode for rsync SST. >> >> We are also crossing our fingers that 10.0.13 resolves this issue (link >> is to codership forum, just posted the same question to maria-discuss a few >> minutes ago): >> https://groups.google.com/forum/#!topic/codership-team/OSnQ1FLloBI. We >> haven't filed a bug for it yet; were hoping to get a sanity check first. >> > > > Fix for both the above issues have been queued for MariaDB Galera Server > 10.0.13, and should quite likely fix the issues that you are facing. > > Thanks! > > - Nirbhay > > > >> Thank you, >> Shannon >> >> Cloud Foundry Service, Pivotal >> >> On Mon, Aug 25, 2014 at 1:05 PM, Nirbhay Choubey <nirbhay(a)skysql.com> >> wrote: >> >>> Hi, >>> >>> On Mon, Aug 25, 2014 at 3:45 PM, Cloud Foundry Services < >>> cf-services-eng(a)pivotal.io> wrote: >>> >>>> Hello, >>>> >>>> Any word on the release of MariaDB Galera Cluster 10.0.13? >>>> >>> >>> It should be out in a couple of days. >>> >>> >>>> We've been seeing issues with replication that we really hope this >>>> release will fix. >>>> >>> >>> What are the issues like? Could you describe them? Or report a bug? >>> >>> mariadb.org/jira >>> >>> Best, >>> Nirbhay >>> >>> >>>> Thank you, >>>> Shannon >>>> >>>> Cloud Foundry Services, Pivotal >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~maria-discuss >>>> Post to : maria-discuss(a)lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~maria-discuss >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> >> >

1 0

Re: [Maria-discuss] MariaDB Galera Cluster 10.0.13
by Cloud Foundry Services 25 Aug '14

25 Aug '14

Hi Nirbhay, We're looking forward to these fixes: https://mariadb.atlassian.net/browse/MDEV-5786 - We were previously running mysql_upgrade on every node and getting errors due to replication. We now disable replication while mysql_upgrade is running but this makes us vulnerable to writes while replication is disabled. We could prevent writes while replication is disabled, but we expect this fix will allow us to revert our automation around disabling replication. https://mariadb.atlassian.net/browse/MDEV-6492 - Our understanding is that until we receive this fix, nodes can receive writes that may not be replicated while in donor mode for an rsync SST. We expect this fix to prevent writes while in donor mode for rsync SST. We are also crossing our fingers that 10.0.13 resolves this issue (link is to codership forum, just posted the same question to maria-discuss a few minutes ago): https://groups.google.com/forum/#!topic/codership-team/OSnQ1FLloBI. We haven't filed a bug for it yet; were hoping to get a sanity check first. Thank you, Shannon Cloud Foundry Service, Pivotal On Mon, Aug 25, 2014 at 1:05 PM, Nirbhay Choubey <nirbhay(a)skysql.com> wrote: > Hi, > > On Mon, Aug 25, 2014 at 3:45 PM, Cloud Foundry Services < > cf-services-eng(a)pivotal.io> wrote: > >> Hello, >> >> Any word on the release of MariaDB Galera Cluster 10.0.13? >> > > It should be out in a couple of days. > > >> We've been seeing issues with replication that we really hope this >> release will fix. >> > > What are the issues like? Could you describe them? Or report a bug? > > mariadb.org/jira > > Best, > Nirbhay > > >> Thank you, >> Shannon >> >> Cloud Foundry Services, Pivotal >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : maria-discuss(a)lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> >> >

1 0

[Maria-discuss] Scaling up cluster results in missing rows on some existing nodes
by Cloud Foundry Services 25 Aug '14

25 Aug '14

Apologies for the cross-post; we submitted this question to the Codership forum a week ago and haven't received a response. https://groups.google.com/forum/#!topic/codership-team/OSnQ1FLloBI Hello, Hoping to get some perspective on an issue we saw yesterday. While scaling up from a single node cluster, we inserted into a table on node 0 and selected the row count for that table on all subsequent nodes (scripts below). For each node that was brought online, we observed that connections to node 0 were suspended during SST, and that there was an additional IST. At this point the nodes reported that they were synced. However, sometimes replication did not occur correctly - the additional nodes reported fewer rows than node 0. Each new node was added by itself, and all other nodes restarted during each scale-up. Nodes that became out-of-sync continued to have an incorrect row count even after restart, and sometimes got further out of sync (i.e. the discrepancy between the number of rows in node 0 and the other nodes increased) We were conducting this experiment to see whether* innodb_disallow_writes *was functioning correctly, but aren't sure whether this issue is related. Has anyone seen similar behavior while scaling up? Insert: #!/bin/bash mysql -u$db_user -p$db_password -e"create database if not exists $db_name;" mysql -u$db_user -p$db_password -e"use $db_name; create table if not exists $table_name (val int);" for i in `seq $start_val $end_val`; do echo "inserting $i" mysql -u$db_user -p$db_password -e"use $db_name; insert into $table_name VALUES ($i); select count(*) from $table_name;" sleep 0.1 done Select: #!/bin/bash for i in `seq $start_val $end_val`; do echo "statement $i" mysql -u$db_user -p$db_password -e"use replication_test; select count(*) from vals;" sleep 0.1 done Thank you, Shannon Cloud Foundry Services, Pivotal

1 0

[Maria-discuss] MariaDB Galera Cluster 10.0.13
by Cloud Foundry Services 25 Aug '14

25 Aug '14

Hello, Any word on the release of MariaDB Galera Cluster 10.0.13? We've been seeing issues with replication that we really hope this release will fix. Thank you, Shannon Cloud Foundry Services, Pivotal

1 0

[Maria-discuss] MariaDB Galera Cluster 5.5.39 now available
by Daniel Bartholomew 21 Aug '14

21 Aug '14

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.39 This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 5.5.39 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-5539-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-5539-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.39 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - Building a Web Application with PHP and MariaDB: A Reference Guide is the latest MariaDB book in Packt's growing MariaDB book series. It guides you through all the steps to get your app up and running. - http://bit.ly/1qrqMQx The recently published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB 5.5 and 10.0. - http://bit.ly/WZs2Pd Another book, Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB. No prior database experience required. - http://bit.ly/MMElbQ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] doubt about spider and vertical partitioning
by Roberto Spadim 13 Aug '14

13 Aug '14

hi guys, i didn't tested, i was reading mariadb manual, and it tell that VP isn't implemented at mariadb, that's true? what could i do to help with it ? -- Roberto Spadim

1 0

[Maria-discuss] Upgrade from 10.0.12 -> 10.0.13 changes default config file location behavior; build-time "-DDEFAULT_SYSCONFDIR=" is now ignored ?
by grantksupport＠operamail.com 12 Aug '14

12 Aug '14

I build MariaDB from src. I've been running v10.0.12 (r4252). I've upgraded to v10.0.13 (r4346). My build config always includes cmake .. --debug-output \ -DCMAKE_BUILD_TYPE="Release" \ -DCMAKE_INSTALL_PREFIX=/usr/local/mariadb \ -DINSTALL_LAYOUT=STANDALONE \ -DINSTALL_SYSCONFDIR=/usr/local/etc/mariadb.DEFAULT \ -DINSTALL_SYSCONF2DIR=/usr/local/etc/mariadb.DEFAULT/conf.d \ -DDEFAULT_SYSCONFDIR=/usr/local/etc/mariadb \ ... I have always kept my config only in /usr/local/etc/mariadb/my.cnf with no ~/.my.cnf in existence. Launching MariaDB (via systemd) with /usr/local/mariadb/bin/mysqld --defaults-file=/usr/local/etc/mariadb/my.cnf --basedir=/usr/local/mariadb --datadir=/var/db/mariadb --plugin-dir=/usr/local/mariadb/lib/plugin --log-error=/var/log/mariadb/mariadb-err.log --pid-file=/var/cache/mariadb/mariadb.pid --socket=/var/cache/mariadb/mariadb.sock --port=3306 and noting cat ./scripts/CMakeLists.txt ... IF(INSTALL_SYSCONFDIR) SET(sysconfdir ${DEFAULT_SYSCONFDIR}) ELSE() SET(sysconfdir "/etc") ENDIF() ... & cat ./mysys/my_default.c ... /* Which directories are searched for options (and in which order) */ ... /* This structure defines the context that we pass to callback function 'handle_default_option' used in search_default_file to process each option. This context is used if search_default_file was called from load_defaults. */ struct handle_option_ctx ... /** Create the list of default directories. @param alloc MEM_ROOT where the list of directories is stored @details The directories searched, in order, are: - Windows: GetSystemWindowsDirectory() - Windows: GetWindowsDirectory() - Windows: C:/ - Windows: Directory above where the executable is located - Unix: /etc/ or the value of DEFAULT_SYSCONFDIR, if defined - Unix: /etc/mysql/ unless DEFAULT_SYSCONFDIR is defined - ALL: getenv("MYSQL_HOME") - ALL: --defaults-extra-file=<path> (run-time option) - Unix: ~/ On all systems, if a directory is already in the list, it will be moved to the end of the list. This avoids reading defaults files multiple times, while ensuring the correct precedence. @retval NULL Failure (out of memory, probably) @retval other Pointer to NULL-terminated array of default directories */ ... & @ https://mariadb.com/kb/en/mariadb/documentation/getting-started/configuring… On a Linux, Unix or Mac server, MariaDB looks for the my.cnf file in the following locations: Location Scope /etc/my.cnf Global /etc/mysql/my.cnf Global SYSCONFDIR/my.cnf Global $MYSQL_HOME/my.cnf Server defaults-extra-file File specified with --defaults-extra-file=path, if any /.my.cnf User SYSCONFDIR is the directory specified with the CMake SYSCONFDIR option when MariaDB was built, by default etc under the compiled-in installation directory. with MariaDB v <= 10.0.12, changes to my config have always been correctly picked up, INCLUDING by all mysql client tools. So, for example, if in my.cnf I add ... [client] user = root password = 'XXXXXX' ... then at shell, instead of mysqlshow -u root -p password: XXXXXX I can just mysqlshow and the options as specified are picked up. With MariaDB 10.0.13, the config file is ignored; no changes to it are picked up. The client apps still require cmd line "-u" & "-p", e.g. mysqlshow -u root -p But if I simply cp -af /usr/local/etc/mariadb/my.cnf ~/.my.cnf then, the changes are picked up -- from the ~/.my.cnf location. and just mysqlshow works, as previously. Is this change in behavior intentional? What't the correct, expected/intended behavior? If it's changed, how do I now specify and use the default config file location? Grant

2 5

[Maria-discuss] MariaDB 10.0.13 now available
by Daniel Bartholomew 11 Aug '14

11 Aug '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.13 This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.13 - Release Notes: https://mariadb.com/kb/en/mariadb-10013-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10013-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.13 About MariaDB 10.0: - https://mariadb.com/kb/en/what-is-mariadb-100/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - Building a Web Application with PHP and MariaDB: A Reference Guide is the latest MariaDB book in Packt's growing MariaDB book series. It guides you through all the steps to get your app up and running. - http://bit.ly/1qrqMQx The recently published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB 5.5 and 10.0. - http://bit.ly/WZs2Pd Another book, Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB. No prior database experience required. - http://bit.ly/MMElbQ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] Galera Cluster: Do we need binlogs? How to limit the space used by binlogs?
by Benoit Panizzon 07 Aug '14

07 Aug '14

Hello We have quite a busy MariaDB operating in a Galera cluster. The Size of the database is not that large, about 2GB. We get several GB of Binlogs per day as we get a lot of transactions (busy mailserver with Bayes DB and a lot of timestamps being updated) I have set: expire_logs_days = 1 But still those binlogs 'waste' several dozends of GB on each node. Does Galera need those logs for syncing? Are there other ways to limit the size used by the binlogs? Kind regards Benoit Panizzon -- I m p r o W a r e A G - ______________________________________________________ Zurlindenstrasse 29 Tel +41 61 826 93 07 CH-4133 Pratteln Fax +41 61 826 93 02 Schweiz Web http://www.imp.ch ______________________________________________________

2 1

[Maria-discuss] quering images
by Roberto Spadim 05 Aug '14

05 Aug '14

hi guys, does anyone know anything about querying images? for example, i have a database with images files (.jpg for example), and i have another image (for example my gmail picture), i want to search images similar or "near" to my image some points that i'm thinking about... images have many data, including meta data, maybe not only querying images (faces for example) but search a barcode or a ocr text, and many others features (i know some features when i worked with some opencv projects) ideas and informations and experiences are wellcome :) -- Roberto Spadim

2 2

[Maria-discuss] MariaDB 5.5.39 now available
by Daniel Bartholomew 05 Aug '14

05 Aug '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.39 This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.39 - Release Notes: https://mariadb.com/kb/en/mariadb-5539-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-5539-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.39 About MariaDB 5.5: - https://mariadb.com/kb/en/what-is-mariadb-55/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - Building a Web Application with PHP and MariaDB: A Reference Guide is the latest MariaDB book in Packt's growing MariaDB book series. It guides you through all the steps to get your app up and running. - http://bit.ly/1qrqMQx The recently published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB 5.5 and 10.0. - http://bit.ly/WZs2Pd Another book, Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB. No prior database experience required. - http://bit.ly/MMElbQ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] 5.5.38: compiler warnings
by Reindl Harald 05 Aug '14

05 Aug '14

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] /mariadb-5.5.38/strings/decimal.c:2154:52: warning: array subscript is below array bounds [-Warray-bounds] /mariadb-5.5.38/strings/decimal.c:2154:56: warning: array subscript is below array bounds [-Warray-bounds] /mariadb-5.5.38/strings/decimal.c:264:56: warning: array subscript is below array bounds [-Warray-bounds] /mariadb-5.5.38/strings/decimal.c:264:60: warning: array subscript is below array bounds [-Warray-bounds] /mariadb-5.5.38/strings/decimal.c:300:26: warning: array subscript is above array bounds [-Warray-bounds] /mariadb-5.5.38/strings/decimal.c:300:30: warning: array subscript is above array bounds [-Warray-bounds] /mariadb-5.5.38/strings/decimal.c:478:31: warning: array subscript is below array bounds [-Warray-bounds] /mariadb-5.5.38/strings/decimal.c:478:35: warning: array subscript is below array bounds [-Warray-bounds] /mariadb-5.5.38/strings/decimal.c:496:29: warning: array subscript is above array bounds [-Warray-bounds] /mariadb-5.5.38/strings/decimal.c:496:33: warning: array subscript is above array bounds [-Warray-bounds] ___________________________________________________________________________ /mariadb-5.5.38/client/mysql.cc:3488:1: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/mysys/lf_alloc-pin.c:337:13: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/mysys/mf_iocache2.c:345:8: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/mysys/mf_qsort.c:95:9: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/mysys/mf_qsort.c:98:9: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/plugin/feedback/sender_thread.cc:170:13: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/sql-common/client.c:2379:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/sql-common/client.c:2462:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/sql/field.cc:8567:1: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/sql/ha_partition.cc:2377:6: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/sql/ha_partition.cc:2775:6: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/sql/log_event.cc:9998:1: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/sql/log_event_old.cc:2019:1: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/sql/log_event_old.cc:516:1: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/sql/opt_range.cc:13595:5: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/sql/opt_range.cc:13832:5: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/sql/opt_range.cc:13973:5: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/sql/sql_acl.cc:8047:13: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/sql/sql_insert.cc:1580:5: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/sql/sql_plugin.cc:1212:13: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/sql/sql_plugin.cc:1509:5: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/sql/sql_plugin.cc:1896:6: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/sql/sql_plugin.cc:2308:6: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/sql/sql_plugin.cc:2739:21: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/sql/sql_plugin.cc:2780:21: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/sql/unireg.cc:112:6: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_blockrec.c:2412:16: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_blockrec.c:5140:9: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_check.c:3210:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_check.c:5974:5: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_check.c:848:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_delete.c:197:9: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_delete.c:282:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_delete.c:547:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_dynrec.c:1550:9: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_dynrec.c:1588:9: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_dynrec.c:243:9: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_dynrec.c:273:9: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_open.c:1770:9: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_pagecache.c:3947:9: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/maria_chk.c:1742:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/maria_chk.c:1936:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/maria_pack.c:2101:17: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/maria_pack.c:2402:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/maria_pack.c:850:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_rt_index.c:1121:9: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_rt_index.c:1266:9: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_rt_index.c:324:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_rt_index.c:57:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_rt_index.c:605:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_rt_index.c:727:5: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_rt_index.c:924:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_rt_split.c:367:5: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/maria/ma_write.c:613:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/myisam/mi_check.c:2010:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/myisam/mi_check.c:4227:5: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/myisam/mi_check.c:731:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/myisam/mi_delete.c:146:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/myisam/mi_delete.c:215:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/myisam/mi_delete.c:401:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/myisam/mi_open.c:72:10: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/myisam/mi_write.c:335:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/myisam/myisamchk.c:1439:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/myisam/myisamchk.c:1618:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/myisam/myisampack.c:2132:17: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/myisam/myisampack.c:2435:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/myisam/myisampack.c:873:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/myisam/rt_index.c:1035:9: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/myisam/rt_index.c:292:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/myisam/rt_index.c:539:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/myisam/rt_index.c:54:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/myisam/rt_index.c:764:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/myisam/rt_index.c:908:5: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/myisam/rt_split.c:244:5: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/xtradb/log/log0log.c:277:1: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/storage/xtradb/log/log0recv.c:2971:1: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/strings/decimal.c:1310:5: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector] /mariadb-5.5.38/strings/decimal.c:2114:12: warning: stack protector not protecting local variables: variable length buffer [-Wstack-protector]

2 1

[Maria-discuss] Aria engine: log initialization failed
by Reindl Harald 05 Aug '14

05 Aug '14

what is in "aria_log.00000001" and "aria_log_control" and can i skip them from backups? as far as i see they don't contain any really needed informations * so can i exclude that files completly from backups * could MariaDB delete them instead of refuse to start in case the are damaged? see my last comment on the following bugreport https://bugzilla.redhat.com/show_bug.cgi?id=1123557 140802 19:35:31 [ERROR] mysqld: Aria engine: log initialization failed 140802 19:35:31 [ERROR] Plugin 'Aria' init function returned error. 140802 19:35:31 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed. 140802 19:35:31 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables

2 2

[Maria-discuss] Need input on crashes on 3rd mariaDB server
by Jeroen Andriessen 30 Jul '14

30 Jul '14

Hi all, We’re currently using a system with three clustered maria-db masters. We are experiencing occasional (once every three weeks or so) crashes of one of the server, namely our third server, which we use as a dedicated donor for the other two. The crashes point to a BF-BF X lock conflict in the same table. I was wondering how to proceed with identifying and localising the problem and counteracting it. We have already tried to rebuild the database in question from an earlier mysql dump, to no effect. Any input is welcome, thanks. —— BF-BF X lock conflict RECORD LOCKS space id 36361 page no 10 n bits 264 index `***REDACTED***` of table `***REDACTED***`.`***REDACTED***` trx id D860A49 lock_mode X locks rec but not gap 140724 6:10:53 [ERROR] mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see http://kb.askmonty.org/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 5.5.38-MariaDB-wsrep-log key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=7 max_threads=1002 thread_count=20 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2329723 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x7f57b3412000 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x7f5c1a16b940 thread_stack 0x48000 (my_addr_resolve failure: fork) /usr/sbin/mysqld(my_print_stacktrace+0x2b) [0xa95bab] /usr/sbin/mysqld(handle_fatal_signal+0x398) [0x6ebc58] /lib64/libpthread.so.0() [0x34e7e0f710] /lib64/libc.so.6(gsignal+0x35) [0x34e7632925] /lib64/libc.so.6(abort+0x175) [0x34e7634105] /usr/sbin/mysqld() [0x50e940] /usr/sbin/mysqld() [0x92c0ff] /usr/sbin/mysqld() [0x931799] /usr/sbin/mysqld() [0x932566] /usr/sbin/mysqld() [0x968a65] /usr/sbin/mysqld() [0x85fe3b] /usr/sbin/mysqld() [0x863ada] /usr/sbin/mysqld() [0x8642de] /usr/sbin/mysqld() [0x84e571] /usr/sbin/mysqld() [0x8337b2] /usr/sbin/mysqld(handler::ha_delete_row(unsigned char const*)+0xb0) [0x6f3640] /usr/sbin/mysqld(Delete_rows_log_event::do_exec_row(Relay_log_info const*)+0x10d) [0x7a41dd] /usr/sbin/mysqld(Rows_log_event::do_apply_event(Relay_log_info const*)+0x26a) [0x798e2a] /usr/sbin/mysqld(wsrep_apply_cb(void*, void const*, unsigned long, unsigned int, wsrep_trx_meta const*)+0x598) [0x69f988] /usr/lib64/galera/libgalera_smm.so(galera::TrxHandle::apply(void*, wsrep_cb_status (*)(void*, void const*, unsigned long, unsigned int, wsrep_trx_meta const*), wsrep_trx_meta const&) const+0xb1) [0x7f5c197462c1] /usr/lib64/galera/libgalera_smm.so(+0x1aaf95) [0x7f5c1977df95] /usr/lib64/galera/libgalera_smm.so(galera::ReplicatorSMM::apply_trx(void*, galera::TrxHandle*)+0x283) [0x7f5c1977ee03] /usr/lib64/galera/libgalera_smm.so(galera::ReplicatorSMM::process_trx(void*, galera::TrxHandle*)+0x45) [0x7f5c1977f6f5] /usr/lib64/galera/libgalera_smm.so(galera::GcsActionSource::dispatch(void*, gcs_action const&, bool&)+0x2c9) [0x7f5c1975c349] /usr/lib64/galera/libgalera_smm.so(galera::GcsActionSource::process(void*, bool&)+0x63) [0x7f5c1975c823] /usr/lib64/galera/libgalera_smm.so(galera::ReplicatorSMM::async_recv(void*)+0x93) [0x7f5c1977b3f3] /usr/lib64/galera/libgalera_smm.so(galera_recv+0x23) [0x7f5c19790743] /usr/sbin/mysqld() [0x6a037f] /usr/sbin/mysqld(start_wsrep_THD+0x365) [0x527415] /lib64/libpthread.so.0() [0x34e7e079d1] /lib64/libc.so.6(clone+0x6d) [0x34e76e8b5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x0): is an invalid pointer Connection ID (thread ID): 17 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 140724 06:10:53 mysqld_safe Number of processes running now: 0 140724 06:10:53 mysqld_safe WSREP: not restarting wsrep node automatically 140724 06:10:53 mysqld_safe mysqld from pid file /var/lib/mysql/***hostnameredacted***.pid ended

1 0

[Maria-discuss] cross-compiling mariadb-galera
by Sylvain Raybaud 25 Jul '14

25 Jul '14

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Dear MariaDB community, I've got a question regarding the cross-compilation of MariaDB. More specifically I'm trying to create a buildroot package for MariaDB Galera cluster. I added mariadb-galera to buildroot/package/Config.in and created a folder buildroot/package/mariadb-galera containing the following files (normal buildroot procedure): buildroot/package/mariadb-galera/Config.in buildroot/package/mariadb-galera/mariadb-galera.mk mariadb-galera.mk contains, among other things: MARIADB_GALERA_CONF_OPT = -DCMAKE_CROSSCOMPILING=1 -DWITH_WSREP=ON - -DWITH_INNODB_DISALLOW_WRITES=1 I'm building for Raspberry Pi. I'm using version 10.0.12. The build fails with: CMake Error at storage/xtradb/CMakeLists.txt:434 (MESSAGE): Percona XtraDB is not supported on this platform This error is trigger in storage/xtradb/CMakeLists.txt when XTRADB_OK is not set; it seems to me that XTRADB_OK is set in either one of the following cases: 1) CMAKE_CROSSCOMPILING is NOT set and some tests are successful (thus setting HAVE_IB_GCC_ATOMIC_BUILTINS) or 2) We're compiling for MSVC or CMAKE_SYSTEM_NAME is "SunOS" and some other conditions are met. Since I'm not compiling for MSVC or SunOS and I'm crosscompiling indeed, XTRADB_OK is not set and the error is triggered. Here I'm stuck. I've got the feeling that as such one cannot cross-compile xtradb because XTRADB_OK will never be set; or maybe with proper options passed to cmake the tests would be made elsewhere and HAVE_IB_GCC_ATOMIC_BUILTINS would be set beforehand? Or maybe I should patch this CMakeLists.txt? Or maybe I should just compile without xtradb altogether, if that's possible? Any guidance would be appreciated. Cheers, Sylvain Raybaud PS: I was not sure whether to post this on -discuss or -devel so I opted for the most general list. Don't hesitate to ask me to repost elsewhere if you feel this would be more appropriate. - -- Sylvain Raybaud www.green-communications.fr -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBAgAGBQJT0hcjAAoJEEkkwl4JtJ9yJx8P/3tGWbYBK+WFAmG0qWH8AJkI UjwNkNBri+p7GwaaHl/cnNrerTaNSFsRrusUvwr9UwSjn2xZgsYd+v/I97tMzORi sjLFYt7JM42/Hm3PmMshpr+B+8CX3oZ9NQa/vy6sJ4jZrYZ/GsjsFMB14HD8FG0I qbySRVxssrixl856ZVPae9W1aVK06oEAiANAQhZ/+ZJOdIMKB+32rXfdDHJR8jGA pseZG74xoZfjWkNQ0D4qmZfkJpeAk1wR1mAU1QE5nFSauvjqGEgYzzUokh3Tp/2/ zyl+dMgu6eG3rl+zrF8Pf6cDoLr2cM6SjlTq4ggMVITLl0CT6x2r9xJQVe8XdqrM LDAhjeHhzKrPbq3AmKKX3UBTj+01v/VdSp3ro73I4ruu8g6XSqF+2DQAOqLZ4qDH 66KZLewagdsuekwCx07jDHRFg840lKchUhXxtuu8GLb1KFIgdbYa4th2rP1U+idf NFHYmOMVyOE20hYa1F4mOI0bAYHThY3oqr4SxnqVYVl6+Rxu9OfBEEfkTi1i4wTz S807RR4N7LC7SbiNxaU3DULycZIDysaOv6f5xoJf8VvUBCis0cwahYzqUj1B97p9 fAYmEhmS7W/YS0R56dhi2S7v//VNbdpLhmpIXPhmwHjvBeyBoEskXovHcdu1wgSQ 58S1ykhVWcHgNpXvZa55 =OFL8 -----END PGP SIGNATURE-----

1 0

[Maria-discuss] race conditions after SIGTERM
by Reindl Harald 24 Jul '14

24 Jul '14

how can that script lead to a race condition where files are not fully written to disk? that never happens if the systemd-unit for the replication instance has "ExecStopPost=/usr/bin/sleep 1" and waits a while my only explaination is that mysqld returns after the SIGTERM from systemd before all data are completly written in some racy situations and so rsynced incompletly to the datadir of the other instance _________________________________________________________ #!/bin/bash systemctl stop replication.service systemctl stop mysqld.service rsync $RSYNC_PARAMS /mysql_replication/ /mysql_data/ systemctl start replication.service systemctl start mysqld.service _________________________________________________________ [Unit] Description=MariaDB Replication [Service] Type=simple PIDFile=/run/mysqld/mysqld_replication.pid ExecStart=/usr/libexec/mysqld --defaults-file=/etc/my-replication.cnf --pid-file=/run/mysqld/mysqld_replication.pid --socket=/var/lib/mysql/mysql_replication.sock --open-files-limit=30000 --basedir=/usr --user=mysql Environment="LANG=en_GB.UTF-8" Restart=always RestartSec=1 _________________________________________________________ 140724 12:22:59 [Note] /usr/libexec/mysqld: Shutdown complete 140724 12:23:01 [Note] Plugin 'InnoDB' is disabled. Cannot find checkpoint record at LSN (1,0x35767) 140724 12:23:01 [ERROR] mysqld: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files 140724 12:23:01 [ERROR] Plugin 'Aria' init function returned error. 140724 12:23:01 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed. 140724 12:23:01 [Note] Plugin 'FEDERATED' is disabled. 140724 12:23:01 [Note] Plugin 'FEEDBACK' is disabled. 140724 12:23:01 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables 140724 12:23:01 [ERROR] Aborting 140724 12:23:01 [Note] /usr/libexec/mysqld: Shutdown complete 140724 12:23:03 [Note] Plugin 'InnoDB' is disabled. Cannot find checkpoint record at LSN (1,0x35767)

1 0

[Maria-discuss] New Question: ST_Transform missing?
by AskMonty KB 24 Jul '14

24 Jul '14

Hello, A new question has been asked in "MariaDB community" by ronna: -------------------------------- Hi there, I just started using MariaDB. Mainly because of the support for GIS. But now I am trying to reproject some geometric objects and I find out there is no ST_Transform function? How can this be? I need it ;-) Is there another function for it? Or will there be support for it soon? I am now using 10.0.11 Thanks for the reply. Ron. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/st_transform-missing/

1 0

[Maria-discuss] MariaDB 10.1 as drop in replacement for mysql55-server-5.5.38-1.ius.el5
by Eero Volotinen 23 Jul '14

23 Jul '14

Hi List, Is it possible to use MariaDB 10.1 as drop-in replacement for mysql55-server-5.5.38-1.ius.el5? like: rpm -e mysql55.. files and then just use yum to install mariadb without reinstalling databases content? br, -- Eero

1 0

[Maria-discuss] Aria engine
by Roberto Spadim 22 Jul '14

22 Jul '14

Hi guys Why aria engine is a beta/alpha engine? -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

2 4

[Maria-discuss] Galera cluster with asynchronous slave
by Johnny Antonsen 21 Jul '14

21 Jul '14

Hi! First off let show you what we are trying to achieve, as a picture says more than a thousand words. galera I'm currently working on a high-availability project where we want to use MariaDB 10 and Galera as the backend. Running this system as it is with Haproxy and keepalived works great. We are able to write to the VIP that is being moved between each node and haproxy takes care of redirecting the server with least connections. The problem comes when we want to do a standard master/slave replication from the cluster to an external slave. The slave is set up to connect to the VIP (or I have also been testing with connecting directly to the haproxied ip), and Using_gtid is set to Slave_pos. However, after some time, once the connection changes to a different node through haproxy, the following error occurs: Got fatal error 1236 from master when reading data from binary log: 'Error: connecting slave requested to start from GTID 3-1-422, which is not in the master's binlog' And the Slave_IO_State shows that it's no longer in sync. I have run SELECT @@GLOBAL.gtid_slave_pos; to check what the current GTID for each node is, and they all return: 1-1-2145, however, sometimes if I add a lot of data, that value is different on some nodes, which is why I think the slave gets confused. On the slave, when activating using_gtid=slave_pos, the following gtid_IO_pos appear: 1-1-2464,2-3-420,3-1-422 From what I have read, this should be somewhat correct, as the first value is the server id. However, in the config I have specified that node 1 has server id 1, node 2 has id 2 and so on, and that the same goes for gtid_domain_id. Is this the correct setup or do the nodes need to have the same server-id or gtid_domain_id? Surely there must be a good way to solve this? Is the system not built to handle an asynchronous slave replicating from one random node? Hope I can get some good feedback on this. Just as a side-note, I'm fairly new to mariadb and galera cluster, so be gentle :) With best regards Johnny Antonsen

3 5

[Maria-discuss] MariaDB 10.0 + Master/Slave + spontanous Got fatal error 1236
by Erik Wasser 18 Jul '14

18 Jul '14

Hello *, I'm doing a master/slave setup in 2 OpenVZ hosts both with debian 7 and MariaDB 10.0 from the offical repository. The problem is that the slave sometimes bails out with the following error message: Got fatal error 1236 from master when reading data from binary log: 'binlog truncated in the middle of event; consider out of disk space on master; the first event 'mysql-bin.000073' at 33590521, the last event read from 'mysql-bin.000073' at 39362449, the last byte read from 'mysql-bin.000073' at 39362560.' Okay, no problem I start the replication with "START SLAVE" but the next error occurs within 5 minutes or so: Got fatal error 1236 from master when reading data from binary log: 'binlog truncated in the middle of event; consider out of disk space on master; the first event 'mysql-bin.000073' at 39362449, the last event read from 'mysql-bin.000073' at 48667806, the last byte read from 'mysql-bin.000073' at 48668672.' Sometimes it runs so for a week sometimes it fails 3 times within 15 minutes. It seems that the slave read some data and but the master havn't finished writing the data to the binlog. That should be impossible. So after starting the slave again everything is fine again. I can start the replication again with "START SLAVE" and everything is fine again for some times until the error appears again. And it's not that I'm running out of disc space I'm running here out of ideas. B-) Some other info: [mysqld] ... binlog-ignore-db = mysql binlog-ignore-db = test server_id = 10 log_bin = mysql-bin read_only = yes sync_binlog = 1 binlog_format = MIXED expire_logs_days = 14 max_allowed_packet = 1047527424 Any other "esoteric" ideas? -- Greetings... Erik Wasser

1 0

Re: [Maria-discuss] Increasing InnoDB page size in 10.1
by Tim Callaghan 15 Jul '14

15 Jul '14

Thanks, that is helpful. It would be good to capture this (and any other technical advantages) in the KB page itself. On Tue, Jul 15, 2014 at 3:44 AM, Jan Lindström <jan.lindstrom(a)skysql.com> wrote: > Hi, > > We had a customer request to increase the page size for uncompressed pages > to allow more blob fields in a table. This request is satisfied by this > implementation. While I was doing this enhancement, I did try to increase > the page size for compressed pages also but this proved too hard for time > constraints I had. I did try to discuss about the problems with only person > I know who really knows how compressed pages storage format is implemented > (Marko Mäkelä) but unfortunately, I did not get it to work with limited > help I received. As soon as I have again time, I will revisit this issue > and see what I can do. > > R: Jan > > > On Mon, Jul 14, 2014 at 4:07 PM, Tim Callaghan <tmcallaghan(a)gmail.com> > wrote: > >> I'm curious as to the reasoning behind this feature. I assumed it was to >> get better compression, but the kb page >> <https://mariadb.com/kb/en/mariadb/mariadb-documentation/mariadb-storage-eng…> >> states that compression will not be supported on the new 32K and 64K page >> size. >> >> -Tim Callaghan >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : maria-discuss(a)lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> >> > > > -- > > -- > > Jan Lindström, Principal Engineer > SkySQL - The MariaDB Company > > skype: jan_p_lindstrom > > www.skysql.com > <http://www.google.com/url?q=http%3A%2F%2Fwww.skysql.com%2F&sa=D&sntz=1&usg=…> > > [image: Twitter] > <http://www.google.com/url?q=http%3A%2F%2Ftwitter.com%2Fskysql&sa=D&sntz=1&u…> > [image: Blog] > <http://www.google.com/url?q=http%3A%2F%2Fwww.skysql.com%2Fblog%2F&sa=D&sntz…> > [image: Facebook] > <http://www.google.com/url?q=http%3A%2F%2Fwww.facebook.com%2Fskysql&sa=D&snt…> > [image: LinkedIn] > <http://www.google.com/url?q=http%3A%2F%2Fwww.linkedin.com%2Fcompany%2F12142…> > [image: Google+] <https://plus.google.com/117544963211695643458/posts> >

2 1

[Maria-discuss] maridb performance issue with master server replication
by Zakir Mahomedy 14 Jul '14

14 Jul '14

I been trying to trouble shoot this problem for sometime now in both mariadb and percona. I been trying to migrate from Mysql5.6 to mariadb or percona, however in our testings our business app performs terrible when multi master circular replication is on. Our setup, 2 servers same specs, running vmsphere 5.5. VMs are created and CentOs 6.5 installed. On the same hardware, same VM setups, we are running Mysql 5.6 com edition with GTID circular replication with no problems in performance. With Mariadb and Percona as soon as I start slave, the master server performs badly with our business app. If I had to run the same business app on the slave machine, while its receiving updates, no problems, but as soon as I make it a Master the performance drops. While all the binary logging stuff are on, without replication turned on by using start slave; the app performs fine as some people suggested that there might be a performance hit with sync-binlogs etc Ive started a thread about this on dba.stack which has my config files etc posted. http://dba.stackexchange.com/questions/71188/slow-writes-on-percona-server-… This is so far the only issue that is stopping us from migrating to mariadb, and its driving me nuts. Our servers are going through a vpn and is lagging 0 seconds behind master Does anyone have an idea what may be the problem. thanks zak |

1 0

[Maria-discuss] Increasing InnoDB page size in 10.1
by Tim Callaghan 14 Jul '14

14 Jul '14

I'm curious as to the reasoning behind this feature. I assumed it was to get better compression, but the kb page <https://mariadb.com/kb/en/mariadb/mariadb-documentation/mariadb-storage-eng…> states that compression will not be supported on the new 32K and 64K page size. -Tim Callaghan

1 0

[Maria-discuss] Building MariaDB audit plugin for Percona 5.5.37-rel35
by Nick Urbanik 10 Jul '14

10 Jul '14

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? 2. Does the user whitelist/blacklist feature work with Percona? 3. Does build/installation work in the same way as for MariaDB? -- Nick Urbanik http://nicku.org nicku(a)nicku.org GPG: 7FFA CDC7 5A77 0558 DC7A 790A 16DF EC5B BB9D 2C24 ID: BB9D2C24

2 3

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

09 Jul '14

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 to help with the install/config, and have been using it trouble-free for a few months now (love it for the most part), until now. Everything seems to be working fine, but since the upgrade to SOGo 2.2.4 on 6/12, which I am told increases the number of connections it uses to the DB, I have been getting very occasional errors like this (the system error is always either 104 or 0): 2014-06-12 03:30:15.530 sogo-tool[31674] ERROR: could not open MySQL4 connection to database 'sogo': Lost connection to MySQL server at 'reading authorization packet', system error: 104 <0x0x236c140[GCSChannelManager]> could not open channel <MySQL4Channel[0x0x22241b0] connection=0x(null)> for URL: mysql://user:password@myhost.com:3306/sogo/sogo_sessions_folder <0x0x236c140[GCSChannelManager]> will prevent opening of this channel 5 seconds after 2014-06-12 03:30:01 -0400 2014-06-12 03:30:15.531 sogo-tool[31674] Can't aquire channel But it only happened once per day after the upgrade, then once it happened twice (about 12 hours apart), and it happened at times when the load would be the lowest (ie, 3:30am for the one above). Googling reveals a lot of reports about this error over the years, some seemingly to be bugs, others DB tuning issues. Should I be looking at tuning: max_connections max_user_connections ? If not, does anyone know where I should start looking? Is there some kind of extra logging I could enable that wouldn't cause serious performance problems? Or... maybe this is simply not something I should be worried about? Thanks for any help/suggestions...

5 23

[Maria-discuss] max_connections variable
by Tanstaafl 08 Jul '14

08 Jul '14

Hello all, How is the max_connections variable used? Apparently it counts the max number of connections for all users combined, but is there a time factor? Ie, is it just simultaneous connections? Or max_connections per day? per hour? Thanks

4 3

[Maria-discuss] Galera cluster with asynchronous slave
by Johnny Antonsen 03 Jul '14

03 Jul '14

Hi! First off let show you what we are trying to achieve: Galera Cluster: MariaDBNode1 - HAProxy - keepalived <- MariaDBNode2 - HAProxy - keepalived <- MariaDB Slave node with GTID MariaDBNode3 - HAProxy - keepalived <- I'm currently working on a high-availability project where we want to use MariaDB 10 and Galera as the backend. Running this system as it is with Haproxy and keepalived works great. We are able to write to the VIP that is being moved between each node and haproxy takes care of redirecting the server with least connections. The problem comes when we want to do a standard master/slave replication from the cluster to an external slave. The slave is set up to connect to the VIP (or I have also been testing with connecting directly to the haproxied ip), and Using_gtid is set to Slave_pos. However, after some time, once the connection changes to a different node through haproxy, the following error occurs: Got fatal error 1236 from master when reading data from binary log: 'Error: connecting slave requested to start from GTID 3-1-422, which is not in the master's binlog' And the Slave_IO_State shows that it's no longer in sync. I have run SELECT @@GLOBAL.gtid_slave_pos; to check what the current GTID for each node is, and they all return: 1-1-2145, however, sometimes if I add a lot of data, that value is different on some nodes, which is why I think the slave gets confused. On the slave, when activating using_gtid=slave_pos, the following gtid_IO_pos appear: 1-1-2464,2-3-420,3-1-422 From what I have read, this should be somewhat correct, as the first value is the server id. However, in the config I have specified that node 1 has server id 1, node 2 has id 2 and so on, and that the same goes for gtid_domain_id. Is this the correct setup or do the nodes need to have the same server-id or gtid_domain_id? Surely there must be a good way to solve this? Is the system not built to handle an asynchronous slave replicating from one random node? Hope I can get some good feedback on this. Just as a side-note, I'm fairly new to mariadb and galera cluster, so be gentle :) With best regards Johnny Antonsen

1 0

[Maria-discuss] information about functions
by Roberto Spadim 02 Jul '14

02 Jul '14

hi guys! does information plugin show something about, what functions i'm using in my mariadb server? for example, i want know what udf functions are being executed and for a second step, there's something to block functions ? like some user only use sum() and min() max(), i want to block count() function -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

2 1

Re: [Maria-discuss] Utexas MariaDb Repository Down?
by Colin Charles 30 Jun '14

30 Jun '14

Hi! On 30 Jun 2014, at 09:25, Dirk Collins <collins.dirk(a)gmail.com> wrote: > I have not been able to download MariaDB from the UTexas Austin secured archive... The files are being corrupted by the server there, and it doesn't seem like the Java Web Publishing app they are using down there is working properly. > > Is there any alternative cloud servers or torrents where I can download 10.0.12 for Windows, either as an MSI or Zip file? You might try: http://ftp.osuosl.org/pub/mariadb/mariadb-10.0.12 And for the Windows files, they are: http://ftp.osuosl.org/pub/mariadb/mariadb-10.0.12/winx64-packages/ HTH -- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles

1 0

[Maria-discuss] New Question: Support for non autoincrement kes
by AskMonty KB 28 Jun '14

28 Jun '14

Hello, A new question has been asked in "Archive" by openiduser42: -------------------------------- This documentation says "ARCHIVE allows a maximum of one key. The key can be a PRIMARY KEY on an AUTO_INCREMENT column. However, it has a limitation ...". This sounds like AUTO_INCREMENT is an optional setting that causes a limitation, but trying to create an archive without auto increment gives an error: CREATE TABLE t1 (id int NOT NULL, PRIMARY KEY (id)) ENGINE = ARCHIVE; Error: Can't create table `test`.`t1` (errno: 140 "Wrong create options") Just adding AUTO_INCREMENT solves the problem. So, is this a bug or AUTO_INCREMENT is mandatory for ARCHIVE tables? If so, the documentation should say MUST, not CAN. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/support-for-non-autoincrement-kes/

1 0

[Maria-discuss] New Question: Connect Spring Hibernate and C3p0 application to Mariadb through SSL certificate authentication.
by AskMonty KB 25 Jun '14

25 Jun '14

Hello, A new question has been asked in "MariaDB FAQ" by ashishjagtap: -------------------------------- I have created application in Spring,Hibernate and c3p0 which is now connecting to Mysql database. now we are migrating our application to MariaDB (Server version: 5.5.5-10.0.7-MariaDB Source distribution) through SSL. following is the configuration file that we are using to connect to Mysql database JDBC.properties jdbc.initialPoolSize=10 jdbc.maxPoolSize=30 jdbc.minPoolSize=5 jdbc.acquireIncrement=3 jdbc.acquireRetryAttempts=0 jdbc.preferredTestQuery=SELECT 1 jdbc.idleConnectionTestPeriod=600 jdbc.numHelperThreads=10 jdbc.debugUnreturnedConnectionStackTraces=true jdbc.mydbUrl=jdbc:mysql://myhost.com:3306/mydb?verifyServerCertificate=true&useSSL=true&requireSSL=true&characterEncoding=utf8 jdbc.mydbUsername=myuser datasource-context.xml <bean id="mydbCommon" class="com.mchange.v2.c3p0.ComboPooledDataSource" abstract="true" destroy-method="close"> <property name="driverClass" value="${jdbc.rptdbDriverClassName}"/>  <property name="initialPoolSize" value="${jdbc.initialPoolSize}"/> <property name="maxPoolSize" value="${jdbc.maxPoolSize}"/> <property name="minPoolSize" value="${jdbc.minPoolSize}"/> <property name="acquireIncrement" value="${jdbc.acquireIncrement}"/> <property name="acquireRetryAttempts" value="${jdbc.acquireRetryAttempts}"/> <property name="preferredTestQuery" value="${jdbc.preferredTestQuery}"/> <property name="idleConnectionTestPeriod" value="${jdbc.idleConnectionTestPeriod}"/> <property name="numHelperThreads" value="${jdbc.numHelperThreads}"/> <property name="debugUnreturnedConnectionStackTraces" value="${jdbc.debugUnreturnedConnectionStackTraces}"/> </bean> <bean id="mydb" parent="mydbCommon"> <property name="jdbcUrl" value="${jdbc.mydbUrl}"/> <property name="user" value="${jdbc.mydbUsername}"/> </bean> we are able to connect to DB server through command line using following command mysql -h myhost.com -P3306 -umyuser --ssl-ca ca.crt --ssl-cert app.crt --ssl-key my-key.key now how can I specify --ssl-ca,--ssl-cert and --ssl-cert files while connecting to MariaDB through Hibernate and c3p0. or what is the steps to connect to MariaDB database through SSL using c3p0 and hibernate. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/connect-spring-hibernate-and-c3p0-application-to-m…

1 0