RE: MySQL 4.1.1 has been released

2003-12-05 Thread Boehn, Gunnar von
Hallo Lenz, > From: Lenz Grimmer [mailto:[EMAIL PROTECTED] > > Any chance to offer binaries for PowerPC Linux as well ? (Preferable > > tgz) > > Yes, we plan to offer Linux/PPC binaries in the near future - we're > currently working on purchasing a system for that. If you have some harddisk sp

RE: fulltext search speed issue with SQL_CALC_FOUND_ROWS

2003-12-05 Thread Boehn, Gunnar von
Hi TK, There was an optimizer bug in MySQL 4.0 This bug is fixed in 4.0.17 (not yet released) # Fixed bug when the optimiser did not # take SQL_CALC_FOUND_ROWS into account # if LIMIT clause was present. (Bug #1274) Kind regards Gunnar > -Original Message- > From: [EMAIL PROTECTED]

RE: MySQL 4.1.1 has been released

2003-12-04 Thread Boehn, Gunnar von
Hi Lenz, Lenz Grimmer wrote: > MySQL 4.1.1, a new version of the popular Open Source/Free Software > database management system, has been released. It is now available in > source and binary form for a number of platforms from our > download pages Any chance to offer binaries for PowerPC Linux

Feature wish

2003-11-18 Thread Boehn, Gunnar von
Hi, I wonder if a small enhancement to the mysql planner/optimizer could be made. The current (mysql4.0) optimizer only uses one index per SELECT. Because of this some queries result in a slow fulltable scan even if all used columns are indexed. Example: SELECT * FROM table1 WHERE columnA='x' O