Databases

если в логах постоянно появляется:
ERROR: relation "pg_stat_statements" does not exist at character 536

и обнаружена проблема в отсутствии полей min_time/max_time/mean_time/stddev_time (https://github.com/prometheus-community/postgres_exporter/issues/541)
фиксим так:

CREATE EXTENSION pg_stat_statements;

и переименовываем поля:
total_time -> total_exec_time
min_time ->

Подробнее

#!/bin/bash

echo 'proxy=socks5://10.35.215.218:443' >/root/.curlrc
echo 'export PATH=/usr/local/bin:${PATH}' >/etc/profile.d/reindexer.sh
git clone https://github.com/Restream/reindexer.git

cd reindexer
./dependencies.sh

cd cpp_src
mkdir -p build

cd build
cmake ..
make -j8
make swagger
make face
make install

useradd --system --home-dir /var/lib/reindexer --no-create-home --shell /sbin/nologin reindexer
mv /etc/reindexer.conf.pkg /etc/reindexer.conf

chkconfig --add reindexer
service

Подробнее

$ cat /etc/my.cnf.d/passw_policy.cnf
## SHOW VARIABLES LIKE 'validate_password%';

[mysqld]

## password validation
#validate_password.check_user_name=ON
validate_password.length=0
validate_password.mixed_case_count=0
validate_password.number_count=0
validate_password.policy=0
validate_password.special_char_count=0

# disable password lifetime
default_password_lifetime=0


$ systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"

$ service mysqld restart

$ mysql -uroot


SET GLOBAL

Подробнее

select q1.tablespace_name, q1.file_id
      ,trunc(q1.all_space/1024/1024) all_space
      ,trunc(q2.free_space/1024/1024) free_space
  from (select tablespace_name, file_id, sum(user_bytes) all_space
          from dba_data_files
         group by tablespace_name, file_id) q1
      ,(select tablespace_name, file_id, sum(bytes) free_space
          from dba_free_space free
         group by

Подробнее

По дефолту при вводе простого пароля MySQL ругается следующей ошибкой:
ERROR 1819 (HY000) at line 10: Your password does not satisfy the current policy requirements

Отключаем эту фигню так:
# cat /etc/my.cnf.d/passw_policy.cnf
##

Подробнее

There are two ways to create a new database on existing oracle db server. One is using 'CREATE DATABASE' sql statement[this is too long,hard for me]. Another is using DBCA(Database

Подробнее

Приконнектиться как sysdba:
sqlplus "sys/PASSWORD@SID as sysdba"

Показать список заблокированных пользователей:
select username,account_status from dba_users where account_status like '%LOCK%';

Посмотреть парольные политики:

SELECT resource_name, limit FROM dba_profiles  WHERE profile = 'DEFAULT' AND resource_type =

Подробнее

SELECT file_name, CEIL (blocks * t.block_size / 1024 / 1024) current_mb,
CEIL ((NVL (hwm, 1) * t.block_size) / 1024 / 1024) smallest_mb
FROM dba_data_files a,
dba_tablespaces t,
(SELECT file_id, MAX (block_id + blocks - 1)

Подробнее