Posts by Alex Gorbachev
Doug Burns has spent 4 weeks in our Ottawa office and now he is back home to Madeline and boys. Yesterday, before he left, we had the lunch at Cock & Lion Ale House:
When checking for new known issues with 10.2.0.3 patchset on Metalink I discovered that an upgrade problem was added – Metalink Note 401435.1. The issue affects all 64 platforms especially when database is upgraded from any previous 32 bit release.
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.
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.
Not that I participate there often but couple months ago I pulled out my 7 years old account there and wanted to change its password. To my surprise – I’m not able to do it.
In one of my previous posts I mentioned SYSTEM_PRIVILEGE_MAP view. Taking this thread further, I looked into another nice view – V$ENABLEDPRIVS – showing the privileges enabled for the session at the moment. It should be pretty useful if you decide to add some diagnostics into your application. You might also find it very helpful to call from PL/SQL.
We humans are not able to process large amount of precise data. In any human–readable report, we don’t need more than ten or twenty lines of numbers. Every time we look at processes or data more complex that that, we employ simplifications — graph trends, mind–mapping, aggregations, and so on. How will we make computers process information just as humans do? Perhaps we can find the answer inside ourselves if we figure out how our minds work. We recognize images even though our brain is not capable of processing huge amounts of data in milliseconds.
MySQL – No Index Used With ORDER BY + LIMIT and DISTINCT. This is actually a follow up on my previous post. Developers tried to rewrite all statements and even overdid it. As we say in Russia – “teach fool how to pray and he will break his forehead”.
Oracle 10.2.0.3 Patchset – Known Issues and Bugs. Oracle 10.2.0.3 patchset is not functional on Solaris SPARC 64bit platform with datafiles on Veritas VxFS.
Today is the first time I had to look at MySQL performance. Tiny database as web application back-end was having significant performance issues with spikes of CPU workload. After identifying problematic queries, I found a pile of statements using IN subqueries. I asked around and our MySQL experts assured me that this is one of the minor and not so disturbing issues, in fact. I can’t imagine what those disturbing issue are. I guess Oracle XE does have some advantages over MySQL for small installations.