CategoryMySQL

SEMrush keeps taking down my site

S

My site is being absolutely bombarded by page requests originating from semrush.com. Its a bot that is¬†indexing and downloading links to my entire site, which would be fine if it were a small website, except that I have content going back to 1996, which is rather a lot, and they are hitting the server with so many requests that Apache2 and/or MySQL Server 5.7 is crashing. It’s utterly...

MySQL Collation Error

M

Occasionally I come across databases written by other developers who have a complete mix of character sets, and where the database character set does not match the character set of fields within a table. This causes all sorts of nasty errors when trying to use CONCAT or CONCAT_WS. Errors like: Illegal mix of collations for operation ‘concat_ws’) The most common cause is that the...

MySQL ibtmp1 file grows exponentially

M

Recently we have had several servers run out of hard drive space causing inaccessibility and crashing. On further investigation the hard drive was full so many operations were complaining. The hard drive was being consumed by a very large file within the /var/lib/mysql directory called ibtmp1. ibtmp1 is a temporary working file for MySQL. When you turn the MySQL server off and on again the file...

Archive

Tags

Get in touch

I'm available on just about every social media platform out there as RMTWeb.