Tag: MySQL

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

Welcome to the 139th edition of Log Buffer, the weekly review of database blogs. Let us begin with a look at the best from the Oracle ‘sphere.

Read More >

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

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

Read More >

InnoDB Hot Backup Utility Bug

If you are using InnoDB Hot Backup utility and the innobackup.pl wrapper script, be very careful if you are not running backups under the system mysql user. There is a bug which causes InnoDB Hot Backup to sometimes report a successful backup when it actually failed.

Read More >

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

This is the 136th edition of Log Buffer, the weekly review of database blogs. Welcome.

Read More >

Twitter — Tracking Production Actions?

don’t want to post the link to this (perhaps, it was left public unintentional?) but here is what I stumbled upon recently. This is a log of production maintenance of IT systems in Perth, Western Australia (as far as I could say): Good idea but shouldn’t companies keep this sort of information private?

Read More >

DBA_OBJECTS View for MySQL

Sometimes a client asks us to change the datatype of a column, but forgets to mention the schema name, and sometimes even the table name. As you can imagine, having this kind of information is vital to locate the object and perform the requested action. This kind of behaviour must be related to Murphy’s Law. In any case, I’d like to share with you a simple stored procedure that has helped us a lot in the past.

Read More >

Google Charts for DBA: Tablespaces Allocation

Pythian DBA’s have daily reports for each monitored database and some of the components are using charts to visualize the data. I’m a big fan of charts myself (when applied appropriately) and want to show how you can generate simple charts directly from the database. You’d be very surprised how easy it can be done from *any* database without installing any additional software or configuring something special.

Read More >

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

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

Read More >

Different Technology Stacks On Production and DR?

Last week, I was at the NetApp office in North Sydney for the presentation on NetApp SnapManager for Oracle. It was good opportunity to learn more about NetApp snapshots while working on a project for one of our clients in Sydney. It was an especially interesting topic as I have some experience using Veritas Checkpoints. I learned that NetApp can provide access to the same LUNs via either Fiber-Channel (FC) or iSCSI. And this is when the interesting argument surfaced.

Read More >

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

Welcome to the 134th edition of Log Buffer, the weekly review of database blogs. There’s no time to lose, so let’s begin—with MySQL.

Read More >
Page 46 of 64« First Page...10...4445464748...60...Last Page »