Menu Content

Podpora

> Diskusní fóra, FAQs & placená podpora
Welcome, Guest
Username Password: Remember me
Forgot your password? Forgot your username? Create an account
ARTIO Forums
Support Forums
JoomSEF
Community Support
JoomSEF 3

Artio SEF and mySql load
(1 viewing) (1) Guest
Support forum for users using free edition of JoomSEF 3 (Joomla 1.5 compatible). These forums are mainly for mutual help between users.

Please note that due to our capacity limitations, we do not monitor these forums regularly.
Reply Topic
New Topic

TOPIC: Artio SEF and mySql load

Re:cpu patch fix? 17 years, 6 months ago #491

  • Steiner
Hello,

unfortunatly i have sometime high DB Server load too, and my provider force me to deactivate the artio SEF.


Here is a piece of the Server LOG:

mysql.log:
                 107139 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-26.html'
                 107583 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-26.html'
                 104104 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-26.html'
                 106260 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/userprofile-1035.html'
                 103058 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-26.html'
                 105174 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-26.html'
                 107139 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-27.html'
                 107583 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-27.html'
                 104104 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-27.html'
                 106260 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/userprofile-1036.html'
                 106260 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/userprofile-1037.html'
                 103058 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-27.html'
                 105174 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-27.html'
                 107139 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-28.html'
                 107583 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-28.html'
                 104104 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-28.html'
                 106260 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/userprofile-1038.html'
                 103058 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-28.html'
                 105174 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-28.html'
                 107139 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-29.html'
                 107583 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-29.html'
                 104104 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-29.html'
                 106260 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/userprofile-1039.html'
                 103058 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-29.html'
                 105174 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-29.html'
                 107139 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-30.html'
                 107583 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-30.html'
                 104104 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-30.html'
                 106260 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/userprofile-1040.html'
                 106260 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/userprofile-1041.html'
                 103058 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-30.html'
                 105174 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-30.html'
                 107139 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-31.html'
                 107583 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-31.html'
                 104104 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-31.html'
                 106260 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/userprofile-1042.html'
                 103058 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-31.html'
                 105174 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-31.html'
                 107139 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-32.html'
                 107583 Query       SELECT newurl FROM mg_redirection
WHERE oldurl = 'firmenverzeichnis/removeconnection-32.html'
 
 


It is only a shortpiece !!!!


So, when there is no Patch or new version of ARTIO SEF i ask for a better descriped solution:

1.) The code posted by nibra, where to put it in ?

2.) The code posted by Michael

 CREATE INDEX `oldurl` ON `jos_redirection` (`oldurl`);


I understand this as a SQL command.

Will it fix my problem ?

Sunny regards

Kurt Steiner
Reply Quote

Re:cpu patch fix? 17 years, 6 months ago #492

  • miun
  • OFFLINE
  • A pesimist is just a well-informed realist.
  • Posts: 563
Hello Kurt,

currently there is not many ways how the number of queries could be reduced for SEF in general.

But it your case, it seems you are using the SEF for some module, where it generates extremely too many URL of the same name (e.g. "firmenverzeichnis/userprofile-1035.html"). This means, each time a new link is generated there is tested over 1000 other, already exisitng URLs that conflict with the name! And that of course is causing a huge overhead for the DB.

The immidiate solution for you would be to turn off SEF for the module(s) causing this problem. Still if you would like to have SEF for that module, an adjusted extension would be needed. Such extension would have to generate the URLs is such a way where not so many name conflicts would emerge.

As regards the SQL code, that should be run over your DB. Adding an index should improve the SEF performace in general, but it will not solve the problem you have.

For the modules where too many different links are generated, the SEF extension would ideally create such URLs that can be translated on-line and do not need storing to DB (this mean they include all the non-SEF link parameters). Of course, this means, that usually such links cannot be so "nice" as the ones that ignore many params and are stored in DB. Something called "compromise" solution is the one mentioned above -- when the links are still stored in DB, but they are generated so that there is maximum a few links with same name, but not thousands of them!

Hopefully you got an idea about the problem. If you need further assistance with solving it, contact us.

Best regards,
Michal
ARTIO Support Team
Reply Quote

Re:cpu patch fix? 17 years, 6 months ago #531

  • nibra
Kurt wrote:
Hello,
1.) The code posted by nibra, where to put it in ?


The SEFTools class is found at the end of the file /administrator/components/com_sef/sef.class.php.

I'd be very appreciated for any comments.

Regards,
Niels
Reply Quote

Re:cpu patch fix? 17 years, 6 months ago #534

  • Arnoud
Michal,

My newsflash modules create around 200 or so extra links on a given day, how would I switch SEF off for these modules? I am aware that you can switch off SEF for components...but not sure how that goes with modules...

Thanks so much
Reply Quote

Re:Artio SEF and mySql load 17 years, 5 months ago #912

CREATE INDEX `oldurl` ON `jos_redirection` (`oldurl`);



I have done the same modification in my database server before I read this forum. It works properly now.

Since Artio SEF create a lot records for lookup the new direction URL, the database always need to access the jos_redirection table. Without the above NEW index, the database server need to do a "table scan" to search the information. "table scan" is always heavy loading task. It is a simple database design problem. All you need is to create a simple index only.

BTW, this SEF component works very well in my website.
Reply Quote
Reply Topic
New Topic
ARTIO Forums
Support Forums
JoomSEF
Community Support
JoomSEF 3
Přihlášení uživatele Prázdný
Vytvořit účet Zapomenuté heslo?
Copyright © 2024 ARTIO