Select Page

MySQL Blogs


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 MySQL high CPU usage

How to fix MySQL high CPU usage

Majority of the 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 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…)

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 Server Support Specialists 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…)

Improve MySQL performance in your servers with these 5 sure-win ways

Improve MySQL performance in your servers with these 5 sure-win ways

Anything from a deteriorated hardware to a poorly configured service can affect the MySQL server performance. Over time and traffic, the database-drive applications often tend to slow down.

To get the maximum performance out of your MySQL server, it is not just enough that you add some more RAM or upgrade your server hardware. (more…)

How to speed up MySQL server for express loading of sites

How to speed up MySQL server for express loading of sites

Many websites run applications that are database driven. Fetching the data from relevant databases and delivering the contents dynamically to a web page, is what most of these applications do.

As the data content or traffic increases, we’ve seen that these applications tend to get slow over time. In our role as Outsourced Tech Support for web hosting companies, we speed up MySQL server for our customers who are web hosts.

(more…)

10 tips to prevent database corruption in your web hosting servers

10 tips to prevent database corruption in your web hosting servers

Many websites run database-driven applications, and a single missing entry in these tables can lead to website downtime. Database corruption is an alarming scenario for webhosts, who end up spending time and effort repairing and restoring their customer databases.

At Bobcares, our staff resolve such scenarios everyday in their role as Outsourced Support Engineers for web hosting providers. And we’ve learned that its better to stay pro-active and prevent a DB corruption, than fire-fighting a website downtime.

(more…)

Page 1 of 3123