very slow delete queries - never ending

I have a problem with a bigger table on mysql 4.0.16-log / debian linux I played around with indexes, delete quick and such, but I just can't get it to work. The following table holds 35mio rows and has 5mio inserts/replaces per day. to clean it up I want to delete all rows older than X days. I

Can somebody help me with round (columna,columnb) ?

Hi I'm having a simple but annoying problem: i want to round() the value of a column, but the number of digits is depending on the value of another column. i found out, that this doesn't work: create table testme - (number double (5,4),digits tinyint(3)); Query OK, 0 rows affected (0.08

RE: Can somebody help me with round (columna,columnb) ?

Hi Dan, Your suggestion works but it slows down things a lot. Thats just a workaround, my quick tests showed it takes about 30% longer for the query to complete... It seems to be a bug in mysql, but the problem is that my whole thing is running fine on a bigger production system and I'd not

Query Problem - need some help here or is it just impossible the way i want it to work?

Hi there, I've been trying around for some time now and i just don't see a solution to my problem: I have a table called feiertage (Holidays):; mysql select * from feiertage;explain feiertage; ++ | datum | ++ | 2001-12-24 | | 2001-12-25 | | 2001-12-26 | | 2002-01-01

table full on innodb-tables?

hi could anybody give me a hint what a table is full-error on an InnoDB-Table means? I had converted some MyISAM-Tables (about 300.000 rows each, 10-23 columns of different integer-types, 3-6 indexes) on a test-system because i hoped for better performance since i have lots of updates and reads