openstack调试 数据库追踪

openstack调试 数据库跟踪
查看openstack代码
openstack每个命令之后，数据库修改了一堆，无法查看
写了个脚本，
每次操作，看openstack对数据操作了什么

[root@net ~]# cat mysql_openstack.sh 
#!/bin/sh
#for i  in `awk ' {if(NR>4 && NR<40)print $2};' a.log `


mysql_user=root
mysql_password=haoning
mysql_host=controller

if [ "$1" =  "" ]
then
        echo "please use ./mysql_openstack.sh [dbname],  for example: ./mysql_openstack.sh keystone";
        echo "this will exit."
        exit 0;
fi 

echo "use db " $1

for i  in ` mysql -u$mysql_user -h$mysql_host -p$mysql_password  $1  -e "show tables" |awk ' {if(NR>1)print $1};'`
do
        echo "mysql -u$mysql_user -h$mysql_host -p$mysql_password $1 -e \"select * from \`$i\`\"";
        mysql -u$mysql_user -h$mysql_host -p$mysql_password $1 -e "select * from \`$i\`";
done
[root@net ~]# 

效果如图