systemd-analyze blame

systemctl show -p Requires lvm2-monitor.service

systemctl disable NetworkManager-wait-online.service

nano /etc/default/grub

GRUB_CMDLINE_LINUX_DEFAULT=

quiet splash

update-grub

sudo pacman -S seahorse

sudo pacman -S cpupower

systemctl start cpupower && systemctl enable cpupower

cat /sys/devices/system/cpu/cpu*/cpufreq/scaling_driver

nano /etc/default/grub

sudo update-grub

sudo reboot

 sudo cpupower frequency-set -d 1.20Ghz -u 2.20Ghz -g powersave -r

cpupower frequency-info

 sudo nano /etc/default/cpupower

sudo reboot

cpupower frequency-info

sudo pacman -S msr-tools

sudo chmod +x ~/turbo-boost.sh

sudo  ~/.oh-my-zsh/turbo-boost.sh disable

sudo  ~/.oh-my-zsh/turbo-boost.sh enable

cpupower frequency-info

• KDE
  
• GNOME SHELL

ssh-keygen -t rsa

ssh sheena@192.168.0.11 mkdir -p .ssh

cat .ssh/id_rsa.pub | ssh sheena@192.168.0.11 'cat >> .ssh/authorized_keys'

ssh sheena@192.168.0.11 "chmod 700 .ssh; chmod 640 .ssh/authorized_keys"

ssh sheena@192.168.0.11

Package.json configuration

"debug": "node $NODE_DEBUG_OPTION node_modules/.bin/webpack-dev-server --config ./path/to/webpack.config.js"

devtool: 'eval-source-map'

Editor configuration

adb devices

adb tcpip 5555

adb connect <IP address of your device>:5555   

adb devices  

sudo apt-get install id3v2

id3v2 -l some_file.mp3

id3v2 -s some_file.mp3

id3v2 -s some_file.mp3

for i in *.mp3; do echo "Processing $i"; id3v2 -s "$i"; done

1. I see all foreign keys to a table or column: SELECT TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_NAME = '<table>'
2. Distinc values in 2 columns from 2 tables:SELECT
    SELECT DISTINCT t1.`ID_POSTULANTE` AS T1_ID_POSTULANTE FROM
     `tb_postulante` t1 INNER JOIN `aulaasignada` as t2
      ON t1.`ID_POSTULANTE` != t2.`ID_POSTULANTE`
      GROUP BY T1_ID_POSTULANTE
3. values duplicate for one column: SELECT certificado_id_correlativo FROM t_certificado_digital group by certificado_id_correlativo having count(*) >= 2
4. update from select: update tabla1 inner join tabla2 on tabla1.id_tabla2 = tabla2.id set tabla1.campo=tabla2.language
   
5. update year sales: update sales set created_at=DATE_FORMAT(created_at, '2020-%m-%d') where YEAR(created_at) < 2020 ;
6. update month sales: update sales set created_at=DATE_FORMAT(created_at, '%y-10-%d') where MONTH(created_at) < 10 ;
7. update day sales: update sales set created_at=DATE_FORMAT(created_at, '%y-%m-25') where DAY(created_at) < 10 and MONTH(created_at) = 10 ;
8. update month invertval sales: update sales set created_at=date_add(created_at, interval 1 month);
9. insert select:
   
1. INSERT INTO generic_stage.entity_items (
       client_id,
       item_type_id,
       item_id,
       action_type,
       action_result,
       marketing_flag,
       creation_timestamp
   )
   SELECT
       '300001' AS client_id,
       8 AS item_type_id,
       cg.id AS item_id,
       1 AS action_type,
       1 AS action_result,
       0 AS marketing_flag,
       NOW() AS creation_timestamp -- use NOW() for current timestamp
   FROM generic_source.item_source cg
   WHERE source_provider_id = 7;
10. 
    

•  https://stackoverflow.com/questions/201621/how-do-i-see-all-foreign-keys-to-a-table-or-column
• http://www.dataprix.com/blog-it/dml/como-hacer-update-select-mysql

#!/bin/bash

sudo mount -o remount,size=40G,noatime /tmp
echo "Done. Please use 'df -h' to make sure folder size is increased."

nano /etc/systemd/system/test.service

[Unit]                                                                                                                                            
Description=test_job                                                                                                                              
                                                                                                                                                  
[Service]                                                                                                                                         
Type=oneshot                                                                                                                                      
ExecStart=/usr/bin/php /tmp/run.php 

nano /etc/systemd/system/test.timer

[Unit]                                                                                                                                            
Description=test                                                                                                                                  
                                                                                                                                                  
[Timer]                                                                                                                                           
OnUnitActiveSec=10s                                                                                                                               
OnBootSec=10s                                                                                                                                     
                                                                                                                                                  
[Install]                                                                                                                                         
WantedBy=timers.target

systemctl daemon-reload

systemctl start test.timer

systemctl list-timers --all

docker run -d --name sonarqube sonarqube

unzip sonar-scanner-cli-*

sudo cp -a sonar-scanner-* /opt/

sudo chmod -R 775 /opt/sonar-scanner-*

sudo ln -s /opt/sonar-scanner-3.2.0.1227-linux/bin/sonar-scanner /bin/sonar-scanner

sudo nano /opt/sonar-scanner-3.2.0.1227-linux/conf/sonar-scanner.properties

# Required metadata
sonar.projectKey=testproject
sonar.projectName=testproject
sonar.projectVersion=1.0.0

# Path to the parent source code directory.
sonar.sources=app

# Language
# We've commented this out, because we want to analyse both PHP and Javascript
#sonar.language=php

# Encoding of the source code
sonar.sourceEncoding=UTF-8

# Reusing PHPUnit reports
sonar.php.coverage.reportPath=ci/codeCoverage/codeCoverage.xml
sonar.php.tests.reportPath=ci/testResults.xml

# Here, you can exclude all the directories that you don't want to analyse.
# As an example, I'm excluding the Providers directory
sonar.exclusions=app/Providers/**

# Additional parameters
#sonar.my.property=value

# Required metadata
sonar.projectKey=project1
sonar.projectName=project1
sonar.projectVersion=1.0.0

# Path to the parent source code directory.
sonar.sources=app

# Language
# We've commented this out, because we want to analyse both PHP and Javascript
sonar.language=php

# Encoding of the source code
sonar.sourceEncoding=UTF-8

# Reusing PHPUnit reports
sonar.php.coverage.reportPath=ci/codeCoverage/codeCoverage.xml
sonar.php.tests.reportPath=ci/testResults.xml

# Here, you can exclude all the directories that you don't want to analyse.
# As an example, I'm excluding the Providers directory
sonar.exclusions=vendor/**

# Additional parameters
#sonar.my.property=value

sonar-scanner -e -X

sudo apt-get install jdk7-openjdk

./ireport --jdkhome "/usr/lib/jvm/java-7-jdk/"