Eric Bergen: Have you ever executed a query from the MySQL command line client only to find that the output wrapped and the result is unreadable?
I have. A lot.
In the past you have to run the query again with \G instead of ; or \g to get it to display the output in a vertical mode. My feature in MySQL 6.0.4 fixes that.
I am standing up and cheering. No, really. I love those little things that make life (yes, I said life) easier:
The auto-vertical-output option tells the command line client to display the results in vertical format if the results are going to be too wide to display horizontally. It does this without re-executing the query because MySQL passes the length of each column in the result set.
It’s a shame MySQL 6 is still so far away, but still: nice feature!
MySQL organizes a lot of conferences thoughout the year — for instance, last October I attended the Customer Conference in London, which was very interesting and gave a nice insight into the world of MySQL. But if there’s one conference that could carry the title ‘The MySQL Conference’, it would be the one held in Santa Clara, CA this week.
Because it is a larger conference, there’s more coverage. And the coverage is more organised. So if you weren’t attending, like me, you might want to dive into the blog posts and presentations that can be found online. This wiki page seems like a good starting point. Anyone got another?
According to Baron Schwarz the second edition of High Performance MySQL (the first edition being written by Jeremy Zawodny and Derek Bailing, which I read twice and still often use as reference) is in production, meaning that it’s written and being prepared for print.
That’s good news! As a MySQL developer and DBA, I’m very interested in knowing every piece of information about how to make MySQL perform well, and as soon as I can, I’ll order a copy.
I’m an admin for a MySQL database server, and today I needed to add a user account. I’m used to doing this using the commandline program or phpMyAdmin, but today I thought “let’s use the nifty MySQL Administrator for Mac,” a GUI tool, very much point-and-click and supposedly easy to use.
Or so I thought. For creating a user, you need to fill in, of course, username and password. When you want to save that, you get notified that you need to add a hostname for the user, first. That makes sense, because in MySQL, a user consists of a username and a hostname. So I press the tiny icon that seems to mean “add host”. Wrong, MySQL admin tells me. I need to save the properties of this user before I can add a host. Allright, but I just tried that.. but whatever. Pressing Save again.. wrong again! Need to add a host first.
As you can see, I can fill my day with this. The MySQL Administrator is no good. Back to the drawing boa.. eh, the commandline tool. At least those things always work.