Select Page

MySQL Blogs


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…)

cPanel MySQL optimization – How it benefits your server

1, 2, 3.. If your site still doesn’t load, it’s obviously not a good sign for your business..

Many server owners get servers with excellent specifications and wait for magic to happen. But server specs alone, cannot guarantee fast websites.

GBs of memory and GHz of CPU go wasted, if they are not optimized to suit your business purpose.  (more…)

MySQL “stop: Unknown instance:” error – Why it happens and how to fix

Server errors are no fun.

And it is especially frustrating when the error is cryptic, like “Unknown instance“.

What does it mean, really?

A common error people face in VPS, Cloud and Dedicated servers is MySQL failing with “stop: Unknown instance:(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…)

5 reasons for error “Your PHP installation appears to be missing the MySQL extension” and how to fix it

5 reasons for error “Your PHP installation appears to be missing the MySQL extension” and how to fix it

Dedicated Support Engineers at Bobcares manage thousands of WordPress sites of web designers, digital marketers, online publishers, web hosts and more.

In these sites, this error usually comes up after a recent migration:

Your PHP installation appears to be missing the MySQL extension which is required by WordPress.
 (more…)

How to fix error in Mysql “tablespace is missing for table XXXXX”

Here at Bobcares, our Hosting Support Engineers monitor & maintain servers of web hosts, digital marketers and other online businesses.

A vast majority of these servers use MySQL as the database server, and a common error seen in them is:

1812 Tablespace is missing for table XXXX

(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…)