ALL POSTS

MySQL Recipes: Connections per hostname using Pager

Over-the-Top Tales from the Trenches: Bringing order to the chaos of every day DBA life. My aim in any posting is to make your job as a DBA in Oracle, SQLserver and MySQL easier. Ever wondered how to get a quick count of the number of connections per hostname from MySQL? Welcome to the arcane (but extremely powerful) world of the MySQL command line pager.

Sequences in Oracle 10g RAC

I got a call from a developer who had a table with a primary key populated by a sequence, a timestamp column with the current date and some other columns. He had a specific set of data that, when ordered by the primary key had out of order timestamps. He was puzzled how this could be. We changed the sequence to “ordered” and increased the cache to 1000. Now selecting on either node gets the next number as he expected. I warned him that there would be some performance implications due to cluster synchronization. Him being a responsive developer, asked me what the impact would be, so I tested it out.

Announcing Pythian Goodies

I’ve been wondering for a while now how best to transfer knowledge efficiently and in a fun way. Presentations are good, but they require a lot of effort in preparation and research, and they are not as interactive as they could be when the group is smaller. To answer some of these issues, I would like to introduce you to Pythian Goodies. What is a Pythian Goody session you ask? Find out here.

MySQL GROUP BY and DISTINCT Oddity

At the end of my last MySQL post I mentioned strange behavior with GROUP BY and DISTINCT. This MySQL “feature” could save some resources on sorts and aggregates but generally I would avoid it as this is not portable solution. Generally speaking, query output is non-deterministic — it depends on the full table scan implementation and on the physical order of rows in a table. This means that it’s actually a bug and , instead, MySQL should produce and error on those statements.

ORA-07202: sltln: invalid parameter to sltln

I’ve started to use DBCA more and I try to use its template management capabilities. It looks like templates is not the most robust feature of Database Configuration Assistant. Sometimes, there are issues when I want to reuse template. I reviewed the parameters and found that control_files is set to an empty string. Checked Metaclick and, indeed, this error is related to empty control_files parameter.

Page 223 of 251« First...102030...221222223224225...230240250...Last »