Hi all,
finally, after several troubles i've my 5.1.7 version (migrated by 3.6.4 through 4.x) almost running.
Almost...
I've to solve the most annoying problem: the "Empty response" when user sends a reply or creates a new topic.
This error message comes when the "create-content/text/" process exceeds the FcgidIOTimeout value set in the fcgid.conf file (45 seconds for me).
I see the error message but replies are regularly written into db and i've to close popup and refresh browser to see them.
Analyzing error log files I've found two very slow queries (up to 200 seconds ): both of them try to Replace or Update something in the vb5_searchlog table.
My searchlog table was 6 GB and had more than 500k records (80% with userid=0).
I don't believe problem could depend on table size but it happens above all for the most active users (more records in searchlog).
So, i've truncated the table and this was good for me: now all users can send posts and create topics in a reasonable time (4-8 seconds).
But truncate searchlog is only a workaround because table grows quickly and i've to repeat the operation.
So, some questions:
Or
Thanks in advance for your help.
Lou
finally, after several troubles i've my 5.1.7 version (migrated by 3.6.4 through 4.x) almost running.
Almost...
I've to solve the most annoying problem: the "Empty response" when user sends a reply or creates a new topic.
This error message comes when the "create-content/text/" process exceeds the FcgidIOTimeout value set in the fcgid.conf file (45 seconds for me).
I see the error message but replies are regularly written into db and i've to close popup and refresh browser to see them.
Analyzing error log files I've found two very slow queries (up to 200 seconds ): both of them try to Replace or Update something in the vb5_searchlog table.
My searchlog table was 6 GB and had more than 500k records (80% with userid=0).
I don't believe problem could depend on table size but it happens above all for the most active users (more records in searchlog).
So, i've truncated the table and this was good for me: now all users can send posts and create topics in a reasonable time (4-8 seconds).
But truncate searchlog is only a workaround because table grows quickly and i've to repeat the operation.
So, some questions:
- what's searchlog table purpose?
- high percentage of records with userid=0 means that also guest operations are logged, why?
- is there a way to make queries on searchlog faster?
Or
- is there a way to avoid using searchlog table?
- is there a scheduled task that truncate the table for me (cleanup, cleanup#2 or dailycleanup)?
Thanks in advance for your help.
Lou
Comment