Skip to content

Instantly share code, notes, and snippets.

MYSQL Docker has multiple files for conf so i show all fles output
$ cat conf.d/docker.cnf
[mysqld]
skip-host-cache
skip-name-resolve
$ cat conf.d/mysql.cnf
[mysql]
$ cat conf.d/mysqldump.cnf
[mysqldump]
I have no name!@db-1-wpfth:/tmp$ ulimit -a
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 127577
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 1048576
pipe size (512 bytes, -p) 8
I have no name!@db-1-wpfth:/tmp$ perl mysqltuner.pl
whoami: cannot find name for user ID 1000250000
>> MySQLTuner 1.7.19 - Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
[--] Skipped version check for MySQLTuner script
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password: [OK] Currently running supported MySQL version 5.7.28
[OK] Operating on 64-bit architecture
auto_generate_certs ON
auto_increment_increment 1
auto_increment_offset 1
autocommit ON
automatic_sp_privileges ON
avoid_temporal_upgrade OFF
back_log 80
basedir /usr/
big_tables OFF
bind_address 0.0.0.0
Aborted_clients 0
Aborted_connects 167
Binlog_cache_disk_use 0
Binlog_cache_use 0
Binlog_stmt_cache_disk_use 0
Binlog_stmt_cache_use 0
Bytes_received 10509
Bytes_sent 198400
Com_admin_commands 140
Com_assign_to_keycache 0
2020-01-20 10:50:39+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.28-1debian9 started.
2020-01-20T10:50:39.685893Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-01-20T10:50:39.690345Z 0 [Note] mysqld (mysqld 5.7.28) starting as process 1 ...
2020-01-20T10:50:39.700703Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-01-20T10:50:39.700722Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-01-20T10:50:39.700726Z 0 [Note] InnoDB: Uses event mutexes
2020-01-20T10:50:39.700729Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-01-20T10:50:39.700732Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-01-20T10:50:39.700734Z 0 [Note] InnoDB: Using Linux native AIO
2020-01-20T10:50:39.700981Z 0 [Note] InnoDB: Number of pools: 1
apiVersion: v1
data:
fluent.conf: |
....
<label @OUTPUT>
## matches
@include configs.d/openshift/output-pre-*.conf
@include configs.d/user/output-operations.conf
@include configs.d/openshift/output-applications.conf
Oct 25 16:08:35 xdww002.my.local origin-node[18869]: E1025 16:08:35.035241 18869 event.go:212] Unable to write event: 'Patch https://xdww001.my.local:8443/api/v1/namespaces/kube-system/events/master-etcd-xdww002.my.local.15d0e894c53b9128: dial tcp 10.11.0.178:8443: i/o timeout' (may retry after sleeping)
Oct 25 16:08:35 xdww002.my.local dockerd-current[6249]: 2019-10-25 16:08:35.205055 I | raft: 1f1b1f1969afb782 is starting a new election at term 366
Oct 25 16:08:35 xdww002.my.local dockerd-current[6249]: 2019-10-25 16:08:35.205078 I | raft: 1f1b1f1969afb782 became candidate at term 367
Oct 25 16:08:35 xdww002.my.local dockerd-current[6249]: 2019-10-25 16:08:35.205090 I | raft: 1f1b1f1969afb782 received MsgVoteResp from 1f1b1f1969afb782 at term 367
Oct 25 16:08:35 xdww002.my.local dockerd-current[6249]: 2019-10-25 16:08:35.205103 I | raft: 1f1b1f1969afb782 [logterm: 243, index: 23857] sent MsgVote request to bbda256326db0d46 at term 367
Oct 25 16:08:35 xdww002.my.local dockerd-current[6249]: E1025 14:08:35.
Trace:
DEBUG http-outgoing-0 >> GET /api/v1/watch/namespaces/my-qa/configmaps/my-config-map HTTP/1.1
DEBUG http-outgoing-0 >> Accept: application/json
DEBUG http-outgoing-0 >> Authorization: Bearer xxx
DEBUG http-outgoing-0 >> breadcrumbId: ID-NB-118-1568476509695-0-1
DEBUG http-outgoing-0 >> firedTime: Sat Sep 14 17:55:14 CEST 2019
DEBUG http-outgoing-0 >> Host: localhost:8443
DEBUG http-outgoing-0 >> Connection: Keep-Alive
DEBUG http-outgoing-0 >> User-Agent: Apache-HttpClient/4.5.6 (Java/1.8.0_162)
DEBUG http-outgoing-0 >> Accept-Encoding: gzip,deflate
@imranrazakhan
imranrazakhan / gist:fa69035bdad111a27dc354e2fc44ec50
Created October 17, 2018 16:27
Container runtime network not ready
Oct 17 16:26:38 c1-ocp origin-node: exec openshift start network --config=/etc/origin/node/node-config.yaml --kubeconfig=/tmp/kubeconfig --loglevel=${DEBUG_LOGLEVEL:-2}
Oct 17 16:26:38 c1-ocp origin-node: ] Args:[] WorkingDir: Ports:[{Name:healthz HostPort:10256 ContainerPort:10256 Protocol:TCP HostIP:}] EnvFrom:[] Env:[{Name:OPENSHIFT_DNS_DOMAIN
Value:cluster.local ValueFrom:nil}] Resources:{Limits:map[] Requests:map[cpu:{i:{value:100 scale:-3} d:{Dec:<nil>} s:100m Format:DecimalSI} memory:{i:{value:209715200 scale:0} d:{D
ec:<nil>} s: Format:BinarySI}]} VolumeMounts:[{Name:host-config ReadOnly:true MountPath:/etc/origin/node/ SubPath: MountPropagation:<nil>} {Name:host-sysconfig-node ReadOnly:true M
ountPath:/etc/sysconfig/origin-node SubPath: MountPropagation:<nil>} {Name:host-var-run ReadOnly:false MountPath:/var/run SubPath: MountPropagation:<nil>} {Name:host-var-run-dbus R
eadOnly:true MountPath:/var/run/dbus/ SubPath: MountPropagation:<nil>} {Name:host-var-run-ovs ReadOnly:true MountPath:/var/run/openv