Re: Sort Select by List
Dan Nelson wrote: --snip-- More efficient would be to use the FIELD function: SELECT * FROM team ORDER BY FIELD(office,Exec,VP,Dir); Oops. I only read the replies and not the original post. Assuming there are many other values for the office field, you might want SELECT * FROM team WHERE office = 'Exec' UNION SELECT * FROM team WHERE office = 'VP' UNION SELECT * FROM team WHERE office = 'Dir'; Indeed! :) Especially if the table is of any decent size (I assumed that it was not *huge*). The UNION will give index accesses, the tricks on the ORDER BY will cause filesorts (although, they will still likely be in memory unless you the table is large, again). You should of course EXPLAIN and tune accordingly (with response times as well). Cheers, Mark -- Mark Leith, Support Engineer MySQL AB, Worcester, England, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
libmap.conf file????
Hi, I am running a FreeBSD6.1 Webserver with mysql but having problems I found below mentioned quote on the net? But I don't know where to find this libmap.conf file? -quote from the NET For FreeBSD 6 tests show that using libthr gives the best performance (search on the net for some benchmarks). To use libthr, just download the precompiled mysql for FreeBSD 6, and add the following lines to your /etc/libmap.conf : [mysqld] libpthread.so.2 libthr.so.2 libpthread.so libthr.so After that restart your mysqld, and from then on it should be using libthr. --end of quote... While, it says that one has to download precompiled mysql. But I installed the mysql50-server from the FreeBSD ports collection. 1. I wonder, that would I have to create /etc/libmap.conf file by myself? Or 2. Do I need to install another port to have it work? 3. If I make the file by myself and restart the server, how could I know that mySQL is using now libthr library? Thanks for your help -- Thanks! BR / vj
Re: Sort Select by List
Thanks Dan, It is a very small table. I really appreciate you help. Keith - Original Message - From: Dan Nelson [EMAIL PROTECTED] To: Mark Leith [EMAIL PROTECTED] Cc: Pintér Tibor [EMAIL PROTECTED]; [MySQL] mysql@lists.mysql.com Sent: Saturday, December 16, 2006 9:48 PM Subject: Re: Sort Select by List In the last episode (Dec 16), Dan Nelson said: In the last episode (Dec 16), Mark Leith said: Pintér Tibor wrote: Keith Spiller írta: I'm wondering how I would turn three different queries: SELECT * FROM team WHERE office = 'Exec' SELECT * FROM team WHERE office = 'VP' SELECT * FROM team WHERE office = 'Dir' Into one query with the sort order of office = 'Exec', 'VP', 'Dir'... Thanks, order by right(office,1) or make an extra column for ordering Or be really smart :) SELECT * FROM team ORDER BY office='Exec' DESC,office='VP' DESC, office='Dir' DESC; More efficient would be to use the FIELD function: SELECT * FROM team ORDER BY FIELD(office,Exec,VP,Dir); Oops. I only read the replies and not the original post. Assuming there are many other values for the office field, you might want SELECT * FROM team WHERE office = 'Exec' UNION SELECT * FROM team WHERE office = 'VP' UNION SELECT * FROM team WHERE office = 'Dir'; -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Recommended Hardware Configurations
I am sure this question has probably been asked in this group before, but I would like to get an updated answer. If you were building your own boxes to run clustered MySQL servers, how would you configure the boxes? (This would of course be for an enterprise level database system.) I am looking for an optimal solution that balances cost and performance; and yes, I realize that is a very subjective standard. My intuitive judgment is that we would be better having several smaller systems in a cluster rather than one huge powerful system and that we would be better off building rather than than buying. If you think I am wrong on either of these points, please share your thoughts and send a link to a recommended system. Sincerely, Mike __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Recommended Hardware Configurations
On Sunday 17 December 2006 13:20, Mike Duffy wrote: My intuitive judgment is that we would be better having several smaller systems in a cluster rather than one huge powerful system and that we would be better off building rather than than buying. If you think I am wrong on either of these points, please share your thoughts and send a link to a recommended system. Well, this gets tricky. If you take a look at: http://www.mysql.com/products/database/cluster/faq.html you'll notice very high requirements for each cluster node. This is mainly due to the fact that mysql clustering does not support filesystem writes (right now at least, I've heard that's supported later). That said, the database has to be stored into memory. If you have a 10 node cluster supporting a 5 gig database, that means all 10 boxes have to have 5+gigs of memory, otherwise it won't work. A single system is a bit easier to manage, but you have to be extra particular about your failsafes, as you've now centralized the point of failure to 1 machine. On the other hand, should your database grow, you just feed it more ram and be done with it, or upgrade the server later on (if you get a really large db). -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Recommended Hardware Configurations
On 12/17/06, Mike Duffy [EMAIL PROTECTED] wrote: I am sure this question has probably been asked in this group before, but I would like to get an updated answer. If you were building your own boxes to run clustered MySQL servers, how would you configure the boxes? (This would of course be for an enterprise level database system.) I am looking for an optimal solution that balances cost and performance; and yes, I realize that is a very subjective standard. I once knew someone who was too cheap to buy a computer case, so he mounted a computer motherboard on a piece of plywood and used it. I don't recommend plywood, but for a cluster you may be able to stack cheap motherboards, power supplies, disk drives, and fans in a single larger metal enclosure (depends on how handy you are at this kind of fab in general). This is at the EXTREME low end of price. Even with 5G of RAM on each one, you may be able to average $600 - $700 per motherboard, all costs included. I'd start with a half-height rack enclosure, and see if you can develop a regular pattern to repeat within. Enterprise-grade servers are EXPENSIVE.
bug
i am getting the error somthing like that GET ERROR(127) TABLE HANDLER PROBLEM i am sorry that i coulde not take mysqlbug script thanks ajay,hyderabad,india __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
