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.
Thanks for your reply, but my problem is not solved by your suggestions:
> mysql>> select *,max(cb) from testb left join testa using (ca) group by
> > testb.ca;
> This query selects all the fields from testb (ca, time) AND
> testa (ca, cb) because of the LEFT JOIN you used. You should
> try spec
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 lik
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
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
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-0
