mysql load balancing

[Miguel Angel Nieto]

Hi,

I am searching fot a Mysql Load Balacing tool. I read about mysql
proxy, sqlrelay, haproxy...

What do you prefer?

What are the benefits and bugs?

:)

Thank you.

-- 
Lo que haría sería hacerme pasar por sordomudo y así no tendría que
hablar. Si querían decirme algo, tendrían que escribirlo en un
papelito y enseñármelo. Al final se hartarían y ya no tendría que
hablar el resto de mi vida.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Why does this query return no rows?

[René Fournier]

This query works as expected:

mysql SELECT id, AsText(coordinates) FROM qs WHERE latitude  48.6 AND 
latitude  53.4 AND longitude  -116.4 AND longitude  -111.6 LIMIT 3;
++--+
| id | AsText(coordinates)  |
++--+
| 168155 | POINT(48.99702035 -111.60886893) | 
| 168154 | POINT(48.99707385 -111.61983703) | 
| 168160 | POINT(48.99712759 -111.63108001) | 
++--+
3 rows in set (0.00 sec)

But this one doesn't:

mysql SELECT id, AsText(coordinates) FROM qs WHERE 
MBRContains(GeomFromText('POLYGON((48.6 -116.4,53.4 -116.4,53.4 -111.6,48.6 
-111.6,48.6 -116.4))'), coordinates) LIMIT 3;
Empty set (0.00 sec)

What am I doing wrong?

...Rene


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Most data sort

[HaidarPesebe]

Dear All,

I need your help to how to call the database.

I've got a mysql database as follows:
--
Name | qty
-
 A 1
 B 2
 A 4
 A 1
 B 1
 A 2
 C 2
 D 1
 C 4

How calling if I want to sort the data according to the most, or the result 
will look like this

A = 7
C = 6
B = 3
D = 1

Thanks a lot
Haidarpesebe