OK, that was just three hours of my life sucked into oblivion. I’m I doing something really stupid, or is MySQL Administrator really that broken?
So what I was trying to do is get long query logging in MySql to work. Don’t use the MySQL Administrator to do this! Just edit your C:\Program Files\MySQL\MySQL Server 5.0\my.ini file, and add the following to the end of the file (in the [mysqld] section)
- log-slow-queries=[log filename or blank for default]
- log-queries-not-using-indexes
Thats all there is to it. Do not try and put it in the [mysql] section. Do not try to use the GUI, which will put it there, but won’t read it unless you change the section name to [MySQL]. Do not think, just do as I eventually did…
And then life is good…
8 months ago
doesn’t appear to like to try and get you zero rows - throws an exception. Guess that kind of makes sense, but lesson learned is trap for this condition before hand or catch the exception…
9 months ago
are funky….
No idea if this is normal behavior, but I am using a ‘DetachedCriteria’ in a search object. I want to generate a page of search results, so I need both the total rows returned as well as the slice of the data for this page. So, generate a DetachedCriteria for the where clause, use a ScalarProjectionQuery to get the total count, and then a SlicedFindAll to get the page. I DON”T THINK SO! Using the DetachedCriteria in one query seems to mess it up for the next query, so I end up making to copies of the where clause, one per query, and it works fine. WTF! Bug or feature? I don’t know, just beware if you are doing the same and getting funky errors.
9 months ago
Or do I blame NHibernate? Big and complicated, huge learning curve. Once I get over it, I may love it, but until then, it’s more swimming in mud….
9 months ago
So don’t believe what you read in the documentation. With the latest version of ActiveRecord, you don’t need to us NHibernate.Generics - NHibernate 1.2 has build in support (see the Iesi.Collections.Generics classes). So that one only cost me a half day. I am having a real love hate relationship with Castle ActiveRecord, maybe I should be switching back to Rails…
NHibernate Generics: Deprecated On 1.2
9 months ago
It was a very intesting conference. Small - only 240 people, which was very cool, as everybody fit in one room, and you had contact with everyone. That’s what it was really about, networking, meeting new people, and just getting a little bit connected. I’m still digesting the content. The morning speakers were all good, but I have to admit, I don’t remember much from the afternoons, and I didn’t take that many notes in the afternoon. More later….
9 months ago