Posts Categorized: Pythian

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

With the rapid advancement in the database technologies, the legacy systems are either being upgraded or replaced. Or, in some cases, technologists are finding ways to support them in new ways, showing us the flexible nature of databases and the belief of professionals that the sky is the limit. For this Log Buffer Edition, we go even beyond.

DBD::Oracle v1.45_00 on Its Way to CPAN

A new trial version of DBD::Oracle has been churned out. This release is mostly about Martin J. Evans going all ninjawesome on minor bug fixes as well as paving the way for an upcoming refactoring/speed boost of ora_verbose. As usual, the new version will be soaked for at least 2 weeks before it will turn into its fit-for-general-consumption v1.46 incarnation. Testers, please give this baby a whirl. The full changelog follows for the curious-minded.

Why You Need to Consider Upgrading to SQL Server 2012

I’ve rewritten this blog post in the series to include other new features in SQL Server 2012 outside of high availability and disaster recovery. Ever since the product has been released, I’ve had a chance to look at features that will address performance challenges and business intelligence requirements.

Mystery Solved: Replication lag in InnoDB

While running a backup with XtraBackup against a slave server we noticed that replication was lagging significantly. The root cause wasn’t clear, but we noticed that DML statements from replication were just hanging for a long time. Replication wasn’t always hanging, but it happened so frequently that a 24 hour backup caused replication to lag…

Optimizing your MySQL Tuning Methodology

Optimizing your queries There are two general methods for creating a query plan for a query. A rule-based optimizer goes through your query, sees if you’re doing X or Y, and then optimizes for method A or B depending. Rule-based optimizers grow rather large as there are many possible cases to account for. Sometime in…

Presentations for Ottawa Oracle User Group

The Ottawa Oracle User Group (OOUG) was kind enough to invite me to give presentations for a whole morning. The group was ultra engaged and asked a lot of good questions, so my usual 50-minute Big Data presentation ended up taking 100 minutes, and the rest of the content had to be squeezed a bit. I hope everyone had a good time!

Locks, Latches, Mutexes, and CPU Usage

So how is the actual “waiting on lock” implemented? How does session B, waiting for a transaction to commit started by session A, knows that the resource is free for use? To find out how it is implemented, I have traced Oracle foreground processes. I tried this on Oracle RDBMS 11.2.0.3 running on Linux. This is a excerpt of system calls being executed during a session waiting for a lock…

NoCOUG Contest: a Gentler, Saner Solution

The actual challenge calls for a more generic solution than originally described in the magazine. Because there is no glory in half-solving a problem, I had to come back to it. And because the Great Karmic Balance could probably use it, I thought I could take advantage of the broader scope to produce a solution more geared toward elegance and modernism.

First MySQL/MariaDB/NoSQL Latin American Event

The first MySQL/MariaDB/NoSQL Latin American event is on its way, and Pythian will have a MySQL guy there. Yes, Francisco Bordenave (Team 14 TTL) is going to be one of the speakers. I am presenting a conference about replication in MySQL, how to’s, and what’s new in newer versions. This is a very important event, and many of our friends will be there.

Page 58 of 223« First...102030...5657585960...708090...Last »