; | YES | | NULL| |
> >>>> | call_dest_realm_name | char(3)
> >>>> | YES | | NULL| |
> >>>> | call_dest_crname| char(50)
> >>>> | YES | | NULL|
S | | NULL| |
>>>> | call_pdd| int(5)
>>>> | YES | | 0 | |
>>>> | h323_dest_ras_error | int(2)
>>>> | YES | | 0 | |
>>>> | h323_dest_h225_error| int
call_dest_crname| char(50)
> | YES | | NULL| |
> | call_dest_custid| char(20)
> | YES | | NULL| |
> | call_zone_data | char(20)
> | YES | | NULL| |
> | calling_party_on_dest_num_type | int(1)
> | YES | | 0 | |
> | calling_party_from_src_num_type | int(1)
>
l Message-
>>>From: Jay Pipes [mailto:[EMAIL PROTECTED]
>>>Sent: Wednesday, August 30, 2006 1:44 PM
>>>To: George Law
>>>Cc: mysql@lists.mysql.com
>>>Subject: RE: Degrading write performance using MySQL 5.0.24
>>>
>>>What type of data are
>
> --
> George
>
>
>
>
>
> >>>-Original Message-
> >>>From: Jay Pipes [mailto:[EMAIL PROTECTED]
> >>>Sent: Wednesday, August 30, 2006 12:06 PM
> >>>To: Phantom
> >>>Cc: mysql@lists.mysql.com
>
On Wed, 2006-08-30 at 09:34 -0700, Phantom wrote:
> Here is the schema for the table are generate Sequence Numbers needed per
> item and the table that actually stores the data :
>
> CREATE TABLE SEQUENCE_NUMBER
> (
> USER_KEY VARBINARY(255) NOT NULL,
> SUBKEY VARBINARY(255)NOT NULL,
>
George
>>>-Original Message-
>>>From: Jay Pipes [mailto:[EMAIL PROTECTED]
>>>Sent: Wednesday, August 30, 2006 12:06 PM
>>>To: Phantom
>>>Cc: mysql@lists.mysql.com
>>>Subject: Re: Degrading write performance using MySQL 5.0.24
>>
On Wed, 2006-08-30 at 08:31 -0700, Phantom wrote:
> We have an application that stores versioned data in MySQL. Everytime a
> piece of data is retrieved and written to, it is stored in the database with
> a new version and all old versions are subsequently deleted. We have a
> request rate of 2 mil