Hi Tibor,
Bigger max_allowed_packet is needed for serialised Python objects,
especially big citation dictionaries that are living as single blobs.
If you don't use citation ranking on your Invenio instance, then the
default max_allowed_packet value should be just fine. Otherwise you can
raise it to something like 100M or 1G, depending on the number of
citer-citee pairs.
Thanks for your explanation of the relation between the citation
dictionaries as single blob and the max_allowed_packet size in the
my.cnf. Now we raise it up in test the result.
Could I see, how big is the citation dictionary / the blob at the
moment? I only see the total data lenght of the rnkCITATIONDATA table.
BTW, I have put up some notes about MySQL tuning on our old wiki:
<https://twiki.cern.ch/twiki/bin/view/CDS/InvenioTuning#1_Tuning_MySQL>
The max_connections part on the wiki and musings about the number of
Apache processes are applicable when you run mod_python of mod_wsgi
embedded mode. With mod_wsgi daemon mode, only the backend daemons are
connecting to MySQL, so things are much better from this point of view.
BTW, have you enabled log-slow-queries in your my.cnf? If yes, then
this log file will show you if you have some SQL queries that take an
unusually long time. This would be a good basis for MySQL
optimisations. E.g. is the load on your DB server higher than the load
on your web application server? Etc.
And thanks for the other tuning hints, especially these for apache and
websearch are very usefull for us :-). Also we would look in our
log-slow file.
Your indexing considerations sounds good!
Best regards
Cornelia
------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
Forschungszentrum Juelich GmbH
52425 Juelich
Sitz der Gesellschaft: Juelich
Eingetragen im Handelsregister des Amtsgerichts Dueren Nr. HR B 3498
Vorsitzender des Aufsichtsrats: MinDirig Dr. Karl Eugen Huthmacher
Geschaeftsfuehrung: Prof. Dr. Achim Bachem (Vorsitzender),
Dr. Ulrich Krafft (stellv. Vorsitzender), Prof. Dr.-Ing. Harald Bolt,
Prof. Dr. Sebastian M. Schmidt
------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
