SecondSight Posted May 7, 2018 Posted May 7, 2018 Hello ! ? I still have the "Content I posted in" item in my activity streams menu but it is slow : it takes about 13 seconds to show the results. Here is the output in the mysql slow log : # Time: 180507 5:00:10 # User@Host: mywebsite[mywebsite] @ localhost [] Id: 4591018 # Query_time: 13.367841 Lock_time: 0.000212 Rows_sent: 25 Rows_examined: 4515423 SET timestamp=1525662010; /*IPS\Content\Search\Mysql\_Query::search:346*/ SELECT main.* FROM `ibf_core_search_index` AS `main` WHERE ( ( index_class IN('IPS\\core\\Statuses\\Status','IPS\\core\\Statuses\\Reply') ) OR index_class='IPS\\forums\\Topic\\Post' OR index_class='IPS\\cms\\Pages\\PageItem' OR ( index_class IN('IPS\\cms\\Records1','IPS\\cms\\Records\\Comment1','IPS\\cms\\Records\\Review1') ) OR ( index_class IN('IPS\\cms\\Records2','IPS\\cms\\Records\\Comment2','IPS\\cms\\Records\\Review2') ) OR ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) OR ( index_class IN('IPS\\gallery\\Image','IPS\\gallery\\Image\\Comment','IPS\\gallery\\Image\\Review') ) OR ( index_class IN('IPS\\gallery\\Album\\Item','IPS\\gallery\\Album\\Comment','IPS\\gallery\\Album\\Review') ) OR ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) OR ( index_class IN('IPS\\links\\Link','IPS\\links\\Link\\Comment','IPS\\links\\Link\\Review') ) OR ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) OR ( index_class IN('IPS\\nexus\\Package\\Item','IPS\\nexus\\Package\\Review') ) ) AND ( ( ( index_class IN('IPS\\core\\Statuses\\Status','IPS\\core\\Statuses\\Reply') ) AND index_is_last_comment=1 ) OR ( index_class='IPS\\forums\\Topic\\Post' AND index_is_last_comment=1 ) OR ( index_class='IPS\\cms\\Pages\\PageItem' AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\cms\\Records1','IPS\\cms\\Records\\Comment1','IPS\\cms\\Records\\Review1') ) AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\cms\\Records2','IPS\\cms\\Records\\Comment2','IPS\\cms\\Records\\Review2') ) AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\gallery\\Image','IPS\\gallery\\Image\\Comment','IPS\\gallery\\Image\\Review') ) AND ( index_container_class IN('IPS\\gallery\\Category') ) AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\gallery\\Album\\Item','IPS\\gallery\\Album\\Comment','IPS\\gallery\\Album\\Review') ) AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\links\\Link','IPS\\links\\Link\\Comment','IPS\\links\\Link\\Review') ) AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) AND index_is_last_comment=1 ) OR ( ( index_class IN('IPS\\nexus\\Package\\Item','IPS\\nexus\\Package\\Review') ) AND index_is_last_comment=1 ) ) AND ( ( ( index_class IN('IPS\\forums\\Topic','IPS\\forums\\Topic\\Post') ) AND (( index_container_id=221 AND index_date_updated > 1458097994) OR ( index_container_id=14 AND index_date_updated > 1458097994) OR ( index_container_id=64 AND index_date_updated > 1458097994) OR ( index_container_id=21 AND index_date_updated > 1458097994) OR ( index_container_id=29 AND index_date_updated > 1458097994) OR ( index_container_id=137 AND index_date_updated > 1458097994) OR ( index_container_id=4 AND index_date_updated > 1458097994) OR ( index_container_id=216 AND index_date_updated > 1458097994) OR ( index_container_id=140 AND index_date_updated > 1458097994) OR ( index_container_id=43 AND index_date_updated > 1458097994) OR ( index_container_id=66 AND index_date_updated > 1458097994) OR ( index_container_id=152 AND index_date_updated > 1458097994) OR ( index_container_id=146 AND index_date_updated > 1458097994) OR ( index_container_id=9 AND index_date_updated > 1458097994) OR ( index_container_id=138 AND index_date_updated > 1458097994) OR ( index_container_id=173 AND index_date_updated > 1458097994) OR ( index_container_id=151 AND index_date_updated > 1458097994) OR ( index_container_id=19 AND index_date_updated > 1458097994) OR ( index_container_id=132 AND index_date_updated > 1458097994) OR ( index_container_id=15 AND index_date_updated > 1458097994) OR ( index_container_id=148 AND index_date_updated > 1458097994) OR ( index_container_id=143 AND index_date_updated > 1458097994) OR ( index_container_id=150 AND index_date_updated > 1458097994) OR ( index_container_id=202 AND index_date_updated > 1458097994) OR ( index_container_id=144 AND index_date_updated > 1458097994) OR ( index_container_id=174 AND index_date_updated > 1458097994) OR ( index_container_id=35 AND index_date_updated > 1458097994) OR ( index_container_id=159 AND index_date_updated > 1458097994) OR ( index_container_id=142 AND index_date_updated > 1458097994) OR ( index_container_id=41 AND index_date_updated > 1458097994) OR ( index_container_id=220 AND index_date_updated > 1458097994) OR ( index_container_id=223 AND index_date_updated > 1458097994) OR ( index_container_id=219 AND index_date_updated > 1458097994) OR ( index_container_id=149 AND index_date_updated > 1458097994) OR ( index_container_id=5 AND index_date_updated > 1458097994) OR ( index_container_id=44 AND index_date_updated > 1458097994) OR ( index_container_id=130 AND index_date_updated > 1458097994) OR ( index_container_id=139 AND index_date_updated > 1458097994) OR ( index_container_id=31 AND index_date_updated > 1458097994) OR ( index_container_id=158 AND index_date_updated > 1458097994) OR ( index_container_id=70 AND index_date_updated > 1458097994) OR ( index_container_id=46 AND index_date_updated > 1464529599) OR ( index_container_id=145 AND index_date_updated > 1458097994) OR ( index_container_id=176 AND index_date_updated > 1458097994) OR ( index_container_id=147 AND index_date_updated > 1458097994) OR ( index_container_id=135 AND index_date_updated > 1458097994) OR ( index_container_id=28 AND index_date_updated > 1458097994) OR ( index_container_id=215 AND index_date_updated > 1460905040) OR ( index_container_id=162 AND index_date_updated > 1458097994) OR ( index_container_id=213 AND index_date_updated > 1458097994) OR ( index_container_id=129 AND index_date_updated > 1458097994) OR ( index_container_id=187 AND index_date_updated > 1458097994) OR ( index_container_id=217 AND index_date_updated > 1458097994) OR ( index_date_updated > 1458097994 AND ( index_container_id NOT IN(221,14,64,21,29,137,4,216,140,43,66,152,146,9,138,173,151,19,132,15,148,143,150,202,144,174,35,159,142,41,220,223,219,149,5,44,130,139,31,158,70,46,145,176,147,135,28,215,162,213,129,187,217) ) )) AND ( index_item_id NOT IN (86812,90614,162202,166898,169393,207016,218227,239556,265966,286815,304207,307640,309413,309931,313878,316195,318155,318456,323927,324145,324562,324899,324936,325316,325387,325397,325412,325418,325581,325995,326065,326183,326595,326799,327227,327391,327554,327802,328035,328154,328199,328393,328415,328474,328952,329248,329400,329405,329667,329755,329767,330052,330106,330379,330597,330852,331016,331169,331171,331559,331610,331688,331692,332027,332110,332368,332481) ) ) OR ( ( index_class IN('IPS\\cms\\Records1','IPS\\cms\\Records\\Comment1','IPS\\cms\\Records\\Review1') ) AND (( index_date_updated > 1458097994)) ) OR ( ( index_class IN('IPS\\cms\\Records2','IPS\\cms\\Records\\Comment2','IPS\\cms\\Records\\Review2') ) AND (( index_date_updated > 1458097994)) ) OR ( ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) AND (( index_container_id=448 AND index_date_updated > 1458097994) OR ( index_date_updated > 1458097994 AND ( index_container_id NOT IN(448) ) )) ) OR ( ( index_class IN('IPS\\gallery\\Image','IPS\\gallery\\Image\\Comment','IPS\\gallery\\Image\\Review') ) AND (( index_container_id=43 AND index_date_updated > 1458097994) OR ( index_container_id=12 AND index_date_updated > 1459385142) OR ( index_date_updated > 1458097994 AND ( index_container_id NOT IN(43,12) ) )) AND ( index_item_id NOT IN (3701,3702,3703,3704,3705,3706,3707,3708,3932,3933,3942,3943) ) ) OR ( ( index_class IN('IPS\\gallery\\Album\\Item','IPS\\gallery\\Album\\Comment','IPS\\gallery\\Album\\Review') ) AND (( index_container_id=43 AND index_date_updated > 1458097994) OR ( index_container_id=12 AND index_date_updated > 1459385142) OR ( index_date_updated > 1458097994 AND ( index_container_id NOT IN(43,12) ) )) ) OR ( ( index_class IN('IPS\\downloads\\File','IPS\\downloads\\File\\Comment','IPS\\downloads\\File\\Review') ) AND (( index_date_updated > 1458097994)) ) OR ( ( index_class IN('IPS\\links\\Link','IPS\\links\\Link\\Comment','IPS\\links\\Link\\Review') ) AND (( index_container_id=65 AND index_date_updated > 1458097994) OR ( index_date_updated > 1458097994 AND ( index_container_id NOT IN(65) ) )) AND ( index_item_id NOT IN (1080) ) ) OR ( ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) AND (( index_date_updated > 1458097994)) ) ) AND ( index_permissions = '*' OR ( FIND_IN_SET(9,index_permissions) OR FIND_IN_SET('m15282',index_permissions) OR FIND_IN_SET('ca',index_permissions) ) ) AND index_hidden=0 AND index_date_updated>1494125997 ORDER BY index_date_commented DESC LIMIT 0,25; Do you have the same problem ? Thank you. ?
bfarber Posted May 7, 2018 Posted May 7, 2018 Some changes have been made for 4.3.2 to improve performance with some streams such as this one. We apologize for any inconvenience in the mean time.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.