Tag: MySQL

MySQL Backup Concepts for (Linux) System Administrators – Part 1

In this blog post, I will cover 3 basic types of MySQL backups for stand-alone database systems. I will not be covering fancy GUI applications, or really complicated processes – just the basic concepts – which is what I think System Administrators (ie – non DBA’s) need to know to have a good/valid backup.

Read More >

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

In order to appreciate the springing blogging innovations, this week’s Log Buffer, Log Buffer #215 picks some of the flowers just for you.

Read More >

Pythian Q2 2011 Speaking: MySQL Conference, Collaborate, & more

Look for the Pythian team at one of the following popular database industry events in Q2, 2011.

We’d like to hear from you. If you have any feedback on our sessions, please send your comments directly to the speaker, or to Vanessa Simmons, Pythian Director of Marketing.

Read More >

Pythian Speaking at Collaborate 2011

Pythian is happy to welcome Michael Abbey back to our team. He joins our list of distinguished speakers below. Keep an eye out for Pythian founder Paul Vallee who will also be making his annual appearance at the show.

Read More >

Pythian Speaking at MySQL Conference 2011

Here is the schedule for Pythian Employees speaking at MySQL Conference 2011

Read More >

MySQL Plug-in for Oracle Grid Control

One MySQL Plug-in customer reported an issue with reports — all charts were displaying an Oracle error and didn’t display any data as if it couldn’t connect to the EM repository. If you face this issue, follow My Oracle Support Note 374382.1 “Grid Control Repository: How to Change the Password of the MGMT_VIEW User”.

Read More >

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 >
Page 33 of 64« First Page...10...3132333435...40...Last Page »