Select Page

database optimization


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 optimize and speed up your server by more than 20%

How to optimize and speed up your server by more than 20%

10 years back, people were happy with sites that loaded in 10 seconds. Not anymore.

These days, people browse sites on the go with their smartphones. If it’s not loading in 2 seconds, they just open the next site. (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…)

Database crash rescue – How we re-built an InnoDB MySQL database when ibdata1 file was corrupted

Database crash rescue – How we re-built an InnoDB MySQL database when ibdata1 file was corrupted

For a website owner or a web host, a hard disk crash is one of the most upsetting things that can happen to their business. It means service downtime, loss of business and valuable time spent on data restoration.

To minimize such catastrophe, many server owners keep regular backups, and even use RAID servers. But even with these precautions, sometimes things can go for a toss when the backups also get lost in a hard disk crash.

(more…)