While doing a standard audit for a new client, I recommended a few changes to get better performance. Because I had several changes, I used the documentation and found that innodb_flush_log_at_trx_commit is a dynamic variable. I was surprised, because most operations dealing with file sizes and operations are not dynamic. So I searched for others who may have had the same error, and ended up getting an unintentional googlewhack.
Calling a group of people with common interests “community” is just as meaningless as saying I live in a “neighborhood”. There has to be a bond there. I am proud to be a part of the MySQL Community, which actually has forged bonds. If you are new to the MySQL community, feel free to come up and talk to me (or anyone, really) — during the conference, or otherwise. Even if you feel you have nothing to say, just say hello. And I must end with a disclaimer: I won last year’s “Community Advocate” award from MySQL, so I guess all in all, I’m still a community advocate.
My name is Vasu Balla, and I’ve been with Pythian for about four months now. I have worked on Oracle E-Business Suite instances for over five years, and I’ve never had a moment where I felt bored. I am constantly challenged with new technologies and new issues, and my Pythian team’s clients continue to present interesting issues. Our team recently encountered an issue a client had had with Oracle Configurator for two years. They had followed up with Oracle Tech Support for over a year and had eventually learned just to live with the problem. When Pythian came in, we were shocked to learn the history of the problem. It turned out to be one of the most exciting problems we’ve resolved.
The answers to the last pop quiz are up. So here’s another pop quiz…good luck!
Recently I encountered a SQL Server 2005 Replication setup where an error message was appearing about every 5 minutes in the SQL Server error logs. The error message was coming from the failing distribution cleanup job. Examining the job history I was able to determine the real error message. The first step in debugging was to confirm if xp_cmdshell was enabled….
If you are a regular reader of this blog, you know that I was at the Hotsos Symposium 2008 this year. You might not know that I also had a chance to take few days off and spend 1+ week vacation in Texas after the symposium — enjoyed the sun and warm weather. My family liked that even more than I did. Unfortunately, when I was back home last weekend, I discovered pretty unpleasant view from my windows…
Welcome to the 89th edition of Log Buffer, the weekly review of database blogs.
Ah, the perils of working in a shared, client environment. One client has us using a login that is not exclusive to us. I prefer using bash; the client is set to use zsh. This is not a problem in and of itself. However, there is a section in the .profile that is causing me issues, let me show you.
In Spotting the Wolf in Sheep’s Clothing, Frank Mash writes about a specific person who is spreading fear, uncertainty and doubt about MySQL. Now, this always gets me, especially with MySQL. For how long will MySQL be the bastard stepchild of the database world? Because really, it’s been a full-fledged DBMS for at least 5 years. Don’t hate MySQL for the wrong reasons and there are plenty of reasons to hate MySQL. But hating MySQL because “it sucks” or because “it doesn’t have blah feature” — which, 9 times out of 10, it has — is just wrong.
I was asked this question recently, and I thought it was a great little tidbit of knowledge to pass along. The short answer is “no”. The slightly longer answer was written up by Jan Kneschke when dealing with a forum post about proxy + connection pooling.