MySQL

Website performance issues

Submitted by stintel on

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

Submitted by stintel on

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

Submitted by stintel on

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