Performance issues with default MySQL
This is an open discussion with no replies, filed under Troubleshooting.
Search
Create an account or sign in to comment.
This is an open discussion with no replies, filed under Troubleshooting.
Create an account or sign in to comment.
Quick Links
Symphony • Open Source XSLT CMS
--with-xsl
)
Hello.
I'm moving a site from shared hosting to a VPS and I'm running into some issues with Search Index and re-indexing sections.
The issue is not tight to Search Index, it's probably a MySQL miss-configuration or similar.
Old server:
New server:
Data:
Copy
field of this section is indexed. Nothing elseOn old server, there are absolutely no problems.
Symptoms:
htop
freezes :)After re-indexing 33 pages (out of 64), number of records in
Search Index
tables:sym_search_index
= 700sym_search_index_entry_keywords
= 203000sym_search_index_keywords
= 16000Before this morning I didn't even know how to install LAMP on Linux. Now I do.
I suspect the culprit is MySQL. I think I have to make some performance settings that already exist on older server.
Can you please, help me? Some MySQL good settings? Other possible causes for the slow execution?
Thank you.