(An Untitled Masterwork)
ActivePublic
Actions

Authored by Marostegui on May 25 2018, 2:30 PM.

Tags

None

Referenced Files

	F18527874:
	May 25 2018, 2:30 PM

Subscribers

None

	root@neodymium:/home/marostegui# for i in db1102 db1120 db1125; do echo "==$i==" ; /home/jynus/mysql.py -h$i -P3316 -e "select count(*) from ruwiki.user;" -BN ;done
	==db1102==
	2303811
	==db1120==
	2303811
	==db1125==
	2303790

Event Timeline

Marostegui created this paste.May 25 2018, 2:30 PM

root@db1125:/home/marostegui# diff -u db1120_config /etc/mysql/mysqld.conf.d/s6.cnf
--- db1120_config	2018-05-25 14:35:13.405602947 +0000
+++ /etc/mysql/mysqld.conf.d/s6.cnf	2018-05-24 17:37:42.477204542 +0000
@@ -3,4 +3,4 @@
 tmpdir=/srv/tmp.s6
 socket=/run/mysqld/mysqld.s6.sock
 port=3316
-innodb_buffer_pool_size = 76G
+innodb_buffer_pool_size = 30G

root@db1061:~# cat /etc/my.cnf | grep server_id
server_id  = 171974883
root@db1061:~# mysql --skip-ssl -e "select @@hostname;select @@server_id"
+------------+
| @@hostname |
+------------+
| db1061     |
+------------+
+-------------+
| @@server_id |
+-------------+
|   171978766 |
+-------------+

(An Untitled Masterwork)ActivePublicActions

Event Timeline

(An Untitled Masterwork)
ActivePublic
Actions