Select Page

Database Blogs


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

How to speed up Apache webserver for maximum Performance

How to speed up Apache webserver for maximum Performance

These days, everyone expects sites to be super fast. For instance, Google’s LightHouse audit tool recommends that a page should load within 1.2 seconds.

Yes, 1.2 seconds sound steep, but what if your competitors heed that advice? They are likely to get better SEO ranks, and customer visits. (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…)

How to fix Magento error “Syntax error or access violation: 1118 Row size too large”

As a server administration company, we often get support requests from website and server owners.

Recently we were called on to fix this error in a Magento 2 server:

SQLSTATE[42000]: Syntax error or access violation:1118 Row size too large. The Maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

(more…)

Speed up website – How the perfect server solution can boost your slow websites

A slow website does more harm to your business than good. Not only would customers abandon it, they may also share negative reviews with others.

We’ve seen scenarios where a single website slows down the entire server. In our server administration services, we often get requests to speed up websites.

(more…)

Page 1 of 512345