MySQL Forums
Forum List  »  Newbie

MySql queries are taking more than 5-10minutes to give results
Posted by: Surya H
Date: April 04, 2022 04:40AM

HI,
Below are the problems we are facing.

on-premise Server Config: 2Core CPU, 8GB Ram, 1TB HDD (200GB for DB).
MySQL server version 5.7.30
OS : Ubuntu Server 18.04 LTS.

issue description:

1. Not able to take a backup of MySQL database via mysqldump query. I tried it and it's been more than 24 hours but still, it was taking the backup. (I tried taking backup of the single table also which is having some 3 crore rows still the same issue).
2. We are having two big tables for storing some data, whenever we are performing any query to these tables it is taking more than 5-10 minutes to give the results. (no. of records is around 4 crores in each table).
3. Not showing any MySQL CPU consumption while performing queries in these tables.
4. I couldn't see any MySQL error logs generated on this particular day.
5. I also restarted the mysql server.

I request somebody to help me what is wrong here, is it because of the number of records in that table or the server configuration is not able to handle this request or something else.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.