Tag: MySQL

PgEast 2011 Day The Second

Well day two here at PgEast has drawn to a close and it was another very informative day.Today I concentrated on the more common tasks of a Pg DBA so I attended three talks (four if you count mine) that where rather heavy on the technical side of being a Pg DBA. Keep reading.

Read More >

How and why tmp_table_size and max_heap_table_size are bounded.

Why am I still doing a post on this? Because I still see MySQL configurations that DBAs seem to use as separate assignments without taking into account the consequences of over-allocation and what impact it has on MySQL server memory usage.

Read More >

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

Database Servers are humming along, and the people who manage them, interact with them or are just in awe of them are busy in blogging about them. This inspires our next Log Buffer, Log Buffer #214.

Read More >

NoCOUG (My)SQL Challenge entry #2

A few days ago I learned about this year’s NoCOUG SQL Challenge and decided to to put the gray matter between my ears to work. I’ve been teaching a MySQL course this week and my first impulse was to use my MySQL VM to test my solution attempts. However, I eventually decided to use Recursive Subquery Factoring to solve the proposed problem and had to switch to an Oracle 11gR2, since it’s the only database that implements this feature that I know how to use (are there any others?). I was happy with my solution, but frustrated that I couldn’t run it on MySQL. So I decided to try to make it somehow work on MySQL.

Read More >

Product Support vs Operational Support

Sometimes I get questions as to whether Pythian is one of the competitors battling with Oracle for MySQL support. The answer lies in the distinction of product support and operational support.

Read More >

Pythian Q1 2011 Speaking: Find us at RMOUG, Hotsos

Pythian will be at RMOUG in full force. Look for Alex Gorbachev, Kellyn Pedersen & Don Seiler. Be sure to stop by our table (#10), say hi to us & our friends from the OakTable Network, and enter our draw to win an Amazon Kindle, and software provided by Cary Millsap (MR-Trace, MR-Tools & Method-R Profiler) among a few other surprises. Pythian is agressively hiring top DBA talent. If this is you, register on our Career Center, or request a time for a short intro chat with Pythian. Alex, Kellyn or Don will be more than happy to give you the inside scoop on the company & share why they love working for Pythian.

Read More >

Pythian Q1 Webinar Schedule Update

Please join us for one of our upcoming Q1 webinars. This post will be updated as new webinars are added. Sign up here if you wish to be notified when new sessions are posted.

Read More >

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

Warm welcome to the Log Buffer, a weekly amalgamation of database news across different technologies. Let’s get warmed up with sizzling Log Buffer #213.

Read More >

DBIx::Class::DeploymentHandler is Awesome

DBIx::Class::DeploymentHandler is a fairly young module. It’s a little raw at the edges and a wee bit terse in term of documentation. It’s also a complex thing and, trust me, it’ll takes more than a few minutes of playing with it to get your mind around how it works. But once you begin to understand what it can do, Whoa, that’s one seriously powerful beast, that module is. But don’t take my word for it, let me show you.

Read More >

Beware Starting Slaves in the Position in the master.info file

I’ve seen many a good DBA make the master of starting slaves from the position in the master.info file, most recently this week, that I want to bring it to everyone’s attention.

Read More >
Page 35 of 65« First Page...10...3334353637...40...Last Page »