• Welcome to the Chevereto user community!

    Here users from all over the world gather around to learn the latest about Chevereto and contribute with ideas to improve the software.

    Please keep in mind:

    • 😌 This community is user driven. Be polite with other users.
    • 👉 Is required to purchase a Chevereto license to participate in this community (doesn't apply to Pre-sales).
    • 💸 Purchase a Pro Subscription to get access to active software support and faster ticket response times.

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