Event feature already working in Server 5.1.37

------=_NextPart_000_001A_01CA9CAF.B6877160
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi,



I just wanted to remark, that the Event feature is already working in server
version 5.1.37 (installed on Debian).



In tech resources is mentioned that this feature would be available since
version 5.1.6 (see
http://dev.mysql.com/tech-resources/articles/event-feature.h tml). So I
wanted to give up using it- but fortunately I tried it on my 5.1.37 server
and it works fine..



So I you have a MySQL server version prior 5.1.6 an need the Event feature -
I suggest just give it a try .



Friendly



Philipp Maske

Software Developer



Dipl.-Oec. Philipp Maske

Location Bretagne

Maske & Maske GbR Ferienhausvermittlung

Am Wasserturm 13

31303 Burgdorf b. Hannover

Deutschland / Allemagne



Email: info@location-bretagne.de

WWW: www.location-bretagne.de

Mobile: +49 (0)172 4523977

OpenBC:
http://www.openbc.com/hp/Philipp_Maske


------=_NextPart_000_001A_01CA9CAF.B6877160--

RE: Event feature already working in Server 5.1.37

I don't "get it"... I mean, I get the concept -- it's a crontab; but why
would someone opt to put these events here instead of in the God-given
CRONTAB as everything else in the system uses? This just seems like one
more place to forget about a query/code and have "unexpected" things
happen.

We already have a plethora of 'cron-like' tools:

* at
* /etc/crontab
* /var/spool/crontabs/root
* /var/spool/crontabs/joeblow
* /etc/cron.d/
* /etc/cron.daily/
* /etc/cron.hourly/
* /etc/cron.monthly/

Unless I'm missing some killer functionality this provides (and from that
URL, I'm not seeing any), then I wish the Sun/mySQL team would have spent
their precious time on more pressing features and or bug-fixes such as this
one that is now FOUR YEARS old... (that is erroneously marked as 'feature
request'!)

http://bugs.mysql.com/bug.php?id=21641
http://bugs.mysql.com/bug.php?id=21641



> -----Original Message-----
> From: Philipp Maske [Location Bretagne]
> [mailto:philipp.maske@location-bretagne.de]
> Sent: Saturday, January 23, 2010 7:43 PM
> To: mysql@lists.mysql.com
> Subject: Event feature already working in Server 5.1.37
>
> Hi,
>
>
>
> I just wanted to remark, that the Event feature is already
> working in server
> version 5.1.37 (installed on Debian).
>
>
>
> In tech resources is mentioned that this feature would be
> available since
> version 5.1.6 (see
> http://dev.mysql.com/tech-resources/articles/event-feature.h tml). So I
> wanted to give up using it- but fortunately I tried it on my
> 5.1.37 server
> and it works fine..
>
>
>
> So I you have a MySQL server version prior 5.1.6 an need the
> Event feature -
> I suggest just give it a try .
>
>
>
> Friendly
>
>
>
> Philipp Maske
>
> Software Developer
>
>
>
> Dipl.-Oec. Philipp Maske
>
> Location Bretagne
>
> Maske & Maske GbR Ferienhausvermittlung
>
> Am Wasserturm 13
>
> 31303 Burgdorf b. Hannover
>
> Deutschland / Allemagne
>
>
>
> Email: info@location-bretagne.de
>
> WWW: www.location-bretagne.de
>
> Mobile: +49 (0)172 4523977
>
> OpenBC:
> http://www.openbc.com/hp/Philipp_Maske
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Event feature already working in Server 5.1.37

In the last episode (Jan 25), Daevid Vincent said:
> I don't "get it"... I mean, I get the concept -- it's a crontab; but why
> would someone opt to put these events here instead of in the God-given
> CRONTAB as everything else in the system uses? This just seems like one
> more place to forget about a query/code and have "unexpected" things
> happen.

For a hosted environment (or a restricted corporate environment), it means
you don't have to give your users shell accounts; they can schedule table
cleanup operations, summary table refreshes, and other operations completely
within MySQL. The events will also fire the same whether the server is
running Unix or Windows.

--
Dan Nelson
dnelson@allantgroup.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Event feature already working in Server 5.1.37

Daevid, all,


Daevid Vincent wrote:
> I don't "get it"... I mean, I get the concept -- it's a crontab; bu=
t why
> would someone opt to put these events here instead of in the God-gi=
ven
> CRONTAB as everything else in the system uses? This just seems like=
one
> more place to forget about a query/code and have "unexpected" thing=
s
> happen.=20

"There's more than one way to do it."
(Perl slogan, I didn't look up the author)

>=20
> We already have a plethora of 'cron-like' tools:
>=20
> * [[...]]

Agreed - but this is Unix/Linux only (not Windows), and this multitud=
e
doesn't make things easier for people working on several systems.

IMNSHO, the question is whether you are viewing some to-be-scheduled
task an aspect of the system as a whole or rather as a database aspec=
t.
In the first case, use your system scheduler, like cron; in the latte=
r
case, it makes sense to handle it internal to the database.

The advantage of scheduling database tasks in the database is that th=
is
allows database backups and migrations to include it. If you handle t=
hat
scheduling via cron (or some other scheduler), you need to handle it =
as
a separate thing in backups and migrations.

In addition, Dan's points are of course valid ones.

>=20
> Unless I'm missing some killer functionality this provides (and fro=
m that
> URL, I'm not seeing any), then I wish the Sun/mySQL team would have=
spent
> their precious time on more pressing features and or bug-fixes [[..=
..]]

My answer above is to explain why this is seen useful by several peop=
le,
not to claim any relative priority of this and other changes.


Regards,
Jörg

--=20
Joerg Bruehe, MySQL Build Team, Joerg.Bruehe@Sun.COM
Sun Microsystems GmbH, Komturstraße 18a, D-12099 Berlin
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels
Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB1610=
28


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Event feature already working in Server 5.1.37

--005045016abd7a9b89047e0f898a
Content-Type: text/plain; charset=ISO-8859-1

On Tue, Jan 26, 2010 at 12:21 AM, Daevid Vincent wrote:

>
> * at
> * /etc/crontab
> * /var/spool/crontabs/root
> * /var/spool/crontabs/joeblow
> * /etc/cron.d/
> * /etc/cron.daily/
> * /etc/cron.hourly/
> * /etc/cron.monthly/
>

That entire list represents exactly two tools: at and crontab. Allright,
three if you wanna be anal about it: anacron. At and Cron are also different
tools: at does one-time scheduling, while cron handled repeated scheduling.



> Unless I'm missing some killer functionality this provides (and from that
> URL, I'm not seeing any), then I wish the Sun/mySQL team would have spent
> their precious time on more pressing features and or bug-fixes such as this
> one that is now FOUR YEARS old... (that is erroneously marked as 'feature
> request'!)
>

Except for the very very very useful "is automagically included in backup
(and possibly replication)" that Joerg already mentioned (that was the
second thing I thought of), there is also the ability to schedule by the
second, whereas cron can only schedule by the minute, and at doesn't handle
repeating events.

Yes, I can definitely see the use in this. If you can't, then just ignore
it.

--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--005045016abd7a9b89047e0f898a--

Re: Event feature already working in Server 5.1.37

Philipp Maske [Location Bretagne] wrote:
> Hi,
>
>
>
> I just wanted to remark, that the Event feature is already working in server
> version 5.1.37 (installed on Debian).
>
>
>
> In tech resources is mentioned that this feature would be available since
> version 5.1.6 (see
> http://dev.mysql.com/tech-resources/articles/event-feature.h tml). So I
> wanted to give up using it- but fortunately I tried it on my 5.1.37 server
> and it works fine..
>
>
>
> So I you have a MySQL server version prior 5.1.6 an need the Event feature -
> I suggest just give it a try .

Perhaps you are confused by the numbering sequence? Version 5.1.37 is 29
releases *later* than 5.1.6 .

Those versions prior to 5.1.6 (the ones that would not have this
feature) would be 5.1.0, 5.1.1, 5.1.2, 5.1.3, 5.1.4, and 5.1.5 .

Sorry for the confusion.

--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Event feature already working in Server 5.1.37

> -----Original Message-----
> From: Dan Nelson [mailto:dnelson@allantgroup.com]
> Sent: Monday, January 25, 2010 11:42 PM
> To: Daevid Vincent
>
> For a hosted environment (or a restricted corporate
> environment), it means you don't have to give your users
> shell accounts; they can schedule table
> cleanup operations, summary table refreshes, and other
> operations completely within MySQL.

Fair enough. I can't imagine a host these days that doesn't give you a
dedicated VM sandbox though. There are hosts out there that put all the
fish in the same pond?! Wow. I certainly wouldn't trust that scenario with
my data/site.

> The events will also fire the same whether the
> server is running Unix or Windows.

People really use Windows for a mySQL server? Weird.

It just seems so clunky. Don't get me wrong. I love XP. I run it on all my
12+ notebooks, netbooks, desktops, etc. But for any LAMP dev work, I either
have a dedicated Linux box setup or a Virtual Machine.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Event feature already working in Server 5.1.37

-----Original Message-----
From: Daevid Vincent
Sent: 26 January 2010 21:50
To: dnelson@allantgroup.com
Cc: mysql@lists.mysql.com
Subject: RE: Event feature already working in Server 5.1.37


> People really use Windows for a mySQL server? Weird.


I'm seem to remember reading somewhere that Windows is currently the most p=
opular platform for MySQL!=20


> It just seems so clunky. Don't get me wrong. I love XP. I run it on all m=
y
12+ notebooks, netbooks, desktops, etc. But for any LAMP dev work, I eithe=
r
have a dedicated Linux box setup or a Virtual Machine.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:  =A0 http://lists.mysql.com/mysql?unsub=3Djohn.daisley=
@butterflysystems.co.uk



===================3D

John Daisley

MySQL 5.0 Certified Database Administrator (CMDBA)
MySQL 5.0 Certified Developer
Cognos BI Developer

Telephone: +44(0)1283 537111
Mobile: +44(0)7812 451238
Email: john.daisley@butterflysystems.co.uk

===================3D

Sent via HP IPAQ mobile device

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Event feature already working in Server 5.1.37

Daevid Vincent wrote:
>> -----Original Message-----
>> From: Dan Nelson [mailto:dnelson@allantgroup.com]
>> Sent: Monday, January 25, 2010 11:42 PM
>> To: Daevid Vincent
>>
>> ...snipped ...
> People really use Windows for a mySQL server? Weird.
>
....

Yes, they do.

Not only is MySQL as cheap as the free version of MS SQL but it doesn't
suffer from the hard limits the free version of MS SQL imposes and it
works across all of your servers, regardless of platform. MS products
are limited to Windows boxes. You cannot assemble a new Linux box and
get MS-anything to run on it natively.

With C, C++, .NET, JAVA, and ODBC connection options available, it's
very easy to make a connection to MySQL from practically any MS
development language.

Some connectors will even integrate themselves into Visual Studio.

Windows, as foreign as it may seem, is actually a very viable MySQL
development platform. I encourage you to try it out and let us know what
you think.

--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Event feature already working in Server 5.1.37

--0016e6db2b1ccf0114047e2265c2
Content-Type: text/plain; charset=ISO-8859-1

Hi friends,

This isn't rarelly to see...its common on these days.
Get this: http://dev.mysql.com/tech-resources/articles/mysql_on_window s.html

WB

2010/1/27 Shawn Green

> Daevid Vincent wrote:
>
>> -----Original Message-----
>>> From: Dan Nelson [mailto:dnelson@allantgroup.com] Sent: Monday, January
>>> 25, 2010 11:42 PM
>>> To: Daevid Vincent
>>>
>>> ...snipped ...
>>>
>> People really use Windows for a mySQL server? Weird.
>>
>> ...
>
> Yes, they do.
>
> Not only is MySQL as cheap as the free version of MS SQL but it doesn't
> suffer from the hard limits the free version of MS SQL imposes and it works
> across all of your servers, regardless of platform. MS products are limited
> to Windows boxes. You cannot assemble a new Linux box and get MS-anything to
> run on it natively.
>
> With C, C++, .NET, JAVA, and ODBC connection options available, it's very
> easy to make a connection to MySQL from practically any MS development
> language.
>
> Some connectors will even integrate themselves into Visual Studio.
>
> Windows, as foreign as it may seem, is actually a very viable MySQL
> development platform. I encourage you to try it out and let us know what you
> think.
>
> --
> Shawn Green, MySQL Senior Support Engineer
> Sun Microsystems, Inc.
> Office: Blountville, TN
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=wagnerbianchijr@gmail.com
>
>

--0016e6db2b1ccf0114047e2265c2--

Re: Event feature already working in Server 5.1.37

--001636d3448dcdcd77047e228653
Content-Type: text/plain; charset=ISO-8859-1

On Tue, Jan 26, 2010 at 10:43 PM, Daevid Vincent wrote:

> 12+ notebooks, netbooks, desktops, etc. But for any LAMP dev work, I either
> have a dedicated Linux box setup or a Virtual Machine.
>

Well... It wouldn't be *Linux*-Apache-Mysql-PHP otherwise, would it :-)


--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--001636d3448dcdcd77047e228653--

Re: Event feature already working in Server 5.1.37

Johan De Meersman wrote:
> On Tue, Jan 26, 2010 at 10:43 PM, Daevid Vincent wrote:
>
>> 12+ notebooks, netbooks, desktops, etc. But for any LAMP dev work, I either
>> have a dedicated Linux box setup or a Virtual Machine.
>>
>
> Well... It wouldn't be *Linux*-Apache-Mysql-PHP otherwise, would it :-)
>
>

It would have to change to WIMP. It's not the best for marketing but we
can't win them all.

Windows - IIS - MySQL - PHP

;-)

Some other production alternatives include:

WIMA - Win, IIS, MySQL, ASP
WAMP - Win, Apache, MySQL, PHP
WWSHM - Win, Windows Scripting Host, MySQL
WTM - Win, Tomcat, MySQL
....

Are there other stacks on MS that you have heard of or are using?
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Event feature already working in Server 5.1.37

>-----Original Message-----
>From: Shawn.Green@Sun.COM [mailto:Shawn.Green@Sun.COM]
>Sent: Wednesday, January 27, 2010 12:21 AM
>To: Daevid Vincent
>Cc: 'Dan Nelson'; mysql@lists.mysql.com
>Subject: Re: Event feature already working in Server 5.1.37
>
>Daevid Vincent wrote:
>>> -----Original Message-----
>>> From: Dan Nelson [mailto:dnelson@allantgroup.com]
>>> Sent: Monday, January 25, 2010 11:42 PM
>>> To: Daevid Vincent
>>>
>>> ...snipped ...
>> People really use Windows for a mySQL server? Weird.
>>
>...
>
>Yes, they do.
>
>Not only is MySQL as cheap as the free version of MS SQL but it doesn't
>suffer from the hard limits the free version of MS SQL imposes and it
>works across all of your servers, regardless of platform. MS products
>are limited to Windows boxes. You cannot assemble a new Linux box and
>get MS-anything to run on it natively.
>
[JS] I second this. Instead of using a LAMP development environment, I went
with WAMP -- even though our production environment was LAMP. It was a lot
easier than setting up LAMP in a virtual machine. When we shut down our LAMP
site for cost reasons, I moved it to a WAMP environment that I bought off the
shelf for $800. For that money I got 8GB of RAM, four cores, and a RAID
controller. Another $90 for a second drive, and I've got mirroring going.

Granted, it's a low-traffic site used for internal administration; but I think
this box could handle a lot more traffic than it does. It seems to be loafing
all of the time. It's a home/SOHO/gamer system, so it probably isn't as
physically robust as a "server" grade machine at twice the price; but if it
dies, I can be up and running on a newer, bigger, cheaper machine in little
more than the time it takes me to run to the nearest big-box store.

Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com







--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Event feature already working in Server 5.1.37

In the last episode (Jan 27), Shawn Green said:
> It would have to change to WIMP. It's not the best for marketing but we
> can't win them all.
>
> Windows - IIS - MySQL - PHP
>
> ;-)
>
> Some other production alternatives include:
>
> WIMA - Win, IIS, MySQL, ASP
> WAMP - Win, Apache, MySQL, PHP
> WWSHM - Win, Windows Scripting Host, MySQL
> WTM - Win, Tomcat, MySQL
> ...
>
> Are there other stacks on MS that you have heard of or are using?

WWJD - Windows, Websphere, Java, Derby? :)


--
Dan Nelson
dnelson@allantgroup.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Event feature already working in Server 5.1.37

--0016e68ee03994c128047e289484
Content-Type: text/plain; charset=ISO-8859-1

On Wed, Jan 27, 2010 at 5:52 PM, Jerry Schwartz
wrote:

> [JS] I second this. Instead of using a LAMP development environment, I went
> with WAMP -- even though our production environment was LAMP.


Generally a bad idea - you keep running into annoying minor differences
between the systems. File paths, for example :-)


> It was a lot easier than setting up LAMP in a virtual machine.


I'll set up up in under an hour, if you want :-)


> When we shut down our LAMP
> site for cost reasons, I moved it to a WAMP environment that I bought off
> the
>

Wait. You shut down machines for cost reasons, and then go buy new ones ?


> shelf for $800. For that money I got 8GB of RAM, four cores, and a RAID
> controller. Another $90 for a second drive, and I've got mirroring going.
>
> Granted, it's a low-traffic site used for internal administration; but I
> think
> this box could handle a lot more traffic than it does. It seems to be
> loafing
> all of the time.


Oh, probably. Webserving isn't all that hard of a job, if the site is
reasonably well-designed. If you're implying that the LAMP setup you had
earlier didn't perform quite as well, though, I'll go out on a leg and say
that it probably wasn't managed very well.


> It's a home/SOHO/gamer system, so it probably isn't as
> physically robust as a "server" grade machine at twice the price; but if it
> dies, I can be up and running on a newer, bigger, cheaper machine in little
> more than the time it takes me to run to the nearest big-box store.
>

True. Me and my server grade machine, however, will not have had that
downtime, because I'll have been notified that a redundant component has
failed, and will have replaced it while the machine was running.

It's ultimately a matter of how much your uptime is worth to you, and keep
in mind that on a saturday evening you may not even find a new machine until
monday morning, and then you still have to start installing everything, not
to mention find the latest backups of your data.

Me, I'll go for the expensive server ones for my professional needs, thanks
:-)



--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--0016e68ee03994c128047e289484--

Re: Event feature already working in Server 5.1.37

--001636cd73c748da46047e289949
Content-Type: text/plain; charset=ISO-8859-1

On Wed, Jan 27, 2010 at 6:10 PM, Dan Nelson wrote:

>
> WWJD - Windows, Websphere, Java, Derby? :)
>

You are an evil, *evil* little man. I just spilled juice all over my
keyboard.



--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--001636cd73c748da46047e289949--

WAMP vs LAMP

------=_NextPart_000_0001_01CAA003.6F027AE0
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable

=20

From: vegivamp@gmail.com [mailto:vegivamp@gmail.com] On Behalf Of Johan =
De Meersman
Sent: Wednesday, January 27, 2010 12:18 PM
To: Jerry Schwartz
Cc: Shawn.Green@sun.com; Daevid Vincent; Dan Nelson; =
mysql@lists.mysql.com
Subject: Re: Event feature already working in Server 5.1.37

=20

=20

On Wed, Jan 27, 2010 at 5:52 PM, Jerry Schwartz =
wrote:

[JS] I second this. Instead of using a LAMP development environment, I =
went
with WAMP -- even though our production environment was LAMP.=20


Generally a bad idea - you keep running into annoying minor differences =
between the systems. File paths, for example :-)



[JS] The file paths were all the same, actually, and the address for =
MySQL is just â€=9Clocalhostâ€=9D.

=20

Iâ€=99ve only run into one incompatibility, and that one bit me =
yesterday: On Windows, the PHP rand() function has a native range of 1 =
â€=93 32767. I replaced that with a call to mt_rand(), and =
allâ€=99s right with the world. (Why are we using random numbers? It =
would take a psychiatric evaluation of my predecessor to determine =
that.)

=20

It was a lot easier than setting up LAMP in a virtual machine.=20


I'll set up up in under an hour, if you want :-)



[JS] Iâ€=99m sure you could. I actually did, before deciding that it =
wasnâ€=99t worth it what with the port forwarding and all.

=20

When we shut down our LAMP
site for cost reasons, I moved it to a WAMP environment that I bought =
off the


Wait. You shut down machines for cost reasons, and then go buy new ones =
?
=20

[JS] The one we shut down was externally hosted, and had =
customer-accessible information on it. When management decided to =
consolidate our customer-accessible sites in Japan, there was no reason =
to have our administrative stuff hosted externally.

=20

shelf for $800. For that money I got 8GB of RAM, four cores, and a RAID
controller. Another $90 for a second drive, and I've got mirroring =
going.

Granted, it's a low-traffic site used for internal administration; but I =
think
this box could handle a lot more traffic than it does. It seems to be =
loafing
all of the time.=20


Oh, probably. Webserving isn't all that hard of a job, if the site is =
reasonably well-designed. If you're implying that the LAMP setup you had =
earlier didn't perform quite as well, though, I'll go out on a leg and =
say that it probably wasn't managed very well.
=20

[JS] It was fine.

=20

It's a home/SOHO/gamer system, so it probably isn't as
physically robust as a "server" grade machine at twice the price; but if =
it
dies, I can be up and running on a newer, bigger, cheaper machine in =
little
more than the time it takes me to run to the nearest big-box store.


True. Me and my server grade machine, however, will not have had that =
downtime, because I'll have been notified that a redundant component has =
failed, and will have replaced it while the machine was running.

It's ultimately a matter of how much your uptime is worth to you, and =
keep in mind that on a saturday evening you may not even find a new =
machine until monday morning, and then you still have to start =
installing everything, not to mention find the latest backups of your =
data.

Me, I'll go for the expensive server ones for my professional needs, =
thanks :-)



[JS] Since this is used internally by a relatively small number of =
people, the cost of downtime is mostly my embarrassment. Our stores are =
open on Sundays. The ones who would scream are the two in our Tokyo =
office who use it for a few minutes when they come in. Thereâ€=99s =
nothing I can do about that.

=20

=20

Regards,

=20

Jerry Schwartz

The Infoshop by Global Information Incorporated

195 Farmington Ave.

Farmington, CT 06032

=20

860.674.8796 / FAX: 860.674.8341

=20

www.the-infoshop.com

=20

=20

=20

=20


--=20
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel


------=_NextPart_000_0001_01CAA003.6F027AE0--

RE: WAMP vs LAMP

------=_NextPart_000_0001_01CAA0C7.52D160B0
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable

From: Wagner Bianchi [mailto:wagnerbianchijr@gmail.com]=20
Sent: Thursday, January 28, 2010 2:03 PM
To: Jerry Schwartz
Subject: Re: WAMP vs LAMP

=20

[JS] The file paths were all the same, actually, and the address for =
MySQL is just â€=9Clocalhostâ€=9D.

[WB]Consider to use MySQL on Unix like environment because the socket =
file. This way you will get more performance then use TCP/IP on MS =
Windows.

=20

[JS] Thatâ€=99s an interesting suggestion. Windows has socket files, =
but Iâ€=99ve never looked at them. In fact, I donâ€=99t even =
know if MySQL can us a socket file and TCP/IP at the same time. =
Weâ€=99re going to have more ODBC traffic than web traffic, I =
expect.

=20

Regards,

=20

Jerry Schwartz

The Infoshop by Global Information Incorporated

195 Farmington Ave.

Farmington, CT 06032

=20

860.674.8796 / FAX: 860.674.8341

=20

www.the-infoshop.com

=20

=20

=20

=20

Best regards.

--
Wagner Bianchi

2010/1/28 Jerry Schwartz



From: vegivamp@gmail.com [mailto:vegivamp@gmail.com] On Behalf Of Johan =
De Meersman
Sent: Wednesday, January 27, 2010 12:18 PM
To: Jerry Schwartz
Cc: Shawn.Green@sun.com; Daevid Vincent; Dan Nelson; =
mysql@lists.mysql.com
Subject: Re: Event feature already working in Server 5.1.37





On Wed, Jan 27, 2010 at 5:52 PM, Jerry Schwartz =
wrote:

[JS] I second this. Instead of using a LAMP development environment, I =
went
with WAMP -- even though our production environment was LAMP.


Generally a bad idea - you keep running into annoying minor differences =
between the systems. File paths, for example :-)



[JS] The file paths were all the same, actually, and the address for =
MySQL is just â€=9Clocalhostâ€=9D.



Iâ€=99ve only run into one incompatibility, and that one bit me =
yesterday: On Windows, the PHP rand() function has a native range of 1 =
â€=93 32767. I replaced that with a call to mt_rand(), and =
allâ€=99s right with the world. (Why are we using random numbers? It =
would take a psychiatric evaluation of my predecessor to determine =
that.)



It was a lot easier than setting up LAMP in a virtual machine.


I'll set up up in under an hour, if you want :-)



[JS] Iâ€=99m sure you could. I actually did, before deciding that it =
wasnâ€=99t worth it what with the port forwarding and all.



When we shut down our LAMP
site for cost reasons, I moved it to a WAMP environment that I bought =
off the


Wait. You shut down machines for cost reasons, and then go buy new ones =
?


[JS] The one we shut down was externally hosted, and had =
customer-accessible information on it. When management decided to =
consolidate our customer-accessible sites in Japan, there was no reason =
to have our administrative stuff hosted externally.



shelf for $800. For that money I got 8GB of RAM, four cores, and a RAID
controller. Another $90 for a second drive, and I've got mirroring =
going.

Granted, it's a low-traffic site used for internal administration; but I =
think
this box could handle a lot more traffic than it does. It seems to be =
loafing
all of the time.


Oh, probably. Webserving isn't all that hard of a job, if the site is =
reasonably well-designed. If you're implying that the LAMP setup you had =
earlier didn't perform quite as well, though, I'll go out on a leg and =
say that it probably wasn't managed very well.


[JS] It was fine.



It's a home/SOHO/gamer system, so it probably isn't as
physically robust as a "server" grade machine at twice the price; but if =
it
dies, I can be up and running on a newer, bigger, cheaper machine in =
little
more than the time it takes me to run to the nearest big-box store.


True. Me and my server grade machine, however, will not have had that =
downtime, because I'll have been notified that a redundant component has =
failed, and will have replaced it while the machine was running.

It's ultimately a matter of how much your uptime is worth to you, and =
keep in mind that on a saturday evening you may not even find a new =
machine until monday morning, and then you still have to start =
installing everything, not to mention find the latest backups of your =
data.

Me, I'll go for the expensive server ones for my professional needs, =
thanks :-)



[JS] Since this is used internally by a relatively small number of =
people, the cost of downtime is mostly my embarrassment. Our stores are =
open on Sundays. The ones who would scream are the two in our Tokyo =
office who use it for a few minutes when they come in. Thereâ€=99s =
nothing I can do about that.





Regards,



Jerry Schwartz

The Infoshop by Global Information Incorporated

195 Farmington Ave.

Farmington, CT 06032



860.674.8796 / FAX: 860.674.8341



www.the-infoshop.com =20










--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

=20


------=_NextPart_000_0001_01CAA0C7.52D160B0--

Re: WAMP vs LAMP

--0016e6d99a2177a5fd047e557178
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

*Hi JS,*

I never see socket file on MS Windows...are you sure about it? But, the
other question is "*yes*", if you make a connection with the MySQL Server
(mysqld) using -h localhost, you will connect with the server using a socke=
t
file (linux only), but, if you make using -h 127.0.0.1, TCP/IP will be use.

*See this: *

*--protocol eneral_protocol>Value
* *Connection Protocol* *Allowable Operating Systems* TCP TCP/IP connectio=
n
to local or remote server All SOCKET Unix socket file connection to local
server *Unix only* PIPE Named-pipe connection to local or remote
server Windows
only MEMORY Shared-memory connection to local server Windows only
*Source*: http://dev.mysql.com/doc/refman/5.0/en/connecting.html
--
Wagner Bianchi


2010/1/29 Jerry Schwartz

> *From:* Wagner Bianchi [mailto:wagnerbianchijr@gmail.com]
> *Sent:* Thursday, January 28, 2010 2:03 PM
> *To:* Jerry Schwartz
> *Subject:* Re: WAMP vs LAMP
>
>
>
> [JS] The file paths were all the same, actually, and the address for MySQ=
L
> is just =93localhost=94.
>
> [WB]*Consider to use MySQL on Unix like environment because the socket
> file. This way you will get more performance then use TCP/IP on MS Window=
s
> *.
>
>
>
> *[JS] That=92s an interesting suggestion. Windows has socket files, but I=
=92ve
> never looked at them. In fact, I don=92t even know if MySQL can us a sock=
et
> file and TCP/IP at the same time. We=92re going to have more ODBC traffi=
c
> than web traffic, I expect.*
>
>
>
> Regards,
>
>
>
> Jerry Schwartz
>
> The Infoshop by Global Information Incorporated
>
> 195 Farmington Ave.
>
> Farmington, CT 06032
>
>
>
> 860.674.8796 / FAX: 860.674.8341
>
>
>
> www.the-infoshop.com
>
>
>
> * *
>
>
>
>
>
> Best regards.
>
> --
> Wagner Bianchi
>
> 2010/1/28 Jerry Schwartz
>
>
>
> From: vegivamp@gmail.com [mailto:vegivamp@gmail.com] On Behalf Of Johan D=
e
> Meersman
> Sent: Wednesday, January 27, 2010 12:18 PM
> To: Jerry Schwartz
> Cc: Shawn.Green@sun.com; Daevid Vincent; Dan Nelson; mysql@lists.mysql.co=
m
> Subject: Re: Event feature already working in Server 5.1.37
>
>
>
>
>
> On Wed, Jan 27, 2010 at 5:52 PM, Jerry Schwartz <
> jschwartz@the-infoshop.com> wrote:
>
> [JS] I second this. Instead of using a LAMP development environment, I we=
nt
> with WAMP -- even though our production environment was LAMP.
>
>
> Generally a bad idea - you keep running into annoying minor differences
> between the systems. File paths, for example :-)
>
>
>
> [JS] The file paths were all the same, actually, and the address for MySQ=
L
> is just =93localhost=94.
>
>
>
> I=92ve only run into one incompatibility, and that one bit me yesterday: =
On
> Windows, the PHP rand() function has a native range of 1 =96 32767. I rep=
laced
> that with a call to mt_rand(), and all=92s right with the world. (Why are=
we
> using random numbers? It would take a psychiatric evaluation of my
> predecessor to determine that.)
>
>
>
> It was a lot easier than setting up LAMP in a virtual machine.
>
>
> I'll set up up in under an hour, if you want :-)
>
>
>
> [JS] I=92m sure you could. I actually did, before deciding that it wasn=
=92t
> worth it what with the port forwarding and all.
>
>
>
> When we shut down our LAMP
> site for cost reasons, I moved it to a WAMP environment that I bought off
> the
>
>
> Wait. You shut down machines for cost reasons, and then go buy new ones ?
>
>
> [JS] The one we shut down was externally hosted, and had
> customer-accessible information on it. When management decided to
> consolidate our customer-accessible sites in Japan, there was no reason t=
o
> have our administrative stuff hosted externally.
>
>
>
> shelf for $800. For that money I got 8GB of RAM, four cores, and a RAID
> controller. Another $90 for a second drive, and I've got mirroring going.
>
> Granted, it's a low-traffic site used for internal administration; but I
> think
> this box could handle a lot more traffic than it does. It seems to be
> loafing
> all of the time.
>
>
> Oh, probably. Webserving isn't all that hard of a job, if the site is
> reasonably well-designed. If you're implying that the LAMP setup you had
> earlier didn't perform quite as well, though, I'll go out on a leg and sa=
y
> that it probably wasn't managed very well.
>
>
> [JS] It was fine.
>
>
>
> It's a home/SOHO/gamer system, so it probably isn't as
> physically robust as a "server" grade machine at twice the price; but if =
it
> dies, I can be up and running on a newer, bigger, cheaper machine in litt=
le
> more than the time it takes me to run to the nearest big-box store.
>
>
> True. Me and my server grade machine, however, will not have had that
> downtime, because I'll have been notified that a redundant component has
> failed, and will have replaced it while the machine was running.
>
> It's ultimately a matter of how much your uptime is worth to you, and kee=
p
> in mind that on a saturday evening you may not even find a new machine un=
til
> monday morning, and then you still have to start installing everything, n=
ot
> to mention find the latest backups of your data.
>
> Me, I'll go for the expensive server ones for my professional needs, than=
ks
> :-)
>
>
>
> [JS] Since this is used internally by a relatively small number of people=
,
> the cost of downtime is mostly my embarrassment. Our stores are open on
> Sundays. The ones who would scream are the two in our Tokyo office who us=
e
> it for a few minutes when they come in. There=92s nothing I can do about =
that.
>
>
>
>
>
> Regards,
>
>
>
> Jerry Schwartz
>
> The Infoshop by Global Information Incorporated
>
> 195 Farmington Ave.
>
> Farmington, CT 06032
>
>
>
> 860.674.8796 / FAX: 860.674.8341
>
>
>
> www.the-infoshop.com
>
>
>
>
>
>
>
>
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
>
>

--0016e6d99a2177a5fd047e557178--

Re: WAMP vs LAMP

Jerry Schwartz wrote:
> From: Wagner Bianchi [mailto:wagnerbianchijr@gmail.com]=20
> Sent: Thursday, January 28, 2010 2:03 PM
> To: Jerry Schwartz
> Subject: Re: WAMP vs LAMP
>=20
> =20
>=20
> [JS] The file paths were all the same, actually, and the address fo=
r MySQL is just â€=9Clocalhostâ€=9D.
>=20
> [WB]Consider to use MySQL on Unix like environment because the sock=
et file. This way you will get more performance then use TCP/IP on MS=
Windows.
>=20
> =20
>=20
> [JS] Thatâ€=99s an interesting suggestion. Windows has socket f=
iles, but Iâ€=99ve never looked at them. In fact, I donâ€=
=99t even know if MySQL can us a socket file and TCP/IP at the same =
time. Weâ€=99re going to have more ODBC traffic than web traffic,=
I expect.
>=20

On Windows they aren't called "sockets", they are "named pipes" and y=
es=20
you can be listening to both internal and external connections at the=
=20
same time.

--enabled-named-pipe
http://dev.mysql.com/doc/refman/4.1/en/server-options.html#o ption_mys=
qld_enable-named-pipe

When connecting locally, you have both options at your disposal
http://dev.mysql.com/doc/refman/4.1/en/connecting.html

There is even another option for Windows, --shared-memory
http://dev.mysql.com/doc/refman/4.1/en/server-options.html#o ption_mys=
qld_shared-memory

This works similar to a named pipe and if you want to enable both (pi=
pes=20
and shares) at the same time, you need to provide different names. T=
he=20
TCP/IP ports are independent and also available.

--=20
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: WAMP vs LAMP

------=_NextPart_000_0284_01CAA32F.DFD1F5F0
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable

=20

=20

Regards,

=20

Jerry Schwartz

The Infoshop by Global Information Incorporated

195 Farmington Ave.

Farmington, CT 06032

=20

860.674.8796 / FAX: 860.674.8341

=20

www.the-infoshop.com

=20

From: Wagner Bianchi [mailto:wagnerbianchijr@gmail.com]=20
Sent: Friday, January 29, 2010 5:49 PM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: WAMP vs LAMP

=20

Hi JS,

I never see socket file on MS Windows...are you sure about it? But, the =
other question is "yes", if you make a connection with the MySQL Server =
(mysqld) using -h localhost, you will connect with the server using a =
socket file (linux only), but, if you make using -h 127.0.0.1, TCP/IP =
will be use.

See this:=20


=
otocol> --protocol Value

Connection Protocol

Allowable Operating Systems


TCP

TCP/IP connection to local or remote server

All


SOCKET

Unix socket file connection to local server

Unix only


PIPE

Named-pipe connection to local or remote server

Windows only


MEMORY

Shared-memory connection to local server

Windows only


Source: http://dev.mysql.com/doc/refman/5.0/en/connecting.html=20
--
Wagner Bianchi



[JS] Perhaps I misspoke, but the basic principle is the same. On *nix, a =
socket file is an inode that is used as a handle for processes to =
â€=9Cfindâ€=9D the appropriate memory-based data. =
Thereâ€=99s no data in the file itself.

On Windows, IPC via file mapping is pretty close to the same thing. It =
is one of many IPC mechanisms that Microsoft has implemented over the =
years. It isnâ€=99t mentioned in the table above, but perhaps they =
included it under the heading of â€=9Cmemoryâ€=9D.

Windows also supports the DCE standard.

=20

2010/1/29 Jerry Schwartz

From: Wagner Bianchi [mailto:wagnerbianchijr@gmail.com]=20
Sent: Thursday, January 28, 2010 2:03 PM
To: Jerry Schwartz
Subject: Re: WAMP vs LAMP

=20

[JS] The file paths were all the same, actually, and the address for =
MySQL is just â€=9Clocalhostâ€=9D.

[WB]Consider to use MySQL on Unix like environment because the socket =
file. This way you will get more performance then use TCP/IP on MS =
Windows.

=20

[JS] Thatâ€=99s an interesting suggestion. Windows has socket files, =
but Iâ€=99ve never looked at them. In fact, I donâ€=99t even =
know if MySQL can us a socket file and TCP/IP at the same time. =
Weâ€=99re going to have more ODBC traffic than web traffic, I =
expect.

=20

Regards,

=20

Jerry Schwartz

The Infoshop by Global Information Incorporated

195 Farmington Ave.

Farmington, CT 06032

=20

860.674.8796 / FAX: 860.674.8341

=20

www.the-infoshop.com

=20

=20

=20

=20

Best regards.

--
Wagner Bianchi

2010/1/28 Jerry Schwartz



From: vegivamp@gmail.com [mailto:vegivamp@gmail.com] On Behalf Of Johan =
De Meersman
Sent: Wednesday, January 27, 2010 12:18 PM
To: Jerry Schwartz
Cc: Shawn.Green@sun.com; Daevid Vincent; Dan Nelson; =
mysql@lists.mysql.com
Subject: Re: Event feature already working in Server 5.1.37





On Wed, Jan 27, 2010 at 5:52 PM, Jerry Schwartz =
wrote:

[JS] I second this. Instead of using a LAMP development environment, I =
went
with WAMP -- even though our production environment was LAMP.


Generally a bad idea - you keep running into annoying minor differences =
between the systems. File paths, for example :-)



[JS] The file paths were all the same, actually, and the address for =
MySQL is just â€=9Clocalhostâ€=9D.



Iâ€=99ve only run into one incompatibility, and that one bit me =
yesterday: On Windows, the PHP rand() function has a native range of 1 =
â€=93 32767. I replaced that with a call to mt_rand(), and =
allâ€=99s right with the world. (Why are we using random numbers? It =
would take a psychiatric evaluation of my predecessor to determine =
that.)



It was a lot easier than setting up LAMP in a virtual machine.


I'll set up up in under an hour, if you want :-)



[JS] Iâ€=99m sure you could. I actually did, before deciding that it =
wasnâ€=99t worth it what with the port forwarding and all.



When we shut down our LAMP
site for cost reasons, I moved it to a WAMP environment that I bought =
off the


Wait. You shut down machines for cost reasons, and then go buy new ones =
?


[JS] The one we shut down was externally hosted, and had =
customer-accessible information on it. When management decided to =
consolidate our customer-accessible sites in Japan, there was no reason =
to have our administrative stuff hosted externally.



shelf for $800. For that money I got 8GB of RAM, four cores, and a RAID
controller. Another $90 for a second drive, and I've got mirroring =
going.

Granted, it's a low-traffic site used for internal administration; but I =
think
this box could handle a lot more traffic than it does. It seems to be =
loafing
all of the time.


Oh, probably. Webserving isn't all that hard of a job, if the site is =
reasonably well-designed. If you're implying that the LAMP setup you had =
earlier didn't perform quite as well, though, I'll go out on a leg and =
say that it probably wasn't managed very well.


[JS] It was fine.



It's a home/SOHO/gamer system, so it probably isn't as
physically robust as a "server" grade machine at twice the price; but if =
it
dies, I can be up and running on a newer, bigger, cheaper machine in =
little
more than the time it takes me to run to the nearest big-box store.


True. Me and my server grade machine, however, will not have had that =
downtime, because I'll have been notified that a redundant component has =
failed, and will have replaced it while the machine was running.

It's ultimately a matter of how much your uptime is worth to you, and =
keep in mind that on a saturday evening you may not even find a new =
machine until monday morning, and then you still have to start =
installing everything, not to mention find the latest backups of your =
data.

Me, I'll go for the expensive server ones for my professional needs, =
thanks :-)



[JS] Since this is used internally by a relatively small number of =
people, the cost of downtime is mostly my embarrassment. Our stores are =
open on Sundays. The ones who would scream are the two in our Tokyo =
office who use it for a few minutes when they come in. Thereâ€=99s =
nothing I can do about that.





Regards,



Jerry Schwartz

The Infoshop by Global Information Incorporated

195 Farmington Ave.

Farmington, CT 06032



860.674.8796 / FAX: 860.674.8341



www.the-infoshop.com =20










--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

=20

=20


------=_NextPart_000_0284_01CAA32F.DFD1F5F0--

RE: WAMP vs LAMP

Thanks for the clarification. As I understand it, the syntax on the client end
is to use "." as the host name.

I was using "localhost" on the LAMP configuration, and never bothered to
change it. With 7 or so web-based users, there isn't much rush.

Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com


>-----Original Message-----
>From: Shawn.Green@Sun.COM [mailto:Shawn.Green@Sun.COM]
>Sent: Monday, February 01, 2010 11:07 AM
>To: Jerry Schwartz
>Cc: 'Wagner Bianchi'; mysql@lists.mysql.com
>Subject: Re: WAMP vs LAMP
>
>Jerry Schwartz wrote:
>> From: Wagner Bianchi [mailto:wagnerbianchijr@gmail.com]
>> Sent: Thursday, January 28, 2010 2:03 PM
>> To: Jerry Schwartz
>> Subject: Re: WAMP vs LAMP
>>
>>
>>
>> [JS] The file paths were all the same, actually, and the address for MySQL
>> is
>just "localhost".
>>
>> [WB]Consider to use MySQL on Unix like environment because the socket file.
>This way you will get more performance then use TCP/IP on MS Windows.
>>
>>
>>
>> [JS] That's an interesting suggestion. Windows has socket files, but I've
>never looked at them. In fact, I don't even know if MySQL can us a socket
>file
>and TCP/IP at the same time. We're going to have more ODBC traffic than web
>traffic, I expect.
>>
>
>On Windows they aren't called "sockets", they are "named pipes" and yes
>you can be listening to both internal and external connections at the
>same time.
>
>--enabled-named-pipe
>http://dev.mysql.com/doc/refman/4.1/en/server-
>options.html#option_mysqld_enable-named-pipe
>
>When connecting locally, you have both options at your disposal
>http://dev.mysql.com/doc/refman/4.1/en/connecting.html
>
>There is even another option for Windows, --shared-memory
>http://dev.mysql.com/doc/refman/4.1/en/server-
>options.html#option_mysqld_shared-memory
>
>This works similar to a named pipe and if you want to enable both (pipes
>and shares) at the same time, you need to provide different names. The
>TCP/IP ports are independent and also available.
>
>--
>Shawn Green, MySQL Senior Support Engineer
>Sun Microsystems, Inc.
>Office: Blountville, TN
>
>
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=jschwartz@the-
>infoshop.com





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org