catyellow.net – blog |
useful IT info |
After query optimization I just needed to run query several times to check time and compare it with original query. Query code was placed into query.sql file.
TIMEFORMAT=%R && for i in {1..10}; do time mysql < query.sql > /dev/null; done |
My main background for a recent years is MySQL DEV/DBA engineer but I’m also participating in wider range of tasks which could be likely called as DataOps/DevOps tasks. You can see my online CV here: http://catyellow.net
Oneliner to check InnoDB status in MySQL every second:
while sleep 1; do date >> /tmp/mysql_innodb_status_log && mysql -e "show engine innodb status\G;" >> /tmp/mysql_innodb_status_log; done |
My main background for a recent years is MySQL DEV/DBA engineer but I’m also participating in wider range of tasks which could be likely called as DataOps/DevOps tasks. You can see my online CV here: http://catyellow.net
Quick hint about how to resume SCP:
rsync --partial --progress --rsh=ssh username@hostname:remote_filename local_filename |
My main background for a recent years is MySQL DEV/DBA engineer but I’m also participating in wider range of tasks which could be likely called as DataOps/DevOps tasks. You can see my online CV here: http://catyellow.net
Using dd I wanted to see the progress. Solution: add pv. Here it is:
sudo dd if=/path/to/file.iso | pv | sudo dd of=/dev/diskX bs=4m |
My main background for a recent years is MySQL DEV/DBA engineer but I’m also participating in wider range of tasks which could be likely called as DataOps/DevOps tasks. You can see my online CV here: http://catyellow.net
Sometimes scripts aren’t working in cron, but they’re working manually. To debug them it’s helpful to simulate their running under cron environment.
add this to cron and let it to run at least once
* * * * * env > ~/cron_env |
run this command to simulate environment:
env - `cat ~/cron_env` /bin/sh |
My main background for a recent years is MySQL DEV/DBA engineer but I’m also participating in wider range of tasks which could be likely called as DataOps/DevOps tasks. You can see my online CV here: http://catyellow.net
The script will start only in case if the same script is not running.
#!/bin/bash |
if ps -ef | grep -v grep | grep "process name" ; then |
echo "process running" |
exit 0 |
else |
echo "process not running" |
exit 0 |
fi |
My main background for a recent years is MySQL DEV/DBA engineer but I’m also participating in wider range of tasks which could be likely called as DataOps/DevOps tasks. You can see my online CV here: http://catyellow.net
This is how to download git project with key-based access:
ssh-agent bash -c 'ssh-add <key file>; git clone git@bitbucket.org:<user>/<repo name>.git' |
My main background for a recent years is MySQL DEV/DBA engineer but I’m also participating in wider range of tasks which could be likely called as DataOps/DevOps tasks. You can see my online CV here: http://catyellow.net
sudo perl -MCPAN -e 'install DBI' |
My main background for a recent years is MySQL DEV/DBA engineer but I’m also participating in wider range of tasks which could be likely called as DataOps/DevOps tasks. You can see my online CV here: http://catyellow.net
Command:
screen -S [screen id] -p 0 -X quit |
My main background for a recent years is MySQL DEV/DBA engineer but I’m also participating in wider range of tasks which could be likely called as DataOps/DevOps tasks. You can see my online CV here: http://catyellow.net
If you did an Apache installation then you also need to enable 80 port in iptables:
iptables -I INPUT 5 -i eth0 -p tcp --dport 80 -m state --state NEW,ESTABLISHED -j ACCEPT |
My main background for a recent years is MySQL DEV/DBA engineer but I’m also participating in wider range of tasks which could be likely called as DataOps/DevOps tasks. You can see my online CV here: http://catyellow.net