MySQL Issues

Technical discussions, how to do geeky things more efficiently.

Moderators: Nanook, carl

Post Reply
User avatar
Nanook
Senior Member
Posts: 95
Joined: Tue Jun 25, 2013 10:08 pm
Location: Shoreline
Contact:

MySQL Issues

Post by Nanook » Sun Aug 14, 2016 2:38 am

I have been experiencing many problems since upgrading to MySQL 5.7, random lockups. First with a gazillion socket operation attempted on non-socket errors, and then one with invalid file descriptors.
At this point I've deleted and re-installed the server entirely on the assumption that something is corrupted and broken.

Salomon
Junior Member
Posts: 1
Joined: Tue Mar 13, 2018 9:44 pm
Contact:

Re: MySQL Issues

Post by Salomon » Tue Mar 13, 2018 9:48 pm

Problem #1: High disk usage: Solution: Configure MySQL to work mainly with memory, not disks
Problem #2: Losing connection to the server.
Problem #3: Getting a “too many connections” error. Solution: Reconfigure MySQL to accept more connections. To do this, change your max_connections variable.

User avatar
Nanook
Senior Member
Posts: 95
Joined: Tue Jun 25, 2013 10:08 pm
Location: Shoreline
Contact:

Re: MySQL Issues

Post by Nanook » Sun Mar 18, 2018 7:57 pm

I've pulled the advertising portion of your reply. There is a group here for that purpose, this isn't the one.

While I'm here, I'll add you are correct with respect to MySQL, the problem with making it mainly run out of memory is that the version that is included with Ubuntu has compiled in limits that make that impossible given our load.

I found a solution in Oracle's "Community MySQL" version which has no compiled in limits allowing me to set them high enough to not exhaust resource and as you say run mainly out of memory. It's all much happier now to the point where our WordPress sites are now faster than 97% of the Internet according to Pingdom.

Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests