Tag: MySQL

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

Tis the season to be fearless in blogging and read the blogs around the database globe. To make your foray in intrepid world of database blogs, this Log Buffer Edition compiles some of the most interesting posts in this Log Buffer #250.

Read More >

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…

Read More >

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

Welcome to Log Biffer #249, the weekly review of database blogs.

Read More >

Hashing Algorithm in MySQL PASSWORD()

Recently we had a question from a customer: What is the hashing algorithm implemented in PASSWORD() ?

Read More >

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…

Read More >

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…

Read More >

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.

Read More >

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…

Read More >

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. :)

Read More >

Rails and Database Session Variables

Ruby’s ActiveRecord provides a very robust means of manipulating database table structures especially in the context of automated deployments such as Capistrano. When there is a master-slave database configuration, it may not always be prudent to perform DDL statements on…

Read More >
Page 26 of 65« First Page...10...2425262728...40...Last Page »