Tag: MySQL

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 >

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

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

Read More >

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

Welcome, readers, to the 163rd edition of Log Buffer, the weekly review of database blogs, your sieve

Read More >

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

Welcome to the 162nd edition of Log Buffer, the weekly review of database blogs.

Read More >

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

Welcome to the 161st edition of Log Buffer, the weekly review of database blogs … and the first one under my penmanship.

Read More >

Release 1.1.1 of MySQL Plug-in for Oracle Enterprise Manager

I have just released a new version of the MySQL plug-in for Oracle Enterprise Manager — MySQL plug-in 1.1.1. This is a long overdue bug fix release. There are no new features implemented (we have another branch in development) but just fixed number of fairly annoying bugs that I was finally able to reproduce.

Read More >

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

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

Read More >

Using the Sphinx Search Engine with MySQL

Implementing SphinxSE into MySQL proved to be easier than it seemed in the beginning, although it took some time to compile and install everything. With a creative use of views, it could potentially be implemented right away in legacy applications, offering numerous advantages.

Read More >
Page 42 of 65« First Page...10...4041424344...50...Last Page »