- discuss - lists.mariadb.org

[Maria-discuss] New Question: MariaDB Installation error
by AskMonty KB 20 Jul '16

20 Jul '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-installation-error/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I am getting error with ibdata1 auto extending of the files when running mysql_install_db and it fills the file with zeroes. But when i delete the ibdata and run the mysql_install_db again everything goes fine. Also the size in my.cnf file is innodb_data_file_path = ibdata1:100M:autoextend InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data! How exactly to resolve the error? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-installation-error/

1 0

[Maria-discuss] Key lengths for file_key_management plugin
by Honza Horak 19 Jul '16

19 Jul '16

I've asked directly in the documentation page, but maybe someone will know answer here: https://mariadb.com/kb/en/mariadb/data-at-rest-encryption/#comment_2346 In that article it is said that 128, 192 or 256-bit keys are supported, but later AES_CTR and AES_CBC modes talk only about 128bit keys. What piece of information am I missing? Honza

2 3

[Maria-discuss] maillist break dkim signed mails
by Benny Pedersen 18 Jul '16

18 Jul '16

but when will it stop that practice ?

2 1

[Maria-discuss] MariaDB 10.1.16 now available
by Daniel Bartholomew 18 Jul '16

18 Jul '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.16. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.16 - Release Notes: https://mariadb.com/kb/en/mdb-10116-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10116-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.16 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ 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 - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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/donate/ 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] after set replicate_wild_do_table, binlog file could not update ?
by Ljr Yang 15 Jul '16

15 Jul '16

Hi, all Today, we setup new master/slave (both MariaDB 10.1.14), add log_slave_updates=1, log_bin , relay_log parameters in slave's my.cnf file. in mariadb client , execute below command, when master update, slave replication normal , and log_bin and relay_log file could update normal too. stop slave; set global replicate_wild_do_table='test01.%,mysql.%' ; start slave; IF add replicate_wild_do_table='test01.%,mysql.%' in slave's my.cnf file and restart salve, replication normal, relay_log file could update, but log_bin file could not update. we test four machines, all have the problem . Please help confirm ,thanks . Ljr

2 1

[Maria-discuss] mariadb-connect-engine-10.1 : Depends: unixODBC but it is not installable
by Umarzuki Mochlis 15 Jul '16

15 Jul '16

2 of 3 mariadb servers 10.1, ubuntu 16.04 unable to install mariadb-connect-engine-10.1 with error The following packages have unmet dependencies: mariadb-connect-engine-10.1 : Depends: unixODBC but it is not installable E: Unable to correct problems, you have held broken packages. I fould bugreport at https://jira.mariadb.org/browse/MDEV-10032 but it seems stalled? One other thing to note, apt-get upgrade does not upgrade mariadb to 10.1.15, only on the one that successfully installed mariadb-connect-engine-10.1 How do I solve this? I already tried apt-get purge mariadb* then reinstall but still same.

3 8

[Maria-discuss] New Question: Galera Cluster In MariaDB Tarball 10.1.14
by AskMonty KB 15 Jul '16

15 Jul '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/galera-cluster-in-mariadb-tarball-10114/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I am not able to configure mariadb galera cluster using mariadb-enterprise-10.1.14-linux-x86_64.tar.gz file as there are no galera libraries. is it possible to configure galera cluster using this tarball package. please provide a link from where to download galera libraries for tarball packages. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/galera-cluster-in-mariadb-tarball-10114/

1 0

[Maria-discuss] New Question: Moving mariadb to docker installation
by AskMonty KB 12 Jul '16

12 Jul '16

Hello, A new question has been asked in "MariaDB Community" by kitzu. Please answer it at http://mariadb.com/kb/en/moving-mariadb-to-docker-installation/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm running debian jessie and I'm currently trying to replace all my server services with docker containers. After some research, i tried this command: docker run --name mariadb -v /var/lib/mysql:/var/lib/mysql -d -p 3306:3306 -d mariadb:latest after stopping the local mariadb service, but this command didn't work. My webapplications didn't have any database access after. How do i currently move all databases? Is there a more secure way? I just want a drop-in replacement. Starting the docker container and using the mariadb server as I used to. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/moving-mariadb-to-docker-installation/

1 0

[Maria-discuss] replicate to multimaster
by Umarzuki Mochlis 12 Jul '16

12 Jul '16

Hi, I have a single Mariadb server 10.1 on Ubuntu 14.04 and 3 Mariadb 10.1 servers on Ubuntu 16.04 with multimaster setup (galera). Is it possible to setup replication from single server to one of multimasters to keep databases and grants updated on multimaster servers? Or should I export databases and grants from single server to any member os multimaster servers? Thanks for any tips/hints.

3 3

[Maria-discuss] Designated donor.
by Thorvald Hallvardsson 08 Jul '16

08 Jul '16

Hi, I want to configure my cluster of 3 nodes let's call them sql1, sql2, sql3 in the way that maxscale will only balance request to sql1 and sql2 but sql3 will be only for backup/donor purposes. My question is... how can I set permanent donor in galera ? Is wsrep_sst_donor the thing ? Thank you. Regards, TH

4 6

[Maria-discuss] Unable to build connector-c
by Muhammad Bashir Al-Noimi 06 Jul '16

06 Jul '16

Hi, I want to use mariadb client for Qt so I tried to build mariadb-connector-c using the following parameters under Linux Mint 17.3 x64 xfce: #!/bin/bash version=2.3.0 pkg=mariadb-connector-c-$version-src.tar.gz url=https://downloads.mariadb.org/f/connector-c-$version/$pkg dir=$(basename $pkg .tar.gz) if [ ! -d $dir ]; then wget -c $url tar -xf $pkg || exit 1 fi pushd $dir sed -i -e"s|ADD_SUBDIRECTORY(unittest/libmariadb)|#ADD_SUBDIRECTORY(unittest/libmariadb)|" CMakeLists.txt sed -i -e"N; s|typedef unsigned short ushort;\n#endif|#endif\ntypedef unsigned short ushort;|" include/my_global.h sed -i -e"N; s|SET_TARGET_PROPERTIES(libmariadb PROPERTIES VERSION.*||" libmariadb/CMakeLists.txt sed -i -e"N; s|SOVERSION \${CPACK_PACKAGE_VERSION_MAJOR})||" libmariadb/CMakeLists.txt # Pig disgusting: the previous multiline thingie should've done it sed -i -e"N; s|\${CPACK_PACKAGE_VERSION_MAJOR}||" libmariadb/CMakeLists.txt # Pig disgusting: what the fuck mkdir build pushd build PKG_CONFIG_PATH=$SR/usr/lib/pkgconfig cmake \ -DCMAKE_BUILD_TYPE=Release \ -DCMAKE_C_FLAGS=--sysroot="$SR" \ -DCMAKE_INSTALL_PREFIX="$SR/usr" \ -DCMAKE_C_COMPILER="$BR"gcc \ -DCMAKE_LINKER="$BR"ld \ -DCMAKE_AR="$BR"ar \ -DCMAKE_NM="$BR"nm \ -DCMAKE_OBJCOPY="$BR"objcopy \ -DCMAKE_OBJDUMP="$BR"objdump \ -DCMAKE_RANLIB="$BR"ranlib \ -DCMAKE_STRIP="$BR"strip \ -DICONV_INCLUDE_DIR="$SR/usr/include" \ -DICONV_LIBRARIES="$SR/usr/lib/libiconv.a" \ -DWITH_EXTERNAL_ZLIB=ON \ -DZLIB_INCLUDE_DIR="$SR/usr/include" \ -DZLIB_LIBRARY="$SR/usr/lib/libz.so" ../ || exit 1 make install || exit 1 popd # ??? pwd cp build/libmariadb/*.{a,so}"$SR/usr/lib/mariadb/" || exit 1 popd But I get this error message: /home/mbnoimi/Snippets/Scripts/Shell/create-mysql-qt-android-plugin/mariadb-connector-c-2.3.0-src/libmariadb/my_context.c: In function 'my_context_init': /home/mbnoimi/Snippets/Scripts/Shell/create-mysql-qt-android-plugin/mariadb-connector-c-2.3.0-src/libmariadb/my_context.c:129:11: error: missing binaryoperator before token"(" #if sizeof(char *) > SIZEOF_INT*2 ^ make[2]: *** [libmariadb/CMakeFiles/mariadb_obj.dir/my_context.c.o] Error 1 make[1]: *** [libmariadb/CMakeFiles/mariadb_obj.dir/all] Error 2 make: *** [all] Error 2 Changes: diff: ./rootfs_files_before.txt: No such file or directory mbnoimi@mbnoimi-laptop ~/Snippets/Scripts/Shell/create-mysql-qt-android-plugin $ How can I fix this issue? NOTE: For full thread about this issue you can use this link <https://forum.qt.io/topic/69038/unable-to-build-mysql-plugin>. -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi

1 0

[Maria-discuss] Unable to build connector-c
by Muhammad Bashir Al-Noimi 06 Jul '16

06 Jul '16

1 0

[Maria-discuss] Regarding DR site set-up
by Karthick Subramanian 05 Jul '16

05 Jul '16

Dear Experts, I have a question on Max Scale requirement: In prod - we have two DB server as Primary(Master) and Secondary(Slave). Both being controlled via MaxScale. Do we need to really set it up similar way in DR site also? I meant - Do we need to keep Max Scale set it up in DR as well. Anyway, DR is going to be exceptional scenarios in which entire application servers also work out of DR site and we can still point all the app servers in DR site configured directly to access the Maria DB server at DR instead of Max Scale. Note: We are currently not using MaxScale for any complex needs, we are using MaxScale for normal routing like RW split etc. I know ideal is keep both Prod site and DR site equivalent. But as cost cutting on servers etc, shall we keep DR the way I mentioned. Could you please provide your opinion on this. Regards, Karthick

2 3

[Maria-discuss] MariaDB 10.2.1 Alpha and other releases now available
by Daniel Bartholomew 04 Jul '16

04 Jul '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.1 Alpha. Also now available are the following Stable (GA) releases: MariaDB Connector/C 2.3.0, MariaDB Galera Cluster 5.5.50, and MariaDB Galera Cluster 10.0.26. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.2.1 Alpha - Release Notes: https://mariadb.com/kb/en/mdb-1021-rn/ - Changelog: https://mariadb.com/kb/en/mdb-1021-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.2.1 About MariaDB 10.2: - https://mariadb.com/kb/en/what-is-mariadb-102/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/C 2.3.0 - Release Notes: https://mariadb.com/kb/en/mcc-230-rn/ - Changelog: https://mariadb.com/kb/en/mcc-230-cl/ - Downloads: https://downloads.mariadb.org/connector-c/2.3.0/ About MariaDB Connector/C: - https://mariadb.com/kb/en/about-mariadb-connector-c/ MariaDB Galera Cluster 5.5.50 - Release Notes: https://mariadb.com/kb/en/mgc-5550-rn/ - Changelog: https://mariadb.com/kb/en/mgc-5550-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.50/ About MariaDB Galera Cluster: - https://mariadb.com/kb/en/about-mariadb-galera-cluster/ MariaDB Galera Cluster 10.0.26 - Release Notes: https://mariadb.com/kb/en/mgc-10026-rn/ - Changelog: https://mariadb.com/kb/en/mgc-10026-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.26/ About MariaDB Galera Cluster: - https://mariadb.com/kb/en/about-mariadb-galera-cluster/ - - 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 - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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/donate/ 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] Expanding Galera cluster
by Thorvald Hallvardsson 04 Jul '16

04 Jul '16

Hi guys, I need some help as I'm preparing to expand my existing Galera cluster. Generally the purpose of it is I need to replace 3 VMs I have a cluster running on to 2 physical servers I have been given for that purpose. My idea was to join 2 physical cluster to the existing cluster of 3 and then remove all 3 VMs from the cluster leaving 2 physical nodes within. I have a arbitrator box within the cluster as well. The config at the moment contains 2 maxscale proxy nodes on the front balancing the read queries across the entire cluster of 3 and write queries to the elected master. What I want to achieve is as I said above but + I will need another help with maxscale to expand and then shrink the cluster down to 2 nodes afterwards. I have had a situation before when I had to do a simple config change on the Galera cluster and I was trying to mark nodes and put them into maintenance mode to stop traffic coming to them but the commands like set server NODE master didn't actually do anything. I had situations when I had 2 masters in the cluster for a second because then something was happening that my manually selected master was becoming a slave again. I couldn't find anything on the internet what would point me into right direction and explain the whole procedure in details. My cluster is quite busy at the moment even overnight so there is no perfect time to do anything on it. I need to do it the least disruptive way and the most controlled way as well. Hence I'm asking for help and suggestions as I found both Galera and maxscale documentation very very brief not actually providing any decent details or procedures. I found much more help from Percona but descriptions don't match sometimes. Please help. Regards, TH

2 2

[Maria-discuss] New Question: Aggregating data with help tables will raise open table cache - solution?
by AskMonty KB 04 Jul '16

04 Jul '16

Hello, A new question has been asked in "MariaDB Community" by TDS. Please answer it at http://mariadb.com/kb/en/aggregating-data-with-help-tables-will-raise-open-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello, I need some inspiration :-) Currently we have ~10 tables, each around 3 million rows and about 100 columns in MyISAM format. These table are only for writing data. A cronjob will aggregate data from these tables to time defined tables, e.g. min, hour, day, etc. And here is the problem: With CREATE TABLE and CREATE TEMPORARY TABLE there are difficulties. We create a table, read in data from main table, calculating values and write new data to time table. After that we delete the help table. But the table open cache gets bigger and bigger (>4000 in a day). So how can we avoid this? Switching to InnoDB or use another schema of aggregating values? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/aggregating-data-with-help-tables-will-raise-open-…

1 0

[Maria-discuss] New Question: explanation of the salt statement
by AskMonty KB 04 Jul '16

04 Jul '16

Hello, A new question has been asked in "Encryption, Hashing and Compression Functions" by max-well_57049. Please answer it at http://mariadb.com/kb/en/explanation-of-the-salt-statement/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello together, I just saw the 'salt' Statement as I traces a login to MariaDB database. Could you explain me what this string is used for? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/explanation-of-the-salt-statement/

1 0

[Maria-discuss] bootstrap okay but wsrep_cluster_size 0
by Umarzuki Mochlis 04 Jul '16

04 Jul '16

2 1

[Maria-discuss] MariaDB 10.1.15 Released and Crash
by Alex 02 Jul '16

02 Jul '16

Hi, Last night one of my servers updated MariaDB to 10.1.15 and it started to crash every few minutes since the update ( from 10.1.14 -> 10.1.15 ). ------------ 160702 10:22:13 [ERROR] mysqld got signal 11 ; 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 https://mariadb.com/kb/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: 10.1.15-MariaDB key_buffer_size=268435456 read_buffer_size=524288 max_used_connections=8 max_threads=1001 thread_count=4 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1804821 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x7f5a89876008 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 = 0x7f5ab5dd9058 thread_stack 0x48400 /usr/sbin/mysqld(my_print_stacktrace+0x2b)[0x7f5c9736641b] /usr/sbin/mysqld(handle_fatal_signal+0x475)[0x7f5c96ec29f5] /lib64/libpthread.so.0(+0xf7e0)[0x7f5c964c77e0] /usr/sbin/mysqld(_ZN10SQL_SELECT17test_quick_selectEP3THD6BitmapILj64EEyybbb+0x1fe5)[0x7f5c96fae535] /usr/sbin/mysqld(+0x49bb90)[0x7f5c96d92b90] /usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0x1e2e)[0x7f5c96da1e9e] /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x20)[0x7f5c96da2fe0] /usr/sbin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x9d)[0x7f5c96da313d] /usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x25d)[0x7f5c96da6add] /usr/sbin/mysqld(+0x451d52)[0x7f5c96d48d52] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x5d7f)[0x7f5c96d5500f] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x28d)[0x7f5c96d5854d] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x243b)[0x7f5c96d5b1ab] /usr/sbin/mysqld(_Z10do_commandP3THD+0x16b)[0x7f5c96d5b75b] /usr/sbin/mysqld(_Z26threadpool_process_requestP3THD+0xa7)[0x7f5c96e51777] mysys/stacktrace.c:247(my_print_stacktrace)[0x7f5c96e9c425] sql/signal_handler.cc:160(handle_fatal_signal)[0x7f5c964bfaa1] sql/opt_range.cc:12843(get_sel_arg_for_keypart)[0x7f5c949a4a8d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f5aaf1b5020): is an invalid pointer Connection ID (thread ID): 456 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=on,exists_to_in=on,orderby_uses_equalities=off ------------ Anyone else encountered crashes on 10.1.15 ? Regards

2 3

[Maria-discuss] New Question: statement metadata
by AskMonty KB 01 Jul '16

01 Jul '16

Hello, A new question has been asked in "Stored Programs and Views" by raphael.quadrini. Please answer it at http://mariadb.com/kb/en/statement-metadata/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, Is there an equivalent function or stored procedure to Sql Server sys.dm_exec_describe_first_result_set? The goal is not to get the table or view metadata but the returned dataset metadata of a statement indead. thanks -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/statement-metadata/

1 0

[Maria-discuss] New Question: No of MariaDB Instances on MONyog
by AskMonty KB 01 Jul '16

01 Jul '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/no-of-mariadb-instances-on-monyog/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How many instances of mariadb can be installed with MONyog. If it depends on license please mention various licences and no of instances of types of licences. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/no-of-mariadb-instances-on-monyog/

1 0

[Maria-discuss] New Question: MONyog version detection
by AskMonty KB 30 Jun '16

30 Jun '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/monyog-version-detection/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to identify which version of MONyog is currently running when we are using the tarball installation?? This situation arises when I havent installed MONyog and I am a user who wwants to find which MONyog version is being used. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-version-detection/

1 0

[Maria-discuss] New Question: Swap usage won't decrease
by AskMonty KB 28 Jun '16

28 Jun '16

Hello, A new question has been asked in "MariaDB FAQ" by alexandraarreaza. Please answer it at http://mariadb.com/kb/en/swap-usage-wont-decrease/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- We have a 5 DB nodes Galera Cluster in Production (MariaDB 10.0). About a week ago a DB import was performed over an existing DB (Its size ~30G) and during this process, all DB nodes started complaining about swap usage and haven't stopped complaining since then (e.g: One of them would be using 814 MB out of 4095 MB). I have read a good few articles about MySQL and swapping issues (this is a good one: https://blog.jcole.us/2010/09/28/mysql-swap-insanity-and-the-numa-architect…) and also about swapping in MariaDB (https://mariadb.com/kb/en/mariadb/configuring-swappiness/) but still can't find out a way of solving this problem without restarting MySQL. We have NUMA architecture with 2 nodes and 96G of RAM. Our buffer pool size is 70G and it is set to use 12 innodb_buffer_pool_instances. 1) Is there any fix to this situation besides restarting MySQL? 2) Is there a way of tuning our cluster to avoid swapping in the future? Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/swap-usage-wont-decrease/

1 0

[Maria-discuss] columnstore
by Roberto Spadim 28 Jun '16

28 Jun '16

Hi guys! anyone testing columnstore? i will test in a SCADA system this week, news and problems i will report here -- Roberto Spadim

2 2

[Maria-discuss] No Response From MariaDB Support Admin
by Tom Jay 28 Jun '16

28 Jun '16

Hello, I emailed support-admin(a)mariadb.com about a problem with the mariadb.com website. I have not yet received a response. Is there anyone else I can contact with my query? Thanks. Tom

2 1

[Maria-discuss] New Question: Problem Connector ODBC between MariaDB and ACCESS
by AskMonty KB 27 Jun '16

27 Jun '16

Hello, A new question has been asked in "MariaDB Connector/ODBC" by jlpierrey_52563. Please answer it at http://mariadb.com/kb/en/problem-connector-odbc-between-mariadb-and-access/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello, I have a problem with the connection between ACCESS (2010), running with W7, and a MariaDB installed on a Synology NAS (DS212J). Test of DSN is OK. Import and link tables from NAS towards ACCESS are OK. But export from ACCESS is impossible: alert message says: " "ODBC l'appel a échoué (the call failed) [ma-2.0.10][5.5.49-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '#O),'C_UFR' INTEGER('#O),'U_SECRETARIAT' VARCHAR,'U-2SECRETARIAT' VAR at line 1 (#1064)" I thank you Complementary Infos: The pb is the same with 1.0.6 2.0.10 2.0.11 releases of mariadb connector (32 and 64 bits) C_UFR, U_SECRETARIAT ant U_2SECRETARIAT are the three first fields of the table i try to export. Setting of the NAS: • Serveur : Localhost via UNIX socket • Type de serveur : MariaDB • Version du serveur : 5.5.49-MariaDB - Source distribution • Version du protocole : 10 • Jeu de caractères du serveur : UTF-8 Unicode (utf8) Serveur Web: • nginx/1.9.11 • Version du client de base de données : libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ • Extension PHP : mysqli curl mbstring • Version de PHP : 5.6.21 -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/problem-connector-odbc-between-mariadb-and-access/

1 0

[Maria-discuss] New Question: MariaDB Backup using CommVault MYSQL iDataAgent
by AskMonty KB 27 Jun '16

27 Jun '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-backup-using-commvault-mysql-idataagent/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Commvault idatagent supports mariadb but i want to know which backup utility scripts are used by idataagent to backup the database. Also does it Backup all storage engines or not? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-backup-using-commvault-mysql-idataagent/

1 0

[Maria-discuss] New Question: MONyog Monitoring when password changed
by AskMonty KB 27 Jun '16

27 Jun '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/monyog-monitoring-when-password-changed/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to get an alert whenever the user with which we are monitoring changes password in the mariadb database ?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-monitoring-when-password-changed/

1 0

[Maria-discuss] New Question: Snchronizing MONyog on two servers
by AskMonty KB 27 Jun '16

27 Jun '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/snchronizing-monyog-on-two-servers/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to monitor MariaDB database from two servers where MONyog is installed and keep them synchronized. By Synchronization i mean if i add a new monitor on one server then that monitor should automatically be added on the second server?? This is important as if one server where monitoring is done goes down MONyog wil stop monitoring the database. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/snchronizing-monyog-on-two-servers/

1 0

[Maria-discuss] Reg .Net with Entity Framework (ORM)
by Karthick Subramanian 27 Jun '16

27 Jun '16

Hi All, We would like to check whether any of you using .Net with Entity Framework to access Maria DB. If yes, 1. What connector is being used 2. What challenges are facing 3. Any other points that I need to take care while workign with .Net Entity Framework with MariaDB Regards, Karthick

3 2

[Maria-discuss] Include TokuDB Hot Backup in the bundled plugin list
by jocelyn fournier 26 Jun '16

26 Jun '16

Hi, In MariaDB, TokuDB is bundled as a plugin, but it's not the case for the Hot Backup plugin (https://github.com/percona/tokudb-backup-plugin) I have to compile it manually against the server source code to have it working properly. Would it be possible to include it in the bundled plugins ? Thanks! Jocelyn -- Jocelyn Fournier Founder M : +33 6 51 21 54 10 https://www.softizy.com Softizy - At your side to Optimize your PHP / MySQL applications

2 1

[Maria-discuss] New Question: Enabling SSL in mariaDB running on Synology NAS
by AskMonty KB 25 Jun '16

25 Jun '16

Hello, A new question has been asked in "Secure Connections" by og_117488504109613889882. Please answer it at http://mariadb.com/kb/en/enabling-ssl-in-mariadb-running-on-synology-nas/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I am having problems with enabling SSL in MariaDB running on Synology NAS (DSM version 6.0) using self signed certificates. I have modified the my.cnf file to point to certificate files and the DB seems to be loading the .cnf file ok, the ssl variables are listing the corect location of the cert files (verified over phpmyadmin) however it still says that ssl is diabled (variable have_ssl=disabled) and the DB is refusing incoming ssl connections. This is my first time working with Synology NAS so I have no idea what to try, so any help or suggestion is most welcome. Thank you in advance. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/enabling-ssl-in-mariadb-running-on-synology-nas/

1 0

[Maria-discuss] MariaDB 10.0.26 now available
by Daniel Bartholomew 24 Jun '16

24 Jun '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.26. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.26 - Release Notes: https://mariadb.com/kb/en/mdb-10026-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10026-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.0.26 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 - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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/donate/ 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] New Question: Traffic Handling For Database Monitoring
by AskMonty KB 24 Jun '16

24 Jun '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/traffic-handling-for-database-monitoring/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- MONyog uses port 5555 for Monitoring the mariadb database which creates a connection on port 3306 on database server. Does this connection creates more load on the 3306 port??? and is there any way to change the port and get the connection established at some other port on which mysqld is not running?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/traffic-handling-for-database-monitoring/

1 0

[Maria-discuss] New Question: US Export Control Classification Number (ECCN)
by AskMonty KB 21 Jun '16

21 Jun '16

Hello, A new question has been asked in "MariaDB Community" by Gareth Smith. Please answer it at http://mariadb.com/kb/en/us-export-control-classification-number-eccn/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I can't find reference to this on any of the pages, so apologies if this is a duplicate. Does MariaDB (specifically 10.1, although others if that version doesn't) have an ECCN from the US Bureau of Industry and Security? If so, what is it please? Thanks very much, Gareth -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/us-export-control-classification-number-eccn/

1 0

Re: [Maria-discuss] MariaDB non-blocking with EPOLL
by Kristian Nielsen 20 Jun '16

20 Jun '16

Dave C <dave.zap(a)gmail.com> writes: > With you help I was able to get the whole thing working this afternoon, > although I will need to spend a lot more time testing and checking I've > caught all the traps. Ok, great! > The core application uses edge triggered epoll for the sake of efficiency > and so far I have not found any problems running the queries now with the > non-blocking API. Yes, I agree edge-triggered is a good way, and it is supposed to work (and if you should find something that does not, I'll fix it). > At this point it's simple so I'm only checking POLLIN as that seems to work > for the connect and query and fetch_row that I'm going. > > I guess the MYSQL_WAIT_TIMEOUT is not being passed because I've just not > run in to that case yet, but will unset it as you mention before passing it > to _cont() > > The timeout on epoll_wait() is set to 1 second, but we never reach that due > the amount of traffic. One second is the max because we must service other > things no later then that, for things such as automatically destroying non > responsive sockets after 30 seconds, including the MariaDB ones. The case > of queries that timeout can be handled in the same way, or else I can check > for standard mysql error codes? Yes, I think you can handle it the same way. It is probably safe to ignore MYSQL_WAIT_TIMEOUT completely. Then the MYSQL_OPT_*_TIMEOUT options for mysql_options() will do nothing, but if you handle non responsive sockets differently anyway, that might be fine. > Thanks again for your help. If I find anything weird I'll drop a post here, > but more often then not the weirdness is on my side. > > One interesting side effect of passing 0 to _cont() functions was the > multitude of segfaults I was getting on other random / unrelated functions > I'll see If I can replicate that once I've bedded everything down. - Kristian.

1 0

[Maria-discuss] MariaDB non-blocking with EPOLL
by Dave C 20 Jun '16

20 Jun '16

Originally posted to : http://stackoverflow.com/questions/37909652/mariadb-non-blocking-with-epoll Edited for context. I have single threaded server written in C that accepts TCP/UDP connections based on EPOLL and supports plugins for the multitude of protocol layers we need to support. That bit is fine. Due to the single threaded nature I wanted to implement a database layer that could utilize the same EPOLL architecture rather then separately iterating over all of the open connections. We use MariaDB and the MariaDB C connector that supports non blocking functions in it's API as described here. https://mariadb.com/kb/en/mariadb/using-the-non-blocking-library/ But what I'm finding is not what I expected, and what I was expecting is described below. First I fire the mysql_real_connect_start() and if it returns zero we dispatch the query immediately as this indicates no blocking was required, although this never happens. Otherwise I fetch the file descriptor that seems to be immediate and register it with EPOLL and bail back to the main EPOLL loop waiting for events. s = mysql_get_socket(mysql); if(s > 0){ brt_socket_set_fds(endpoint, s); struct epoll_event event; event.data.fd = s; event.events = EPOLLRDHUP | EPOLLIN | EPOLLET | EPOLLOUT; s = epoll_ctl(efd, EPOLL_CTL_ADD, s, &event); if (s == -1) { syslog(LOG_ERR, "brd_db : epoll error."); // handle error. }... So then some time later I do get the EPOLLOUT indicating the socket has been opened. And I dutifully call mysql_real_connect_cont() but at this stage it is still returning a non-zero value, indicating I must wait longer? But then that is the last EPOLL event I get, except for the EPOLLRDHUP when I guess the MariaDB hangs up after 10 seconds. Can anyone help me understand if this idea is even workable? Thanks David

2 1

[Maria-discuss] MariaDB 5.5.50 and updated connectors now available
by Daniel Bartholomew 18 Jun '16

18 Jun '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.50, MariaDB Connector/J 1.4.6, and MariaDB Connector/ODBC 2.0.11. These are all Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.50 - Release Notes: https://mariadb.com/kb/en/mdb-5550-rn/ - Changelog: https://mariadb.com/kb/en/mdb-5550-cl/ - Downloads: https://downloads.mariadb.org/mariadb/5.5.50 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 Connector/J 1.4.6 - Release Notes: https://mariadb.com/kb/en/mcj-146-rn/ - Changelog: https://mariadb.com/kb/en/mcj-146-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.4.6/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ MariaDB Connector/ODBC 2.0.11 - Release Notes: https://mariadb.com/kb/en/mco-2011-rn/ - Changelog: https://mariadb.com/kb/en/mco-2011-cl/ - Downloads: https://downloads.mariadb.org/connector-odbc/2.0.11/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-odbc/ - - 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 - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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/donate/ 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

3 3

[Maria-discuss] New Question: MariaDB Backup using Percona XtraBackup
by AskMonty KB 16 Jun '16

16 Jun '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-backup-using-percona-xtrabackup/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Does percona xtrabackup backs up binary log files also and does it backup all storage engines when using innobackupex as on percona website it says it backs up only Innodb xtradb and myiasm?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-backup-using-percona-xtrabackup/

1 0

[Maria-discuss] New Question: Could you suggest a connector which can work for Django and mariaDB?
by AskMonty KB 15 Jun '16

15 Jun '16

Hello, A new question has been asked in "MariaDB Community" by cpwen. Please answer it at http://mariadb.com/kb/en/could-you-suggest-a-connector-which-can-work-for-d… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, sirs. I am a new guy to learn Django and MariaDB. Could you suggest a connector which can work for Django and mariaDB? The environment is Python3.4, Django1.9, MariaDB10.0. Ubuntu15.10. Thanks a lot in advance. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/could-you-suggest-a-connector-which-can-work-for-d…

1 0

[Maria-discuss] New Question: MONyog Auto-Discovery of MariaDB Databases
by AskMonty KB 15 Jun '16

15 Jun '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/monyog-auto-discovery-of-mariadb-databases/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to discover all the mariadb instance running on a particular server and register them automtically in monyog..suppose i have mariadb 1 running on port 3306 and mariadb 2 on 3307 and what monyog should do is i give the ip address of the server and mariadb 1 and mariadb 2 should get confgured automatically and start monitoring. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-auto-discovery-of-mariadb-databases/

1 0

[Maria-discuss] New Question: ST_AsGeoJSON Support
by AskMonty KB 14 Jun '16

14 Jun '16

Hello, A new question has been asked in "Geographic Features" by jerome_savin. Please answer it at http://mariadb.com/kb/en/st_asgeojson-support/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, Are there some plans to support ST_AsGeoJSON function ? Will ST_AsGeoJSON be available soon ? Many Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/st_asgeojson-support/

1 0

[Maria-discuss] Odd behavior with query and connection pool
by Stu Smith 14 Jun '16

14 Jun '16

Hello, Forgive me for reporting this on the behalf of some other developers, I will gather more details as needed. But the basic problem we're having is with a query that: - is always fast the first time ( < 3 seconds ) - is very slow the following time, when using a connection pool (~ 30 seconds) - is pretty fast the following time, when not using a connection pool (5 or 6 seconds) This is even on a single DB with no other load. It's a fairly complicated query with sub queries, grouping, and such. I've been told it creates two temp tables. I know this is not a whole lot to go one - but are there any pointer for connection pool vs no connection pool on a lightly loaded DB? This was actually tried and reproduced with multiple connection pools - hikari-db, c3p0, and apache connection pool. Take care, -stu

3 2

[Maria-discuss] R: Odd behavior with query and connection pool
by Federico Razzoli 14 Jun '16

14 Jun '16

Weird issue. I'm trying to figure out how the connection pool can add an overhead to a single query. The only case I can think is if you use a network storage engine (Federated, Connect, Spider) pointing to tables on localhost. Is this the case? More likely... are you sure this problem is caused by the connection pool? * After the first execution, do a SHOW STATUS. Then FLUSH STATUS. Then execute again and, if it takes long time, do another SHOW STATUS. Post your results here, so we can see what happened. * While the query takes a long time, try a SHOW PROCESSLIST from another client. See if the connection is waiting for a lock. Regards Federico -------------------------------------------- Mar 14/6/16, Stu Smith <stu26code(a)gmail.com> ha scritto: Oggetto: [Maria-discuss] Odd behavior with query and connection pool A: maria-discuss(a)lists.launchpad.net Data: Martedì 14 giugno 2016, 03:36 Hello, Forgive me for reporting this on the behalf of some other developers, I will gather more details as needed. But the basic problem we're having is with a query that: - is always fast the first time ( < 3 seconds ) - is very slow the following time, when using a connection pool (~ 30 seconds) - is pretty fast the following time, when not using a connection pool (5 or 6 seconds) This is even on a single DB with no other load. It's a fairly complicated query with sub queries, grouping, and such. I've been told it creates two temp tables. I know this is not a whole lot to go one - but are there any pointer for connection pool vs no connection pool on a lightly loaded DB? This was actually tried and reproduced with multiple connection pools - hikari-db, c3p0, and apache connection pool. Take care, -stu -----Segue allegato----- _______________________________________________ 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] New Question: the difference
by AskMonty KB 14 Jun '16

14 Jun '16

Hello, A new question has been asked in "What is in the Different MariaDB Releases?" by hongyan_0318_54417. Please answer it at http://mariadb.com/kb/en/the-difference/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- About MariaDB I am a new boy,now I am using version 5.5.36 ,I want to upgrade version to 10.0.2 ,so the quesion is what's the question between them ,my English is poor ,give me a simply apply please ,thanks a lot . -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/the-difference/

1 0

[Maria-discuss] F5 iRules for galera
by Umarzuki Mochlis 14 Jun '16

14 Jun '16

I found a article related to monitoring galera at https://devcentral.f5.com/articles/monitoring-open-source-databases-with-bi…. but it did no into detail of iRules used for multi-master. Anyone have sample(s) to share? Mariadb 10.1 Big-IP 11

1 0

[Maria-discuss] Problems with running out of connections in cluster
by Lee Bennett 13 Jun '16

13 Jun '16

Hi We are running a 7 node cluster (6 data nodes and 1 arbiter node) which span 2 data centers using version 10.1.13. We have had several occasions where the application have gone off and created so many connections that the max connections are filled up which leads to the database becoming unresponsive. The connections cannot be killed and and in the ‘killed’ state forever. Today when this occurred all six cluster node maxed out on connections. The only way to get the servers back is by restarting the databases but when the first node we restarted it tried to connect to the cluster is to IST it could not connected. After shutdown a second node the cluster seemed to sort its self out and everything came back. Is anyone aware of any bugs that might cause this issue. Regards LB

1 0

[Maria-discuss] New Question: MariaDB Monitoring Using MONyog
by AskMonty KB 13 Jun '16

13 Jun '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-monitoring-using-monyog/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- can we get summary of all the servers registered which are online and which are not with help of charts like in OEM?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-monitoring-using-monyog/

1 0

[Maria-discuss] New Question: MariaDB with Galera on RedHat 7.2 not starting
by AskMonty KB 12 Jun '16

12 Jun '16

Hello, A new question has been asked in "Starting and Stopping MariaDB" by veselin_vasilev_g. Please answer it at http://mariadb.com/kb/en/mariadb-with-galera-on-redhat-72-not-starting/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, can someone please help as I couldn't find relevant information online. When trying to initialize the first node of the cluster, I get this: Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so' Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: wsrep_load(): Galera 25.3.15(r3578) by Codership Oy <info(a)codership.com> loaded Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: CRC-32C: using hardware acceleration. Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 172.20.1.56; bas Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510378977024 [Note] WSREP: Service thread queue flushed. Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: wsrep_sst_grab() Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: Start replication Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: protonet asio version 0 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: Using CRC-32C for message checksums. Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: backend: asio Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: restore pc from disk failed Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: GMCast version 0 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: (b5e7b88e, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: (b5e7b88e, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: EVS version 0 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Note] WSREP: gcomm: connecting to group 'galera_cluster', peer '172.20.1.56:,172.20.1.57:,17 Jun 12 11:14:40 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:40 140510611449984 [Warning] WSREP: (b5e7b88e, 'tcp://0.0.0.0:4567') address 'tcp://172.20.1.56:4567' points to Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:43 140510611449984 [Warning] WSREP: no nodes coming from prim view, prim not possible Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:43 140510611449984 [Note] WSREP: view(view_id(NON_PRIM,b5e7b88e,1) memb { Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: b5e7b88e,0 Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: } joined { Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: } left { Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: } partitioned { Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: }) Jun 12 11:14:43 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:14:43 140510611449984 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.50184S), skipping check Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [Note] WSREP: view((empty)) Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 11 Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: at gcomm/src/pc.cpp:connect():162 Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed to open backend connection: - Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1379: Failed to open channel 'galera_cluster' at 'g Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [ERROR] WSREP: gcs connect failed: Connection timed out Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [ERROR] WSREP: wsrep::connect(gcomm://172.20.1.56,172.20.1.57,172.20.1.58) failed: 7 Jun 12 11:15:13 mariadb-N1.intelligene.local mysqld[10404]: 2016-06-12 11:15:13 140510611449984 [ERROR] Aborting Jun 12 11:15:14 mariadb-N1.intelligene.local systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE Jun 12 11:15:14 mariadb-N1.intelligene.local systemd[1]: Failed to start MariaDB database server. -- Subject: Unit mariadb.service has failed -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-with-galera-on-redhat-72-not-starting/

1 0

[Maria-discuss] New Question: MariaDB Galera cluster gtid's falling out of sync inspite of setting wsrep_cluster
by AskMonty KB 11 Jun '16

11 Jun '16

Hello, A new question has been asked in "MariaDB Community" by kk1674. Please answer it at http://mariadb.com/kb/en/mariadb-galera-cluster-gtids-falling-out-of-sync-i… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have asynchronous replication between 2 clusters (calling master cluster, slave cluster). As expected a node in the slave cluster receives async replication and galera transmits to the rest of the nodes of the slave cluster. When the gtid counter is being incremented on the nodes of this slave cluster, the node acting as the slave node is keeping track of master server id and incrementing the gtid by wsrep_domain_id, server_id, galera counter+1. However the other nodes of the slave cluster are not keeping track of the server id variable and increment gtid by wsrep_domain_id, galera counter+1. See below Slave node of the slave cluster show variables like '%gtid%'; +------------------------+-------------------------+ | Variable_name | Value | +------------------------+-------------------------+ | gtid_binlog_pos | 2-100-36261 | | gtid_binlog_state | 2-200-36263,2-100-36261 | | gtid_current_pos | 1-100-36261 | | gtid_domain_id | 22 | | gtid_ignore_duplicates | OFF | | gtid_seq_no | 0 | | gtid_slave_pos | 1-100-36261 | | gtid_strict_mode | OFF | | last_gtid | 2-200-36263 | | wsrep_gtid_domain_id | 2 | | wsrep_gtid_mode | ON | +------------------------+-------------------------+ 11 rows in set (0.00 sec) Another node in the slave cluster show variables like '%gtid%'; +------------------------+-------------------------+ | Variable_name | Value | +------------------------+-------------------------+ | gtid_binlog_pos | 2-100-36265 | | gtid_binlog_state | 2-200-36264,2-100-36265 | | gtid_current_pos | 1-100-36259 | | gtid_domain_id | 22 | | gtid_ignore_duplicates | OFF | | gtid_seq_no | 0 | | gtid_slave_pos | 1-100-36259 | | gtid_strict_mode | OFF | | last_gtid | | | wsrep_gtid_domain_id | 2 | | wsrep_gtid_mode | ON | +------------------------+-------------------------+ 11 rows in set (0.00 sec) This behavior has been noted in MariaDB 10.1.11, 10.1.13 and 10.1.14. In 10.1.11, gtid_slave_pos table is being replicated by galera hence if the slave node goes down it is possible to move the slave process to another node, by first setting the gtid_slave_pos variable. However starting 10.1.13 the table is not longer being replicated I see it as a fix for another issue agreeably, but now there is no means to determine the slave position to be able to start replication on another node of the cluster. Can this behavior be classified as bug and a bug request opened? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-galera-cluster-gtids-falling-out-of-sync-i…

1 0