Select Page

mysql


How to resolve “InnoDB: Unable to lock ./ibdata1, error: 11”

ERROR (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

 

This is a commonly seen error in database driven sites. The same error can show up when a connection or restart for MySQL server is attempted via commandline.

A quick check of the log files may reveal that the actual error faced by MySQL server is “InnoDB: Unable to lock ./ibdata1, error: 11”.

In our role as Outsourced Tech Support for web hosting providers, database errors are one major category of issues we resolve for the customers.

(more…)

“mysqld: out of memory” – 4 major reasons why you get this error

Database errors can present themselves in the form of ‘503 Service Unavailable’ or ‘500 Server Error’ in websites.

As part of our Outsourced Tech Support services for web hosts, database errors are a commonly resolved issue for customers who report website issues.

To know the exact cause for the MySQL error, we examine the MySQL service error logs and the server logs. (more…)

How to fix MySQL “job failed to start” error

Bobcares.com provides Server Maintenance Services to web hosts, digital marketers and other online businesses.

As part of our services, we manage MySQL servers, and troubleshoot performance issues and server errors. (more…)

How to fix MySQL high CPU usage

How to fix MySQL high CPU usage

A majority of web applications are database driven. MySQL is a popular database server for open source applications, but we’ve seen that it can cause performance issues in the long run.

MySQL databases grow in size, and tables fragment over time. This contributes to MySQL load spikes. So, protecting a server from MySQL high CPU issues requires close monitoring and periodic optimization.
(more…)

Top 8 causes for MySQL performance issues, and how to fix it

PHP-MySQL websites like WordPress are ridiculously simple to use. Which is why they are so popular.

But they are also infamous for their performance issues. Apache, PHP & MySQL often cause high server load, and drag down the website.

Here at Bobcares, we help website owners, digital marketers and web hosts recover from and prevent website performance issues.

Today, we’ll go through the top 8 reasons we’ve seen for MySQL performance issues, and how we fix them. (more…)

How to improve MySQL performance – A guide for web masters & web hosts

At one time or the other, every website owner will face a “slow MySQL” issue.

Then they google “how to improve MySQL performance“.

And what do they find? A lot of tech jargon that analyzes threadbare query performance.

That stuff can make anyone’s head hurt.

Which is why we’ve put together a list of things we do here at Bobcares to quickly fix MySQL performance issues in our customer websites. (more…)

7 reasons why you get ‘mysql failed to start’ errors and how we fix them

7 reasons why you get ‘mysql failed to start’ errors and how we fix them

[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed

Many a times, you’d have come across this message in your server while trying to restart the database server.

Our Dedicated Server Admins support the server infrastructure of several web hosting companies, and this is a common issue we’ve seen in many Linux servers.

Here, we’ll see the common causes and solutions for ‘Mysql failed to start’ issues.

Click here to protect your web & database services from downtime.

(more…)

How to resolve MySQL ‘1146 table doesn’t exist’ errors in your server

How to resolve MySQL ‘1146 table doesn’t exist’ errors in your server

In our role as Hosting Support Engineers for web hosts, we manage servers with various services such as web, database, mail, control panels, FTP, etc.

MySQL is the most commonly used database server in Linux hosting and handling the databases and resolving the errors associated with it, is a common task that we perform. (more…)

How to fix ‘MySQL Remote Root Code Execution’ / ‘Privilege Escalation’ (zero day ) vulnerability – CVE-2016-6662

How to fix ‘MySQL Remote Root Code Execution’ / ‘Privilege Escalation’ (zero day ) vulnerability – CVE-2016-6662

On Sep 12th, Dawid Golunski announced CVE-2016-6662 aka MySQL Remote Root Code Execution / Privilege Escalation (0 day) vulnerability.

CVE-2016-6662 is reported as a critical exploit which can allow local and remote attackers to execute arbitrary code with root privileges in a vulnerable MySQL server. (more…)