MYSQL
setglobalinnodb_lock_wait_timeout=500;
setGLOBALmax_connections=20000;
setglobalmax_allowed_packet=9999999999999999;
setgloballog_bin_trust_function_creators=1;
安装卸载
http://www.jz123.cn/text/2937389.html
http://liuyix.com/install-mysql-on-ubuntu-10-04-from-source
http://www.cnblogs.com/bylikai/archive/2012/01/03/2311334.html
mysql创建函数问题
今天在整理数据时，又碰到MySQL函数不能创建的问题，以前也遇到过多次，解决是解决了，但是解决办法总是记不住，也没有很好地写下来，以至于每次都要再次Google，耗时耗力，这次终于受不了了，还是选择写出来：
出错信息大致类似：
ERROR1418(HY000):ThisfunctionhasnoneofDETERMINISTIC,NOSQL,orREADSSQLDATAinitsdeclarationandbinaryloggingisenabled(you*might*wanttousethelesssafelog_bin_trust_function_creatorsvariable)
ERROR1418(HY000):ThisfunctionhasnoneofDETERMINISTIC,NOSQL,orREADSSQLDATAinitsdeclarationandbinaryloggingisenabled(you*might*wanttousethelesssafelog_bin_trust_function_creatorsvariable)
建立不了函数，是未开启功能：
SQLcodemysql>showvariableslike'%func%';
+---------------------------------+-------+
|Variable_name|Value|
+---------------------------------+-------+
|log_bin_trust_function_creators|OFF|
+---------------------------------+-------+
1rowinset(0.00sec)
mysql>setgloballog_bin_trust_function_creators=1;
QueryOK,0rowsaffected(0.00sec)
mysql>showvariableslike'%func%';
+---------------------------------+-------+
|Variable_name|Value|
+---------------------------------+-------+
|log_bin_trust_function_creators|ON|
+---------------------------------+-------+
1rowinset(0.00sec)
mysql>
http://www.uini.net/2010/03/mysql-create-function-problem.html