Re: statistics statement in general log

2010-09-12 Thread raid fifa
Schwartz ba...@xaprb.com 主题: Re: statistics statement in general log 收件人: mysql@lists.mysql.com 日期: 2010年9月11日,周六,上午1:56 Those are from a 'status' API call.  Many ORMs use such calls to check that the database connection is alive. On Thu, Sep 9, 2010 at 2:14 AM, raid fifa raid_f...@yahoo.com.cn wrote

statistics statement in general log

2010-09-09 Thread raid fifa
Hi guys, anyone knows what's the meaning of statistics in general log ? thanks. ... 100908  9:40:11 21513 Statistics 100908  9:40:14 21518 Statistics 100908  9:40:19 21518 Statistics 100908  9:40:21 21513 Statistics 100908  9:40:24 21518 Statistics 100908  9:40:29 21518 Statistics 100908  9:40:31

slave stop: Error 'No data - zero rows fetched, selected, processed' on query

2010-08-06 Thread raid fifa
hi guys, we have a mysql replication setup in our production. Master: mysql-5.0.77 slave: mysql-5.1.46 Recently, slave show many these kind of issues and SQL thread was stopped: Last_SQL_Error: Error 'No data - zero rows fetched, selected, or processed' on query. Default

the max length of one SQL statement

2009-03-20 Thread raid fifa
Hi guys,   Anybody knows that how many bytes the max length of on SQL statement can be in MySQL database? I know it's 64KB in Oracle.   Thanks. *^_^* ___ 好玩贺卡等你发,邮箱贺卡全新上线! http://card.mail.cn.yahoo.com/

about mysql_ping() function

2008-12-29 Thread raid fifa
Hi guys, I used mysql_ping() function in my program. But when I unplug the network wire between client and MySQL server, my program has no response as mysql_ping() can not return value and hanged there. Is this a bug of mysql_ping() ? or any other advice? thanks!!! *^_^*

log_output variable

2008-12-02 Thread raid fifa
hi guys,   mysql show variables like '%output%'; +---+---+ | Variable_name | Value | +---+---+ | log_output    | FILE  | +---+---+ 1 row in set (0.00 sec) mysql set global log_output=table; ERROR 1064 (42000): You have an error in your SQL syntax;

about powerbuilder calling SP

2008-08-22 Thread raid fifa
hi guys, I used powerbuilder to connect MySQL database,but it seems like that powerbuilder can not call stored procedure in my database. It said the database does not currently support retrieval of procedure text. Is this ok? or I was wrong somewhere. Thanks. *^_^*