Find the Palomino Team at an event near you in 2013!

• NY's Effective MYSQL Group, March 2013
• NYC* Tech Day - March 2013
• Percona Live Santa Clara April, 2013
• PGCon May 2013
• Velocity June 2013

New York’s Effective MYSQL Meet up Group, March 12, 2013

As New York’s only active MYSQL meetup group, NY Effective MYSQL states its purpose is to share practical education for MySQL DBAs, Developers and Architects.  At their next meeting on March 12 at 6:30 PM, Laine Campbell, CEO & Principal of PalominoDB, …

Find the Palomino Team at an event near you in 2013!

• NY's Effective MYSQL Group, March 2013
• NYC* Tech Day - March 2013
• Percona Live Santa Clara April, 2013
• PGCon May 2013
• Velocity June 2013

New York’s Effective MYSQL Meet up Group, March 12, 2013

As New York’s only active MYSQL meetup group, NY Effective MYSQL states its purpose is to share practical education for MySQL DBAs, Developers and Architects.  At their next meeting on March 12 at 6:30 PM, Laine Campbell, CEO & …

Over at the OurSQL podcast, Gerry and I were inspired by the Percona blog post about MySQL 5.5 and 5.6 default variable values differences. We were going to do a show where we talked about that, but in researching that topic, we found there were lots (around 20 to be exact) of variables and a few features in MySQL 5.6 that are ignored, removed or deprecated.

These are variables that should be removed from your configuration so as not to cause warnings or errors. When I was writing up the show notes I realized that it was a pretty good list of variables, that anyone can just read – whether or not you are willing/able to listen to the 28-minute podcast.

So if you want to see the list of variables that are deprecated, removed and ignored, complete …

This week we discuss deprecated, removed and ignored variables in MySQL 5.6. Ear Candy is about innodb_file_per_table enabled by default, and At the Movies is "Different MySQL Forks for Different MySQL Folks".

Events
Upcoming MySQL tech tours

Open Database Camp will be part of the Northeast LinuxFest at Harvard University, Cambridge MA Saturday March 16th and Sunday March 17th, 2013. You can register and submit presentations on the opensqlcamp.org website.

…

New updates in Jet Profiler 3 include the following improvements:

• Improved multiple instance handling.
• Faster data retrieval.
• New, more efficient MySQL JDBC driver from SkySQL / MariaDB.
• Top Schemas is now available in the free version by default.
• Faster startup time.
• Bug fixes.

To read the full changelog, click here.


Comments

Ayasdi emerges. Amazon slashes DynamoDB prices. And more

For 451 Research clients: Ayasdi applies TDA, machine learning and Hadoop twist to advanced analytics bit.ly/XYG0fZ By Krishna Roy

— Matt Aslett (@maslett) March 8, 2013

For 451 Research clients: Software AG launches In-Genius take on in-memory operational intelligence bit.ly/XYFI8G

— Matt Aslett (@maslett) March 8, 2013

For 451 clients: Anaplan lands $30m to accelerate growth, sets out expansion strategy under new CEO bit.ly/YMQ6gF By Krishna Roy

— Matt Aslett (@maslett) …

Last time I wrote about memory allocators and how they can affect MySQL performance in general. This time I would like to explore this topic from a bit different angle: What impact does the number of processor cores have on different memory allocators and what difference we will see in MySQL performance in this scenario?

Let me share a conclusion first: If you have a server with more than 8 cores you should use something different than the default glibc memory allocator.
We recommend jemalloc or tcmalloc.

In my test I will use Dell R720 box(spec), Centos 6.3, upcoming Percona Server 5.5.30 and 3 allocators – stock glibc 2.13, jemalloc-3.1.0, the latest tcmalloc from svn repo. …

Here is a collection of upcoming events that are interesting to me as a MySQL user (in some cases because I’m speaking). I think some of them are must-see events. I am sure I am missing a lot of events, but some of these are only publicized in specific channels, and I wanted to mention them here to help spread the word.

Upcoming Meetups

This coming Thursday, Charlottesville’s Neon Guild tech group will co-host a Meetup with a noted Kanban expert.

I’m joining two Meetups soon to talk about building database (MySQL) applications with the Go programming language:

• Wednesday, March 13, 2013 in Charlottesville Virginia
• Tuesday, …

MySQL is deployed in 9 of the top 10 most trafficked sites on the web including Facebook, Twitter, eBay and YouTube, as well as in some of the fastest growing services such as Tumblr, Pinterest and box.com

Working with these companies has given MySQL developers, consultants and support engineers unique insight into how to design database-driven web architectures – whether deployed on-premise or in the cloud.

The MySQL Web Reference Architectures are a set of documented and repeatable best practices for building infrastructure that deliver the highest levels of scalability, agility and availability with the lowest levels of cost, risk and complexity. 

Four components common to most web and mobile properties are sized, with optimum deployment architectures for each:

• …

There are so many great blogs out there regarding Oracle, SQL Server, MySQL and various other database technologies. Keeping track of all of them is no less than a Herculean task. This Log Buffer Edition is an effort to pick few of those great blog posts to appreciate the oceans of database blogs out there.

Oracle:

Nial Litchfield recently reviewed a table with no fewer than 23 indexes on it.

Toon Koppelaars asks. And what about table constraints?

Can Oracle Database Release 2 (11.2.0.3) Properly Count Cores? No. Does It Matter All That Much? Not Really.. …