Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 13 3 Older Entries

Displaying posts with tag: Rants (reset)

Indirection of SHOW commands between MySQL 4.1 and 5.1
+1 Vote Up -0Vote Down

Today, while helping someone find some of the code that implements SHOW VARIABLES I was reminded at how insanely complex it all got with the information_schema implementation and the changes to the SHOW commands that came with it. Specifically, I was trying to find exactly how the SHOW VARIABLES output gets populated — what the source data is.

By way of example, I present the code to implement it in 5.1.51 (the new way), and in 4.1.21 (the old way). I, at least, have a much easier time sorting out the old way. They both start with the same basic entry point, in the parser, in show: within sql/sql_yacc.yy.

SHOW VARIABLES …

  [Read more...]
Another article on Telecommuting. The Ugly, The Bad and The Good
+0 Vote Up -0Vote Down

Computer World has an article about Telecommuting . So, I thought I’d chip in my inflated $0.02. Telecommuting, doesn’t mean working from home. This is one of the biggest myths, and truths people will realize over time. What makes me such an expert? I’ve been telecommuting for the past 3 years, straight, full time. I’m not talking about moonlighting, and doing part time work for companies who post on craigslist. I’m talking multi million dollar projects. I haven’t been …

  [Read more...]
Reasons to upgrade to Leopard, The non fanboi reasons
+0 Vote Up -0Vote Down

Apple announced, as expected, a release date for Mac OS 10.5 Leopard. The date is October 26th, 2007 in case you missed it. Since everyone on the internet is a guru, and therefore, so am I, I will give you plebes reasons to upgrade to Leopard. But, first let me qualify myself worthy of such preachery (gurus can make up words).

  1. I’ve been using Leopard since January 2007, since I’m an ADC Member, and I have early access.
  2. I’ve been using it on my primary work machine since September 2007.
  3. This is the internet, and somehow you found this post to read, therefore you don’t know any better..
…  [Read more...]
On ?On PHP? and version numbers
+0 Vote Up -0Vote Down

Matt has a good post on the recent push to make people use PHP 5. He makes several good points, and I’m just jumping on the same bandwagon.. forcing a version # change, just because the engine works better is pointless. Going into the political arena a little bit, making people switch to PHP 5 is like changing CAFE standards, it won’t do a thing for the billions of cars already out there, and it won’t change the basic dependence on crude oil. It’s just a lot of hot air to make the choir sing to themselves, again.

I’ve been running PHP 5 on my systems for the past 3 years, without …

  [Read more...]
The Fun Never Ends
+0 Vote Up -0Vote Down

So what happened? Well, two days ago I noticed connection issues while trying to create a blog post on MySQL?s new enterprise offering (more on that later). I sent in a support request to Tera-Byte, my colocation provider. After a while I checked and noticed that I could connect via SSH, but that the server was rejecting my private key and my password.This had me concerned so I called Tera-Byte and asked what was happening. Turns out that they had mistakenly deleted my virtual private server. But they were kind enough to not only increase my new virtual private server?s memory from 360 megs to 512, but …

  [Read more...]
Show @&!# status again!
+0 Vote Up -0Vote Down

I’m not the first person to run into this and I certainly won’t be the last. This is also already covered in: Bug #19093 I just want to say again how annoying it is that the default for show status is session instead of global. It bit me again yesterday. I ran show status and was confused because most of Com_* is 0 yet uptime was a few days. Then it hit like a brick to the face that I was working on 5.0 instead of 4.1 and the default for show status is session. I know the default has changed and it still bites me. This is going to cause people hours of confusion the first time they do what I just …

  [Read more...]
Testing Software on Non-Production Hardware
+0 Vote Up -0Vote Down

Just a quick note while it is in my head:

When testing software, especially for performance, remember to test on the same hardware you intend to deploy on. One trend I have seen for some time is that testing is often done on whatever happens to be lying around and not otherwise assigned.

While you can certainly test MySQL or an email server on such hardware, you should at least be aware that by providing hardware that does not match what you use in production you will not get an accurate picture, and sometimes the differences can be dramatic. This is especially true of enterprise software with high demands for …

  [Read more...]
Madness continues: SHOW STATUS
+0 Vote Up -0Vote Down

Last month I blogged about the silly changes to the default for the SHOW STATUS command in MySQL 5.0 in Stop the madness: SHOW STATUS, and I filed MySQL Bug #19093: SHOW STATUS defaults to SESSION.

Well, it looks like Monty has spoken and this will not be fixed. That’s unfortunate, but oh well, I tried.

You can read the full text of Monty’s reply in the bug report itself, but his reasons for supporting the current behaviour boil down to:

  • It’s similar to …
  [Read more...]
Stop the madness: SHOW STATUS
+0 Vote Up -0Vote Down

Are you a MySQL user? Have you tried 5.0? Did you notice that SHOW STATUS was giving you strange results?

Here’s the skinny: The SHOW STATUS command, which has been in MySQL, well forever, has had a long-standing feature request; to have the ability to report its metrics per-session. That functionality was added in MySQL 5.0, in the form of two new syntaxes: SHOW SESSION STATUS and SHOW GLOBAL STATUS to give the per-session and server-wide statistics, respectively. It’s great, and I’m happy to see it.

The problem comes in because of the default behaviour that was chosen for the basic SHOW STATUS with no SESSION or GLOBAL …

  [Read more...]
MySQL 5.0: Remarkably Painful
+0 Vote Up -0Vote Down

MySQL 5.0 has a ton of new features. In fact, several tons. Many people and companies were waiting endlessly for some of these features. Some of the new features include: Views, Stored Procedures and Stored Functions, Triggers, and some extra optimizations. …

  [Read more...]
Showing entries 1 to 10 of 13 3 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.