Posts by Sheeri Cabral
I was contacted by the folks at MONyog and asked if I would review MONyog. Since using MONyog is something I have been wanting to do for a while, I jumped at the chance. Of course, “jumped” is relative; Rohit asked me at the MySQL User Conference back in April, and here it is two months later, in June. My apologies to folks for being slow. Have a look.
Usenix 2008 – Automated System Management, by Ã†leen Frisch of Exponential Consulting
From 7:30 – 8:30 pm tonight, Wed. June 25th, in the Berkeley room of the Sheraton Boston, I will be hosting a Birds of a Feather conversation entitled “Pros and Cons of Managed Services”. This will go beyond MySQL and even beyond remote database management, and just deal with the overall pros and cons. Come, share your good and bad experiences, and discuss why managed services may or may not be appropriate for your situation. I will try to take notes at the BoF.
I have *never* had this happen to me. Maybe it’s because it’s MySQL 6.0.4, maybe it’s because it’s on Windows, or perhaps I am just up working too late. I have seen mojibake before, but usually it is unintelligible. But this? After I post this I am backing away slowly from my computer. Has your data ever smiled at you?
ANSI_QUOTES mode changes the functionality of double quotes (“) to be like the backtick (`). Normally the functionality of double quotes is more like that of single quotes (‘). You might use this when you have a table with spaces or other special characters you would like to escape, without having to use the backtick key. This is also ANSI standard SQL behavior (one of the more annoying things about Oracle is that I keep forgetting I can’t use “, only ‘). Here is an example in the MySQL default mode.
If you are attending Usenix 2008 at the Sheraton Hotel in downtown Boston, you can meet me and ask your burning MySQL questions at my “The Guru is In” session. On Friday, June 27th, 2008 from 2 – 3:30 pm in Constitution B, I will be helping folks out by optimizing queries and schemas, teaching general principles of working with MySQL databases, and answering (to the best of my ability) any other question they may throw at me. Hope to see you there!
he Boston MySQL User Group was lucky enough to get Keith Murphy to speak at the June User Group meeting, about backups. here are links to the video and presentation materials, and reference information in this post. Enjoy!
So, we have all heard that Billy Joel played a concert at Oracle’s OpenWorld in 2007. What follows is an actual IRC conversation among Don Seiler, Dave Edwards, and myself. Comment here with your own database-themed parody of a Billy Joel song. Perhaps if we get enough MySQL-themed entries, we can get him to come to the MySQL Conference in April.
In the case when the error log writes to a non-default path, FLUSH LOGS actually does not work as specified for the error log. I have not seen issues with binary logs in non-default paths, but we just ran into this issue on a client site and it threw us for a big loop. The bug description is here…
At last night’s event, a lot of the questions were really implicitly asking, “Is open source better? Why?” The first answer everyone comes up with is that it’s free, and that’s better. However, that is neither necessary nor sufficient to deem it “better”. Let me explain….