This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

Mysqld blocks
#1
Mysqld blocks
There is a website that has heavy database usage, and after a while it doesn't load
Web page returns the following error:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

In this cases i restart mysqld, to make it work.
Please tell me what do i do to diagnose/fix it, thanks.
Reply
Thanks given by:
#2
RE: Mysqld blocks
Mysql crashing here so, maybe increase server resources: ram and optimize your sql requests. Focus on indexes, use a profiler and avoid broad searches in the db.
No support using PM (Auto adding to IGNORE list!), use the forum. 
How to ask
Freelance AWS Certified Architect & SysOps// DevOps

10$ free to start your VPS
Reply
Thanks given by:


Possibly Related Threads…
Thread Author Replies Views Last Post
Critical Error: [0100] - MySQL server offline & mysqld.service not found oliverhoff 1 4 ,964 06-20-2017, 04:09 AM
Last Post: TGates
Problems with Mysqld service andreapuglisi95 11 24 ,572 12-01-2015, 06:19 AM
Last Post: andreapuglisi95

Forum Jump:


Users browsing this thread: 1 Guest(s)