MySQL logging queries under OS X

I really wanted to get MySQL logging all the queries rails was producing.  After a good hour of messing around I have cracked it!

Mac OS X has a startup file which starts mysql on startup.  This needs to be modified to turn on logging support.

This can be found in /Library/StartupItems/MySQLCOM.  The file required editing is MySQLCOM.  Open it up using your favorite text editor.  The the StartService() method, and then after the start command add

” –log=/var/log/mysqld.log”

To create the log file, use the following commands

sudo cd /var/log

sudo touch mysqld.log

sudo chown mysql mysqld.log

Once that has been done, restart the server

sudo /Library/StartupItems/MySQLCOM/./MySQLCOM restart

You can then tail the log file and see all the queries in real time

tail -f mysqld.log

 

Bobs your uncle! Done

 

Technorati tags: , ,

MySQL logging queries under OS X

I really wanted to get MySQL logging all the queries rails was producing.  After a good hour of messing around I have cracked it!

Mac OS X has a startup file which starts mysql on startup.  This needs to be modified to turn on logging support.

This can be found in /Library/StartupItems/MySQLCOM.  The file required editing is MySQLCOM.  Open it up using your favorite text editor.  The the StartService() method, and then after the start command add

” –log=/var/log/mysqld.log”

To create the log file, use the following commands

sudo cd /var/log

sudo touch mysqld.log

sudo chown mysql mysqld.log

Once that has been done, restart the server

sudo /Library/StartupItems/MySQLCOM/./MySQLCOM restart

You can then tail the log file and see all the queries in real time

tail -f mysqld.log

 

Bobs your uncle! Done

 

Technorati tags: , ,

DDD4 Agenda Posted

The agenda has been posted on the site.

http://www.developerday.co.uk/ddd/agendaddd4.asp

This is what I think I am going to do:

SQL AND XML (Presentation) Dave McMahon or How to Write Crap Code in C# (Presentation) Ben Lamb

An Introduction to Microsoft Robotics Studio (Presentation) Steve Tudor or The Use and Abuse of Reflection (Presentation) Joanna Carter

“But it works on my PC!” or continuous integration to improve software quality (Presentation) Richard Fennell or Securing applications and communications in ASP.NET (Presentation) Barry Dorrans

Introduction to Aspect Oriented Programming (Presentation) Abid Quereshi or TechED Highlights (Presentation) Richard Costall & Dave McMahon

Extensible LINQing (Presentation) Oliver Sturm

Depends how I feel on the day which I will be attending, but looks like there is something for everyone.

There is a strong NxtGenUG feel to the day which is great to see.

 

Technorati tags: ,

Microsoft Windows Vista RTM

BIG NEWS! Vista has gone RTM!! This is a big moment and it should be available on MSDN soon (no confirmation yet, but within the week!).

Can’t wait to get my hands on a copy (via MSDNAA of course…).

Keep an eye on YouTube for MacBook + Vista RTM videos – as soon as I see one with glass effects running properly I’m going to buy one (I think).

 

Office 2007 also went RTM last Friday. Looks like we are all released up and ready to go!

 

UPDATE: I forgot, the build number is 6000.16386 “061101-2205″

 

Technorati tags: , , ,

MacBook Core 2 Duo Released

Apple have just upgraded their range of MacBook’s to include Core 2 Duo.

The question now is => Should I get one?  @ £699.71 it’s very tempting.

 

  • 1GB 667 DDR2 – 2x512MB SO-DIMMs
  • 60GB Serial ATA drive (5400rpm)
  • Apple Mini-DVI to VGA Adapter
  • Keyboard (English) & Mac OS (English)
  • Country kit
  • 1.83GHz Intel Core Duo
  • Combo Drive
  • AirPort Extreme Card & Bluetooth
  • Power Adapter
  • Battery

 

Technorati tags: , ,

.Net Framework 3.0 RTM

Didn’t get chance to blog this yesterday, but .Net Framework 3.0 has gone RTM.

You can download it the parts at the following places.

  • NET Framework 3.0 Runtime Components
  • Windows SDK for Vista and the .NET Framework 3.0
  • Visual Studio 2005 Extensions for .NET Framework 3.0 (Windows Workflow Foundation)
  • Visual Studio 2005 Extensions for .NET Framework 3.0 (WCF & WPF), November 2006 CTP
  •  

    Remember this works on XP and 2003 and is not just a Vista feature (just incase you didn’t know).

     

    Technorati tags: ,

    TechEd Europe

    Highly jealous of these guys, going to have to pick their brains lots @ DDD4 but my friends over @ usingtangent.net are at TechEd this week and are keeping a really good blog on their adventures.

    Check it out @ http://blog.usingtangent.net

     

    Reminders

    Keep an eye on NxtGenUG’s site – http://www.nxtgenug.net/ as they are doing a podcast a day regarding what’s happening over there.

    Finally, The Virtual Side has some really good videos http://www.mseventseurope.com/TechEd/06/pre/defaultDev.aspx

     

    Lots and lots of reading and videos to watch this week – best get started

     

    WPF Healthcare Sample Source

    Ben Riga has just posted information regarding the WPF Healthcare prototype source code have been released. This is an old demo (PDC 05) but still one of the best I have seem (maybe due to lack of public prototypes). 

    Within the zip file you will find the source code, some gadget source code and documents breaking code the application and code which is cool!

    Download it from the link below and have a look at this great application, maybe get some ideas for your next application.  Looking forward to getting some time for WPF soon (well, one can hope).

     

    Links:

    http://blogs.msdn.com/benriga/archive/2006/11/02/wpf-healthcare-sample-source-posted.aspx

    http://wpf.netfx3.com/files/folders/applications/entry6608.aspx

     

    Technorati tags: , ,

    Vista Launch Date

    Microsoft have announced that Vista is going to be launched to businesses on November 30th along with Office 2007 and Exchange 12/2007, although E12 isn’t going to be RTM until December (like the Biztalk 2006 launch…).  I am guessing this means that it will be available on MSDN from November 30th as well.

    Retail launch is not until January (30th approaching to APCMag).

    Build number will be forced to 6000.

     

    Box Art

    Source: Bink.nu
    Source: Bink.nu

    Looks cool!! Only boxed copy of Windows I have saw is Windows ME which wasn’t that cool (all the rest have been OEM) – wonder if I will get chance to see this one.

     

    More here:

    http://news.bbc.co.uk/1/hi/technology/6110958.stm

    and here:

    http://apcmag.com/node/4258  http://www.apcstart.com/node/4236

    and here:

    How the Windows Vista Packaging will open

     

    Technorati tags: , , ,