Tag Archives: mysql

MySQL : What management tools do you use?

A quick question out to the world. What management tools do you use for MySQL? We currently have: MySQL Workbench : It’s OK, but I don’t really like it. It feels like half a product compared to tools I’ve used for other database engines… phpMyAdmin : I’ve used this on and off for over a decade […]

MySQL Upgrades

I read Wim Coekaerts post about the MySQL 5.6.20-4 this morning. I logged on to my server and did the following command as root. # yum update -y That’ll be the upgrade done then… If you are using MySQL on Linux you can use the MySQL Repository for your distribution, rather than using the bundled MySQL […]

Oracle Linux and MySQL : Progress

A few months ago I wrote about some MySQL on Oracle Linux migrations we were working through. It’s been a long time coming, but last weekend was the go-live for this batch of migrations. So far so good! Most of the elapsed time since my last post on this subject has been spent with the […]

Oracle Linux and MySQL

I’m in the process of taking on some of the MySQL databases in my company. The first ones are MySQL 4.1 running on Windows, so we are upgrading them to MySQL 5.6 on Oracle Linux. As with many of our systems, these will be running on VMware virtual machines. Since the current installations are so […]

mySQL: OR, UNION and UNION ALL

I was doing some SQL tuning on mySQL today and I learned a few interesting things. Let’s take an example of a simple query where we have an OR of two mutually exclusive conditions, each on indexed columns. SELECT * FROM   t1 WHERE  user_id = 1 OR     location_id = 2; In mySQL there is a […]

MySQL Disaster Recovery…

Within a couple of weeks of doing our disaster recovery testing we’ve had a number of disasters, one of which was our Bugzilla server. The recovery was pretty sweet. The database engine (mySQL) was loaded as part of the Linux install and recovering the database was done with one command: mysql -u root –password=”myPassword” bugs […]