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.00G

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: 2008年12月

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

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 S

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

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 c

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 wrote: > Am I

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 wrote: > I have a char fiel where I am keeping dates forma

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 Joh

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 proj_archive=0

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 http://dev.mysql.com/

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: http://webmeeting.dimdim