Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Files
F31955340
raw.txt
No One
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Authored By
jcrespo
Jul 31 2020, 8:57 AM
2020-07-31 08:57:40 (UTC+0)
Size
2 KB
Referenced Files
None
Subscribers
None
raw.txt
View Options
MyFirstPC:$ ssh db1108.eqiad.wmnet
Linux db1108 4.19.0-9-amd64 #1 SMP Debian 4.19.118-2+deb10u1 (2020-06-07) x86_64
Debian GNU/Linux 10 (buster)
db1108 is a Backup Analytics Multiinstance Databases (mariadb::misc::analytics::backup)
The last Puppet run was at Fri Jul 31 08:44:01 UTC 2020 (11 minutes ago).
Last puppet commit: (eb4ac7c5be) Jaime Crespo - mariadb: Increase analytics binlog retention time to 14 days
Debian GNU/Linux 10 auto-installed on Wed Jun 24 16:23:57 UTC 2020.
Last login: Fri Jul 31 08:44:15 2020 from 2620:0:862:1:91:198:174:60
jynus@db1108:~$ sudo -s
root@db1108:~$ run-puppet-agent
Info: Using configured environment 'production'
Info: Retrieving pluginfacts
Info: Retrieving plugin
Info: Retrieving locales
Info: Loading facts
Info: Caching catalog for db1108.eqiad.wmnet
Info: Applying configuration version '(b9f066737c) Jaime Crespo - mariadb: Increase misc db binlog retention to 14 days'
Notice: /Stage[main]/Mariadb::Config/File[/etc/my.cnf]/content:
--- /etc/my.cnf 2020-07-02 07:33:58.030362178 +0000
+++ /tmp/puppet-file20200731-16714-7yior1 2020-07-31 08:55:50.951563504 +0000
@@ -43,7 +43,7 @@
binlog_cache_size = 1M
max_binlog_size = 1000M
binlog_format =
-expire_logs_days = 7
+expire_logs_days = 14
slave_transaction_retries = 4294967295
table_open_cache = 5000
Info: Computing checksum on file /etc/my.cnf
Info: /Stage[main]/Mariadb::Config/File[/etc/my.cnf]: Filebucketed /etc/my.cnf to puppet with sum 3de49fae2016c9ef773fa4616cdd042f
Notice: /Stage[main]/Mariadb::Config/File[/etc/my.cnf]/content: content changed '{md5}3de49fae2016c9ef773fa4616cdd042f' to '{md5}401fd5cfd3e47f42af1c570866061196'
Notice: Applied catalog in 11.20 seconds
root@db1108:~$ my matomo
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 564
Server version: 10.4.13-MariaDB-log MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
root@db1108[(none)]> SET GLOBAL expire_logs_days=14;
Query OK, 0 rows affected (0.000 sec)
root@db1108[(none)]> Bye
root@db1108:~$ my analytics_meta
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 571
Server version: 10.4.13-MariaDB-log MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
root@db1108[(none)]> SET GLOBAL expire_logs_days=14;
Query OK, 0 rows affected (0.000 sec)
File Metadata
Details
Attached
Mime Type
text/plain; charset=utf-8
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
8485738
Default Alt Text
raw.txt (2 KB)
Attached To
Mode
P12131 update options in a hot way
Attached
Detach File
Event Timeline
Log In to Comment