Page 1 of 1

One user account slow load mysql data

Posted: Tue Feb 09, 2016 4:36 pm
by robindirksen
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?

Re: One user account slow load mysql data

Posted: Tue Feb 09, 2016 10:20 pm
by tjebbeke
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.

Re: One user account slow load mysql data

Posted: Wed Feb 10, 2016 4:10 pm
by robindirksen
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.

Re: One user account slow load mysql data

Posted: Thu Feb 11, 2016 7:59 am
by tjebbeke
Maybe it's a network issue?
If it's the MySQL database, try to optimize it (mysqltuner.com).