diff options
Diffstat (limited to 'qa/archives/mk.mysql.sh')
| -rwxr-xr-x | qa/archives/mk.mysql.sh | 63 |
1 files changed, 63 insertions, 0 deletions
diff --git a/qa/archives/mk.mysql.sh b/qa/archives/mk.mysql.sh new file mode 100755 index 0000000..9953960 --- /dev/null +++ b/qa/archives/mk.mysql.sh @@ -0,0 +1,63 @@ +#!/bin/sh +# +# Recipe for creating the mysql archive +# + +. $PCP_DIR/etc/pcp.env + +here=`pwd` +tmp=/tmp/$$ +rm -rf $tmp + +if pmprobe mysql 2>&1 | grep -q 'Unknown metric name' +then + echo "Arrg, mysql PMDA is apparently not installed" + exit 1 +fi + +version=0 +while [ -f mysql-$version.0 ] +do + version=`expr $version + 1` +done + +trap "rm -rf $tmp; exit" 0 1 2 3 15 + +echo 'log mandatory on 5sec { mysql }' >$tmp.config +${PCP_BINADM_DIR}/pmlogger -s 5 -c $tmp.config mysql-$version & + +# Now do some work to make mysql stats move a little +# We assume the example classicmodels DB has been installed +# (available from http://www.mysqltutorial.org/mysql-sample-database.aspx) +# and is available to be used. +# +# May need to change the user and password ... +SQLUSER=root +SQLPASSWORD=letmein + +for i in 1 2 3 4 5 6 +do + sleep 4 + cat <<End-of-File | mysql -u$SQLUSER -p$SQLPASSWORD classicmodels +select count(*) from customers; +select count(*) from payments; +select count(*) from employees; +select count(*) from offices; +select count(*) from orders; +select count(*) from orderdetails; +select count(*) from products; +select count(*) from productlines; + +select productCode, productName, textDescription +from products c1 inner join productlines c2 +on c1.productline = c2.productline; + +select c1.orderNumber, status, sum(quantityOrdered*priceEach) total +from orders as c1 inner join orderdetails +as c2 on c1.orderNumber = c2.orderNumber +group by orderNumber; + +End-of-File +done + +wait |