From: Natasha B. <natasha.brown@WikiTranslate.org> - 2013-04-12 11:45:18
|
It took me almost about 2 weeks to upgrade :) WikiTranslate is still slow :( I am going to https://www.mediawiki.org/wiki/Amsterdam_Hackathon_2013 Thank you one more time David for your advice. On 24 March 2013 12:01, Natasha Brown <nat...@wi...>wrote: > Thank you, David! > > I didn't know about SMW 1.8! I will upgrade next week and see how it goes > :) > > My Version is 1.7.1 http://wikitranslate.org/wiki/Special:Version ** > > > On 24 March 2013 11:44, David Leonelli <leo...@gm...> wrote: > >> Well, no, I would be more interested in what version of SMW you are >> running first. Go to the page Special:Version and note and post your >> Version information for >> >> MediWiKi >> PHP >> MySQL >> and under extensions Semantic MediaWiki >> >> Remember that unless you are doing custom development like creating or >> modifying an extension or the core SMW code you do not have control over >> the database schema or how queries are constructed so some types of tuning >> are unavailable. >> >> I'm interested in the above because it seems that substantial >> improvements in query response times have been reported by user who have >> recently upgraded to SMW 1.8 so lets go there first. >> >> David >> >> On Sat, Mar 23, 2013 at 2:31 PM, Natasha Brown < >> nat...@wi...> wrote: >> >>> Thanks, David, for asking... >>> >>> >>> Executed 978 min ago for 4 sec on Database --> unknown. >>> SELECT /* SMW::getQueryResult 176.92.112.25 */ DISTINCT t9.smw_id AS >>> id,t9.smw_title AS t,t9.smw_namespace AS ns,t9.smw_iw AS >>> iw,t9.smw_subobject AS so,t9.smw_sortkey AS sortkey FROM `smw_ids` AS t9 >>> INNER JOIN `smw_atts2` AS t7 ON t9.smw_id=t7.s_id INNER JOIN `smw_atts2` AS >>> t3 ON t7.s_id=t3.s_id INNER JOIN `smw_atts2` AS t5 ON t3.s_id=t5.s_id WHERE >>> ((t7.value_xsd='Child') AND t7.p_id='451' AND ((t3.value_xsd='Russian >>> films') AND t3.p_id='2314' AND ((t5.value_xsd='3') AND t5.p_id='11298'))) >>> ORDER BY t9.smw_sortkey ASC LIMIT 21 >>> Executed 805 min ago for 4 sec on Database --> unknown. >>> SELECT /* SMW::getQueryResult 173.199.115.107 */ DISTINCT t9.smw_id AS >>> id,t9.smw_title AS t,t9.smw_namespace AS ns,t9.smw_iw AS >>> iw,t9.smw_subobject AS so,t9.smw_sortkey AS sortkey FROM `smw_ids` AS t9 >>> INNER JOIN `smw_atts2` AS t7 ON t9.smw_id=t7.s_id INNER JOIN `smw_atts2` AS >>> t3 ON t7.s_id=t3.s_id INNER JOIN `smw_atts2` AS t5 ON t3.s_id=t5.s_id WHERE >>> ((t7.value_xsd='Child') AND t7.p_id='451' AND ((t3.value_xsd='Russian >>> films') AND t3.p_id='2314' AND ((t5.value_xsd='3') AND t5.p_id='11298'))) >>> ORDER BY t9.smw_sortkey ASC LIMIT 21 >>> Executed 688 min ago for 4 sec on Database --> unknown. >>> SELECT /* SMW::getQueryResult 173.199.115.107 */ DISTINCT t7.smw_id AS >>> id,t7.smw_title AS t,t7.smw_namespace AS ns,t7.smw_iw AS >>> iw,t7.smw_subobject AS so,t7.smw_sortkey AS sortkey FROM `smw_ids` AS t7 >>> INNER JOIN `smw_atts2` AS t1 ON t7.smw_id=t1.s_id INNER JOIN `smw_atts2` AS >>> t3 ON t1.s_id=t3.s_id INNER JOIN `smw_atts2` AS t5 ON t1.s_id=t5.s_id WHERE >>> ((t1.value_xsd LIKE '%Lesson%') AND t1.p_id='6315' AND ((t3.value_xsd LIKE >>> '%Child%') AND t3.p_id='451') AND ((t5.value_xsd='en: English') AND >>> t5.p_id='268')) ORDER BY RAND() LIMIT 3,4 >>> Executed 357 min ago for 4 sec on Database --> unknown. >>> SELECT /* SMW::getQueryResult 208.115.113.82 */ DISTINCT t9.smw_id AS >>> id,t9.smw_title AS t,t9.smw_namespace AS ns,t9.smw_iw AS >>> iw,t9.smw_subobject AS so,t9.smw_sortkey AS sortkey FROM `smw_ids` AS t9 >>> INNER JOIN `smw_atts2` AS t7 ON t9.smw_id=t7.s_id INNER JOIN `smw_atts2` AS >>> t3 ON t7.s_id=t3.s_id INNER JOIN `smw_atts2` AS t5 ON t3.s_id=t5.s_id WHERE >>> ((t7.value_xsd='Child') AND t7.p_id='451' AND ((t3.value_xsd='Russian >>> films') AND t3.p_id='2314' AND ((t5.value_xsd='3') AND t5.p_id='11298'))) >>> ORDER BY t9.smw_sortkey ASC LIMIT 21 >>> Executed 162 min ago for 5 sec on Database --> unknown. >>> SELECT /* SMW::getQueryResult 199.21.99.98 */ DISTINCT t7.smw_id AS >>> id,t7.smw_title AS t,t7.smw_namespace AS ns,t7.smw_iw AS >>> iw,t7.smw_subobject AS so,t7.smw_sortkey AS sortkey FROM `smw_ids` AS t7 >>> INNER JOIN `smw_atts2` AS t1 ON t7.smw_id=t1.s_id INNER JOIN `smw_atts2` AS >>> t3 ON t1.s_id=t3.s_id INNER JOIN `smw_atts2` AS t5 ON t1.s_id=t5.s_id WHERE >>> ((t1.value_xsd LIKE '%Lesson%') AND t1.p_id='6315' AND ((t3.value_xsd='en: >>> English') AND t3.p_id='268') AND ((t5.value_xsd='en: English') AND >>> t5.p_id='7720')) ORDER BY RAND() LIMIT 1 >>> >>> >>> >>> Does it tells you something :) It tells me that I don't want to look at >>> it all :( What do I do??? >>> >>> >>> >>> On 23 March 2013 17:42, David Leonelli <leo...@gm...> wrote: >>> >>>> Well Natasha I'm sure the community can be of help here (aside from >>>> your possible desire for an individual ongoing consultant) to help you. But >>>> I think we need more information. Version info on your configuration would >>>> be a good start. Also are you sure this is a MySQL issue and not a general >>>> performance issue? And "slow" is a relative term. Do you have any metrics? >>>> >>>> Dave >>>> >>>> "In the land of the blind, the one eyed man (OK, or women) is King" >>>> >>>> On Sat, Mar 23, 2013 at 8:08 AM, Natasha Brown < >>>> nat...@wi...> wrote: >>>> >>>>> I don't know too much about MySQL. WikiTranslate generates slow >>>>> queries. I >>>>> think that they are connected with the semantic mediawiki. We have to >>>>> optimize MySQL so there would be no slow queries. Someone should >>>>> regularly >>>>> check the database, the logs, and the generated queries, in order to >>>>> perform a successful optimization. >>>>> >>>>> I can't do it myself so I need someone to help me with the job. >>>>> -- >>>>> Natasha Brown >>>>> >>>>> *skype: russian_natasha * >>>>> *lea...@gm... **http://wikitranslate.org** >>>>> * >>>>> >>>>> London NW5 4BJ, tel: +44 (0)7905353429, +44 (0)2074858680 >>>>> ------------------------------------------------------------------------------ >>>>> Everyone hates slow websites. So do we. >>>>> Make your web apps faster with AppDynamics >>>>> Download AppDynamics Lite for free today: >>>>> http://p.sf.net/sfu/appdyn_d2d_mar >>>>> _______________________________________________ >>>>> Semediawiki-user mailing list >>>>> Sem...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/semediawiki-user >>>>> >>>> >>>> >>> >>> >>> -- >>> Natasha Brown >>> >>> *skype: russian_natasha * >>> *natasha.brown@WikiTranslate.org **http://wikitranslate.org** >>> >>> Learn new language - Teach your language >>> * >>> >>> London NW5 4BJ, tel: +44 (0)7905353429, +44 (0)2074858680 >>> >> >> > > > -- > Natasha Brown > > *skype: russian_natasha * > *natasha.brown@WikiTranslate.org **http://wikitranslate.org** > > Learn new language - Teach your language > * > London NW5 4BJ, tel: +44 (0)7905353429, +44 (0)2074858680 > -- Natasha Brown *skype: russian_natasha * *natasha.brown@WikiTranslate.org **http://wikitranslate.org** Learn new language - Teach your language * London NW5 4BJ, tel: +44 (0)7905353429, +44 (0)2074858680 |