Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Main Section Web Server
  • Search

One user account slow load mysql data

Questions regarding the Web Server
Apache + Nginx, Nginx + PHP5-FPM
Post Reply
  • Print view
Advanced search
4 posts • Page 1 of 1
robindirksen
Posts: 13
Joined: Tue Dec 22, 2015 8:34 pm

One user account slow load mysql data
  • Quote

Post by robindirksen » Tue Feb 09, 2016 4:36 pm

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?
Top

tjebbeke
Collaborator
Posts: 783
Joined: Mon May 11, 2015 8:43 am
Contact:
Contact tjebbeke
Website

Os: CentOS 6x
Web: apache + nginx
Re: One user account slow load mysql data
  • Quote

Post by tjebbeke » Tue Feb 09, 2016 10:20 pm

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.
Top

robindirksen
Posts: 13
Joined: Tue Dec 22, 2015 8:34 pm

Re: One user account slow load mysql data
  • Quote

Post by robindirksen » Wed Feb 10, 2016 4:10 pm

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.
Top

tjebbeke
Collaborator
Posts: 783
Joined: Mon May 11, 2015 8:43 am
Contact:
Contact tjebbeke
Website

Os: CentOS 6x
Web: apache + nginx
Re: One user account slow load mysql data
  • Quote

Post by tjebbeke » Thu Feb 11, 2016 7:59 am

Maybe it's a network issue?
If it's the MySQL database, try to optimize it (mysqltuner.com).
Top


Post Reply
  • Print view

4 posts • Page 1 of 1

Return to “Web Server”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

Login  •  Register

I forgot my password