One user account slow load mysql data
-
- Posts: 13
- Joined: Tue Dec 22, 2015 8:34 pm
One user account slow load mysql data
Is this a known bug that one user account slow load MySQL data from server?
a site with multiple mysql connections load slow, and the same site with a few less mysql query's loads fast.
This is only on account 'user1', 'user2' doesn't have trobble.
Any idea's?
a site with multiple mysql connections load slow, and the same site with a few less mysql query's loads fast.
This is only on account 'user1', 'user2' doesn't have trobble.
Any idea's?
-
- Collaborator
- Posts: 783
- Joined: Mon May 11, 2015 8:43 am
- Contact:
- Os: CentOS 6x
- Web: apache + nginx
Re: One user account slow load mysql data
What kind of server do you have? RAM, CPU cores?
Is the MySQL database large?
A not optimized MySQL server on a small server with a large database can slow down the performance.
Is the MySQL database large?
A not optimized MySQL server on a small server with a large database can slow down the performance.
-
- Posts: 13
- Joined: Tue Dec 22, 2015 8:34 pm
Re: One user account slow load mysql data
tjebbeke wrote:What kind of server do you have? RAM, CPU cores?
Is the MySQL database large?
A not optimized MySQL server on a small server with a large database can slow down the performance.
A few days ago the site loads within a second, but now the site takes 30 seconds to load. There aren't any new records in the MySQL DB.
-
- Collaborator
- Posts: 783
- Joined: Mon May 11, 2015 8:43 am
- Contact:
- Os: CentOS 6x
- Web: apache + nginx
Re: One user account slow load mysql data
Maybe it's a network issue?
If it's the MySQL database, try to optimize it (mysqltuner.com).
If it's the MySQL database, try to optimize it (mysqltuner.com).