I have now tried out the buffer split page hash patches on
both a Linux/x86 box and a SPARC/Solaris server (tests done
by Dimitri).

The three variants in short description are:
1) The Google v3 derived patch. This introduces a new array
of mutexes that only protect the buffer page hash. Thus some
extra checking is needed to ensure the page hasn't been
removed from the hash before using it. This is a very simple
and attractive patch from that point of view. The patch uses
an array of 64 mutexes.

2) A variant I developed with some inspiration from the Percona
patches. This patch uses an array of page hashes which each has
its own read-write lock. I've tried this with 1, 4 and 16 page
hashes and 4 is the optimum number. The rw-lock protects the
page hash long enough to ensure that the block hasn't been
possible to remove from the …

ScienceLogic embeds MySQL in its EM7 network management appliances. An installation of EM7 can perform over half a billion database queries daily, storing massive amounts of data for both real-time and trended performance reporting.

Michael McFadden, senior software architect with ScienceLogic, will discuss all this in an upcoming MySQL webinar.

ScienceLogic embeds MySQL in its EM7 network management appliances. An installation of EM7 can perform over half a billion database queries daily, storing massive amounts of data for both real-time and trended performance reporting.

Michael McFadden, senior software architect with ScienceLogic, will discuss all this in an upcoming MySQL webinar.

Hi all,

Up until now, I've been working with Fedora AMIs in my quest to master working with virtual servers on AWS. Today I jumped over to an OpenSolaris AMI.

I love it! The pkg command makes things very easy.

So far installing things like Ant, JDK, and MySQL have gone perfectly. I'll write more as I learn.

Cheers!

--James

Hi all,

Up until now, I've been working with Fedora AMIs in my quest to master working with virtual servers on AWS. Today I jumped over to an OpenSolaris AMI.

I love it! The pkg command makes things very easy.

So far installing things like Ant, JDK, and MySQL have gone perfectly. I'll write more as I learn.

Cheers!

--James

(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...

read more

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
* …

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

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 …