openstack调试 数据库跟踪

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

[code="java"]
# 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
#
[/code]
效果如图
[img]http://dl2.iteye.com/upload/attachment/0115/5428/3687e241-4af4-35e6-a2c0-c4b9418d96aa.png[/img]