How to clean old binary logs

Recently I had a problem with Disc space on my MythTV box. I found the the inary logs for MYSQL were over a gig in size. These are records of all database transactions. They wllo you to recreate the database if a backup is out of date, as you can replay all transactions. Anyway I was able to lose a lot of these, and regain disc space, without affecting safety.

mysql -u root --password mythconverg
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 53 to server version: 4.1.21-log

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> show master logs;
+——————-+———–+
| Log_name | File_size |
+——————-+———–+
| mythtv-bin.000001 | 79 |
| mythtv-bin.000002 | 79 |
| mythtv-bin.000003 | 79 |
| mythtv-bin.000004 | 50504 |
| mythtv-bin.000005 | 2767417 |
| mythtv-bin.000006 | 42523 |
| mythtv-bin.000007 | 79 |
| mythtv-bin.000008 | 7099399 |
| mythtv-bin.000009 | 60102 |
| mythtv-bin.000010 | 23028247 |
| mythtv-bin.000011 | 13157557 |
| mythtv-bin.000012 | 3300816 |

mysql> purge master logs to ‘mythtv-bin.010’;

Configuring Boot Behavior for Alpha Systems

Configuring Boot Behavior for Alpha Systems

Whilst playing with my Alpha 600a workstation (Cheers Andres!), I’ve been struggling to find out how to automate booting from the bios (well the alpha version of a bios!).
Well

Show bootdef_dev

will show you the default boot device.

set bootdef_dev

will set it. In my case this is a SCSI device on ID3. so
set bootdef_dev dkc

running ,code>boot now boots from that device. Rather than having to run boot dkc

Now all I just need to do is find out how to make it boot without prompting…!!!

EDIT… Aha!!!  when a default boot device is set, it will be booted automatically!!  Cool!

Mark Thomas on demonstrating near the Houses of Parliament

Guardian Unlimited Politics | Special Reports | Mark Thomas on demonstrating near the Houses of Parliament

Mark Thomas is that quite unique combination (unfortunately too unique) of being very, very funny and pretty moralisticaly correct. Unlike a lot of the “right on” crows of the late 80’s alternative crew he is consistent to his own politics (As Alexei), and keeps being a thorn in the side of the establishment. Here he shows just how stupid the law restricting demonstrations near the Houses of Parliment is, by following the paperwork trail correctly, and applying to do 21 demo’s in a single day. Hilarious!

Useful links:

Mark Thomas’s homepage

Veil teacher ‘should be sacked’

BBC NEWS | England | Bradford | Veil teacher ‘should be sacked’

This is quite a tricky one. A primary school teacher refuses to remove her full face veil (Burka?) whilst teaching mixed sex classes.
Personally I think she should be sacked for breach of contract. She attended the interview without the veil (male or female interviewer?), therefore intending to wear this during her employment is wrong.

Also my opinion is that hiding a women’s face due to some religious writing is an abomination. However, restricting the wearing of this does impinge on this women’s rights.

In this situation the children’s rights should be paramount, and if there is any evidence that the children suffer because of reduced communication (as there appears to be) then the veil should be removed. It also promotes the wearing of the veil to the impressionable children. Teaching children overly political messages is wrong, and so is promoting religious views (in my opinion even moderate religious views should be restricted).

It is a much more complicated matter than the recent one of BA telling a female employee to hide her cross. Although there is no issue of sexual discrimination in the wearing of the cross, it is an overtly religious symbol and its display should be able to be regulated by a person’s employer. Again though this affects the wearer’s human rights.

Tricky one. How do you combine a strong belief in freedom of speech with a strong dislike of indoctrination and propaganda? Where is the line drawn? Personally this is easy to judge, but how do you determine the line in law?

holiday in Greece

Finally on holiday. Bloody weather is great too. I sit writing this facimg =
a gorgeous blue sea with snow capped peaks facing me across the straits. =
Very relaxing. I have almost forgotten what i do for a living. Getting used =
to the m600i’s leyboard too. Well almost.