Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

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

In your hands, the new edition of Log Buffer is smiling and it wants your undivided attention, because it is full of selected simmering yet cool blog posts from around the blogistan of database arena. Enjoy the Log Buffer #226.

Oracle:

Kyle Hailey is exploring I/O histogram values in Automatic Workload Repository.

Charles Hopper tells us what is wrong with the quote - Addressing TM Enqueue Contention

Richard Foote blogs about some random notes in his sweet style.

Woohoo, Jonathan Lewis is writing another book. What a good news of 2011.

Marco blogs about a HowTo of XML partitioning and multiple XMLIndex structures.

SQL Server:

Vishal discusses the sys.database_principals which contains all users/roles in the current database.

SQL Server "Denali" is the code name for the next version of SQL Server. James Serra blogs about the releases of CTP1 of Denali and promises to blog more.

Chris Webb says that most of the time when you're using dimension security with SSAS, you're slicing a hierarchy vertically.

The syspolicy_purge_history SQLAgent job is used by Policy Based Management in SQL server to clear out the policy evaluation history kept by PBM. Ryan Adams has more.

Andy Lohn gives the TSQL Tip of the week and that is how to copy a table structure.

MySQL:

MySQL Connector/Net 6.3.7, a new version of the all-managed .NET driver for MySQL has been released. This is a maintenance release to our existing 6.3 products and is suitable for use in production environments against MySQL server 5.0-5.5, as per Reggie Burnett.

Henrik Ingo touches the Galera clustering for MySQL first time and is pretty excited about it.

Nicholas Goodman evangelizes the single biggest advantage of enabling SQL Access to CouchDB Views.

Kristian Nielsen tells us the tale of the bug lp:798213 and document it.

Giuseppe Maxia blogs about the less known facts about MySQL user grants.

Happy Summer!!!


PlanetMySQL Voting: Vote UP / Vote DOWN
Source Article
Comments
0
Be the first to comment

Join with account you already have


Sign in with Twitter account
Sign in with Facebook account
Sign in with Google Friend Connect
avatar
Tags: henrik ingo, james serra, nicholas goodman, jonathan lewis, richard foote, production environments, sweet style, chris webb, ssas, policy evaluation, random not
Seeking Postgres users, DBAs and developers in areas where we don't have conferences or user groups
Apr 5, 2011
Hi! I'm trying to find people who use, administrate or develop PostgreSQL and live in regions that our community doesn't currently serve. By "doesn't currently serve", I mean that: * You don't know many other people that use PostgreSQL in your…

4k buffer limit?
May 11, 2011
Hi, I'm reading an inputstream, but somehow the input gets chopped off at around 4k characters. I'm reading the characters one by one from the input stream. I've never seen this before, but then, maybe I've never read input more than 4k at a…

mime_parser_parse can look beyond the end of buffer
Nov 14, 2010
Hi All, When calling mime_parser_parse you are expected to set 'end' to point to one byte beyond the end of the buffer (See docs for INKMimeHdrParse and comment above HTTP.cc:http_parser_parse_req). If the header buffer ends with a single…

Buffer Overflow
Nov 16, 2010
I'm seeing this in my catalina.out log file. I've been able to narrow the problem to a single JSP page, and the problem only happens with a single user when that user is using Windows XP/FireFox 3.6.12. I've tested the page with XP/Firefox…

Buffer Overflow
Nov 16, 2010
I'm running Tomcat 6.0.29 I'm seeing this in my catalina.out log file. I've been able to narrow the problem to a single JSP page, and the problem only happens with a single user when that user is using Windows XP/FireFox 3.6.12. I've tested…

mmap:ed i/o and buffer sizes
Dec 10, 2010
I was looking closer at sliced_buffer_size_in_kb and column_index_size_in_kb and reached the conclusion that for the purpose of I/O, these are irrelevant when using mmap:ed I/O mode (which makes sense, since there is no way to use a "buffer size"…

Re: buffer overflow or so in exim
Jan 19, 2011
On 2011-01-19 at 13:50 +0100, Pascal Bourdais wrote: > # exim -bV > Exim version 4.68 #8 built 03-Sep-2009 09:01:10 There are known issues with that version. There have been security notices from major vendors urging people to upgrade. If…

cf-monitord: LDT Buffer full at 10
Sep 22, 2010
This is a multi-part message in MIME format. This is a multi-part message in MIME format. I'm trying to understand this message because I've got users asking about it, thinking it may be causally related to some unexpected in-house application…

Protocol Buffer Timeouts
Jul 30, 2010
Hello all, We're doing some load testing using Riak erlang protocol buffers interface and are running into timeouts. From the looks of it, the timeouts are coming from the gen_server:calls in riakc_pb_socket.erl which don't specify a timeout,…

Shared Buffer Size
May 27, 2011
Hi All, I am little confused about the internal working of PostgreSQL. There is a parameter shared_buffer in postgres.conf and I am assuming that it is used for buffer management in PostgreSQL. If there is a need to bring in a new page in the…