Skip to main content

CPanel Open File Limits

October 13, 20141 min read
CPanel Open File Limits
Uh Oh! MySQL stopped connecting, now what?!? This scenario happened to us on our new AWS platform so we decided to dig a little further into the problem. Every 4-6 hours we would get a notice from our monitoring platform that we are receiving an error 500 on our website. When we check the site in a web browser, we see an error that WordPress can not connect to the MySQL database. That’s scary as we haven’t changed anything on our server, or our site to have any conflicts! Did we get hacked, did we break something that we weren’t aware of?!? NOPE, the answer was actually that we ended up reaching our servers soft limit for open files, we’ll explain that in a little bit. To determine if this is what has happened to you, before you restart your server or MySQL, check your server’s “/var/lib/mysql/hostname.err“

Explore a website growth scenario

Change the assumptions to see how traffic and inquiries affect the estimated lifetime revenue of customers acquired in one month. The starting values are examples. This calculator does not measure lost revenue or predict what a redesign will achieve.

Use the same monthly period for visitors and leads.

Use distinct inquiries attributable to those visitors.

Your own estimate of the share that fits your business.

Use your observed rate or label it as an assumption.

Revenue across the customer relationship, before costs.

A scenario you choose, not a prediction from Stoute.

For example, adding 1 point changes a 2% conversion rate to 3%.

One month’s acquired customers

Customers under current assumptions
3.0
Customers in your scenario
3.0
Current cohort’s estimated lifetime revenue
$3,000
Scenario cohort’s estimated lifetime revenue
$3,000
Difference across those customers’ lifetimes
$0

Visitor-to-lead rate: 2.0% → 2.0%. Scenario conversion is limited to 0–100%. Fractional customers represent an average, not a literal customer count.

These amounts are gross lifetime revenue, not monthly cash flow, profit, or return on investment. The model holds qualification, close rate, and customer value constant. It excludes project costs, advertising, delivery costs, and payment timing.

Have a specific WordPress improvement in mind? Describe it in a written inquiry.