Upgrading Mysql from 3.22 to 3.23

Hi there, Looking at upgrading from version 3.22.27 to the current release of 3.23 on Solaris 2.7 platform. We successfully built from built the 3.22.27 and looking to do the same with 3.23. Are there any gottcha's out there that I should be aware of? I looked at the Mysql documentation and

Help Slow Query

Hi there, I have a query that is taking 19 - 23 sec's to complete, it used to take 5 sec or less to complete, the only thing we have added are a new database unrelated to this on. The system is a Sun Ultra 10s running Solaris 2.7 with 256mb and 333mhz processor. Mysql version is 3.22.27. Any

Slow Loading page and query

Hi there, Using MySQL 3.22.27 and php3. The page I have does 7 queries to the database and then displays the page. The first time it runs it takes 9 secs or more before the data is displayed and then after that the thread is cached on MySQL. But when I run the same Query from MySQL console I

how force mysql to use certain indexes

Hi there, I'm using mysql 3.22.27. How can I force mysql to use index's in my select statement? When I use explain to see what the optimiser is doing I see that its using the wrong index. When I try to use the USE INDEX(KEY1,KEY) i get a syntax error. Any ideas Thanks, Pat Pat Militzer

SQL Syntax question

Hi there, I'm using mysql 3.22.27 and get error when trying to run this select statement: SELECT custmls.mlsnumber,custmls.streetnumber,custmls.streetdirect, FORMAT(custmls.currentprice,0),custmls.streetnam,custmls.streetaddtl, custmls.municname,custmls.state,custmls.zipcd,custmls.salesassoc,