Skip to content

Instantly share code, notes, and snippets.

root@22f3b4dc367f:/var/www/html# composer -vvv install
Reading ./composer.json
Loading config file ./composer.json
Checked CA file /etc/ssl/certs/ca-certificates.crt: valid
Executing command (/var/www/html): git branch --no-color --no-abbrev -v
Executing command (/var/www/html): git describe --exact-match --tags
Executing command (/var/www/html): git log --pretty="%H" -n1 HEAD
Reading /composer/composer.json
Loading config file /composer/composer.json
Reading /var/www/html/vendor/composer/installed.json
avg-cpu: %user %nice %system %iowait %steal %idle
21.90 0.00 6.88 0.53 1.56 69.14
Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util
xvda 0.00 0.00 0.00 1030.00 0.00 40012.00 77.69 39.10 36.14 0.00 36.14 0.26 27.20
avg-cpu: %user %nice %system %iowait %steal %idle
27.65 0.00 8.84 1.29 1.53 60.69
Ran run-tests.sh with the Database testgroup and repeat of 10.
Pgsql: Test run duration: 4 min 3 sec
Mysql: Test run duration: 2 min 2 sec
The run was captured to an scap file using sysdig:
root@ip-172-31-25-132:~# sysdig -r pgsql.scap -c fdbytes_by fd.type
Bytes fd.type
root@ip-172-31-25-132:~# sysdig -r pgsql.scap -c fdbytes_by fd.filename "fd.directory=/var/lib/postgresql/9.1/main/base/16386"
Bytes fd.filename
--------------------------------------------------------------------------------
88.54G 11685
82.67G 11662
849.55M 11666
269.80M 11665
215.53M pg_internal.init
213.22M 11688
199.01M 11689
postgres=# select * from pg_class where pg_relation_filenode(oid) = 11685;
WARNING: terminal is not fully functional
relname | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | reltoastrelid | reltoastidxid | relhasindex | relisshared | relpersistence | relkind | relnatts | relchecks | relhasoids
| relhaspkey | relhasrules | relhastriggers | relhassubclass | relfrozenxid | relacl | reloptions
----------+--------------+---------+-----------+----------+-------+-------------+---------------+----------+-----------+---------------+---------------+-------------+-------------+----------------+---------+----------+-----------+------------
+------------+-------------+----------------+----------------+--------------+---------------+------------
pg_class | 11 | 83 | 0 | 10 | 0 | 0 | 0 | 8 | 281 | 0 | 0 | t | f | p | r |
postgres=# select * from pg_statio_all_tables where relname in ('pg_class','pg_type');
relid | schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit
-------+------------+----------+----------------+---------------+---------------+--------------+-----------------+----------------+----------------+---------------
1247 | pg_catalog | pg_type | 8 | 58 | 13 | 65 | | | |
1259 | pg_catalog | pg_class | 114 | 742 | 30 | 611 | | | |
(2 rows)
@ryanaslett
ryanaslett / Docker Builds
Created February 12, 2017 20:53
output of our latest drupalci docker builds.
This file has been truncated, but you can view the full file.
Started by an SCM change
Building remotely on build1 in workspace /home/bender/jenkins/workspace/drupalci_build_containers
> git rev-parse --is-inside-work-tree # timeout=10
Fetching changes from the remote Git repository
> git config remote.origin.url git://git.drupal.org/project/drupalci_environments.git # timeout=10
Fetching upstream changes from git://git.drupal.org/project/drupalci_environments.git
> git --version # timeout=10
> git fetch --tags --progress git://git.drupal.org/project/drupalci_environments.git +refs/heads/*:refs/remotes/origin/*
Seen branch in repository origin/2609560-Base-DCI-containers-off-official-containers
Seen branch in repository origin/2609642-web-7-official-container
[0x7fa4d8bdf870] basename("core/modules/system/tests/themes/test_invalid_basetheme_sub/test_invalid_basetheme_sub.info.yml", ".info.yml") [internal function]
[0x7fa4d8bdf810] Drupal\Core\Extension\Extension->getName() /var/www/html/core/lib/Drupal/Core/Extension/Extension.php:82
[0x7fa4d8bdf770] Drupal\Core\Extension\ExtensionDiscovery->process(array(41)[0x7fa4d8bdf7c0]) /var/www/html/core/lib/Drupal/Core/Extension/ExtensionDiscovery.php:378
[0x7fa4d8bdf660] Drupal\Core\Extension\ExtensionDiscovery->scan("theme") /var/www/html/core/lib/Drupal/Core/Extension/ExtensionDiscovery.php:221
[0x7fa4d8bdf4c0] Drupal\Core\Extension\ThemeHandler->rebuildThemeData() /var/www/html/core/lib/Drupal/Core/Extension/ThemeHandler.php:247
[0x7fa4d8bdf400] Drupal\Core\Extension\ThemeHandler->refreshInfo() /var/www/html/core/lib/Drupal/Core/Extension/ThemeHandler.php:225
[0x7fa4d8bdf370] Drupal\Core\Extension\ThemeHandler->listInfo() /var/www/html/core/lib/Drupal/Core/Extension/ThemeHandler.php:186
[0x7fa4d8bdf2b0] Drupal\Core\Ext
[0x7f5a2841cfd0] basename("core/modules/system/tests/themes/test_theme_twig_registry_loader_subtheme/test_theme_twig_registry_loader_subtheme.info.yml", ".info.yml") [internal function]
[0x7f5a2841cf70] Drupal\Core\Extension\Extension->getName() /var/www/html/core/lib/Drupal/Core/Extension/Extension.php:82
[0x7f5a2841ced0] Drupal\Core\Extension\ExtensionDiscovery->process(array(41)[0x7f5a2841cf20]) /var/www/html/core/lib/Drupal/Core/Extension/ExtensionDiscovery.php:378
[0x7f5a2841cdc0] Drupal\Core\Extension\ExtensionDiscovery->scan("theme") /var/www/html/core/lib/Drupal/Core/Extension/ExtensionDiscovery.php:221
[0x7f5a2841cc20] Drupal\Core\Extension\ThemeHandler->rebuildThemeData() /var/www/html/core/lib/Drupal/Core/Extension/ThemeHandler.php:247
[0x7f5a2841cb60] Drupal\Core\Extension\ThemeHandler->refreshInfo() /var/www/html/core/lib/Drupal/Core/Extension/ThemeHandler.php:225
[0x7f5a2841cad0] Drupal\Core\Extension\ThemeHandler->listInfo() /var/www/html/core/lib/Drupal/Core/Extension/ThemeHandler.php:186
[0x7
@ryanaslett
ryanaslett / database_cloner.sh
Last active June 12, 2017 17:13
Fix broken replication.
#!/bin/bash
set +uex
#Gather some variables
PRIMARY=$(crm status --as-xml |xpath -q -e "string(/crm_mon/resources/clone/resource[@role='Master']/node/@name)" 2>/dev/null)
REPLICA=$(crm status --as-xml |xpath -q -e "string(/crm_mon/resources/clone/resource[@role='Slave']/node/@name)" 2>/dev/null)
PRIMARY_IP=$(crm status --as-xml |xpath -q -e "string(/crm_mon/node_attributes/node[@name='${PRIMARY}']/attribute[@name='p_mysql_mysql_master_IP']/@value)" 2>/dev/null)
REPLICATION_PW=$(crm configure show xml |xpath -q -e "string(/cib/configuration/resources/master/primitive/instance_attributes/nvpair[@id='p_mysql-instance_attributes-replication_passwd']/@value)" 2>/dev/null)
#disable puppet on both nodes