Main menu

MySQL

15 Nov

Website performance issues

Published by stintel

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

Topics 

General

Tags 

Linux, MySQL
Read more
01 Apr

MySQL 5.0 DBA II

Published by stintel

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

Topics 

Life

Tags 

MySQL
Read more
15 Jan

Emerging mysql-gui-tools

Published by stintel

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.

Topics 

Linux

Tags 

Linux, MySQL, Gentoo
Read more

Stijn Tintel. Curegemstraat 37, BE-3071 Erps-Kwerps. BTW BE-0812.308.286. KBC 734-0269514-57.

 

Powered by Drupal, an open source content management systemRunning on Gentoo LinuxPowered by nginxPowered by PHP5Powered by MySQLipv6 ready