Search Results for: min

How people are using MySQL… from 1 user to 100 million (upcoming conference talk)

MySQL can be deployed in several ways, and that means you can choose a tailor-made path that best meets your needs. With simple services or development systems, many people are using a single server with some backups configured, and then simply take the downtime when a restore is needed. As the application evolves, additional requirements […]

Percona MySQL University coming to Toronto this Friday!

Percona MySQL University, Toronto is taking place this Friday and I’m very excited about this event because it is a special opportunity to fit a phenomenal number of specific and focused MySQL technical talks all into one day, for free. Over the course of the day we will cover some of the hottest topics in the MySQL […]

Reminder: Speaking at MySQL Meetups in Charlotte and Atlanta today and tomorrow.

In a few hours I’m leaving for my “SouthEast Meetup Tour” first going to Charlotte where I’m speaking Today, Jan 14, about MySQL Indexing: Best practices on local MySQL Meetup and then going to Atlanta to give the same talk on Atlanta MySQL Meetup Jan 15th. If you’re in the area please come by, I’ll […]

Minimizing Downtime from Lengthy AWS Outages

Well, it happened again…  Another lengthy EBS outage in the US-East region impacted several sites across the net.  While failures like this are rare, they can be quite costly and translate into headaches for the operations team when impact production systems for any length of time.  At Percona, we routinely help clients architect and deploy […]

Upcoming webinar on PRM

Just a reminder that Wednesday the 26th at 10am Pacific time, I’ll give a webinar on PRM, the Percona replication manager. During the webinar, I’ll walk you through the setup of a PRM cluster and show you how to perform some basic management tasks. If you are interested, click here to register. See you Wednesday! […]

When is MIN(DATE) != MIN(DATE) ?

Inspiration for this post is courtesy of a friend and former colleague of mine, Greg Youngblood, who pinged me last week with an interesting MySQL puzzle. He was running Percona Server 5.5.21 with a table structure that looks something like this:

When he ran this query:

The result came back as 2012-06-22 10:28:16. […]