自制数据库空洞率清理工具-C版-03-EasyClean-V1.2（支持南大通用数据库Gbase8a）

1、配置环境变量 /home/gbase/.bashrc中添加如下 export CLEAN_VOID_RATE_TOOL_HOME=/home/gbase/EasyClean/ export LD_LIBRARY_PATH=$CLEAN_VOID_RATE_TOOL_HOME/Libs:$LD_LIBRARY_PATH 2、生效环境变量 source /home/gbase/.bashrc 3、检验动态链接是否正常 [gbase@czg0 Exec]$ ldd Manager linux-vdso.so.1 => (0x00007ffe315b5000) libPublicFunction.so => /home/gbase/EasyClean//Libs/libPublicFunction.so (0x00007f54c1a1b000) libLog.so => /home/gbase/EasyClean//Libs/libLog.so (0x00007f54c1817000) libGbase8aOperate.so => /home/gbase/EasyClean//Libs/libGbase8aOperate.so (0x00007f54c160a000) libgbase.so.16 => /home/gbase/EasyClean//Libs/libgbase.so.16 (0x00007f54c114a000) libSqQueue.so => /home/gbase/EasyClean//Libs/libSqQueue.so (0x00007f54c0f45000) libDataConvertion.so => /home/gbase/EasyClean//Libs/libDataConvertion.so (0x00007f54c0d42000) libProcess.so => /home/gbase/EasyClean//Libs/libProcess.so (0x00007f54c0b3e000) libFileOperate.so => /home/gbase/EasyClean//Libs/libFileOperate.so (0x00007f54c0938000) libMyHashTable.so => /home/gbase/EasyClean//Libs/libMyHashTable.so (0x00007f54c0734000) libc.so.6 => /lib64/libc.so.6 (0x00007f54c0366000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f54c014a000) libdl.so.2 => /lib64/libdl.so.2 (0x00007f54bff46000) libm.so.6 => /lib64/libm.so.6 (0x00007f54bfc44000) /lib64/ld-linux-x86-64.so.2 (0x00007f54c1c1e000) [gbase@czg0 Exec]$ ldd Executor linux-vdso.so.1 => (0x00007ffddffde000) libPublicFunction.so => /home/gbase/EasyClean//Libs/libPublicFunction.so (0x00007f7563dff000) libLog.so => /home/gbase/EasyClean//Libs/libLog.so (0x00007f7563bfb000) libGbase8aOperate.so => /home/gbase/EasyClean//Libs/libGbase8aOperate.so (0x00007f75639ee000) libgbase.so.16 => /home/gbase/EasyClean//Libs/libgbase.so.16 (0x00007f756352e000) libSqQueue.so => /home/gbase/EasyClean//Libs/libSqQueue.so (0x00007f7563329000) libDataConvertion.so => /home/gbase/EasyClean//Libs/libDataConvertion.so (0x00007f7563126000) libProcess.so => /home/gbase/EasyClean//Libs/libProcess.so (0x00007f7562f22000) libFileOperate.so => /home/gbase/EasyClean//Libs/libFileOperate.so (0x00007f7562d1c000) libMyHashTable.so => /home/gbase/EasyClean//Libs/libMyHashTable.so (0x00007f7562b18000) libc.so.6 => /lib64/libc.so.6 (0x00007f756274a000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f756252e000) libdl.so.2 => /lib64/libdl.so.2 (0x00007f756232a000) libm.so.6 => /lib64/libm.so.6 (0x00007f7562028000) /lib64/ld-linux-x86-64.so.2 (0x00007f7564002000) 如果有动态库没有找到，就要看看环境变量是否配置正确或是否生效。 4、运行例子 [gbase@czg0 EasyClean]$ ./Manager '192.168.142.12;czg;qwer1234;gbase;5258;utf8;3;zxj;0;2;' 5、参数介绍 序号 参数 备注 1 DbHost 连接源端数据库IP。 2 DbUser 连接源端数据库用户。 3 DbPwd 连接源端数据库用户密码。 4 DbName 连接源端数据库。 5 DbPort 连接源端数据库端口号。 6 DbCharset 连接源端数据库的字符集。 7 ChdProcessNum 启动的子进程数。 8 TargetDb 需要清理空洞率的数据库。 9 VoidRate 空洞率到达此值时进行清理，1-100。 10 CleanTabNum 清理TargetDb下空洞率超过VoidRate的表的个数。如果是0，表示无限制。