MySQL

Website performance issues

If you recently visited my website (let's say in the last two or three days), you might have noticed some performance issues. It seems I didn't pay that much attention to the MySQL binary logging configuration, when I enabled this feature so that I could do point-in-time recovery in case something goes wrong.

In /etc/mysql/my.cnf, I had these options related to binlogging:

[mysqld]
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 100M

Tags: 

Topics: 

MySQL 5.0 DBA II

Although Murphy didn't want it to happen (there has been a power outage at the testing center, which resulted in a fried core switch, and there  was no spare switch of the same type), I passed the MySQL 5.0 DBA II exam today. Score: 60/70.

Sweet :D

Tags: 

Topics: 

Emerging mysql-gui-tools

Some time ago I tried "emerge mysql-gui-tools" on my Gentoo x86_64 box. Unfortunately, the compilation process failed because of some errors (will include the error in this post when I find the time to reproduce it).

Today, I'm preparing myself for MySQL DBA certification, and I really need the MySQL Administrator tool, so at first I downloaded the precompiled tar archive from the MySQL website, which worked without any problems.

Later on, I downloaded the MySQL Community server RPM for RHEL5, which I installed on my CentOS 5 virtual machine running in KVM. To have the same version of MySQL on my Gentoo box, I decided to "emerge mysql-community" rather then the "normal" mysql ebuild.

Tags: 

Topics: 

Subscribe to RSS - MySQL