Re: Event feature already working in Server 5.1.37

[Johan De Meersman]

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

Re: Event feature already working in Server 5.1.37

[Johan De Meersman]

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

Re: Event feature already working in Server 5.1.37

[Dan Nelson]

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
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

RE: Event feature already working in Server 5.1.37

[Jerry Schwartz]

>-Original Message-
>From: shawn.gr...@sun.com [mailto:shawn.gr...@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:dnel...@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=arch...@jab.org

Re: Event feature already working in Server 5.1.37

[Shawn Green]

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=arch...@jab.org

Re: Event feature already working in Server 5.1.37

[Johan De Meersman]

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

Re: Event feature already working in Server 5.1.37

[Wagner Bianchi]

Hi friends,

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

WB

2010/1/27 Shawn Green 

> Daevid Vincent wrote:
>
>> -Original Message-
>>> From: Dan Nelson [mailto:dnel...@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=wagnerbianch...@gmail.com
>
>

Re: Event feature already working in Server 5.1.37

[Shawn Green]

Daevid Vincent wrote:

-Original Message-
From: Dan Nelson [mailto:dnel...@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=arch...@jab.org

RE: Event feature already working in Server 5.1.37

[John Daisley]

-Original Message-
From: Daevid Vincent 
Sent: 26 January 2010 21:50
To: dnel...@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 
popular platform for MySQL! 


> 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=john.dais...@butterflysystems.co.uk



===

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.dais...@butterflysystems.co.uk

===

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=arch...@jab.org

RE: Event feature already working in Server 5.1.37

[Daevid Vincent]

> -Original Message-
> From: Dan Nelson [mailto:dnel...@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=arch...@jab.org

Re: Event feature already working in Server 5.1.37

[Shawn Green]

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.html). 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=arch...@jab.org

Re: Event feature already working in Server 5.1.37

[Johan De Meersman]

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

Re: Event feature already working in Server 5.1.37

[Joerg Bruehe]

Daevid, all,


Daevid Vincent wrote:
> 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. 

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

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

Agreed - but this is Unix/Linux only (not Windows), and this multitude
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 aspect.
In the first case, use your system scheduler, like cron; in the latter
case, it makes sense to handle it internal to the database.

The advantage of scheduling database tasks in the database is that this
allows database backups and migrations to include it. If you handle that
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.

> 
> 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 [[...]]

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


Regards,
Jörg

-- 
Joerg Bruehe,  MySQL Build Team,  joerg.bru...@sun.com
Sun Microsystems GmbH,   Komturstraße 18a,   D-12099 Berlin
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels
Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Event feature already working in Server 5.1.37

[Dan Nelson]

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
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

RE: Event feature already working in Server 5.1.37

[Daevid Vincent]

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.ma...@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.html). 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:   i...@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=arch...@jab.org