MySQL

Log Buffer #251, A Carnival of the Vanities for DBAs

ew Year is the time to bid farewell to the old year and welcome the coming year. It is the time to remember the golden olden blog posts. It is the time for new beginnings and new starts in life, and of course for new blog posts. Bloggers in the database arena are also enjoying the festivities with full zeal and zest and this Log Buffer Edition, which is Log Buffer #251 covers just that. Happy Holidays.

Once again about innodb-concurrency-tickets

I had to refresh my knowledge on how InnoDB threads queue works the other day when debugging activity spikes on one of the customer’s production system and while I had general idea about InnoDB kernel and queue, thread concurrency and queue join delays I didn’t have a complete model of how InnoDB concurrency control works. So I started from manual…

Hashing Algorithm in MySQL PASSWORD()

Recently we had a question from a customer: what is the hashing algorithm implemented in PASSWORD() ? The manual doesn’t give a straight answer in any of these two pages: http://dev.mysql.com/doc/refman/5.1/en/encryption-functions.html#function_password http://dev.mysql.com/doc/refman/5.1/en/password-hashing.html   It is enough to dig a bit more to find the solution in http://forge.mysql.com/wiki/MySQL_Internals_ClientServer_Protocol#4.1_and_later that specifies “mysql.user.Password stores SHA1(SHA1(password))” .   Instead of blindly…

Building libMemcached RPMs

A client running CentOS 5.4 Amazon EC2 instances needed the latest libMemcachedversion installed. With the inclusion of the “make rpm” target, libMemcached makes it easy to build the libMemcached RPMs by doing the following: Spin up a new CentOS Amazon EC2 instance, As root on the new instance: yum install @development-tools yum install fedora-packager /usr/sbin/useradd…

Log Buffer #248, A Carnival of the Vanities for DBAs

Simple messages are the most powerful. Keep it simple is the advice given by top technologists. One reason why blogs are extremely popular is their simplicity. This simplicity comes from the shortness and focus of the message of the blog. This Log Buffer Edition collects some simple yet powerful blog posts for you in Log Buffer #248.

Using HAProxy for MySQL failovers

There are a number of solutions available for MySQL architecture that provide automatic failover, but the vast majority involve potentially significant and complex changes to existing configurations. Fortunately, HAProxy can be leveraged for this purpose with a minimum of impact to the current system.  Alex Williams posted this clever solution a couple years ago in…

Log Buffer #247, A Carnival of the Vanities for DBAs

Thanksgiving is here and the circular chain of thankfulness is going on. Clients are thankful that they have applications, applications are thankful to their databases, database are thankful to their DBAs, and DBAs are thankful to clients. And they all are thankful that there is weekly Log Buffer Edition, of which the latest is Log Buffer #247. :)

Page 20 of 85« First Page...10...1819202122...30...Last Page »