- Forum
- UNIX/Linux Programming
- showquery and mysql_real_query
showquery and mysql_real_query
Hi all
On weekends, my server ran abnomal. It seemed to be related to the perfomence of MySql.
In my server, it has a table which includes fileds like UID and POINT. And there is a operation to update these two fields as "UPDATE TB SET POINT=xxx WHERE UIN=xxx" via mysql_real_query. I found that in weekends when too many uses login, there were many mistakes. mysql_realy_query returned 0 which seemed that it executed succeeded. Sometimes, however, it said 0 rows affected, which is conflict with the fact that the UID to be updated do be in the table!What's the worse, the SQL do execute finally-but the server knew nothing about it.
Who can help me!
On weekends, my server ran abnomal. It seemed to be related to the perfomence of MySql.
In my server, it has a table which includes fileds like UID and POINT. And there is a operation to update these two fields as "UPDATE TB SET POINT=xxx WHERE UIN=xxx" via mysql_real_query. I found that in weekends when too many uses login, there were many mistakes. mysql_realy_query returned 0 which seemed that it executed succeeded. Sometimes, however, it said 0 rows affected, which is conflict with the fact that the UID to be updated do be in the table!What's the worse, the SQL do execute finally-but the server knew nothing about it.
Who can help me!
Topic archived. No new replies allowed.