Re: statistics statement in general log
thank you Baron, yes, it's check-alive code from our application gateways which was confirmed by our developers. But, how can it impact slave sql thread executing transaction extracted from binary log ? thanks! Liu Xian *^_^* --- 10年9月11日，周六, Baron Schwartz 写道： 发件人: Baron Schwartz 主题: 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 wrote: > 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 21513 Statistics > 100908 9:40:34 21518 Statistics > 100908 9:40:39 21518 Statistics > 100908 9:40:41 21513 Statistics > 100908 9:40:44 21518 Statistics > 100908 9:40:49 21518 Statistics > 100908 9:40:51 21513 Statistics > ... > > this general log is on my slave server. those "Statistics" blocked slave SQL > thread, results in some transactions "Lock wait timeout exceeded; try > restarting transaction" errors. > Actually, these transactions run fast on my master. > > *^_^* > > > -- Baron Schwartz Percona Inc <http://www.percona.com/> Consulting, Training, Support & Services for MySQL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=raid_f...@yahoo.com.cn
statistics statement in general log
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 21513 Statistics 100908 9:40:34 21518 Statistics 100908 9:40:39 21518 Statistics 100908 9:40:41 21513 Statistics 100908 9:40:44 21518 Statistics 100908 9:40:49 21518 Statistics 100908 9:40:51 21513 Statistics ... this general log is on my slave server. those "Statistics" blocked slave SQL thread, results in some transactions "Lock wait timeout exceeded; try restarting transaction" errors. Actually, these transactions run fast on my master. *^_^*
slave stop: Error 'No data - zero rows fetched, selected, processed' on query
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 database: 'fwmrm_oltp'. Query: 'INSERT INTO lt_asset_group_assignment (`asset_group_id`, `id`, `lt_asset_id`) VALUES(190356, NULL, 23047707)' did you see this problem? thank you for your advice. *^_^*
the max length of one SQL statement
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
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!!! *^_^* ___ 好玩贺卡等你发，邮箱贺卡全新上线！ http://card.mail.cn.yahoo.com/
log_output variable
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; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table' at line 1 Server version: 5.1.30-enterprise-gpl-advanced-log MySQL Enterprise Server - Advanced Edition (GPL) It's the same situation on Linux and Win OS. Is this a bug for "set global log_output=table" on 5.1.30 which is GA just now??? *^_^* ___ 好玩贺卡等你发，邮箱贺卡全新上线！ http://card.mail.cn.yahoo.com/
about powerbuilder calling SP
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. *^_^* ___ 雅虎邮箱，您的终生邮箱！ http://cn.mail.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
