… Ya se que estás piantao, piantao, piantao…

For my lastest blog, a review of the MySQL, NoSQL and Cloud Conference, I’ll continue to use the tango metaphor. Balada para un loco (ballad for a crazy one) is a Piazzola classic and explains what I think of Santiago Lertora from Binlogic for single handedly putting together this event; he had to be piantao (slang for ‘crazy’) to pursue his vision to kick start the Open Source database community in South America into becoming as active as it is in the US and Europe. He was able to gather some renowned speakers such as our own Martin Farach-Colton, Sheeri Cabral from Mozilla, Max Mether and Massimo Brignoli from SkySQL, Colin Charles from Monty Program, Alejandro Kojima from the MySQL team at Oracle, Oracle ACE director Ronald Bradford, and many more. Among the firms attending, some …

Did you ever wonder how the big companies run things behind the scenes? Come to the MySQL Connect Conference and learn from the best. There are over seventy sessions and the following session are from MySQL customers. And please note the early registration discount window is closing!

• Sheeri Cabral — Database Scaling at Mozilla andGoogle-Hacking MySQL
• Bradley Kuszmaul Chief Architect , MIT — Solving the Challenges of Big Databases with MySQL
• Andrew Aksyonoff Sphinx Technologies Inc — Full-Text Search with MySQL and Sphinx
• Daniel Austin Chief Architect , PayPal, Inc. — Big Data Is a Big Scam (Most of the Time)
• Eric Grancher DBA , Cern — CERN’s MySQL “as a Service” Deployment with Oracle VM: Empowering Users
• VADYM TKACHENKO Percona Inc — MySQL and Solid-State Drives: Usage …

Hi,

Amazon Elastic Compute Cloud (Amazon EC2) is a web service that provides resizable compute capacity in the cloud. Amazon EC2 is known for its uptime, thereby making it the right candidate for running monitoring tools like MONyog. You cannot monitor something effectively, unless the monitoring system is available almost all the time.

We are happy to introduce pre-configured Amazon Machine Image (AMI) which runs MONyog on an Amazon Linux instance of EC2. Launching this AMI would create an EC2 instance and starts the trial version of MONyog. In short, with just a click of a button you get your favorite MySQL monitoring tool on a trusted platform that is available almost all the time. MONyog can monitor MySQL servers running on Amazon RDS, Amazon EC2 or any other remote machine.

Additionally, popular cloud database services like …

I’ve had a talk accepted for the MySQL Connect conference, in San Francisco at the end of September. I’ll be talking about Profiling with Performance Schema.

Here’s the abstract:

The Performance Schema feature was introduced in MySQL 5.5 and has been greatly enhanced within the coming 5.6 release. It exposes a new wealth of instrumentation, to DBAs and developers alike, that enable you to find answers to many of the questions that have been impossible, or more difficult than necessary, to answer in the past. Come to this session to learn how to set up and use Performance Schema to perform everyday profiling and performance monitoring tasks, such as finding problem queries; researching blocked hosts; profiling I/O usage; analyzing resource usage by schema, table, or user; or tracing a session to see exactly where it spends its …

Well seeing as I'm going to open this blog up again I figured I better come in and have a little clean up. Checking the comments it was obvious that most of the 1000+ comments were some form of spam so I decided that I'd clear then all out, including the good ones, sorry about that but I didn't have the time to read each one and decide what was worth keeping.

It seems that the blog still gets a number of visitors even though it's not been updated in some considerable time. It's linked from a number of significant places and still rates reasonably well in Google.

In the next few days I'll be writing something about my new Raspberry Pi computer, including setting up MySQL.

Are you tired of manually generating test data for your MySQL tables? If you’re looking for random data generator, look no further! Introducing the MySQL Random Data Generator, a powerful…

The post How To Generate Random test Data In MySQL first appeared on Change Is Inevitable.

Originally way to handle warnings and errors in MySQL stored routine was designed as follows:

• 
  
• if warning was generated during stored routine execution which has a handler for such a warning/error, MySQL remembered the handler, ignored the warning and continued execution
  
• after routine is executed MySQL checked if there is a remembered handler and activated if any
  
  

This logic was not ideal and causes several problems, particularly:

• 
  
• it was not possible to choose right handler for an instruction which generated several warnings or errors, because only first one was chosen
  
• handling conditions in current scope messed with conditions in different
  
• there were no generated warning/errors in Diagnostic Area that is against SQL Standard.
  
  
…

I’ve been updating my (sadly very very neglected, and hacked) blog recently, and along with the new look and feel, have put together a new page for ps_helper (a schema of helper views and procedures for analyzing MySQL’s Performance Schema data):

http://www.markleith.co.uk/ps_helper/

I’ve also updated it with the things that I’ve talked about recently (including my last post on Statement Digests), and put together a couple of version specific scripts, that can be used against 5.5 or the new 5.6 versions.

Each view or procedure now has examples, and their source individually listed too, so that you can see the benefits that you may get from …

MySQL 5.6.5 was released recently, with many a great blog written by various developers involved in making it such an awesome …

MySQL Connect is taking place on September 29 and 30 in San Francisco. The early bird discount enabling you to save US$ 500 is only running for a few more days, until July 13.

Are you still wondering if you should sign up? Here are 10 reasons why you definitely should:

• Learn from other companies how they tackled similar challenges to the ones you’re facing. Find out what they learned along the way, and how you can save time, money and a lot of troubles by avoiding repeating the same mistakes and applying the best practices they’ve developed. You’ll get the chance to hear from organizations including PayPal, Verizon, Twitter, Facebook, Ticketmaster, Ning, Mozilla, CERN, Yahoo! …