• Welcome to the Chevereto User Community!

    Here, users from all over the world come together to learn, share, and collaborate on everything related to Chevereto. It's a place to exchange ideas, ask questions, and help improve the software.

    Please keep in mind:

    • This community is user-driven. Always be polite and respectful to others.
    • Support development by purchasing a Chevereto license, which also gives you priority support.
    • Go further by joining the Community Subscription for even faster response times and to help sustain this space
  • Chevereto Support CLST

    Support response

    Support checklist

    • Got a Something went wrong message? Read this guide and provide the actual error. Do not skip this.
    • Confirm that the server meets the System Requirements
    • Check for any available Hotfix - your issue could be already reported/fixed
    • Read documentation - It will be required to Debug and understand Errors for a faster support response

Mysql slow log

G

gisher

Chevereto Member
Hello!
I turn on Mysql slow log, and all of log are queries from Chevereto. log_queries_not_using_indexes=1
They are a lot of queries without join indexes.
Can You fix this? It's overload server
Sorry for my english

Example of log attached
 

Attachments

Sort by date Sort by votes
gisher said:
Can You fix this?
Click to expand...
There's nothing to fix. Not all queries can have indexes and based on how it performs (indexes) I will try to avoid relying in that in favor of cache.

But that won't happen anytime soon, the database will be the very last component to improve.

I recommend you to get a bigger machine or turn off features in your website.
 
Upvote 0 Downvote
gisher said:
Hello!
I turn on Mysql slow log, and all of log are queries from Chevereto. log_queries_not_using_indexes=1
They are a lot of queries without join indexes.
Can You fix this? It's overload server
Sorry for my english

Example of log attached
Click to expand...
In what way is this overloading the server? mysql won't overload a server unless you got alot of visitors and weak server that get's cpu load to be 90%. Problem is not mysql logging chevereto logs, it's visitors, you would then need to limit the access to visitors by setting max amount of connections at once. So if you have 150 visitors then limit it to maybe 100 so it will tell other 50 that website is currently not available. So they know why due to overload.

I agree with Rodolfo that i also cannot see anything in log that needs fixing.
 
Upvote 0 Downvote
You must log in or register to reply here.
Back
Top