March 2017 - discuss - lists.mariadb.org

[Maria-discuss] explain for insert/update/delete
by MARK CALLAGHAN 08 Jul '25

08 Jul '25

Does MariaDB have any plans to support explain for insert/update/delete/replace/CTAS? There have been feature requests open for a very long time on official MySQL without any progress. I have had a few problems in production from 'bad' delete statements that had a very different plan than the select statement with the same where clause. The only way to check for a bad plan today is to use SHOW INNODB STATUS to determine whether the statement locks all rows in a table. http://bugs.mysql.com/bug.php?id=14745 http://bugs.mysql.com/bug.php?id=35355 -- Mark Callaghan mdcallag(a)gmail.com

3 3

[Maria-discuss] Galera 23.2.7 mariadb 5.5.33a msvc 1600 binaries available
by Yann Nayn 21 May '25

21 May '25

Binaries have been uploaded for both x86 and amd64 platforms. due to github file size limitations , the directories have been uploaded unarchived. for Win33 binaries , please checkout https://github.com/YannNayn/galera-mariadb-win32.git and for Win64(amd64) binaries (being uploaded/pushed): https://github.com/YannNayn/galera-mariadb-win64.git they are not recommended for a production environment. in the my.cnf file: _________ wsrep_provider=galera_smm.dll wsrep_sst_method=msqldump # percona xtrabackup will be tested soon _________ libevent and openssl(the provided binaries use respectively 2.1.3-alpha and 1.1.0-dev versions ) will be added next on github some limitations are stated on openssl website copied here for convenience: ____________ from http://www.openssl.org/ ____________ This software package uses strong cryptography, so even if it is created, maintained and distributed from liberal countries in Europe (where it is legal to do this), it falls under certain export/import and/or use restrictions in some other parts of the world. PLEASE REMEMBER THAT EXPORT/IMPORT AND/OR USE OF STRONG CRYPTOGRAPHY SOFTWARE, PROVIDING CRYPTOGRAPHY HOOKS OR EVEN JUST COMMUNICATING TECHNICAL DETAILS ABOUT CRYPTOGRAPHY SOFTWARE IS ILLEGAL IN SOME PARTS OF THE WORLD. SO, WHEN YOU IMPORT THIS PACKAGE TO YOUR COUNTRY, RE-DISTRIBUTE IT FROM THERE OR EVEN JUST EMAIL TECHNICAL SUGGESTIONS OR EVEN SOURCE PATCHES TO THE AUTHOR OR OTHER PEOPLE YOU ARE STRONGLY ADVISED TO PAY CLOSE ATTENTION TO ANY EXPORT/IMPORT AND/OR USE LAWS WHICH APPLY TO YOU. THE AUTHORS OF OPENSSL ARE NOT LIABLE FOR ANY VIOLATIONS YOU MAKE HERE. SO BE CAREFUL, IT IS YOUR RESPONSIBILITY. ________________________________________________ msvc 1600 redistributables SP1 need to be installed/available on the target machine: vcredist_x86.exe : http://www.microsoft.com/en-us/download/details.aspx?id=8328 vcredist_x64.exe : http://www.microsoft.com/en-us/download/details.aspx?id=13523 MSys binaries are provided and msqld.bat should then be used instead of mysqld.exe (e.g. mysld.bat --console --wsrep_cluster_address=gcomm:// ) in order to have a working sh shell(cygwin has been proved to do it as well) Please note that oqgraph is disabled (boost trunk is used , that is 1.55) Comments and suggestions are welcome.

5 4

[Maria-discuss] why stdout? -> [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096
by Reindl Harald 05 Jul '20

05 Jul '20

Aug 6 12:24:24 testserver mysqld: 150806 12:24:24 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096 ... why is this now stdout instead mysql logs? on systemd based distributions that spits now to the global syslog and finally on machines restarting 2 instances every hour for backup reasons it annoys until 10.0.19 or 10.0.20 that was not this way

5 13

[Maria-discuss] Cross compile error
by Lucian Cristian 16 May '17

16 May '17

Hi I'm trying to cross compile (any 10.* versions) using musl and uClibc++ for a LEDE/Openwrt system and I have problems with these errors: staging_dir/target-x86_64_musl/usr/include/uClibc++/associative_base:444:8: error: 'void std::__base_associative<Key, ValueType, Compare, Allocator>::swap(std::__base_associative<Key, ValueType, Compare, Allocator>&) [with Key = dict_foreign_t*; ValueType = dict_foreign_t*; Compare = dict_foreign_compare; Allocator = ut_allocator<dict_foreign_t*>]' is protected void __base_associative<Key, ValueType, Compare, Allocator>::swap(__base_associative<Key, ValueType, Compare, Allocator>& m) ^ build_dir/target-x86_64_musl/mariadb-10.2.4/storage/innobase/dict/dict0dict.cc:1996:32: error: within this context table->foreign_set.swap(fk_set); ^ storage/innobase/CMakeFiles/innobase.dir/build.make:542: recipe for target 'storage/innobase/CMakeFiles/innobase.dir/dict/dict0dict.cc.o' failed staging_dir/target-x86_64_musl/usr/include/uClibc++/map: In instantiation of 'std::map<Key, T, Compare, Allocator>::reference std::map<Key, T, Compare, Allocator>::operator[](const key_type&) [with Key = const char*; T = dict_index_t*; Compare = ut_strcmp_functor; Allocator = ut_allocator<std::pair<const char*, dict_index_t*> >; std::map<Key, T, Compare, Allocator>::reference = std::pair<const char*, dict_index_t*>&; std::map<Key, T, Compare, Allocator>::key_type = const char*]': build_dir/target-x86_64_musl/mariadb-10.2.4/storage/innobase/dict/dict0stats.cc:2518:22: required from here staging_dir/target-x86_64_musl/usr/include/uClibc++/map:143:13: error: invalid initialization of reference of type 'std::map<const char*, dict_index_t*, ut_strcmp_functor, ut_allocator<std::pair<const char*, dict_index_t*> > >::reference {aka std::pair<const char*, dict_index_t*>&}' from expression of type 'dict_index_t*' return i->second; ^ storage/innobase/CMakeFiles/innobase.dir/build.make:614: recipe for target 'storage/innobase/CMakeFiles/innobase.dir/dict/dict0stats.cc.o' failed build_dir/target-x86_64_musl/mariadb-10.2.4/plugin/handler_socket/handlersocket/hstcpsvr.cpp: In constructor 'dena::hstcpsvr::hstcpsvr(const dena::config&)': build_dir/target-x86_64_musl/mariadb-10.2.4/plugin/handler_socket/handlersocket/hstcpsvr.cpp:92:37: error: invalid initialization of non-const reference of type 'std::auto_ptr<volatile dena::database_i>&' from an rvalue of type 'dena::database_ptr {aka std::auto_ptr<volatile dena::database_i>}' cshared.dbptr = database_i::create(c); ^ In file included from staging_dir/target-x86_64_musl/usr/include/uClibc++/vector:22:0, from build_dir/target-x86_64_musl/mariadb-10.2.4/plugin/handler_socket/handlersocket/hstcpsvr.cpp:12: staging_dir/target-x86_64_musl/usr/include/uClibc++/memory:137:12: note: initializing argument 1 of 'std::auto_ptr<T>& std::auto_ptr<T>::operator=(std::auto_ptr<T>&) [with T = volatile dena::database_i]' auto_ptr& operator=(auto_ptr& p) throw(){ ^ plugin/handler_socket/CMakeFiles/handlersocket.dir/build.make:134: recipe for target 'plugin/handler_socket/CMakeFiles/handlersocket.dir/handlersocket/hstcpsvr.cpp.o' failed make[5]: *** [plugin/handler_socket/CMakeFiles/handlersocket.dir/handlersocket/hstcpsvr.cpp.o] Error 1 this is the command line (cd /build_dir/target-x86_64_musl/mariadb-10.2.4; CFLAGS="-Os -pipe -fno-caller-saves -fno-plt -fhonour-copts -Wno-error=unused-but-set-variable -Wno-error=unused-result -iremap/build_dir/target-x86_64_musl/mariadb-10.2.4:mariadb-10.2.4 -Wformat -Werror=format-security -fstack-protector -D_FORTIFY_SOURCE=1 -Wl,-z,now -Wl,-z,relro -fpic " CXXFLAGS="-Os -pipe -fno-caller-saves -fno-plt -fhonour-copts -Wno-error=unused-but-set-variable -Wno-error=unused-result -iremap/build_dir/target-x86_64_musl/mariadb-10.2.4:mariadb-10.2.4 -Wformat -Werror=format-security -fstack-protector -D_FORTIFY_SOURCE=1 -Wl,-z,now -Wl,-z,relro -fpic " LDFLAGS="-L/staging_dir/target-x86_64_musl/usr/lib -L/staging_dir/target-x86_64_musl/lib -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/usr/lib -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/lib -znow -zrelro " cmake -DCMAKE_SYSTEM_NAME=Linux -DCMAKE_SYSTEM_VERSION=1 -DCMAKE_SYSTEM_PROCESSOR=x86_64 -DCMAKE_BUILD_TYPE=Release -DCMAKE_C_FLAGS_RELEASE="-DNDEBUG" -DCMAKE_CXX_FLAGS_RELEASE="-DNDEBUG" -DCMAKE_C_COMPILER="/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/bin/x86_64-openwrt-linux-musl-gcc" -DCMAKE_C_COMPILER_ARG1="" -DCMAKE_CXX_COMPILER="/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/bin/g++-uc" -DCMAKE_CXX_COMPILER_ARG1="" -DCMAKE_ASM_COMPILER="/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/bin/x86_64-openwrt-linux-musl-gcc" -DCMAKE_ASM_COMPILER_ARG1="" -DCMAKE_EXE_LINKER_FLAGS:STRING="-L/staging_dir/target-x86_64_musl/usr/lib -L/staging_dir/target-x86_64_musl/lib -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/usr/lib -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/lib -znow -zrelro" -DCMAKE_MODULE_LINKER_FLAGS:STRING="-L/staging_dir/target-x86_64_musl/usr/lib -L/staging_dir/target-x86_64_musl/lib -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/usr/lib -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/lib -znow -zrelro -Wl,-Bsymbolic-functions" -DCMAKE_SHARED_LINKER_FLAGS:STRING="-L/staging_dir/target-x86_64_musl/usr/lib -L/staging_dir/target-x86_64_musl/lib -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/usr/lib -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/lib -znow -zrelro -Wl,-Bsymbolic-functions" -DCMAKE_AR="/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/bin/x86_64-openwrt-linux-musl-gcc-ar" -DCMAKE_NM="/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/bin/x86_64-openwrt-linux-musl-gcc-nm" -DCMAKE_RANLIB="/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/bin/x86_64-openwrt-linux-musl-gcc-ranlib" -DCMAKE_FIND_ROOT_PATH="/staging_dir/target-x86_64_musl/usr;/staging_dir/toolchain-x86_64_gcc-5.4.0_musl" -DCMAKE_FIND_ROOT_PATH_MODE_PROGRAM=BOTH -DCMAKE_FIND_ROOT_PATH_MODE_LIBRARY=ONLY -DCMAKE_FIND_ROOT_PATH_MODE_INCLUDE=ONLY -DCMAKE_STRIP=: -DCMAKE_INSTALL_PREFIX=/usr -DDL_LIBRARY=/staging_dir/target-x86_64_musl -DCMAKE_PREFIX_PATH=/staging_dir/target-x86_64_musl -DCMAKE_SKIP_RPATH=TRUE -DCMAKE_SYSTEM_NAME=Linux -DSTACK_DIRECTION=-1 -DWITH_WSREP=ON -DWITH_INNODB_DISALLOW_WRITES=1 -DCONNECT_WITH_JDBC=OFF -DWITHOUT_TOKUDB=1 -DIMPORT_EXECUTABLES=/build_dir/hostpkg/mariadb-10.2.4/host/import_executables.cmake /build_dir/target-x86_64_musl/mariadb-10.2.4 ) can someone give me an advice ? Regards

2 2

Re: [Maria-discuss] mysqladmin - flush failed: Unknown error
by Daniel Black 06 Apr '17

06 Apr '17

On 30/03/17 20:46, Matthew Pash wrote: > Morning Daniel, > > Thanks for your reply, I've been doing some more testing. The logrotate > script (below) currently runs fine when executed manually (sudo > logrotate -v -f /etc/logrotate.d/mysql) but fails when run overnight by > cron. > > /var/log/mysqld.log { > compress > daily > missingok > notifempty > rotate 3 > postrotate > if test -x /usr/bin/mysqladmin && /usr/bin/mysqladmin ping &>/dev/null > then > /usr/bin/mysqladmin flush-logs > fi > endscript > } > > I tweaked it last night to capture the output of the mysqladmin command > and it did this: > > /usr/bin/mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user 'root'@'localhost' (using password: NO)' > > Which makes me think the problem is more about cron than MariaDB. No, MariaDB doesn't have a passwordless root user that mysqladmin needs to issue the flush-logs command. I suspect that there was originally a root user with socket authentication this system. Even after fixing this the mysqld may not be able to create new logs in /var/log/. I'd normally expect /var/log/mysql to be owned by the mysql user and its configuration to log the error to a file in this directory. > I've > added some extra information gathering, so we'll see how it runs tonight. > > > On 27 March 2017 at 22:34, Daniel Black <daniel.black(a)au1.ibm.com > <mailto:daniel.black@au1.ibm.com>> wrote: > > I think you'll find that the mysql user don't have permissions to create > a new file in /var/log/. As such logrotate renames the file which is > still open by mysqld. As such it is now writing to mysqld.log.1. > > On 28/03/17 00:13, Matthew Pash wrote: > > Hi, > > > > We've got some database servers running MariaDB 10.1.22, and are having > > issues with logrotate. Specifically, after it runs, it leaves a 0 byte > > file and continues writing log data to mysqld.log.1 > > > > Manually running logrotate in verbose mode shows this error from > > mysqladmin when it tries to run -flush_logs: > > > > /usr/bin/mysqladmin: flush failed; error: 'Unknown error' > > error: error running non-shared postrotate script for > > /var/log/mysqld.log of '/var/log/mysqld.log ' > > set default create context > > What does the logrotate script look like? It really should be a "shared" > (in a logrotate way) script. > > > > > Has anyone seen this before? It doesn't look like a permissions error - > > the logs are created fine if you run systemctl restart mariadb. > > Is the log actually writing to /var/log/mysqld.log using systemd? It > normally writes to the journal because with systemd redirects stderr > there > > > From lsof, it looks like /var/log/mysqld.log is being written to by the > mysql process itself: > $ sudo lsof | grep mysqld.log > mysqld 38803 mysql 1w REG 8,3 > 31781 537216904 /var/log/mysqld.log.1 > mysqld 38803 mysql 2w REG 8,3 > 31781 537216904 /var/log/mysqld.log.1 > ... > > > > > > Thanks, > > ~Matt > > > > -- > > *Matthew* > > Senior Systems Administrator, IT Services > > University of Bristol > > > > > > _______________________________________________ > > Mailing list: https://launchpad.net/~maria-discuss > <https://launchpad.net/%7Emaria-discuss> > > Post to : maria-discuss(a)lists.launchpad.net > <mailto:maria-discuss@lists.launchpad.net> > > Unsubscribe : https://launchpad.net/~maria-discuss > <https://launchpad.net/%7Emaria-discuss> > > More help : https://help.launchpad.net/ListHelp > <https://help.launchpad.net/ListHelp> > > > > > > > -- > *Matthew Pash* > Senior Systems Administrator, IT Services > University of Bristol

2 1

Re: [Maria-discuss] Cross compile error
by Daniel Black 01 Apr '17

01 Apr '17

On this error I'm not sure. Looks to be some sort of inheritance hierarchy that is different in musl from glibc et al. I'd chase them up to see who is violating the C++ spec. Have you tried using buildroot? It has a stable 10.1 version that is kept up to date and it has the one outstanding uclibc patch (that is waiting in jira https://jira.mariadb.org/browse/MDEV-10841) On 26/03/17 02:52, Lucian Cristian wrote: > Hi > > I'm trying to cross compile (any 10.* versions) using musl and uClibc++ > for a LEDE/Openwrt system and I have problems with these errors: > > > staging_dir/target-x86_64_musl/usr/include/uClibc++/associative_base:444:8: > error: 'void std::__base_associative<Key, ValueType, Compare, > Allocator>::swap(std::__base_associative<Key, ValueType, Compare, > Allocator>&) [with Key = dict_foreign_t*; ValueType = dict_foreign_t*; > Compare = dict_foreign_compare; Allocator = > ut_allocator<dict_foreign_t*>]' is protected > void __base_associative<Key, ValueType, Compare, > Allocator>::swap(__base_associative<Key, ValueType, Compare, Allocator>& m) > ^ > build_dir/target-x86_64_musl/mariadb-10.2.4/storage/innobase/dict/dict0dict.cc:1996:32: > error: within this context > table->foreign_set.swap(fk_set); > ^ > storage/innobase/CMakeFiles/innobase.dir/build.make:542: recipe for > target 'storage/innobase/CMakeFiles/innobase.dir/dict/dict0dict.cc.o' > failed > > > > staging_dir/target-x86_64_musl/usr/include/uClibc++/map: In > instantiation of 'std::map<Key, T, Compare, Allocator>::reference > std::map<Key, T, Compare, Allocator>::operator[](const key_type&) [with > Key = const char*; T = dict_index_t*; Compare = ut_strcmp_functor; > Allocator = ut_allocator<std::pair<const char*, dict_index_t*> >; > std::map<Key, T, Compare, Allocator>::reference = std::pair<const char*, > dict_index_t*>&; std::map<Key, T, Compare, Allocator>::key_type = const > char*]': > build_dir/target-x86_64_musl/mariadb-10.2.4/storage/innobase/dict/dict0stats.cc:2518:22: > required from here > staging_dir/target-x86_64_musl/usr/include/uClibc++/map:143:13: error: > invalid initialization of reference of type 'std::map<const char*, > dict_index_t*, ut_strcmp_functor, ut_allocator<std::pair<const char*, > dict_index_t*> > >::reference {aka std::pair<const char*, > dict_index_t*>&}' from expression of type 'dict_index_t*' > return i->second; > ^ > storage/innobase/CMakeFiles/innobase.dir/build.make:614: recipe for > target 'storage/innobase/CMakeFiles/innobase.dir/dict/dict0stats.cc.o' > failed > > > > build_dir/target-x86_64_musl/mariadb-10.2.4/plugin/handler_socket/handlersocket/hstcpsvr.cpp: > In constructor 'dena::hstcpsvr::hstcpsvr(const dena::config&)': > build_dir/target-x86_64_musl/mariadb-10.2.4/plugin/handler_socket/handlersocket/hstcpsvr.cpp:92:37: > error: invalid initialization of non-const reference of type > 'std::auto_ptr<volatile dena::database_i>&' from an rvalue of type > 'dena::database_ptr {aka std::auto_ptr<volatile dena::database_i>}' > cshared.dbptr = database_i::create(c); > ^ > In file included from > staging_dir/target-x86_64_musl/usr/include/uClibc++/vector:22:0, > from > build_dir/target-x86_64_musl/mariadb-10.2.4/plugin/handler_socket/handlersocket/hstcpsvr.cpp:12: > > staging_dir/target-x86_64_musl/usr/include/uClibc++/memory:137:12: > note: initializing argument 1 of 'std::auto_ptr<T>& > std::auto_ptr<T>::operator=(std::auto_ptr<T>&) [with T = volatile > dena::database_i]' > auto_ptr& operator=(auto_ptr& p) throw(){ > ^ > plugin/handler_socket/CMakeFiles/handlersocket.dir/build.make:134: > recipe for target > 'plugin/handler_socket/CMakeFiles/handlersocket.dir/handlersocket/hstcpsvr.cpp.o' > failed > make[5]: *** > [plugin/handler_socket/CMakeFiles/handlersocket.dir/handlersocket/hstcpsvr.cpp.o] > Error 1 > > > this is the command line > > (cd /build_dir/target-x86_64_musl/mariadb-10.2.4; CFLAGS="-Os -pipe > -fno-caller-saves -fno-plt -fhonour-copts > -Wno-error=unused-but-set-variable -Wno-error=unused-result > -iremap/build_dir/target-x86_64_musl/mariadb-10.2.4:mariadb-10.2.4 > -Wformat -Werror=format-security -fstack-protector -D_FORTIFY_SOURCE=1 > -Wl,-z,now -Wl,-z,relro -fpic " CXXFLAGS="-Os -pipe -fno-caller-saves > -fno-plt -fhonour-copts -Wno-error=unused-but-set-variable > -Wno-error=unused-result > -iremap/build_dir/target-x86_64_musl/mariadb-10.2.4:mariadb-10.2.4 > -Wformat -Werror=format-security -fstack-protector -D_FORTIFY_SOURCE=1 > -Wl,-z,now -Wl,-z,relro -fpic " > LDFLAGS="-L/staging_dir/target-x86_64_musl/usr/lib > -L/staging_dir/target-x86_64_musl/lib > -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/usr/lib > -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/lib -znow -zrelro " cmake > -DCMAKE_SYSTEM_NAME=Linux -DCMAKE_SYSTEM_VERSION=1 > -DCMAKE_SYSTEM_PROCESSOR=x86_64 -DCMAKE_BUILD_TYPE=Release > -DCMAKE_C_FLAGS_RELEASE="-DNDEBUG" -DCMAKE_CXX_FLAGS_RELEASE="-DNDEBUG" > -DCMAKE_C_COMPILER="/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/bin/x86_64-openwrt-linux-musl-gcc" > -DCMAKE_C_COMPILER_ARG1="" > -DCMAKE_CXX_COMPILER="/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/bin/g++-uc" > -DCMAKE_CXX_COMPILER_ARG1="" > -DCMAKE_ASM_COMPILER="/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/bin/x86_64-openwrt-linux-musl-gcc" > -DCMAKE_ASM_COMPILER_ARG1="" > -DCMAKE_EXE_LINKER_FLAGS:STRING="-L/staging_dir/target-x86_64_musl/usr/lib > -L/staging_dir/target-x86_64_musl/lib > -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/usr/lib > -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/lib -znow -zrelro" > -DCMAKE_MODULE_LINKER_FLAGS:STRING="-L/staging_dir/target-x86_64_musl/usr/lib > -L/staging_dir/target-x86_64_musl/lib > -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/usr/lib > -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/lib -znow -zrelro > -Wl,-Bsymbolic-functions" > -DCMAKE_SHARED_LINKER_FLAGS:STRING="-L/staging_dir/target-x86_64_musl/usr/lib > -L/staging_dir/target-x86_64_musl/lib > -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/usr/lib > -L/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/lib -znow -zrelro > -Wl,-Bsymbolic-functions" > -DCMAKE_AR="/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/bin/x86_64-openwrt-linux-musl-gcc-ar" > -DCMAKE_NM="/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/bin/x86_64-openwrt-linux-musl-gcc-nm" > -DCMAKE_RANLIB="/staging_dir/toolchain-x86_64_gcc-5.4.0_musl/bin/x86_64-openwrt-linux-musl-gcc-ranlib" > -DCMAKE_FIND_ROOT_PATH="/staging_dir/target-x86_64_musl/usr;/staging_dir/toolchain-x86_64_gcc-5.4.0_musl" > -DCMAKE_FIND_ROOT_PATH_MODE_PROGRAM=BOTH > -DCMAKE_FIND_ROOT_PATH_MODE_LIBRARY=ONLY > -DCMAKE_FIND_ROOT_PATH_MODE_INCLUDE=ONLY -DCMAKE_STRIP=: > -DCMAKE_INSTALL_PREFIX=/usr -DDL_LIBRARY=/staging_dir/target-x86_64_musl > -DCMAKE_PREFIX_PATH=/staging_dir/target-x86_64_musl > -DCMAKE_SKIP_RPATH=TRUE -DCMAKE_SYSTEM_NAME=Linux -DSTACK_DIRECTION=-1 > -DWITH_WSREP=ON -DWITH_INNODB_DISALLOW_WRITES=1 -DCONNECT_WITH_JDBC=OFF > -DWITHOUT_TOKUDB=1 > -DIMPORT_EXECUTABLES=/build_dir/hostpkg/mariadb-10.2.4/host/import_executables.cmake > /build_dir/target-x86_64_musl/mariadb-10.2.4 ) > > > can someone give me an advice ? > > Regards > > > _______________________________________________ > 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 >

2 1

[Maria-discuss] MariaDB memory usage
by Selvam 31 Mar '17

31 Mar '17

Hi, Hi, I have MariaDB 10.1.19 with 1 GB of RAM on (AWS RDS) and another one with 4 GB of RAM (production instance). Memory usage keeps on increasing on both. Free memory goes below 50MB. InnoDB status shows "History list length 2671". My total table count is 225 and shows around 10 GB of data for them. I am giving the InnoDB engine status for your reference below, I would be happy to get any pointers on this issue. ===================================== 2017-03-31 10:53:08 2b25f6ec2700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 41 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 6695 srv_active, 0 srv_shutdown, 187084 srv_idle srv_master_thread log flush and writes: 193768 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 77210 OS WAIT ARRAY INFO: signal count 212544 Mutex spin waits 201779, rounds 289254, OS waits 5769 RW-shared spins 71644, rounds 1292843, OS waits 28918 RW-excl spins 27933, rounds 1582253, OS waits 41414 Spin rounds per wait: 1.43 mutex, 18.05 RW-shared, 56.64 RW-excl ------------ TRANSACTIONS ------------ Trx id counter 106794202 Purge done for trx's n:o < 106794191 undo n:o < 0 state: running but idle History list length 3618 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 106794062, not started MySQL thread id 110715, OS thread handle 0x2b25f6ec2700, query id 5020955 182.71.229.138 ebuser init SHOW ENGINE INNODB STATUS ---TRANSACTION 106794201, not started MySQL thread id 8, OS thread handle 0x2b25a2703700, query id 5020954 localhost 127.0.0.1 rdsadmin cleaning up ---TRANSACTION 106028547, not started MySQL thread id 1, OS thread handle 0x2b25a2681700, query id 0 Waiting for background binlog tasks -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 748253 OS file reads, 1159722 OS file writes, 187669 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 101, seg size 103, 63021 merges merged operations: insert 49746, delete mark 141267, delete 44296 discarded operations: insert 0, delete mark 0, delete 0 29.05 hash searches/s, 1.85 non-hash searches/s --- LOG --- Log sequence number 150636062402 Log flushed up to 150636062402 Pages flushed up to 150636062402 Last checkpoint at 150636062402 Max checkpoint age 216721613 Checkpoint age target 209949063 Modified age 0 Checkpoint age 0 0 pending log writes, 0 pending chkp writes 138085 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 3021996032; in additional pool allocated 0 Total memory allocated by read views 416 Internal hash tables (constant factor + variable factor) Adaptive hash index 262562512 (46748264 + 215814248) Page hash 366056 (buffer pool 0 only) Dictionary cache 13611078 (11688592 + 1922486) File system 960472 (812272 + 148200) Lock system 7306496 (7305416 + 1080) Recovery system 0 (0 + 0) Dictionary memory allocated 1922486 Buffer pool size 180216 Buffer pool size, bytes 2952658944 Free buffers 8193 Database pages 158851 Old database pages 58475 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1247738, not young 25033050 0.00 youngs/s, 0.00 non-youngs/s Pages read 748000, created 43142, written 994180 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 158851, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 22527 Buffer pool size, bytes 369082368 Free buffers 1025 Database pages 19861 Old database pages 7311 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 98238, not young 2723636 0.00 youngs/s, 0.00 non-youngs/s Pages read 92864, created 5425, written 135077 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 19861, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 22527 Buffer pool size, bytes 369082368 Free buffers 1024 Database pages 19853 Old database pages 7308 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 95625, not young 3098260 0.00 youngs/s, 0.00 non-youngs/s Pages read 89244, created 5544, written 116844 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 19853, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 22527 Buffer pool size, bytes 369082368 Free buffers 1024 Database pages 19851 Old database pages 7307 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 128795, not young 3109159 0.00 youngs/s, 0.00 non-youngs/s Pages read 96654, created 5166, written 121945 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 19851, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 22527 Buffer pool size, bytes 369082368 Free buffers 1024 Database pages 19847 Old database pages 7306 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 305308, not young 4040408 0.00 youngs/s, 0.00 non-youngs/s Pages read 96897, created 5125, written 135851 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 19847, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 22527 Buffer pool size, bytes 369082368 Free buffers 1024 Database pages 19852 Old database pages 7308 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 128721, not young 3047134 0.00 youngs/s, 0.00 non-youngs/s Pages read 94024, created 5765, written 126032 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 19852, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 22527 Buffer pool size, bytes 369082368 Free buffers 1024 Database pages 19860 Old database pages 7311 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 146912, not young 2641167 0.00 youngs/s, 0.00 non-youngs/s Pages read 94359, created 5540, written 120390 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 19860, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 22527 Buffer pool size, bytes 369082368 Free buffers 1024 Database pages 19872 Old database pages 7315 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 96242, not young 3087412 0.00 youngs/s, 0.00 non-youngs/s Pages read 88868, created 4950, written 119917 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 19872, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 22527 Buffer pool size, bytes 369082368 Free buffers 1024 Database pages 19855 Old database pages 7309 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 247897, not young 3285874 0.00 youngs/s, 0.00 non-youngs/s Pages read 95090, created 5627, written 118124 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 19855, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB 0 RW transactions active inside InnoDB 0 RO transactions active inside InnoDB 0 out of 1000 descriptors used Main thread process no. 9357, id 47444582741760, state: sleeping Number of rows inserted 1455191, updated 16167028, deleted 1399680, read 1844055639 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 30.83 reads/s Number of system rows inserted 3, updated 641, deleted 3, read 20758 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.12 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ -- Regards, Selvam KnackForge <http://knackforge.com>

1 0

[Maria-discuss] semi-sync replication rpl_semi_sync_master_clients question ?
by Ljr Yang 29 Mar '17

29 Mar '17

HI, we have many groups master slave , used semi-sync are normal. but there a group master and slave , semi-sync status show have a little question. master: 10.1.0.61 (MariaDB 10.1.22) slave1 : 10.1.0.62 (MariaDB 10.1.22) slave2: 10.1.0.63 (MariaDB 10.1.22) three machine's semi-sync parameter: rpl_semi_sync_master_enabled ON rpl_semi_sync_master_timeout 10000 rpl_semi_sync_master_wait_point AFTER_COMMIT rpl_semi_sync_slave_enabled ON on master: SHOW GLOBAL STATUS LIKE '%semi%' ; *Rpl_semi_sync_master_clients 1 # should show : 2 * ...... on slave1: stop slave io_thread; then on master: SHOW GLOBAL STATUS LIKE '%semi%' ; *Rpl_semi_sync_master_clients ０* on slave1: start slave io_thread; on master: SHOW GLOBAL STATUS LIKE '%semi%' ; *Rpl_semi_sync_master_clients 1* on slave2: stop slave io_thread; then on master: SHOW GLOBAL STATUS LIKE '%semi%' ; *Rpl_semi_sync_master_clients ０* on slave2: start slave io_thread; on master: SHOW GLOBAL STATUS LIKE '%semi%' ; *Rpl_semi_sync_master_clients 1* *on slave1 and slave2 , I had uninstall and reinstall semi-sync plugin, * *still show **Rpl_semi_sync_master_clients is 1* I don't know where config have question? please you help, thanks

2 4

[Maria-discuss] mysqladmin - flush failed: Unknown error
by Matthew Pash 27 Mar '17

27 Mar '17

Hi, We've got some database servers running MariaDB 10.1.22, and are having issues with logrotate. Specifically, after it runs, it leaves a 0 byte file and continues writing log data to mysqld.log.1 Manually running logrotate in verbose mode shows this error from mysqladmin when it tries to run -flush_logs: /usr/bin/mysqladmin: flush failed; error: 'Unknown error' error: error running non-shared postrotate script for /var/log/mysqld.log of '/var/log/mysqld.log ' set default create context Has anyone seen this before? It doesn't look like a permissions error - the logs are created fine if you run systemctl restart mariadb. Thanks, ~Matt -- *Matthew* Senior Systems Administrator, IT Services University of Bristol

2 1

[Maria-discuss] MariaDB Galera Cluster 10.0.30 and Connector/J 1.5.9 now available
by Daniel Bartholomew 22 Mar '17

22 Mar '17

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.30 and MariaDB Connector/J 1.5.9. These are both stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 10.0.30 - Release Notes: https://mariadb.com/kb/en/mgc-10030-rn/ - Changelog: https://mariadb.com/kb/en/mgc-10030-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.30 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/J 1.5.9 - Release Notes: https://mariadb.com/kb/en/mcj-159-rn/ - Changelog: https://mariadb.com/kb/en/mcj-159-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.5.9/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ - - Developers Meetup and M|17 User Conference in April - - - - - - - The MariaDB Foundation is hosting a MariaDB Developers Meetup from 9-10 April in New York City. This event is being held in conjunction with the MariaDB Corporation sponsored M|17 MariaDB User Conference being held from 11-12 April, also in NYC. Details on both events can be found at: - https://mariadb.org/2017-developers-meetup-new-york/ - https://m17.mariadb.com/ - - 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/mariadbfdn - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0