• 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

MySql Slow queries

Status
Not open for further replies.
Nirjonadda

Nirjonadda

💖 Chevereto Fan
Website URL
<private>

Chevereto version
3.10.1

Description of the issue
How to fix mysql Slow queries log issue? I have found Slow queries: 4438 in Admin CP.

MySQL server info:Uptime: 22254 Threads: 3 Questions: 47033 Slow queries: 4438 Opens: 311 Flush tables: 1 Open tables: 303 Queries per second avg: 2.113
Click to expand...

This my my.cnf files setting.

Code: 
expire-logs-days = 7
log-error=/var/log/mysqld.log
log-queries-not-using-indexes   = 1
long-query-time  = 8
max-binlog-size  = 100M
slow-query-log = 1
slow-query-log-file = /var/log/mysqlslowqueries.log
 
Nirjonadda said:
Website URL
<private>

Chevereto version
3.10.1

Description of the issue
How to fix mysql Slow queries log issue? I have found Slow queries: 4438 in Admin CP.



This my my.cnf files setting.

Code: 
expire-logs-days = 7
log-error=/var/log/mysqld.log
log-queries-not-using-indexes   = 1
long-query-time  = 8
max-binlog-size  = 100M
slow-query-log = 1
slow-query-log-file = /var/log/mysqlslowqueries.log
Click to expand...


Please tell us more about your server infrastructure? Perhaps you are on an oversold server where it cannot keep up with the i/o requirements needed for your site.
 
I can't guess which are the slow queries, please post them to take s look.
 
Rodolfo said:
I can't guess which are the slow queries, please post them to take s look.
Click to expand...

I am using MySQL version:5.6.37, slow queries log happen with option "log-queries-not-using-indexes" , One more questions, Currently installed: MySQL 5.6 but I am thinking Upgrade to MariaDB 10.2. Please can you let me know that what are recommended for site speed? About Site performance .... ?
 
I have Upgrade to MariaDB 10.2 but why showing MySQL version:5.5.5?

Jdk6VADvRjy6TiuzoyidzA.png
 
I'm sure I've seen this before on other applications. It's a small bug with MariaDB and something to do with the MYSQL client not stripping off the 5.5.5- prefix.

Rodolfo might know, but I think you can just ignore it.

Not sure you should have upgraded though, far better to sort any issues out first. As Rodofo requested you needed to supply the queries.

Also, Chevereto is merely reporting what it sees, consequently the 5.5.5. prefix is not a Chevereto issue.

Edit: Yep, thought it was a bug, here you go:

https://jira.mariadb.org/browse/MDEV-4575
 
Last edited:
Chevereto only reads what your server throws so everything you see there is provided by your server. Is not made up by Chevereto so I don't know how I can help you with this.
 
Status
Not open for further replies.
Back
Top