- discuss - lists.mariadb.org

Re: [Maria-discuss] MariaDB,TokuDB and FusionIO
by Dhananjoy Das 30 Sep '14

30 Sep '14

Hi Christophe, This is Dhananjoy Das (Joy) from SanDisk (formally Fusion-io inc.,) contributor to the NVM Compression. In regards to your query on access to NVMFS, yes currently its supported on Atomics Series of ioMemory cards(PX/SX), I would suggest its best to get in touch with the SanDisk Sales team (formally Fusion-io inc.,) and request for the LA NVMFS 1.0 (Limited Edition). Additionally, NVM Compression (changes are part of InnoDB/XtraDB) is independent of the TokuDB DB-engine. Hope that help, feel free to reach out. Thanks, Dhananjoy Das (Joy) mailto:Dhananjoy.Das@SanDisk.com Sr. Architect, SanDisk Corporation From: Christophe Le Roux <christophe.le.roux(a)fr.clara.net<mailto:christophe.le.roux@fr.clara.net>> Subject: [Maria-discuss] MariaDB,TokuDB and FusionIO Date: 26 September 2014 19:05:49 GMT+8 To: "maria-discuss(a)lists.launchpad.net<mailto:maria-discuss@lists.launchpad.net>" <maria-discuss(a)lists.launchpad.net<mailto:maria-discuss@lists.launchpad.net>> 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/> [cid:C1D6FBD4-E7DA-4EF6-A28E-00B0FF3DA706]<http://www.claranet.fr/> [cid:7968F977-345B-49BE-B90E-B0E5C25851A5]<http://www.linkedin.com/company/claranet> [cid:3F049FCF-C7CF-42AA-B1BF-9AABDFA7AF7A]<https://twitter.com/#!/Claranet_FR> [cid:88A700FC-5D51-471E-8AF6-E8F2220BA02D]<http://www.youtube.com/user/ClaranetFR> [cid:4F716A83-5DA5-4C6B-AF45-AED5D649A6B9]<http://www.claranet.fr/propos-de/gartner.html> This e-mail (and any attachments) is confidential and may be privileged. Any unauthorized use, copying, disclosure or dissemination of this communication is prohibited. If you are not the intended recipient, please notify the sender immediately and delete all copies of the message and its attachments.

2 1

[Maria-discuss] MariaDB Cluster wont start
by Carlos Raúl Laguna 30 Sep '14

30 Sep '14

I have a 3node galera-mariadb10 cluster working without issues until today in ubuntu 14.04, all node stop, all i can grasp from mysqld is this: [Warning] option 'table_cache': unsigned value 2097152 adjusted to 524288 [Note] WSREP: Read nil XID from storage engines, skipping position init [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so' [Note] WSREP: wsrep_load(): Galera 25.3.5-wheezy(rXXXX) by Codership Oy < info(a)codership.com> loaded successfully. [Note] WSREP: CRC-32C: using hardware acceleration. [Note] WSREP: Found saved state: 193c65da-169f-11e4-a58c-ba3055701076:-1 [Note] WSREP: Passing config to GCS: base_host = 172.17.1.2; base_port = 4567; cert.log_conflicts = no; debug = no; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 1; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo = false; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = P30S; pc.weight = 1; protonet. Note] WSREP: Service thread queue flushed. [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 [Note] WSREP: wsrep_sst_grab() [Note] WSREP: Start replication [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 [Note] WSREP: protonet asio version 0 [Note] WSREP: Using CRC-32C (optimized) for message checksums. [Note] WSREP: backend: asio [Note] WSREP: GMCast version 0 [Note] WSREP: (d35fbdc5-47fa-11e4-88ce-ebeacde19e39, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 140929 13:05:34 [Note] WSREP: (d35fbdc5-47fa-11e4-88ce-ebeacde19e39, 'tcp:// 0.0.0.0:4567') multicast: , ttl: 1 [Note] WSREP: EVS version 0 [Note] WSREP: PC version 0 [Note] WSREP: gcomm: connecting to group 'baruwa_cluster', peer 'baruwadb1:,baruwadb2:,baruwadb3:' [Warning] WSREP: (d35fbdc5-47fa-11e4-88ce-ebeacde19e39, 'tcp://0.0.0.0:4567') address 'tcp://172.17.1.2:4567' points to own listening address, blacklisting [Warning] WSREP: no nodes coming from prim view, prim not possible [Note] WSREP: view(view_id(NON_PRIM,d35fbdc5-47fa-11e4-88ce-ebeacde19e39,1) memb { d35fbdc5-47fa-11e4-88ce-ebeacde19e39,0 } joined { } left { } partitioned { }) [Note] WSREP: gcomm: connected 7 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) [Note] WSREP: Opened channel 'baruwa_cluster' [Note] WSREP: Waiting for SST to complete. [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 [Note] WSREP: Received NON-PRIMARY. [Note] WSREP: New cluster view: global state: :-1, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version -1 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.5018S), skipping check my.cnf: #galera settings wsrep_provider=/usr/lib/galera/libgalera_smm.so wsrep_cluster_address="gcomm://baruwadb1,baruwadb2,baruwadb3?pc.wait_prim=no" wsrep_sst_method=rsync wsrep_cluster_name="baruwa_cluster" Any help will be appreciated. Thanks and regards

2 6

[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