In this issue of the MaxDB series we will introduce you to some selected aspects of transactions. The topic of transactions seems pretty boring. But in fact it depends very much on the point of view you take. We have tried to put a light on the subject that shows some rather advanced aspects of transactions which are a little less often discussed in database classes.
Tokyo ? Smart Style Co. Ltd., the MySQL solution experts in Japan, today announced that it has extended its membership in the MySQL partner program in order to expand its MySQL sales activities throughout Japan.
In MySQL, privileges are stored in tables in the mysql database, so if I have UPDATE privileges to that database, it’s easy to update my own privileges. For an example of what the desired privileges should be, run the following query: select * from user where User='root'; The Grant_priv column is what I’m interested in. I just update that value to ‘Y’ for my user, execute FLUSH PRIVILEGES, log out, and log back in.
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 what SHOW VARIABLES does. — Yes, this is true, but neither commands’ output makes sense, really. If you do SHOW [SESSION] STATUS, you get a mix of session-scoped and global-scoped results back, and there’s no way to tell which is which. Same goes for SHOW [SESSION] VARIABLES. Ugh. …
Test
I ran across this article while going through some of the articles on Planet MySQL. The article is about how to properly file a bug report. It’s very well written, you can find the article here. If you use software, you need to read this. (That means all of you do).
The post that took me to this article, is here.
Tags: bug reports,, software qa
T-Dose, the Technical Dutch Open Source Event, a kind of Fosdem but in Eindhoven has just released their Call for Papers / Participation.
Go and have a look at it.. they are looking at all kind of open source contributions, ranging from Linux on the desktop, Weird things to do with MySQL to Open Source Games.
Go read the CFP yourselves at the T-Dose site
On one hand I want to be there.. on the other hand .. I hope to miss T-Dose in favour of LiSA 06
Vani and I both started using "Life Balance":http://www.llamagraphics.com/LB/LifeBalanceTop.html for our todo lists in the last week or two. It's great so far.
One of the items I added was a occasionally recurring "File a bug report" task.
Writing a "good bug report":http://www.chiark.greenend.org.uk/~sgtatham/bugs.html is a relatively quick and easy way to help the authors and maintainers of the software you use make it better.
I was working a bit with "Xen":http://www.cl.cam.ac.uk/Research/SRG/netos/xen/ on Fedora Core 5 some days ago and found out that the default scripts don't deal nicely with anything but the most basic net configuration. "Hello bugzilla":https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=193322.
MySQL is one of the nicest projects to file bug reports for, because they are very nice about "following up":http://bugs.mysql.com/bug.php?id=19498 and actually …
[Read more]Vani and I both started using "Life Balance":http://www.llamagraphics.com/LB/LifeBalanceTop.html for our todo lists in the last week or two. It's great so far.
One of the items I added was a occasionally recurring "File a bug report" task.
Writing a "good bug report":http://www.chiark.greenend.org.uk/~sgtatham/bugs.html is a relatively quick and easy way to help the authors and maintainers of the software you use make it better.
I was working a bit with "Xen":http://www.cl.cam.ac.uk/Research/SRG/netos/xen/ on Fedora Core 5 some days ago and found out that the default scripts don't deal nicely with anything but the most basic net configuration. "Hello bugzilla":https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=193322.
MySQL is one of the nicest projects to file bug reports for, because they are very nice about "following up":http://bugs.mysql.com/bug.php?id=19498 and actually …
[Read more]