Hi,
There two little qustion in MariaDB 10.1.31, please confirm, thanks.
1) After install MariaDB 10.1.31 , in error log show xtradb version
5.6.36-83.0 ?
it should 5.6.38-83.0
2018-02-07 19:07:47 140196300970016 [Note] InnoDB: Percona XtraDB (
http://www.percona.com) 5.6.36-83.0 star
Hi,
Recently, we upgrade 8 MariaDB slaves from MariaDB 10.1.22 to MariaDB
10.2.6.
In error log, it frequent occurrence some innodb Note:
.
2017-06-26 9:01:03 140022654363392 [Note] InnoDB: page_cleaner: 1000ms
intended loop took 6142ms. The settings might not be optimal. (flus
HI,
Today, we upgrade a group MariaDB 10.1.22 to MariaDB 10.2.6, after
upgade, start delay slave : change master to master_delay=86400
start slave and execute show all slaves status ,
Seconds_Behind_Master continue grow and Exec_Master_Log_Pos not change,
please help confirm what
+08:00 Ljr Yang :
> Thank you reply.
> 1) it have not "Starting semi-sync replication" in master's error log
>
> 2) slave1 : 10.1.0.62 (serverid = 62), slave2 : 10.1.0.63 (serverid = 63)
>
> on two slaves, all set rpl_semi_sync_master_enabled = on and
> log_s
eally true?
> Such setting on the slaves will probably work only if
> log_slave_updates is set to OFF. Is it set to OFF on your slaves? If
> not then you should set rpl_semi_sync_master_enabled to OFF on the
> slaves to not make them wait for their slaves (which don't exist) to
> ack the commi
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 machi
Hi,
we config master slave and set log_slave_updates = 1 on slave.
on master server‘s binlog file and pos , example: mysql-bin.05
2036891 ,
how could quick find corresponding binlog file and pos on slave?
Thanks.
--
Ljr
___
Mailing li
HI, all
We use MariaDB 10.1.18 and CentOS 6.7, today, try to use server audit log.
after execute SET GLOBAL server_audit_events =
"query_ddl,query_dml,query_dcl" and
SET GLOBAL server_audit_logging = 1 ;
find have not filter "select" statement in audit log
20161102
11:08:52,fm-test-118,root,
Hi, all
Today, we use optimize table in MariaDB 10.1.16.
Table test01 have about 2 millions records.
session 1: optimize table test01;
session 2: select count(*) from test01 ;
when session 1 run, In processlist session 2 state: Waiting FOR TABLE
LEVEL LOCK
we had set innodb_d
Hi, All
we use MariaDB 10.1.16 , about have 30 machines. Recently ,there one
master and slave's ibdat1 growed to about 4GB, others machine are normal.
mainly parameter in my.cnf :
innodb_data_home_dir = /data/mysql/data
innodb_data_file_path = ibdata1:2G:autoextend
innodb_log_files_in_group=3
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 sla
Hi, All
Recently, We use Sysbench Test MariaDB 10.1.13. In Test ,We found
server lock and can't write .
Testing environment:
server1: 10.2.1.242(HP OEM Fusion IO PCIE Card 3.2TB )
server2: 10.2.1.239(ScanDisk Fusion IO PCIE Card 3.2TB)
sysbench test script:
sysbench --test=/usr
12 matches
Mail list logo
