linux 下使用c操作mysql数据库时写个测试程序 int main(void){ mysql m_mysql; mysql_init(m_mysql); const char plocalhost[] = localhost; const char puser[] = root; const char ppass[] = 123456; const char pdb[] = httpcontrol; if(mysql_re
linux 下使用c操作mysql数据库时写个测试程序
int main(void){ mysql m_mysql; mysql_init(&m_mysql); const char plocalhost[] = localhost; const char puser[] = root; const char ppass[] = 123456; const char pdb[] = httpcontrol; if(mysql_real_connect(&m_mysql,plocalhost,puser,ppass,pdb,0,null,0) == null) cout
编译后使用valgrind检测内存泄露
[root@localhost string]# valgrind --tool=memcheck --leak-check=full ./mysql
==10352== memcheck, a memory error detector
==10352== copyright (c) 2002-2009, and gnu gpl'd, by julian seward et al.
==10352== using valgrind-3.5.0 and libvex; rerun with -h for copyright info
==10352== command: ./mysql
==10352==
connect success
==10352==
==10352== heap summary:
==10352==     in use at exit: 61,336 bytes in 16 blocks
==10352==   total heap usage: 118 allocs, 102 frees, 115,929 bytes allocated
==10352==
==10352== 24,528 bytes in 6 blocks are possibly lost in loss record 4 of 5
==10352==    at 0x4005903: malloc (vg_replace_malloc.c:195)
==10352==    by 0x30dd75: my_once_alloc (in /usr/lib/mysql/libmysqlclient.so.15.0.0)
==10352==    by 0x30e59c: ? (in /usr/lib/mysql/libmysqlclient.so.15.0.0)
==10352==    by 0x30ef96: ? (in /usr/lib/mysql/libmysqlclient.so.15.0.0)
==10352==    by 0x30f111: get_charset_by_csname (in /usr/lib/mysql/libmysqlclient.so.15.0.0)
==10352==    by 0x32c3d2: mysql_init_character_set (in /usr/lib/mysql/libmysqlclient.so.15.0.0)
==10352==    by 0x32dabb: mysql_real_connect (in /usr/lib/mysql/libmysqlclient.so.15.0.0)
==10352==    by 0x8048a76: main (str.cpp:32)
==10352==
==10352== 28,616 bytes in 7 blocks are possibly lost in loss record 5 of 5
==10352==    at 0x4005903: malloc (vg_replace_malloc.c:195)
==10352==    by 0x30dd75: my_once_alloc (in /usr/lib/mysql/libmysqlclient.so.15.0.0)
==10352==    by 0x30e57a: ? (in /usr/lib/mysql/libmysqlclient.so.15.0.0)
==10352==    by 0x30ef96: ? (in /usr/lib/mysql/libmysqlclient.so.15.0.0)
==10352==    by 0x30f111: get_charset_by_csname (in /usr/lib/mysql/libmysqlclient.so.15.0.0)
==10352==    by 0x32c3d2: mysql_init_character_set (in /usr/lib/mysql/libmysqlclient.so.15.0.0)
==10352==    by 0x32dabb: mysql_real_connect (in /usr/lib/mysql/libmysqlclient.so.15.0.0)
==10352==    by 0x8048a76: main (str.cpp:32)
==10352==
==10352== leak summary:
==10352==    definitely lost: 0 bytes in 0 blocks
==10352==    indirectly lost: 0 bytes in 0 blocks
==10352==      possibly lost: 53,144 bytes in 13 blocks
==10352==    still reachable: 8,192 bytes in 3 blocks
==10352==         suppressed: 0 bytes in 0 blocks
==10352== reachable blocks (those to which a pointer was found) are not shown.
==10352== to see them, rerun with: --leak-check=full --show-reachable=yes
==10352==
==10352== for counts of detected and suppressed errors, rerun with: -v
==10352== error summary: 2 errors from 2 contexts (suppressed: 3
还是网上找最后找到了
http://dev.mysql.com/doc/refman/5.0/en/mysql-library-end.html
简单的说是在断开数据库连接后使用
mysql_library_end()
关闭mysql 使用的库
即在mysql_close(。。。)
后添加
mysql_library_end();
就ok了
再添加一句，在使用mysql api之前最好是
调用mysql_library_init(。。。。)