…/run_worker to contain the following: #!/bin/bash while [ 1 ] do ./worker >> /dev/null 2>&1 … data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact… summarize the output from the ./run_query command, called pivot_results cd shard-query/ $ ./run_query …
Post: High availability for MySQL on Amazon EC2 - Part 5 - The instance monitoring script
October 22, 2010 By Leave a Comment
… MySQL node. At its smallest expression, the instance monitoring script is a simple empty loop that will run forever like: #!/bin/bash… provide a basic functional one that monitor MySQL with the mysqladmin ping command. #!/bin/sh # MySQL basedir passed as argument # mysqladmin must be… on the Monitor node will loop and restart again the MySQL node. Stopping the heartbeat service achieve the desired result without…
Post: Announcing Percona Toolkit Release 2.0.3
February 6, 2012 By 2 Comments
… Nichter. This tool is also completely rewritten. Instead of a Bash script that you have to configure with environment variables and… a “real” Percona Toolkit tool ought to have, such as command-line options and a configuration file. In addition, we merged…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
… don’t noticeably affect the results. Here is the tcpdump command used. tcpdump -i eth0 -s 65535 -x -n -q -tttt… your own risk and update to suit your needs. #!/bin/bash # Set some defaults d=$(date +%F-%T | tr :- _) self=`basename…
Comment: Neat tricks for the MySQL command-line pager
June 24, 2008 By 10 Comments
…. superpager.bash: #!/bin/bash teefile=~/.mysqltee goback=100 # find the last ^mysql> lastcmd=$(tail -n $goback $teefile | grep “^mysql> “|tail -1| awk -F”mysql> ” ‘{print… passed args like “last command” but this is a decent enough hack until they implement that in version 6.1 of mysql. 
Post: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
May 19, 2010 By 9 Comments
…:~# cat /usr/local/bin/fake_ndb_mgmd #!/bin/bash /usr/bin/nohup /usr/local/mysql/libexec/ndb_mgmd > /dev/null & while [ 1…_cluster_start #!/bin/bash #Give some time to the nodes to connect /bin/sleep 15 /usr/local/mysql/bin/ndb_mgm -e… cib in xml format, editing and reloading. In term of commands, it means: cibadmin –query > local.xml vi local.xml cibadmin…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
… to quote each field. After that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD DATA INFILE ‘/data/d1/AirData…. LucidDB Here it took time to find how to execute command from command line using included sqlline utility, and I did not… results are impressive. On drawbacks – the command line is weak ( I had to use bash and pass query as parameter, otherwise I…
Comment: Slow Query Log analyzes tools
November 19, 2008 By 83 Comments
… is more attractive,so I just installed Fedora 9 and MySQL 5.1.29. Unfortunately, I am newbie in Linux and… install,when I download the mysql_slow_log_filter file and issue the command “tail -f mysql-slow.log | mysql_slow_log_filter -T 0.5 -R 1000″, the result is always “bash: mysql_slow_log_filter: command…
