Subject: Re: how to get production (non-debug) binaries for win32? - msg#00220
List: db.mysql.windows
I think you're mistaken. In my C:\mysql, I have several different
executables, exactly according to the following from the 4.1.1-alpha doc:
QUOTE
2.1.1.4 Selecting a Windows Server
Starting with MySQL 3.23.38, the Windows distribution includes both the
normal and the MySQL-Max server binaries. Here is a list of the different
MySQL servers from which you can choose:
Binary Description
mysqld Compiled with full debugging and automatic memory allocation
checking, symbolic links, and InnoDB and BDB tables.
mysqld-opt Optimised binary. From version 4.0 on, InnoDB is enabled.
Before 4.0, this server includes no transactional table support.
mysqld-nt Optimised binary for NT/2000/XP with support for named
pipes.
mysqld-max Optimised binary with support for symbolic links, and
InnoDB and BDB tables.
mysqld-max-nt Like mysqld-max, but compiled with support for named
pipes.
All of the preceding binaries are optimised for modern Intel processors but
should work on any Intel i386-class or higher processor.
UNQUOTE
There is more information than I have quoted here.
HTH, G.
----- Original Message -----
From: "Ben Engelsma" <bengelsm@xxxxxxx>
To: <win32@xxxxxxxxxxxxxxx>
Sent: Thursday, June 17, 2004 6:22 PM
Subject: how to get production (non-debug) binaries for win32?
>
Hi all:
>
>
The following section in the manual seems to indicate that I shouldn't
>
compile my own win32 version since a suitable binary might already
>
exist.
>
>
However, the only binaries available for win32 seem to be debug
>
versions (even the older 3.23.* versions).
>
>
My questions:
>
>
1) where can I get a non-debug version of MySQL for win32 (version
>
4.0.*)
>
2) why are there no non-debug binaries for win32 available?
>
>
Any help appreciated.
>
>
Thanks,
>
Ben
>
>
>
2.3.6 Installing MySQL from Source on Windows
>
These instructions describe how to build MySQL binaries from source for
>
versions 4.1 and above on Windows. Instructions are provided for
>
building binaries from a standard source distribution or from the
>
BitKeeper tree that contains the latest development source.
>
Note: The instructions in this document are strictly for users who want
>
to test MySQL on Windows from the latest source distribution or from the
>
BitKeeper tree. For production use, MySQL AB does not advise using a
>
MySQL server built by yourself from source. Normally, it is best to use
>
precompiled binary distributions of MySQL that are built specifically
>
for optimal performance on Windows by MySQL AB. Instructions for
>
installing a binary distributions are available at section 2.2.1
>
Installing MySQL on Windows.
>
>
--
>
MySQL Windows Mailing List
>
For list archives: http://lists.mysql.com/win32
>
To unsubscribe:
http://lists.mysql.com/win32?unsub=graeme_st_clair@xxxxxxxxxxxxxx
>
>
--
MySQL Windows Mailing List
For list archives:
http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=gcdmw-win32@xxxxxxxxxxx
Was this page helpful?
Thread at a glance:
Previous Message by Date:
click to view message preview
Re: Simple IF in query
Here you go...
select
IF(LicenseType = 'Trial', CONCAT('A Trial Version - No user limit'),
IF(LicenseType = 'Purchase', CONCAT('A Purchased Version - ', NumUsers),
'No rows found')) as Expr1
Fredrick
----- Original Message -----
From: "Greg Quinn" <greg@xxxxxxxxxxxxxx>
To: <win32@xxxxxxxxxxxxxxx>
Sent: Friday, June 18, 2004 5:37 AM
Subject: Simple IF in query
> I have a table with a few records...
>
> tblLicenses
>
> CompanyID LicenseType NumUsers
> 1 Trial 10
> 2 Purchase 25
> 3 Purchase 5
> 4 Trial 15
>
> What I need to do is return two different values based on whether the
> licensetype was a TRIAL or a PURCHASE
>
> For example
>
> IF LicenseType = Trial
> Select CONCAT('A Trial Version', '- No user limit') as Expr1
> IF LicenseType = Purchase
> Select CONCAT('A Purchased Version', '-', NumUsers) as Expr1
>
>
> How do I write a query that does this?
>
> Thanks
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
http://lists.mysql.com/win32?unsub=palmtreeFRB@xxxxxxxxxxxxx
>
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@xxxxxxxxxxx
Next Message by Date:
click to view message preview
ERROR 2013: Lost connection to MySQL server during query
I am getting an error message when my computer goes into inactivity for
several hours.
but if i press an "enter" key twice, the connection recovered.
And also, I think that it causes a database connection to the JBoss server.
is there any way not to lose a connection?
i am sure that some people have the same problem...
thanks..
_________________________________________________________________
Previous Message by Thread:
click to view message preview
how to get production (non-debug) binaries for win32?
Hi all:
The following section in the manual seems to indicate that I shouldn't
compile my own win32 version since a suitable binary might already
exist.
However, the only binaries available for win32 seem to be debug
versions (even the older 3.23.* versions).
My questions:
1) where can I get a non-debug version of MySQL for win32 (version
4.0.*)
2) why are there no non-debug binaries for win32 available?
Any help appreciated.
Thanks,
Ben
2.3.6 Installing MySQL from Source on Windows
These instructions describe how to build MySQL binaries from source for
versions 4.1 and above on Windows. Instructions are provided for
building binaries from a standard source distribution or from the
BitKeeper tree that contains the latest development source.
Note: The instructions in this document are strictly for users who want
to test MySQL on Windows from the latest source distribution or from the
BitKeeper tree. For production use, MySQL AB does not advise using a
MySQL server built by yourself from source. Normally, it is best to use
precompiled binary distributions of MySQL that are built specifically
for optimal performance on Windows by MySQL AB. Instructions for
installing a binary distributions are available at section 2.2.1
Installing MySQL on Windows.
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@xxxxxxxxxxx
Next Message by Thread:
click to view message preview
non-debug win32 binary?
Hi,
How can I get a win32 non-debug binary for production usage?
The one I downloaded says
Version: '4.0.20a-debug' socket: '' port: 3306