205 questions
0
votes
0
answers
73
views
Magento2 database table locking error causing site to go offline several times a day
Several times a day a database insert query runs that seems to take a long time and locks up a table, and this in turn causes our site to go offline (error 503). It does not come back up until certain ...
- 1
1
vote
1
answer
158
views
How to optimize query performance in a large fact table with billions of rows?
I'm thinking of building a data warehouse for a retail company, and we have a fact table called Sales that contains billions of rows. The table stores transaction-level data with columns like ...
- 11
0
votes
0
answers
167
views
AWS RDS MariaDB slow logs empty rows
I enabled the slow query logging on my AWS mariadb RDS as described here. And set up the publishing to Cloudwatch logs.
Parameter group family:
mariadb10.11
My parameters:
log_output = FILE
...
- 65
0
votes
1
answer
83
views
How can I optimize the performance of a slow-running query in MySQL?
I have a query that is taking over 30 seconds to run and is causing delays in our application. I've tried indexing the tables and adjusting the query structure, but it's still slow. Are there any ...
0
votes
2
answers
232
views
optimize TIMESTAMPDIFF in mysql query
I need help optimizing a query for large data table
when I test manually it shows fast , but in my slow query log it is logged as taken 10s+ for some reason .
SELECT q.id, q.village_id, q....
0
votes
1
answer
1k
views
How to check Slow Query for MySQL in GCP
Building a MySQL DataBase with GCP's CloudSQL.
To check Slow Query in MySQL, we have enabled the following labels
[Label]
slow_query_log: on
log_output: file
long_query_time: 3
After configuring the ...
0
votes
1
answer
77
views
Slow query log - Row_send record count differs with actual records
Recently in my application which uses MariaDB 10.6, I am facing some weird issues where the same query took more than the expected time and consumes more IO at random times.
Enabled slow query to ...
- 345
0
votes
1
answer
61
views
Slow Log Issue: SP Calls Not Highlighting Against Temporary Table
I have activated slow logs in mysql 5.7.30. I notice some SP's calls are not highlighting in slow logs even its taking more then time to my threshold value which is 2-sec. On investigation, I found ...
- 47
0
votes
3
answers
1k
views
MYSQL 8.0.26 using CPU upto 300-400%
See my processes screenshots
I have ubuntu server 20.0 having following VPS configuration
4 vCPU Cores
8 GB RAM
50 GB NVMe
I am also attaching my mysqld.cnf
#
# The MySQL database server ...
- 1,556
0
votes
1
answer
144
views
Mysql query return too slow
I have written a query. It works better. But currently, all tables have 100K rows, and one of my queries returns too slow. Can you please suggest to me how I can optimize the query?
select *
from ...
1
vote
1
answer
1k
views
WP Slow queries / Duplicated queries - images
I have problems with slow and duplicated queries, I'll need assistance, I'm working on this for more than 10h+.
Latest WP version - Latest Flatsome theme and just Query monitor and Woocommerce plugins ...
- 45
-1
votes
1
answer
406
views
mysql insert too slow and high io/cpu usage some time
the table row is about one hundred million, sometimes the io bps about 150
IOPS about 4k
os version: CentOS Linux 7
MySQL version: docker mysql:5.6
server_id=3310
skip-host-cache
skip-name-resolve
...
- 319
2
votes
1
answer
1k
views
mariadb slow query not logged
As the title suggests, no log is recorded in the log file even though the related settings have been completed.
slow_query_log_file = /var/log/mysql/mariadb-slow.log
slow_query_log = 1
...
- 33
1
vote
1
answer
72
views
Slow simple mysql query
I have a problem with the speed of query. Simple mysql query, but when I have a lot of records (currently > 1 000 000), the performance is really slow. Question is similar to this one, but can't ...
- 900
0
votes
2
answers
68
views
Slow join with order query
I have a problem with the speed of query. Question is similar to this one, but can't find solution. Explain says that MySQL is using: Using where; Using index; Using temporary; Using filesort
Slow ...
- 900
0
votes
2
answers
2k
views
Amazon RDS - Slow queries at every minute change
We recently noticed that we have a lot more records in our slow query log at every minute change (at around second 0 of every minute). This didn't seem to be related to any of our cronjobs so I ...
- 326
0
votes
1
answer
837
views
MariaDB error and slow query log became empty
So I enabled error log and slow query log on MariaDB and I could see the data in log files. But after a couple of hours when I checked back again then they were empty. It is showing both log files ...
- 3,469
0
votes
1
answer
46
views
mysql: why below query unused union index?
table a
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| id | int(...
- 319
0
votes
2
answers
928
views
SQL gets slow on a simple query with ORDER BY
I have problem with MySQL ORDER BY, it slows down query and I really don't know why, my query was a little more complex so I simplified it to a light query with no joins, but it stills works really ...
- 1,688
1
vote
2
answers
3k
views
query logging in MariaDB on Windows 10
How to enable {all type of, not just slow} query logging to FILE in MariaDB Server version: 10.4.11 running on Windows 10 ?
I have modified my.ini file and added these line at the bottom but it did ...
- 17.6k
0
votes
0
answers
737
views
SQL Insert New Record if not exists else update the existing one
I have 2 tables Staging & Main Table both has the columns SKU and Price. Records are inserted into staging table from there depending on the record its decided whether new record is to be inserted ...
- 109
0
votes
1
answer
929
views
Very slow MySQL LeftJoin on AWS RDS, but very quick elsewhere
MySQL in PROD is running through AWS RDS (Aurora, db.t3.small). The resource ultization across the board is well within happy levels.
If I execute the following SELECT, it's almost instanteneous:
...
- 319
0
votes
1
answer
783
views
Unable to login as root in mysql
I've been trying out all solutions mentioned in google for this problem to no avail. This website is built using bitnami wordpress stack in AWS. All I want to do is to log slow query. I only have wp-...
- 2,466
-3
votes
1
answer
44
views
MYSQL Query Optimization with subqueries and joins
Hi I have 8 million row data and need to optimize Mysql query to fetch a row from that data. I am using below query but its server response time is too high that creating issue in page loading speed
...
2
votes
0
answers
385
views
Random slow response time making app crash on beanstalk
We have a php app using laravel on elastic beanstalk that's been running for almost 2 years. Since the last 2 weeks(almost 3) we've been having random really high response time which cause the ...
- 290