Day: 16 June 2007

Posted on

Mysql binary logs

How to clean old binary logs

Here’s a little quick tip on cleaning your MythTV box of space cluttering binary logs. These are generated for every transaction that Mysql does. So if you have any corruption you can redo the tables. However, if you have a lot of listings data being imported into the table, then these can be pretty large.

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’;

Posted on

How children lost the right to roam in four generations | the Daily Mail

I dislike the Daily Mail and all the middle class tabloids of its ilk, but for once here’s an interesting article spotted on BoingBoing, on the DM’s website. Regarding the changes in the amount of area that 4 generations of 8 yr old hildren could roam.
How children lost the right to roam in four generations | the Daily Mail

However, it upsets me that they do not see the hypocrisy in this article.  It is papers like these that maintain the hysteria regarding paedo’s on the hunt for your child. Research seems to show that it is far more likely that a child is abused by a member of their family. However, whenever a child is attacked by some wretched creature, or some knee jerk legislation is discussed, it is papers like this that give it publicity.  They must take some responsibility for the hysteria they generate. It is this hysteria that then makes mothers and fathers too scared to let their little darlings out of their sight. Of course the child then grows up scared of the outside world.

Anybody who preys on children is not worthy of oxygen, and should spend the rest of their lives locked away.  They may be ill, but a type of sickness such as this should never be allowed to roam. However, their intended prey should be allowed to roam.  As a child I had the freedom of the world around me. The children of today do not. I doubt whether they are more at risk than I was.  This must be detrimental to them.