Tag: MySQL

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 >

MySQL 5.1 and InnoDB Hot Backup Gotcha

Recently while we were building a slave with a newer version of MySQL 5.1 from an InnoDB Hot backup an error occurred The problem is, in MySQL 5.1, it is possible to log the slow query log and general log to tables in the mysql schema. These tables are created by default as CSV tables for performance reasons, even if MySQL is set not to log to tables. CSV tables, however, are not copied as part of the InnoDB Hot Backup process, creating this error. Here is the fix to get the slave working

Read More >
Page 43 of 66« First Page...10...4142434445...50...Last Page »