(Continued from part II where I tried to fix a bug and found out that the affected part of the code had been rewritten, so the bug didn't exist anymore.)
Magnus gives a helpful hint...
Jun
04
2009
Jun
04
2009
Well, let me cut right to the chase. You can finally search the
archives of PlanetMySQL. Yes, just go to the sidebar, enter your
query and off you go. Yes, it is using a MySQL fulltext search
index, and why not, we are MySQL after all ;) The search is
happening in Boolean Mode so all the operators and expectations for doing such a
search will help you find whatever you are looking for.
But Wait...! There's a bit more than that.
You might notice under each post title there's a new row of
words.
We've been importing the tags you place on your posts for years,
we just never did anything with them. So what can you do?
* You can see how people tagged their posts
* You can click on a tag and see all the similar tags across
PlanetMySQL
* …
Jun
04
2009
Today, I would like to post one of my more favorite tricks. This is a useful trick when you want to obtain a value of a row you have updated. For instance, you have a blogs table and you’ve updated its timestamp and want to know the ID of the table you updated. You can emply this:
First, make sure to set the user-defined variable to NULL:
select @v_id = NULL;
UPDATE blogs SET timestampcol = ?, id = (@v_id := id) WHERE owner = ’someone’ AND title = ‘Hejsan Kaj!’;
Now, you can run:
SELECT @v_id;
And @v_id will contain the id of the row updated. If @v_id is NULL, then that means the row was not updated!
Note: This syntax is for MySQL. Other DBs mileage may vary
Jun
04
2009
|
Tucked at the end of TS-4923, Mahesh had a few slides on DTrace support on GlassFish v3. Not yet in the Preview release we released this week but "soon". The support is via Btrace; Mahesh has promised a writeup on the details and I'll try to get a screencast, maybe a Webinar. With this we will have DTrace support on all the key containers: … |
Jun
04
2009
Dear users,
Devart has released today dbForge Schema Compare for MySQL 1.00 - a special advanced tool for modern comparison and synchronization of MySQL databases. dbForge Schema Compare for MySQL 1.00 meets the needs of both database administrators and developers to automate and simplify the diversity of tasks related to updating and migrating of MySQL databases.
Being part of dbForge Studio for MySQL, a company’s bestseller product for MySQL database administration and development, the functionality of dbForge Schema Compare has met approval of many DBAs and developers.
Speed, simplicity, and safety
As a modern MySQL database management tool, dbForge Schema Compare is based on the solid cornerstones vital for …
[Read more]
Jun
04
2009
|
All this started during a long drive from Charlottesville to Washington, back in November 2008, when I and Dups discussed the status of MySQL Community web presence. We agreed that we needed to enhance the usefulness of the tools for the community, and MySQL Planet was the first candidate for change. Externally, you have noticed very little until now. First, a login, then the voting system, the Buzz, the Italian, Japanese, and Russian aggregators, an improved treatment for group blogs, and finally the Tags and … |
Jun
04
2009
|
All this started during a long drive from Charlottesville to Washington, back in November 2008, when I and Dups discussed the status of MySQL Community web presence. We agreed that we needed to enhance the usefulness of the tools for the community, and MySQL Planet was the first candidate for change. Externally, you have noticed very little until now. First, a login, then the voting system, the Buzz, the Italian, Japanese, and Russian aggregators, an improved treatment for group blogs, and finally the Tags and … |
Jun
04
2009
The current release of MySQL Cluster 7.0 is based on MySQL Server
5.1.34, normally we update the MySQL Server version as soon as a
new one has been released. That is an almost automated process
since it's just another branch in bazaar - ie "bzr pull", resolve
any conflicts and commit.
The cluster team mainly work with the files in storage/ndb/ where
the source for ndbd, ndb_mgmd and all the ndb_* tools for working
with MySQL Cluster is kept. We have also produced improvements to
the MySQL Server itself. While most of them have been merged back
up - either to 5.1 or 6.0 - some hasn't. This means that when
someone touch an are that has been improved we get a few
conflicts when merging down the latest MySQL Server version.
Fortunately that is quite rare now when 5.1 is GA.
Some of the improvements are generic and simply improves MySQL
Server's portability, while some are specific and useful only for
ha_ndbcluster(the MySQL …
Jun
04
2009
In large vBulletin forum we had strange problem in memory table "session", we've 25M post, 1.7M user, 20K online user.So we change engine of session table to InnoDB and set configuration of innoDB as follow (be careful this configuration is not proper for other tables because this is good in performance but bad in crash and recovery, and data reliability)innodb_data_home_dir = /dev/shm/mysql/
Jun
04
2009
If you had to configure a Wordpress MU installation without access to any details of your MySQL Configuration, what would you do?
What top five configuration settings would you use?
I asked the community this question, see For MySQL DBA fame and glory. Prize included and a number of brave soles responded for a chance to win a free copy of MySQL Administrators Bible by MySQL Community She-BA Sheeri Cabral.
There is no perfect answer and of course you would want to set more then five options, however the purpose of the competition was to seek what people would do with limited information and a limited choice of …
[Read more]