2011年10月31日
HandlerSocket安装记录
摘要： HandlerSockettar zxvf ahiguti-HandlerSocket-Plugin-for-MySQL-1.0.6-23-g4cfc840.tar.gzcd ahiguti-HandlerSocket-Plugin-for-MySQL-4cfc840./autogen.shYou should add the contents of `/usr/share/aclocal/libtool.m4' to `aclocal.m4'.cat /usr/share/aclocal/libtool.m4 >> aclocal.m4./configure -- 阅读全文
posted @ 2011-10-31 10:35 wwh 阅读(316) 评论(0) 推荐(0)
MySQL存储过程中的sql_mode问题
摘要： 在my.cnf中设置了sql_mode='STRICT_TRANS_TABLES';却发现还是有非法数据的写入，比如无符号整数字段本来值是0，还可以减，结果当然溢出了，经检查发现存储过程中默认的sql_mode并没有使用global的sql_mode，测试如下：CREATE PROCEDURE p_test()BEGINselect @@session.sql_mode,@@global.sql_mode;END;call p_test();+--------------------+---------------------+| @@session.sql_mode | @@ 阅读全文
posted @ 2011-10-31 10:33 wwh 阅读(392) 评论(0) 推荐(0)
error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory
摘要： error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory问题解决办法：locate libmysqlclient.so.16如我的mysql安装在/usr/local/mysql下，则结果为/usr/local/mysql/lib/mysql/libmysqlclient.so.16vi /etc/ld.so.conf增加一行 /usr/local/mysql/lib/mysql然后执行ldconfig生效。 阅读全文
posted @ 2011-10-31 10:31 wwh 阅读(483) 评论(0) 推荐(0)