Server Works well until but then hangs for 5 mins
Server Works well until but then hangs for 5 mins
Recently Set up on to our new server, it's relatively decent spec 2x intel xeon 5318Y w/ 256GB ram. Have around 5 busy sites and 10 not so busy. But nothing majorly busy.
It seems that at certain times of the day (not fixed times) the sever goes from being spritely to slow for 2 of the busiest sites only. The other sites are still accessible and still reasonably fast to access.
When this happens I sit back and try and look through the processes in WHM and when i check the Show database processes, then these seem to have built up a longer list of processes and I do notice Indexing has long wait times. So I am assuming that this indexing is causing a queue. I have checked apache workers and these seem to be fine. No error pages, Just hangs and takes about a minute to access the site.
The MariaDB is box standard, I have not made any changes, although i did try what was suggested within the editor and these made it slightly worse when indexing.
How can i improve the Indexing time and would i need to do a Mysql optimisation tweaks/ which area should i concentrate on?
As you can tell I am not a server tech, i have dabbled in this stuff for years but just never dabbled enough :)
Does anyone have any suggestions?
-
Hey there! For not being a tech, it sounds like you've made good progress and have potentially narrowed down to the issue to a problem with MySQL - that's an excellent start!
When the issue is happening, run this command on the server:
mysqladmin proc status
This will show you what MySQL is doing in real-time on the machine, so you can see if there is slowness there that is causing the behavior.
0 -
i think that the Create Sort Index loads in to the memory but the optimization need to allow more memory
37669151 | **username** | localhost | **database** | Execute | 0 | Creating sort index | /*club_forum::club_user::IPS\Node\_Model::loadIntoMemory:755*/ SELECT * FROM `oc_l | 0.000
this was not under load (at this time) but I am wondering if MariaDB does not have access to enough memory, as we have 256GB of it I was wondering if releasing more memory for the Create Sort Index would help?
what part of my.conf would be good to tweak to get that to work?
0 -
Were there a large number of those processes running on the system? Since the "time" column is 0, that indicates the processes are running quickly and aren't lingering in the queue, so this line alone doesn't indicate an issue.
0
Please sign in to leave a comment.
Comments
3 comments