[replication and using temp tables]

Description: I have 2 Servers one master and one slave. The Master was 3.23.36 and the slave 3.23.44 and i start a replication between these servers. Then i get errors: error 'Unknown table 'o,i'' on query 'drop table db_logistik.o,db_logistik.i from the replication server. I found the bug

Queries with Time=0 in mysql-slow.log

Description: We have a mysql-slow.log activated. We found many queries with a Time of 0. See here: # Time: 010206 13:54:51 # User@Host: xx[xx] @ xx.mobilcom.de [xx] # Time: 0 Lock_time: 0 Rows_sent: 18 select st_klasse,st_wert from stati group by st_klasse,st_wert order by

Server down with ELT,FIELD Funktion and GROUP BY

Description: When I make a "SELECT count(*) AS Anzahl, ELT(FIELD(kundentyp, ... ), ... ) as Kundentyp,kategorie FROM table WHERE ... GROUP BY kundentyp,kategorie ORDER BY kategorie" the Server response with: mysql SELECT count(*) AS Anzahl,