mysql

Conjouring a daemon

“A long time ago – in a galaxy far, far, away” … as the story goes I left University with...

Error Code: 1175. You are using safe update mode

So today’s annoyance and resulting note to myself is Error Code 1175 – and safe mode for updates. Error Code: 1175....

Is it okay to delete _site_transient_browser_ ? Yes.

WordPress – mySQL / MariaDB – Slow queries accessing  wp_options? This is a short article about transient entries in the WordPress...

mysql ibdata1 – Where has my disk space gone?

So – here we are – arrive to desk with monitoring screaming about a mySQL server running out of disk...

UTF-8 Latin1 and the £ that looked like a ?

On moving a Database from an older version of PHP and MySQL 5.old to a newer version of PHP and...

mySQL table and DB sizes in

A colleague today asked me about size of a specific database on a dedicated database server for a shared hosting...

PBA-S WHOIS privacy retrospectively

Adding WHOIS Privacy to Plesk / Odin PBA-S after the event has not been supported for quite some period of...

MariaDB and InnoDB MySQL Row size too large

ERROR 1118 (42000) at line 876: Row size too large (> 8126). Changing some columns to TEXT or BLOB or...

MariaDB 10.1 crashing repeatedly

Too much time today has been spent looking over a lightly loaded MariaDB instance that was crashing and restart repeatedly....

mySQL innodb binary to .sql dump files

Today I found out that you can grab a .sql file from an innodb or other format binary reliably –...

Skip to toolbar