Tag: MySQL

Log Buffer #169: A Carnival of the Vanities for DBAs

The 169th edition of Log Buffer, the weekly review of database blogs, has been published on Pakistan’s First Oracle Blog by Fahd Mirza.

Read More >

MySQL on Debian and Ubuntu

When MySQL is first installed on Ubuntu/Debian, this problem never occurs because the package as part of the post installation process randomly creates a password for the debian-sys-maint user, creates the user in MySQL (during the initial installation the root MySQL user has no password so is able to login as root), and creates the /etc/mysql/debian-my.cnf file on the system. So what’s the solution? Well, there are ways to deal with it.

Read More >

Where we’ve been…

You might notice that I haven’t blogged in oh, 2 years.  How remiss of me.  The only defense I have is that we’ve been non-stop busy!  Since then we’ve built our client portfolio, brought in two new team members, presented…

Read More >

Log Buffer #168: A Carnival of the Vanities for DBAs

This is the 168th edition of Log Buffer, the weekly review of database blogs. Let’s give the wheel a spin and see who comes first . . .

Read More >

Gerry Narvaja: the Winds Of Change

For very personal reasons that don’t belong in this article, I decided a few weeks ago that it’s time for me to move on. The year and a half that I worked for Pythian have been a wonderful experience, and this is article is my tribute to this great company.

Read More >

Log Buffer #167: A Carnival of the Vanities for DBAs

Welcome to the 167th edition of Log Buffer, the weekly review of database blogs.

Read More >

sar-sql: The Script Formerly Known as MySAR

The title of the Launchpad page already reflects the change. What remains to be done is: a) change the name of the Perl script and documentation; and b) change the Launchpad URL. It is likely that I will change the name of the script when I release version 1.x (see below). I’m not sure of all the implications in Bazaar regarding the URL change, so that task will have to wait for now. Now a little more info on the status of the project.

Read More >

MySAR, a Sidekick for Other Monitoring Tools

What Was Going On Around 2:30pm? This is a question a customer asked us. To answer it we ran MySAR for a few days and queried the results for analysis. Looking at the data, we determined that the number of INSERT operations was significantly higher than any other, so we queried for the Com_insert status values. Com_insert is a counter that accumulates the number of INSERTs issued since the last server start (or since the last FLUSH STATUS command). For details on the variables available check Chapter 1. mysqld Options/Variables Reference.

Read More >

Log Buffer #165: A Carnival of the Vanities for DBAs

Welcome to the 165th edition of Log Buffer, the weekly review of database blogs.

Read More >

MySAR: A sar-like Utility for MySQL

One day, while looking into slave lag problem, the idea of MySAR popped into my head and a few hours later I was using its first incarnation. I was able to relate the server’s I/O activity peaks with these lags and in turn, discovered that it was caused by a great number of INSERT statements coming in in waves. It was an encouraging outcome for what was nothing more than a proof of concept.

Read More >
Page 41 of 64« First Page...10...3940414243...50...Last Page »