MySQL University session on December 18: Using DTrace with MySQL

2008-12-15 Thread Stefan Hinz
This Thursday (December 18th), Martin MC Brown will talk about using DTrace with MySQL. The session will start at 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow). Note that we'll be using a new session address / Dimdim URL:

Windows source distribution

2008-12-15 Thread Edward Diener
The MySql manual in section 2.4.15.6.2 mentions building MySql from the Windows source distribution. I need to do this in order to add SSL support to my MySql server on Windows. From where do I download the Windows source distribution ? The source distributions listed at

Help with query

2008-12-15 Thread Néstor
I have a char fiel where I am keeping dates formatted as year-month-day (2006-10-09) Now I am trying to find all the records between 2 strings (2 dates). The 2 queries below should return the same number of records by they do not. My query is this: SELECT COUNT(*) FROM proj where

Re: Help with query

2008-12-15 Thread John Daisley
Are you sure those are the results to those queries? ¢,m Your second query will return more because it includes values outside of the date range specified in the first query. In the second result set you have 2009 and 'invalid dates' that would not be picked up by the first query. Regards

Re: Help with query

2008-12-15 Thread Phil
Am I totally missing something? Why do you believe the two queries should return the same # of rows? First one has a qualification of proj_adv_date '2008-12-16' whilst the second one does not... On Mon, Dec 15, 2008 at 12:12 PM, Néstor rot...@gmail.com wrote: I have a char fiel where I am

Re: Help with query

2008-12-15 Thread Néstor
Sorry!!! I apoligized for being blind. Yes, in my small mind I was thinking that I do not have records biggeer than 2008 but I do and my mind refused to see the records for 2009 and 2010. Sorry again for being so blind to the obvious. :-( On Mon, Dec 15, 2008 at 9:50 AM, Phil

Re: Windows source distribution

2008-12-15 Thread Warren Young
Edward Diener wrote: The source distributions listed at http://dev.mysql.com/downloads/mysql/5.0.html#source do not specify any as the Windows source distribution. I downloaded the .zip file, thinking that might be the one, but it is not. I just downloaded it, and it looks like the source

Re: Windows source distribution

2008-12-15 Thread Edward Diener
Warren Young wrote: Edward Diener wrote: The source distributions listed at http://dev.mysql.com/downloads/mysql/5.0.html#source do not specify any as the Windows source distribution. I downloaded the .zip file, thinking that might be the one, but it is not. I just downloaded it, and it

Building MySql for Windows with SSL

2008-12-15 Thread Edward Diener
In the MySql manual section 5.5.7.2 it specifies how to build MySql on a Unix/Linux platform with SSL by using 'configure'. I need to build MySql for Windows with SSL support. In section 2.4.15.6.1 for building MySql for Windows itr specifies the available options for using win/configure, but

MySQL 5.0.67 on SMP

2008-12-15 Thread xufeng
Hi Is there a way to check if my MySQL5.0.67 works well on SMP? I have two CPUs with each two cores, and I want to know if MySQL distributes loads over the two CPUs. System OS: Linux 2.6.9-42.ELsmp MySQL Version: 5.0.67 Intel(R) Xeon(TM) CPU 3.00GHz * 2 Thank you in advance. Yours, Xu Feng

RE: MySQL 5.0.67 on SMP

2008-12-15 Thread xufeng
Hi fire9, Thank you for your reply. Do you have some official document on MySQL 5.0.67 not supporting SMP? If so, would you please give me some info on how to get the smp patches? Yours, Xu Feng From: fire9 [mailto:fire9di...@gmail.com] Sent:

Re: MySQL 5.0.67 on SMP

2008-12-15 Thread Dan Nelson
In the last episode (Dec 16), xufeng said: Is there a way to check if my MySQL5.0.67 works well on SMP? I have two CPUs with each two cores, and I want to know if MySQL distributes loads over the two CPUs. System OS: Linux 2.6.9-42.ELsmp MySQL Version: 5.0.67 Intel(R) Xeon(TM) CPU 3.00GHz *