Databases

Просмотров: 214

если в логах постоянно появляется:
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 -> min_exec_time
max_time -> max_exec_time
mean_time -> mean_exec_time
stddev_time -> stddev_exec_time

т.к. в оф доке разделили выполнение на plan и exec, также изменили названия параметров (https://www.postgresql.org/docs/13/pgstatstatements.html)

Просмотров: 2789

#!/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 reindexer start
Просмотров: 2339

$ 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 validate_password.policy=LOW;
ALTER USER USER() IDENTIFIED BY 'new_mysql_root_password';
FLUSH PRIVILEGES;

$ systemctl unset MYSQLD_OPTS="--skip-grant-tables"
Просмотров: 1383

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 tablespace_name, file_id) q2
 where q1.tablespace_name = q2.tablespace_name(+)
   and q1.file_id = q2.file_id(+)
  order by q1.tablespace_name, q1.file_id;

Категории