2 major problems It seems that mysql_connect error is popping up on anything to do with attachments or images: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '192.168.1.3' (115) /opt/www/das/public_html/includes/class_core.php on line 311 Its only on images though and max connections are not being hit. Then another problem this query pops up in my slow query logs all the time and just hammers the mysql server. # Query_time: 3.224211 Lock_time: 0.073289 Rows_sent: 208846 Rows_examined: 417694 Rows_affected: 0 Rows_read: 1 use das_forum; SELECT postid AS itemid* post.visible AS post_visible* thread.visible AS thread_visible* thread.forumid* thread.threadid* thread.postuserid* post.userid* IF(postuserid = 121097* 'self'* 'other') AS starter FROM post AS post INNER JOIN thread AS thread ON(thread.threadid = post.threadid) WHERE postid IN(3300398* 3300382* 3300377* 3300374* 3300368* 3300350* 3300348* 3300346* 3300335* 3300327* 3300323* 3300320* 3300305* 3300304* 3300303* 3300290* 3300289* 3300280* 3300278* 3300276* 3300237* 3300233* 3300229* 3300223* 3300191* 3300187* 3300183* 3300182* 3300176* 3300171* 3300166* 3300164* 3300159* 3300155* 3300149* 3300135* 3300128* 3300110* 3300103* 3300094* 3300092* 3300090* 3300089* 3300083* 3300073* 3300072* 3300070* 3300066* 3300055* 3300044* 3300040* 3300032* 3300031* 3300028* 3300026* 3300025* 3300023* 3300005* 3300002* 3300000* 3299997* 3299990* 3299973* 3299964* 3299963* 3299958* 3299955* 3299954* 3299948* 3299941* 3299938* 3299932* 3299930* 3299921* 3299917* 3299900* 3299899* 3299897* 3299882* 3299883* 3299878* 3299876* 3299870* 3299868* 3299867* 3299843* 3299841* 3299826* 3299823* 3299806* 3299797* 3299793* 3299792* 3299791* 3299789* 3299787* 3299785* 3299749* 3299727* 3299714* 3299706* 3299703* 3299694* 3299682* 3299680* 3299676* 3299672* 3299670! this query goes on for 3 pages or so with all those numbers* any advice ? |
الساعة الآن 10:33 AM |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By
Almuhajir