MySQL

About MySQL

MySQL with Docker

First, I pulled the image ‘docker pull mysql’ that was the last easy thing I did. I wanted to use my own my.cnf file. So put it in /my/custom and used: ‘-v /my/custom:/etc/mysql’. I pulled a highly optimized one off github: https://gist.githubusercontent.com/rhtyd/d59078be4dc88123104e/raw/12d79310970e21604480c41d0c34813e6946be44/my.cnf I had to comment a lot out as many options are deprecated #datadir  

MySQL with Docker Read More »

MySQL Workbench 19.04 Hack

Ubuntu 19.04 (Disco Dingo) does not have a package for MySQL Workbench. It was difficult to build from source. I don’t even remember what I did. But once I built it, I saved the source tree in a zipfile. Then in the build directory, wb-build, I copied the Makefile to Makefile.install. I removed any dependencies

MySQL Workbench 19.04 Hack Read More »

MySQL woes

My websites were running slowly. It just kept saying “transferring”. I tried everything with regard to apache and the network. But as it turns out, it was the MySQL database. I noticed some errors in the MySQL log “Got timeout reading communication packets” so, of course, I googled it and changed a value in /etc/mysql/my.cnf

MySQL woes Read More »