I took the MySQL 5.6-Exam today and it really is not easy. Lets get straight to the facts i remember: I had 130 questions and 180 minutes time I needed 155 minutes but i was a bit exhausted at the end so went a bit quicker through the questions as in the beginning. Normally i […]
Recently Todd blogged about why you should register for MySQL 5.6 certification exams now: http://mysqlblog.fivefarmers.com/2013/10/04/why-you-should-register-for-mysql-5-6-certification-exams-now/ and i also think that now is a good opportunity to renew or take a new mysql certification. The most interesting point in my opinion is that you can save a lot of money if you take the exam NOW! The […]
Today as i was learning for the new MySQL 5.6-certification (more about that in a later post) i stumbled again across the host_cache-Table that was added to MySQL in 5.6.5. Before that you had no chance to check which hosts are already known by the MySQL-server. So thats a pretty good feature for us. And […]
Recently i had to manage big database installation that was running out of disk space. The partition on which the mysql datadir was located only had a few gigabytes free. Resizing the partition was not possible without a long downtime so that was no option. The installation had only innodb-tables so using symlinks was also […]
Recently i updated to MySQL 5.6 and we were really excited about the very good overall performance. But beside a major bug concerning wrong results when running a SELECT that includes a HAVING based on a function (see http://bugs.mysql.com/bug.php?id=69638) we also noticed that from time to time the replication breaks with the following error: Last_SQL_Errno: 1590 […]
So lets see how this goes.