Posts Categorized: Pythian

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

Getting stuck on technical problems is a norm in the life of any IT professional and DBAs are no exception. With evolving databases and their streaming new features make it more challenging. Blogs often provide the Eureka moment for those problems. So sit back and enjoy this Log Buffer Edition, which is Log Buffer #245.

New & Improved: MooseX::Role::BuildInstanceOf

Okay, so MooseX::Role::BuildInstanceOf is not one of my modules. And while I submited the patch, the feature itself was born out of fREW’s DBIx::Class::DeploymentHandler. So, in all this, my role was at best to be the pollinator agent between two beautiful flowers. But, hey, it’s not like a little bit of noise is going to hurt any of the involved parties, sooo… let’s see what the buzz’s about.

RMAN Duplicate in Details

I took debug of duplication and figured out that RMAN internally executes procedure dbms_tts.transport_set_check preventing any further copy operations if tablespaces do not satisfy TTS requirements. Now the plot thickens and considering RMAN shows everything that it does in log file I decided to repeat the same steps but one by one and manually. Let’s get into it.

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

Managing the databases of any kind of any size in the production environment requires the administrators to remain up to date and on the toes every time. They need to learn fast and apply their knowledge fast. Keeping abreast of the newer features and the troubleshooting techniques is must for them and this Log Buffer Edition helps easing that task. Enjoy the Log Buffer #244.

Cluster Wide ASH Report

One of the most nice thing about the newer versions of Oracle is the advent of ASH and AWR as they provide awesome diagnostic information. Many customers at the Pythian use Real Application Cluster and having a cluster wide AWR report by using awrgrpt.sql script is very handy.

How to recreate an InnoDB table after the tablespace has been removed

Does your error log ever get flooded with errors like this one? [ERROR] MySQL is trying to open a table handle but the .ibd file for table my_schema/my_logging_table doesnot exist. Have you deleted the .ibd file from thedatabase directory under the MySQL datadir, or have you used DISCARD TABLESPACE? See http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html how you can resolve…

Announcing PalominoDB’s Non Profit Program

I’ve always had a dream of being able to use what we are doing at PalominoDB not only for our for profit clients, but for those who go out day to day helping those who need it.  We always try to work with clients who make people’s lives better, but there are those whose entire…

Getting a List of Users From the MySQL General Log

From time to time, organizations want to know if there are any users that are not used. For clients using MySQL 5.1 and up, that can handle a 1% overhead for general logging, we will enable the general log for a period of time and analyze the users that connect. Note: we have some extremely…

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

From Percona Live, London to TechEd Australia to Oracle Open World USA, the blogosphere of Oracle, MySQL, SQL Server and the related technologies is bustling with the eye witness accounts of these conferences, technical overviews, observations, predictions, and much more. This Log Buffer Edition covers all that and as usual more in Log Buffer #243.

Page 80 of 230« First...102030...7879808182...90100110...Last »