August 2014 - discuss - lists.mariadb.org

[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