UBB.Dev
Posted By: kit400 Slow Mysql Querys - 03/21/2005 11:48 AM
I've examined my mysql-slow.log ad foud many Querys like:
Code
  <br /># Query_time: 243  Lock_time: 208  Rows_sent: 1  Rows_examined: 767                                 <br />SELECT COUNT(*) AS posts, SUM(B_Topic) AS topics.                                                   <br />                                        FROM   w3t_Posts.                                           <br />                                        WHERE  B_Posted > ''.                                       <br />                                        AND B_Approved = 'yes'.                                     <br />                                        AND    B_Board = 'forum';     <br /><br /># Query_time: 240  Lock_time: 205  Rows_sent: 1  Rows_examined: 767                                 <br />SELECT COUNT(*) AS posts, SUM(B_Topic) AS topics.                                                   <br />                                        FROM   w3t_Posts.                                           <br />                                        WHERE  B_Posted > ''.                                       <br />                                        AND B_Approved = 'yes'.                                     <br />                                        AND    B_Board = 'forum';    <br />


So is it bug of ubbthreads or misconfiguration of MySQL ?
How can i solve this problem ?

10nx
Posted By: JoshPet Re: Slow Mysql Querys - 03/24/2005 6:01 AM
That's full new post tracking, which is a major slowdown if you have a large post table.

On version 6.4 (maybe 6.3) and higher, there's a control panel to turn off the full new post tracking.

This line:
WHERE B_Posted > ''.

Should have a timestamp, unless there's none for anonymouse users. Not sure if that'a bug or not... you didn't saw what version. But I think some bugs about full post tracking being on for anonymous users have been posted at www.ubbcentral.com
© UBB.Developers