The mailing list for listmasters using Sympa

[Kazim Koybasi <address@concealed>]

Hello Steve,

Thanks for informations. I set slow query parameters in mysql to detect slow queries but nothing is written in log. Our database not contain all information so I doubt that the reason is slow queries. . Can you explain that how we can create index in database about sympa list names?  I do not understand meaning of index creation in database . We also have external database resources which feeds our list content. I suspect from them. Do you have any other advise for solution.

Best Regards.

On Thu, 10 Oct 2019 at 23:09, Steve Shipway <address@concealed> wrote:

We plan to upgrade our Sympa version from 6.1.20 to 6.2.44. New Sympa version installed on Centos 7 server and there is no low memory or IO problem with our server.. When opening list index sympa web interface works very slow very slow in our case. It was same in old version. We have about 800 Sympa list.  How can we increase load speed of web interface?

This is almost certainly due to a missing index in your database causing the sort to be done at query time.  If you can check to see which queries are running the slowest (how to do this depends on your database) then you should be able to identify which index/indices would improve the performance.

Back when I managed a 6.1 system of comparable size, I added an index on the list name, tuned mysql to allocate more memory to in-memory indices, and also modified the code slightly to make it use RLIKE rather than selection when searching for lists (this is mysql-specific and the code then did not use it)

Steve

--
Steve Shipway | Senior Email Administrator
Mobile: +64 21 753 189 Freephone: 0800 SMX SMX (769 769)
SMX Limited: Level 10, 19 Victoria Street West, Auckland, New Zealand
Web: http://smxemail.com

This email has been filtered by SMX. For more information visit smxemail.com.

This email has been filtered by SMX. For more information visit smxemail.com