"Matthew Simpson" <[EMAIL PROTECTED]> wrote on 05/20/2005 02:21:54 PM:
> I use Mysql to store call detail records from telephone calls. I have
> around 20 voice switches that send the call detail records in real time
> using INSERT statements.
>
> I am having a problem where I need to delete "
Also try running the delete more frequently. It won't cause much of a
lock if there is an index on accountcode and mysql doesn't find any rows
to delete.
gerald_clark wrote:
Matthew Simpson wrote:
I use Mysql to store call detail records from telephone calls. I
have around 20 voice switches th
Is MyISAM a bad choice for this kind of table?
- Original Message -
From: "Dathan Pattishall" <[EMAIL PROTECTED]>
To: "Matthew Simpson" <[EMAIL PROTECTED]>;
Sent: Friday, May 20, 2005 1:48 PM
Subject: RE: slow DELETE query
DELETE LOW_PRIORITY
But since
Matthew Simpson wrote:
I use Mysql to store call detail records from telephone calls. I have
around 20 voice switches that send the call detail records in real
time using INSERT statements.
I am having a problem where I need to delete "junk" call records that
get generated [old call records, c
DELETE LOW_PRIORITY
But since your using myISAM the table will have to lock.
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Matthew Simpson [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 20, 2005 11:22 AM
> To: mysql@lists.mysql.com
> Sub
Hi Matthew,
have you any foreign keys, if yes can you show :
- show create table cdr
- show create referenced in foreign keys and foreach the indexes
Mathias
Selon Matthew Simpson <[EMAIL PROTECTED]>:
> I use Mysql to store call detail records from telephone calls. I have
> around 20 voice