blob: 995396095a4de6429d43c3f95373badfe5df782d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
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
|
