Welcome to Log Buffer, the weekly roundup of database blogs.
Kicking off this week in Log Buffer #191 are posts from Alisher Yuldashev:
Randolf Geist blogs on an Advanced Oracle Troubleshooting Session – PGA/UGA memory fragmentation for when a batch process takes significantly longer than expected.
…
[Read more]Welcome to Log Buffer, the weekly roundup of database blogs. We’re back this week with a short Log Buffer #190. Only ten more issues, and we’ll be celebrating our 200th edition post.
Chen Shapira was eager to share news early this week, sending along her favorite picks on Tuesday.
Prof. Neil Gunther doesn’t like the way
commercial load testing software distributes think
times.
…
Welcome to Log Buffer, a weekly review of the database industry. This week’s issue Log Buffer #189 is generously published by Iggy Fernandez, editor of the quarterly journal of the Northern California Oracle User Group (NoCOUG).
As always, if you’d like to host your own issue of Log Buffer, simply reach out to the Log Buffer coordinator.
Please enjoy Iggy’s issue of …
[Read more]Most database companies would be proud to say that their products perform optimally out of the box. It means they accomplished a Herculean feat of engineering. But most databases have configuration options because this is almost impossible. For example, MySQL has scores of tuning options, and it needs a lot more.
So when someone benchmarks your database and makes you look bad, usually you can say “that benchmark was run by someone who doesn’t know how to properly tune my database software.”
But what if the benchmarker claims that your database didn’t need to be tuned, (via Dave Page), because it’s optimal out of the box? Do you accept the benchmark results, or reject the compliment?
Related posts:
It’s Friday already, and we know what that means! Log Buffer, the industry’s weekly review of database blogs is here again for your reading pleasure in the 188th issue.
Starting off this week’s issue is a request from Mark Grennan a DBA who would like to let the community know about his blog MySQL Fan Boy, where he wrote an interesting post on including a script to replace MySQL table files on a live system, making it faster and limiting locking on large table loads. Also a post this week on whether MariaDB is a drop in …
[Read more]Welcome to Log Buffer. This week’s issue #187 was another group effort. Thanks to all our contributors – you rock!
Suggested by Pythian’s Bradd Piontek, is a post he really liked because he used to write pipelined functions for Dynamic Search queries, – Tom Kyte’s something new I learned about estimated cardinalities. He’s also highlighted something new Tom learned about sqlplus. And the fact that Richard Foote announced the …
[Read more]Welcome to the 186th Edition of Log Buffer. Lots to report this week, so read on…
In Oracle news:
We begin with Gary Myers at the Sydney Oracle Lab who mixes GUI
and CLI and shows how to manage your database from EMACS.
You have to read a post that starts with: “There is a place of
shadow, a place between the dark lands of the command-line
interface, and the shining brightness of the GUI. In the days of
yore, many dwelled in the shadow lands, but almost all have been
attracted to the lights of SQL Developer…”
Tanel Poder gives a step by step tour of his …
It’s a busy time of year for Pythian. With many of our team tied up on client engagements, away at MySQL conference this week, and Collaborate 2010 next week, I’m pinch hitting as volunteer editor in helping to pull together this week’s edition of Log Buffer. Enjoy!
MySQL Conference 2010
Big news this week from MySQL Conference as Oracle’s Edward Screven elaborates on Oracle’s plans for MySQL in his opening keynote. Pythian’s Paul Vallee was interviewed by Network World’s John Brodkin, before the conference in anticipation of the session.
Ronald Bradford responds, writing about his …
[Read more]This is the 184th edition of Log Buffer, the weekly review of database blogs. I’ve edited a couple of Log Buffers before, but this is the first time I get to post directly to the Pythian blog. Just one of the many perks of being a Pythian employee ;)
On the Oracle front:
It is always good to start the day with a pop quiz to get the brain into gear: Charles Hooper posted a 3-part series with seemingly innocent True/False questions. He covers sorting, SQL tuning and …
[Read more]
Last week a customer called me and reported that MySQL was 30
times slower than MS SQL server. Oooops. That's a lot. No way to
argue or throw smoke bombs. 30 times slower! It was a standard
installation of MySQL (typical install option) on plain Windows 7
and the same for MS SQL Server 2008. The test run was a batch of
30.000 INSERT commands in an SQL script. Runtime was 1 minute on
MSSQL and 30 minutes on MySQL. Some tests later we found out that
it was only bad on InnoDB. MyISAM was as fast as MSSQL. (I didn't
care which one was a bit faster. I didn't care as long as InnoDB
was 30 times slower) Finally we nailed the problem down to one
parameter in MySQL: innodb_flush_log_at_trx_commit Each INSERT
statement is a single transaction (autocommit mode). MySQL is
configured very faithfully and ensures that each …