checksum error in innodb - what can do to find the reason ?

, Christian Rabe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

AW: Problem with query cache and comments

I may add, that it is always the same comment, so the query is exactly the same and SHOULD be cached. -Ursprungliche Nachricht- Von: Christian Rabe [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 12. Januar 2003 01:41 An: [EMAIL PROTECTED] Betreff: Problem with query cache and comments Hi

Problem with query cache and comments

, but there are no more hits I dont think this is intended ... Please reply or CC me directly, because I'm not on the list atm. Thanx and Regards, Christian Rabe - Before posting, please check: http://www.mysql.com/manual.php

Is there a function like for multiplying grouped values ... ?

Say, I have a table (simple case): +--+---+ |id|val| +--+---+ | 1| 10| | 1| 20| | 2| 5| | 2| 5| | 2| 10| +--+---+ SELECT id, MUL(val) FROM above_table GROUP BY id; I would get: ++---+ | id| MUL(val)|

AW: User Define Function

I'm having the same problem (Invalid Argument) at the moment. Did you find any solution ? Thanx -Ursprüngliche Nachricht- Von: Elteto Zoltan [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 16. April 2002 11:32 An: [EMAIL PROTECTED] Betreff: User Define Function Hi all, I need to

AW: AW: User Define Function

]] Gesendet: Donnerstag, 18. April 2002 13:17 An: Christian Rabe; [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: Re: AW: User Define Function No I have not :((( And believe me I have tried several posibilities... I have on one mysql server such a setup and this works good. So I have made

Creating an unique multipartkey with first part often NULL in InnoDB takes forever ...

Hi, reading the table-dump with MyISAM takes about 30 seconds. With InnoDB it ran 3 hours before I killed it. I removed the Unique-key definitions and it took 22 seconds with InnoDB. Now I'm creating one unique key and it's running more than 20 hours already. Perhaps someone with a

AW: Creating an unique multipartkey with first part often NULL in InnoDB takes forever ...

Here is the time for creating one unique index. Query OK, 211921 rows affected (1 day 9 hours 23 min 43.63 sec) Records: 211921 Duplicates: 0 Warnings: 0 And its already on the todo to disable unique secondary keys temporarily :) -Ursprüngliche Nachricht- Von: Christian Rabe [mailto

AW: InnoDB frightens me...

Hi :) Are there plans on creating more than on tablesspace plus making them selectable ? So that I can tell the DB: - in which datafiles to store the tablespace X - in which tablespace to store table Y With MYISAM we could simply move the data+index files to a separate disc, create symlinks and

AW: InnoDB frightens me...

tablespace. Regards, Christian -Ursprungliche Nachricht- Von: Rick Flower [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 4. Marz 2002 19:17 An: MySQL Mailing List Cc: Heikki Tuuri Betreff: AW: InnoDB frightens me... Christian Rabe writes: Are there plans on creating more than on tablesspace plus

Replication of rename table

Hi, I just run into a problem. RENAME TABLE put_tablename_here TO another_tablename here is not replicated. But a ALTER TABLE RENAME put_tablename_here TO another_tablename here is replicated. Is this a feature, or do I something wrong ? Regards PS (Filter): Mysql is the greatest

Re: AW: mySQL vs Oracle

some tables to extra discarrays to take some load from the machine. Regards On Mon, 22 Jan 2001, Christian Rabe wrote: we use mysql here for our whole site. there are up to 500 inserts/second alone from the stockdata-feed and thats only part of our site and about 200-300 selects/second per