Yesterday, Today, Tomorrow
Yesterday I spend a lot of time outside with Lily. We went to the
fountain we watched film at home. The film was called "Wild Hogs"
it was supposed to be a fun commedy (only supposed to be). This
week is going to be a taugh one. We have to present a project at
Marketing Research. I have to write a 600 words resume about
International Enterprice, also we have to make a presentation in
Culture. Today in the morning i was on a Liturgy again. God's grace
is here ! The week passed without serious server issues (Thanks
God). Today I checked some logs of one of the servers and I
observed oddities there. I checked the crontab and I realized it's
because of a crontab. The dumped database is a HUGE one 2.6G
(bzipped). I asked in irc.freenode.net #mysql, and the guys there
pointed me to a similar issue which was supposed to be an MySQL bug
when dumping large database. Since the dumping databases were of a
type MyISAM I ofcourse could have used mysqlhotcopy. But in the end
the solution to the problem was removing "--opt" option from the
backup opts of mysqldump and passing "--skip-opt" to it (I suspect
this would slow the dumping process a lot). But I don't care it is
much better (a slow dumping), than hanging the whole Webserver and
interrupting the site's visibility over the Internet. Btw I started
playing Quake 2, it's cool but a little annoying there are too many
tunnels and very often after I kill most of the bad guys I spend a
lot of time searching for keys and stuff .. :).