"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
ts.mysql.com
> Subject: slow DELETE query
>
> 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&qu
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
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, call records with no acc
