Skip to content

Instantly share code, notes, and snippets.

View guriandoro's full-sized avatar

グリアンドロ guriandoro

View GitHub Profile
@guriandoro
guriandoro / pt-stalk-pg_gather-integration-tests.sh
Created December 2, 2022 20:50
Tests for integrating pt-stalk and pg_gather.
./anydbver deploy \
node0 pg:13 sysbench sysbench-pg:node0 oltp_read_write \
node1 sysbench sysbench-pg:node0 oltp_read_write
./anydbver ssh node1
percona-release setup ppg-11
yum -y install percona-postgresql11-libs
/usr/local/bin/run_sysbench.sh
./anydbver ssh node0
pi@raspberrypi:~ $ sudo apt-get install git vim
pi@raspberrypi:~ $ curl -LO https://golang.org/dl/go1.15.2.linux-armv6l.tar.gz
pi@raspberrypi:~ $ tar xzf go1.15.2.linux-armv6l.tar.gz
pi@raspberrypi:~ $ sudo mv go /usr/local/go
pi@raspberrypi:~ $ echo "export PATH=\$PATH:/usr/local/go/bin" >> .bashrc
pi@raspberrypi:~ $ source .bashrc
pi@raspberrypi:~ $ go version
pi@raspberrypi:~ $ mkdir -p ~/go/src/github.com/percona/
pi@raspberrypi:~ $ cd ~/go/src/github.com/percona/
sudo yum -y install vim wget git
sudo yum -y install glibc-static.aarch64 gcc.aarch64
mkdir -p ~/go/src/github.com/percona/
cd $_
git clone https://github.com/percona/pmm-admin.git
git clone https://github.com/percona/pmm-agent.git
git clone https://github.com/percona/node_exporter.git
cd /tmp/
#!/bin/bash
readonly mysql_command="/home/agustin.gallego/sandboxes/ps_5.7.25/use";
echo "--> Creating tables in MySQL.";
date;
# Create schema and tables needed
$mysql_command -e "CREATE SCHEMA IF NOT EXISTS ar";
$mysql_command -e "DROP TABLE IF EXISTS ar.percona_server_modules";
This file has been truncated, but you can view the full file.
{
"features": [
{
"geometry": {
"coordinates": [
[
[
-56.199340053606321,
-34.905494773940909
],
#!/bin/bash
# Example link:
# http://www.precios.uy/images/sipc/analisisdeprecios/reportes/mensual/2017/Setiembre/cadenas.pdf
for year in `seq 2016 2018`; do
month_numeric=1;
echo $year;
mkdir $year && cd $year;
for month in Enero Febrero Marzo Abril Mayo Junio Julio Agosto Setiembre Octubre Noviembre Diciembre; do
@guriandoro
guriandoro / install_pmm_highram.sh
Created April 3, 2019 18:41
Steps to install pmm server on highram, using /bigdisk/pmm/ as mount point.
mkdir -p /bigdisk/pmm/opt/
mkdir -p /bigdisk/pmm/opt/prometheus
mkdir -p /bigdisk/pmm/var/lib/
docker create \
-v /opt/prometheus/data \
-v /opt/consul-data \
-v /var/lib/mysql \
-v /var/lib/grafana \