Moving Mysql binary logs

In connection with the disc space problem of the binary logs, I found it was dead easy to put them on a different partition.

In /etc/mysql/my.cnf there is a line

log-bin

just change this to

log-bin = /newdirectory

Then just restart mysql.

You might want to purge the old logs first, by connecting to your database and running:

purge master logs to '.000001';

Just how simple is that!

DNA, Quarks, The Milky Way and my Chiropracter

An interesting question came to my mind this morning. Cause in part by a conversation I had whilst my chiropracter was pummeling my back. We were chatting about my job, and got onto the topic of DNA. He said he was amazed at just how we can manipulate DNA molecules, due to there size. He commeneted on two recent patients of his. One guy was working with subatomic particles, and the next day, he cracked the bones of a astronomer who “works” with galaxies. The range of size of the objects these guys were researching is quite amazing.

This lead to a conversation with collegues later of just where am I in this range? With a scale going from a quark to a galaxy, just where does a chromosome fit. Now the initial opinion of people was that this is very very close to the quark. But this is not that true. A quark is many orders of magnitude smaller than an atom. A chromosome has many many atoms. You then have to consider what dimension to measure too. Volume, mass or length.

So as any lazy scientist does, instead of calculating something, off to wiki I went…!
Length

  • Milky way width 10 +21
  • size of chromosomes 10 -7
  • upper limit for quarks 10-18

So if we take a quark as the smallest particle then a chromosome is much closer to the smallest particle than a galaxy. But wait…… the smallest theoretical particle is a string…. The theoretical size of a string is:

  • 10 -35

    So therfore the original question is not that daft. A chromosome is almost mid way between a subatomic particle and a galaxy. Crazy… !!

    Meetings

    Why do we have meetings? Or should i say why so many and so long? Why is =
    the default time au hour? every meeting should have a non participating =
    moderator to tell people to shut it. I waste a lot of my time in meetings. =
    Far too much!