MySQL University session on December 18: Using DTrace with MySQL
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.com/portal/JoinForm.action?confKey=mysqluniversity You can bookmark this address, since it will remain valid for all future MySQL University sessions. Remember, though, that the meeting room will open only 15 minutes before the session starts. MySQL University is an educational program run virtually on the 'net. Sessions are open to anyone. MySQL University focuses on MySQL internals and on Sun technology that can be used in connection with MySQL, but we're open to hear your suggestions for other topics. Related URLs: - http://forge.mysql.com/wiki/Using_DTrace_with_MySQL - http://forge.mysql.com/wiki/MySQL_University That concludes the series of MySQL University sessions for this calendar year. Have a great Christmas season/winter break, everyone! In January, we'll likely continue with a set of sessions on performance and scalabilty – straight from the Sun QA labs. Find the tentative 2009 schedule on the MySQL University home page. Cheers, Stefan -- *** Sun Microsystems GmbHStefan Hinz Sonnenallee 1Manager Documentation, Database Group 85551 Kirchheim-Heimstetten Phone: +49-30-82702940 Germany Fax: +49-30-82702941 http://www.sun.de/mysql mailto: stefan.h...@sun.com Amtsgericht Muenchen: HRB161028 Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Windows source distribution
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/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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Help with query
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 AND (proj_adv_date = '2008-01-01' AND proj_adv_date '2008-12-16') order by proj_type, proj_adv_date, proj_bid_date, proj_name ASC; +-+---+ | proj_id | proj_adv_date | +-+---+ | 181 | 2008-11-25| | 217 | 2008-10-27| | 136 | 2008-12-01| | 219 | 2008-12-08| | 225 | 2008-12-11| +-+---+ 5 rows in set (0.00 sec) I get only 5 records returned but if I do this query: SELECT COUNT(*) FROM proj where proj_archive=0 AND (proj_adv_date '2008-01-01') order by proj_type, proj_adv_date, proj_bid_date, proj_name ASC; +-+---+ | proj_id | proj_adv_date | +-+---+ | 181 | 2008-11-25| | 221 | 2008-12-23| | 108 | 2009-01-00| | 173 | 2009-03-00| | 149 | 2009-10-00| | 143 | 2009-7-00 | | 179 | 2010-04-00| | 217 | 2008-10-27| | 136 | 2008-12-01| | 219 | 2008-12-08| | 225 | 2008-12-11| | 187 | 2009-01-00| | 199 | 2009-01-01| | 177 | 2009-02-01| | 69 | 2009-03-00| | 70 | 2009-03-00| | 71 | 2009-03-00| | 142 | 2009-03-00| | 122 | 2009-04-00| | 124 | 2009-04-00| | 207 | 2009-04-01| | 72 | 2009-07-00| | 73 | 2009-07-00| | 82 | 2009-07-00| | 209 | 2009-10-01| | 211 | 2009-10-01| | 213 | 2010-03-01| +-+---+ 27 rows in set (0.00 sec) thanks, Rotsen :-)
Re: Help with query
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 John Daisley Email: john.dais...@butterflysystems.co.uk Mobile: 07816 815424 MySQL Certified Database Administrator (CMDBA) MySQL Certified Developer (CMDEV) MySQL Certified Associate (CMA) Comptia A+ Certified Professional IT Technician On Mon, 2008-12-15 at 09:12 -0800, Néstor wrote: 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 AND (proj_adv_date = '2008-01-01' AND proj_adv_date '2008-12-16') order by proj_type, proj_adv_date, proj_bid_date, proj_name ASC; +-+---+ | proj_id | proj_adv_date | +-+---+ | 181 | 2008-11-25| | 217 | 2008-10-27| | 136 | 2008-12-01| | 219 | 2008-12-08| | 225 | 2008-12-11| +-+---+ 5 rows in set (0.00 sec) I get only 5 records returned but if I do this query: SELECT COUNT(*) FROM proj where proj_archive=0 AND (proj_adv_date '2008-01-01') order by proj_type, proj_adv_date, proj_bid_date, proj_name ASC; +-+---+ | proj_id | proj_adv_date | +-+---+ | 181 | 2008-11-25| | 221 | 2008-12-23| | 108 | 2009-01-00| | 173 | 2009-03-00| | 149 | 2009-10-00| | 143 | 2009-7-00 | | 179 | 2010-04-00| | 217 | 2008-10-27| | 136 | 2008-12-01| | 219 | 2008-12-08| | 225 | 2008-12-11| | 187 | 2009-01-00| | 199 | 2009-01-01| | 177 | 2009-02-01| | 69 | 2009-03-00| | 70 | 2009-03-00| | 71 | 2009-03-00| | 142 | 2009-03-00| | 122 | 2009-04-00| | 124 | 2009-04-00| | 207 | 2009-04-01| | 72 | 2009-07-00| | 73 | 2009-07-00| | 82 | 2009-07-00| | 209 | 2009-10-01| | 211 | 2009-10-01| | 213 | 2010-03-01| +-+---+ 27 rows in set (0.00 sec) thanks, Rotsen :-) __ This email has been scanned by Netintelligence http://www.netintelligence.com/email
Re: Help with query
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 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 AND (proj_adv_date = '2008-01-01' AND proj_adv_date '2008-12-16') order by proj_type, proj_adv_date, proj_bid_date, proj_name ASC; +-+---+ | proj_id | proj_adv_date | +-+---+ | 181 | 2008-11-25| | 217 | 2008-10-27| | 136 | 2008-12-01| | 219 | 2008-12-08| | 225 | 2008-12-11| +-+---+ 5 rows in set (0.00 sec) I get only 5 records returned but if I do this query: SELECT COUNT(*) FROM proj where proj_archive=0 AND (proj_adv_date '2008-01-01') order by proj_type, proj_adv_date, proj_bid_date, proj_name ASC; +-+---+ | proj_id | proj_adv_date | +-+---+ | 181 | 2008-11-25| | 221 | 2008-12-23| | 108 | 2009-01-00| | 173 | 2009-03-00| | 149 | 2009-10-00| | 143 | 2009-7-00 | | 179 | 2010-04-00| | 217 | 2008-10-27| | 136 | 2008-12-01| | 219 | 2008-12-08| | 225 | 2008-12-11| | 187 | 2009-01-00| | 199 | 2009-01-01| | 177 | 2009-02-01| | 69 | 2009-03-00| | 70 | 2009-03-00| | 71 | 2009-03-00| | 142 | 2009-03-00| | 122 | 2009-04-00| | 124 | 2009-04-00| | 207 | 2009-04-01| | 72 | 2009-07-00| | 73 | 2009-07-00| | 82 | 2009-07-00| | 209 | 2009-10-01| | 211 | 2009-10-01| | 213 | 2010-03-01| +-+---+ 27 rows in set (0.00 sec) thanks, Rotsen :-) -- Distributed Computing stats http://stats.free-dc.org
Re: Help with query
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 freedc@gmail.com wrote: 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 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 AND (proj_adv_date = '2008-01-01' AND proj_adv_date '2008-12-16') order by proj_type, proj_adv_date, proj_bid_date, proj_name ASC; +-+---+ | proj_id | proj_adv_date | +-+---+ | 181 | 2008-11-25| | 217 | 2008-10-27| | 136 | 2008-12-01| | 219 | 2008-12-08| | 225 | 2008-12-11| +-+---+ 5 rows in set (0.00 sec) I get only 5 records returned but if I do this query: SELECT COUNT(*) FROM proj where proj_archive=0 AND (proj_adv_date '2008-01-01') order by proj_type, proj_adv_date, proj_bid_date, proj_name ASC; +-+---+ | proj_id | proj_adv_date | +-+---+ | 181 | 2008-11-25| | 221 | 2008-12-23| | 108 | 2009-01-00| | 173 | 2009-03-00| | 149 | 2009-10-00| | 143 | 2009-7-00 | | 179 | 2010-04-00| | 217 | 2008-10-27| | 136 | 2008-12-01| | 219 | 2008-12-08| | 225 | 2008-12-11| | 187 | 2009-01-00| | 199 | 2009-01-01| | 177 | 2009-02-01| | 69 | 2009-03-00| | 70 | 2009-03-00| | 71 | 2009-03-00| | 142 | 2009-03-00| | 122 | 2009-04-00| | 124 | 2009-04-00| | 207 | 2009-04-01| | 72 | 2009-07-00| | 73 | 2009-07-00| | 82 | 2009-07-00| | 209 | 2009-10-01| | 211 | 2009-10-01| | 213 | 2010-03-01| +-+---+ 27 rows in set (0.00 sec) thanks, Rotsen :-) -- Distributed Computing stats http://stats.free-dc.org
Re: Windows source distribution
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 code to me. I think you're just not finding the build instructions, or not understanding them. The zip file contains just one top-level directory, mysql-5.0.67. Inside that is a file called INSTALL-WIN-SOURCE. Read it, ignoring the claims that you should find .sln files within the package; it's clearly outdated information. You will probably need to get cmake from somewhere to generate the .sln and .vcproj files. At that point, building MySQL should be straightforward. Getting it to find the openssl libraries, as discussed on the other list, is another question... I've not done this myself, just reporting on what I've figured out in a few minutes' poking around. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Windows source distribution
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 looks like the source code to me. I think you're just not finding the build instructions, or not understanding them. No, I am not finding the VC++ .sln files as explained in the MySql reference manual section 2.4.15.6.2. Building MySQL from a Windows Source Distribution. The zip file contains just one top-level directory, mysql-5.0.67. Inside that is a file called INSTALL-WIN-SOURCE. Read it, ignoring the claims that you should find .sln files within the package; it's clearly outdated information. You will probably need to get cmake from somewhere to generate the .sln and .vcproj files. At that point, building MySQL should be straightforward. Essentially then the entire 2.4.15.6.2* *section in the MySql reference is just obsolete and the reference manual never was updated to reflect that. In fact what you are saying is that in 2.4.15.6, where it says: There are three solutions available for building from the source code on Windows: * Build from the standard MySQL source distribution. For this you will need CMake and Visual C++ Express Edition or Visual Studio. Using this method you can select the storage engines that are included in your build. To use this method, see Section 2.4.15.6.1, “Building MySQL from the Standard Source Distribution” ch02s04.html#windows-source-build-cmake. * Build from the MySQL Windows source distribution. The Windows source distribution includes ready-made Visual Studio solution files that enable support for all storage engines (except |NDB|). To build using using method you only need Visual C++ Express Edition or Visual Studio. To use this method, see Section 2.4.15.6.2, “Building MySQL from a Windows Source Distribution” ch02s04.html#windows-vc-plus-plus-build. * Build directly from the BitKeeper source repository. For this you will need CMake, Visual C++ Express Edition or Visual Studio, and |bison|. For this method you need to create the distribution on a Unix system and then copy the generated files to your Windows build environment. To use this method, see Section 2.4.15.6.5, “Creating a Windows Source Package from the BitKeeper Repository” ch02s04.html#windows-bitkeeper-build. that the middle way does not really exist. Getting it to find the openssl libraries, as discussed on the other list, is another question... I've not done this myself, just reporting on what I've figured out in a few minutes' poking around. I guess I actually believed the docs. Thanks for telling me that they are just plain wrong. I will follow the INSTALL-WIN-SOURCE file and just ignore the reference manual in this situation. But really the docs should be corrected so that others do not attempt to follow the incorrect path it outlines in 2.4.15.6.2 ch02s04.html#windows-vc-plus-plus-build. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Building MySql for Windows with SSL
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 SSL is not among them. How then can I build MySql for Windows with SSL support ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL 5.0.67 on SMP
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: MySQL 5.0.67 on SMP
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月16日 11:54 To: xufeng Subject: Re: MySQL 5.0.67 on SMP hi, I think the version is not support SMP.You may use smp patches in this version. 在 2008-12-16，上午11:44， 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=fire9di...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL 5.0.67 on SMP
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 * 2
The easiest way to check would be to run top, then run a long-running
CPU-hungry query like
SELECT BENCHMARK(1,ENCODE('hello','goodbye'));
from two separate mysql client sessions. You should see two CPUs worth
of load on the system at that point.
In fact, any version of mysql should scale to multiple CPUs as long as
your OS supports kernel-based threads (most do). Note that a single
query will always only use one CPU, so you need multiple queries in
parallel to use more.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
