- discuss - lists.mariadb.org

[Maria-discuss] MariaDB 10.2.5 RC now available
by Daniel Bartholomew 05 Apr '17

05 Apr '17

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.5 Release Candidate (RC). See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.2.5 - Release Notes: https://mariadb.com/kb/en/mdb-1025-rn/ - Changelog: https://mariadb.com/kb/en/mdb-1025-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.2.5 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 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

[Maria-discuss] NOT AGAIN PLEASE
by Federico Razzoli 05 Apr '17

05 Apr '17

Periodically this list becomes an early 90's fashion BBS. For days. It is very interesting to discuss how every single human being except one is an idiot who don't reply messages correctly to emails but 1- After some years, if you didn't convince anyone, maybe you are not totally right. 2- It is a bit off topic here. Maybe setup a list like use-reply-correctly-or-die(a)lists.launchpad.net and use this list to talk about MariaDB? 3- Yes, I wrote the subject in uppercase and killing me is still illegal. What a nasty world. Thanks. Federico -------------------------------------------- Mer 5/4/17, Reindl Harald <h.reindl(a)thelounge.net> ha scritto: Oggetto: Re: [Maria-discuss] searching for etc/my.cnf and CMAKE_INSTALL_PREFIX A: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Mercoledì 5 Aprile 2017, 19:23 Am 05.04.2017 um 19:14 schrieb MARK CALLAGHAN: > Why do you need to shout about this? why don't you bring ANY specific reasoining for your sloppy "Maybe someone should edit the too strong claims" - anyways - if someone is too dumb to respond just to the list instead reply-all and convert plaintext mails in the quote to HTML all is said.... > On Wed, Apr 5, 2017 at 10:04 AM, Reindl Harald <h.reindl(a)thelounge.net > <mailto:h.reindl@thelounge.net>> wrote: > > > > Am 05.04.2017 um 18:57 schrieb MARK CALLAGHAN: > > It is different from upstream MySQL in many ways as that page > explains. > > > bla - if it woul dbe just a recompile from the mysql sources it > would not be a fork - in 99.9% of all cases IT IS a > drop-in-replacement - if you have REAL issues name them - period > > On Wed, Apr 5, 2017 at 8:03 AM, Reindl Harald > <h.reindl(a)thelounge.net <mailto:h.reindl@thelounge.net> > <mailto:h.reindl@thelounge.net <mailto:h.reindl@thelounge.net>>> > wrote: > > and why? > > it is and where it isn't unintentional report it and help to > get it > fixed, that said from a admin which dozens of MariaDB > servers where > the datadir was originally created on Windows under MySQL > 3.x, got > moved in prduction for some years to MacOS, later to Linux > and now > is running MariaDB 10.1 just fine with the same datadirs and the > help of "mysql_upgrade" over the years > > > Am 05.04.2017 um 16:50 schrieb MARK CALLAGHAN: > > Maybe someone should edit the too strong claims > on > https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/ > <https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/> > > <https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/ > <https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/>> > > In bold at the top of the page... > > > MariaDB is a binary drop in replacement for MySQL > > > On Tue, Apr 4, 2017 at 9:58 PM, Sergei Golubchik > <serg(a)mariadb.org <mailto:serg@mariadb.org> > <mailto:serg@mariadb.org <mailto:serg@mariadb.org>>> wrote: > > Hi, Mark! > > On Apr 04, Mark Callaghan wrote: > > With upstream (5.6 and 5.7) MySQL when I use cmake > > -DCMAKE_INSTALL_PREFIX=$X, then after I install > the build, > mysqld searches > > in $X/etc for my.cnf. That is not true for MariaDB > Server > 10.2. Why can't > > this match upstream? > > > It certainly can. It just doesn't. Because we merge > from 5.6 into > MariaDB feature by feature, and nobody has requested > this > particular > feature so far. At least I couldn't find it in Jira. > > Regards, > Sergei > Chief Architect MariaDB > and security(a)mariadb.org > <mailto:security@mariadb.org> <mailto:security@mariadb.org > <mailto:security@mariadb.org>> _______________________________________________ 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] restore db from dump?
by l vic 05 Apr '17

05 Apr '17

Hello, I have "mydump.sql" with dump of all databases in cluster. I am trying to selectively restore one database only from the scenario below: Have created 2 databases: test1 and test2 with table "person": +-------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+--------------+------+-----+---------+-------+ | name | varchar(255) | YES | | NULL | | +-------+--------------+------+-----+---------+-------+ Insert name "one" into table "person" for both databases: insert into person values ('name'); Backup all data into "mysqldump.sql": mysqldump -P3306 -uroot -pdbpass --all-databases >mysqldump.sql drop database test2 (my mistake); and insert additional data into "test1": insert into person values ('name1'); insert into person values ('name2'); Now, i'd like to restore database test2 only: mysql -uroot -pdbpass -e "create database if not exists test2;" mysql -uroot -pdbpass test2 < mysqldump.sql Success !! test2 is restored with all the data, but when I'checked "test1" i only see one record "name" - two records that I've added after backup are lost It looks as mysql just restore all data in dump file, regardless of specifying the "target" database. Is that expected, or do i have some error in my backup/restore procedure? If this is expected, is there some comprehensive method to restore one database selectively? Thanks, vl

3 3

[Maria-discuss] searching for etc/my.cnf and CMAKE_INSTALL_PREFIX
by MARK CALLAGHAN 05 Apr '17

05 Apr '17

With upstream (5.6 and 5.7) MySQL when I use cmake -DCMAKE_INSTALL_PREFIX=$X, then after I install the build, mysqld searches in $X/etc for my.cnf. That is not true for MariaDB Server 10.2. Why can't this match upstream? -- Mark Callaghan mdcallag(a)gmail.com

3 8

Re: [Maria-discuss] searching for etc/my.cnf and CMAKE_INSTALL_PREFIX
by Federico Razzoli 05 Apr '17

05 Apr '17

Or maybe people can file bugs/feature requests when they think they have a "practical purpose". If those bugs are ignored, then yes, the page should be edited :) Federico -------------------------------------------- Mer 5/4/17, MARK CALLAGHAN <mdcallag(a)gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] searching for etc/my.cnf and CMAKE_INSTALL_PREFIX A: "Sergei Golubchik" <serg(a)mariadb.org> Cc: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Mercoledì 5 Aprile 2017, 16:50 Maybe someone should edit the too strong claims on https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/ In bold at the top of the page... MariaDB is a binary drop in replacement for MySQL On Tue, Apr 4, 2017 at 9:58 PM, Sergei Golubchik <serg(a)mariadb.org> wrote: Hi, Mark! On Apr 04, Mark Callaghan wrote: > With upstream (5.6 and 5.7) MySQL when I use cmake > -DCMAKE_INSTALL_PREFIX=$X, then after I install the build, mysqld searches > in $X/etc for my.cnf. That is not true for MariaDB Server 10.2. Why can't > this match upstream? It certainly can. It just doesn't. Because we merge from 5.6 into MariaDB feature by feature, and nobody has requested this particular feature so far. At least I couldn't find it in Jira. Regards, Sergei Chief Architect MariaDB and security(a)mariadb.org -- Mark Callaghan mdcallag(a)gmail.com _______________________________________________ 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] thanks for ROW
by Federico Razzoli 03 Apr '17

03 Apr '17

Dear MariaDB team, I have just read carefully this KB page: https://mariadb.com/kb/en/mariadb/row/ Thank you for implementing the ROW type in procedures. We talked about procedures limitations several times in this list, and this is clearly a step in increasing usability and power. Cheers, Federico

1 0

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