high performance mysql

Hello everyone!
I have a site with High-Loaded slow database queries. There is probably a taxonomy
for example:

Hi Everyone.

I was reading on several forums that using MYSQL 5.5 will be a good option as it improves the performance compared to my current version 5.0.77.

I guess we are able to run things, only because we are using boost to completely cache the server.

I have listed some of the status variables from our website's drupal admin below. Some of them, made me think that something is wrong.

What should we do in order to correct the issues.

Hi

Today I talked to an Sysadmin in my favorite coffee bar and he gives me tipp. They are trying out in the firm a new PHP Server called HIPHOP.
http://developers.facebook.com/news.php?story=358&blog=1

You seet it in the URL. Facebook has developed it and delivers 90 % of his webtraffic over Hiphop.

Hello,

I would like to know what are your general advices regarding to a multiserver Drupal website that has to deal with a lot of mySQL queries ? What could be the best architecture for heavy load mySQL deployement ?

I think about a mySQL master/slave configuration, with separate hardware. But I heard that Drupal isn't ready to use a real master/slave configuration, and the slave should only be used as fail-over. Could you confirm this ?

I attached my planned architecture with this post.

Thanks a lot for your time