Hi everyone!
Here's a video of this week's #DBHangOps:
March 27th at 12:00pm PDT (19:00 GMT) is when the next #DBHangOps is gonna go down. Check out the twitter search and hop on the google hangout to contribute some discussion! This week’s topics are:
This week we discuss new variables in MySQL 5.6. Ear Candy talks about a problem with XFS performance on a Linux kernel, and At the Movies discusses columnar databases.
@eRadical points out a correction to episode 130 - multiple InnoDB buffer pools were new in MySQL 5.5, not MySQL 5.6.
Events
Call for Papers for MySQL Connect is open! The call closes Friday, April 12th.
MySQL Connector/Net 6.5.6, a new maintenance release of our 6.5 series, has been released. This release is GA quality and is appropriate for use in production environments. Please note that 6.6 is our latest driver series and is the recommended product for development. It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)
MySQL Connector/Net 6.7.0, a new version of the all-managed .NET driver for MySQL has been released. This is the first of two alpha releases intended to introduce users to the new features in the release. This release is not feature complete and there are significant limitations but it should be stable enough for users to understand the new features and how we expect them to work. As is the case with all non-GA releases, it should not be used in any production environment. It is appropriate for use with MySQL server versions 5.0-5.6
Who has not experienced a fast growing system table space. This is related to innoDB undos (Rollback segments).
In MySQL 5.5 and in 5.6 by default undos are located in the innoDB system tablespace. Beside the space consomption issue, the second penalty is that the access to the undos generates a lot of random IOs [...]
Instant InnoDB by PACKT publishing is 83 page
book on getting a basic understanding of InnoDB. Enough of an
understanding to know what questions to ask in the future. The
book is not for intermediate or advance Innodb users. It has the
basics to get you started. Some basics covered, defining ACID, a
page on Innodb params for mySQL that run innodb as a few
examples.
Overall I think its a good book to get you started. The problem
is the book just doesn't flow. There is a section on benchmarking
with a blurb about 4 tools. This book could use more meat in
explaining what are good numbers or bad-as a result of the
benchmark and how they relate to Innodb. Also these section do
not explain what Status variables to …
Until 2.1.1-beta the functions exposed in custom rankers for handling relevancy based on term frequency and Inverse Document Frequency (IDF) did not take field or document lengths into account. In 2.1.1-beta, Sphinx includes functions that take relevance ranking to the next level. New IDF functions mysql> SELECT * FROM myindex WHERE MATCH(‘less_common more_common’) OPTION RANKER= [...]
BE sure to attend the NOWG (Norwegian Oracle Users Group) conference (on a cruise ship) this April for presentations on Powerful EXPLAIN in MySQL 5.6 by Øystein Grovlen, What’s New in MySQL Server 5.6? by Geir Hoydalsvik, MySQL Query Optimizer: an overview by Jørgen Løland, and MySQL: An Introduction for Oracle DBAs also by by Øystein Grovlen.
There are no rules for blogging. There cannot be any, because you cannot trap the wind in your hands. It’s innovation, it’s creativity, and it’s right out of the core of the technology from the bleeding edge. This Log Buffer drips into that, and brings you some of the finest posts.
Oracle:
Yes its not a fad. Big Data is the commercial supercomputing in the age of Datafication.
Tanel Poder is listing Exadata storage cells and their configuration info from V$CELL_CONFIG.
How well do you know your hints? When Jonathan asks, it stays …
[Read more]On April 3 at 10 a.m. PST, I’ll be giving a webinar titled “5 Percona Toolkit Tools for MySQL That Could Save Your Day.” In this presentation you’ll learn how to perform typical but challenging MySQL database administration tasks.
My focus will be on the following tools:
