List:General Discussion« Previous MessageNext Message »
From:Mathias Date:July 1 2005 7:55am
Subject:Re: Possible to delay index writes until server is less busy?
View as plain text  
gunmuse@stripped wrote:

> Write to a memory table first then do a hotcopy on a scheduled basis.

I'll look into that. Thanks for your reply.

  - Mathias



>
>
>
> ----- Original Message ----- From: "Mathias" 
> <mathias.engvall@stripped>
> To: <mysql@stripped>
> Sent: Thursday, June 30, 2005 9:10 AM
> Subject: Possible to delay index writes until server is less busy?
>
>
>> We've been benchmarking a database that in real-life will have a huge 
>> write load (max peak load 10000 inserts/second) to the same table 
>> (MyISAM).
>>
>> We will need about 4 indexes for that table. However, from our 
>> benchmark tests, it is clear that writing indexes takes too many 
>> resources and impedes the speed of inserting new records.
>>
>> To overcome this, we are thinking of:
>> 1 -  using several smaller tables (instead of one big one) by 
>> creating and writing to a new table every x hours,
>> 2 -  wait with writing the indexes until a new table has been created 
>> where the next inserts will be (i.e, not write indexes until the 
>> table has been closed)
>>
>> The biggest problem now is if the indexes are created when the server 
>> is very busy. If there was a way of telling MySQL to delay creating 
>> the indexes when it is busy, then a big obstacle would be out of the 
>> way.
>>
>> Is this possible? We could not find anything in the MySQL 
>> documentation concerning this.
>>
>> Any suggestions would be greatly appreciated.
>>
>> Kind regards,
>>
>> Mathias
>>
>>
>> -- 
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    
>> http://lists.mysql.com/mysql?unsub=1
>>
>>
>>
>


Thread
Possible to delay index writes until server is less busy?Mathias30 Jun
  • Re: Possible to delay index writes until server is less busy?gunmuse30 Jun
    • Re: Possible to delay index writes until server is less busy?Mathias1 Jul
    • Re: Possible to delay index writes until server is less busy?Mathias1 Jul
  • Re: Possible to delay index writes until server is less busy?Dan Nelson30 Jun
    • Re: Possible to delay index writes until server is less busy?Mathias1 Jul
      • Re: Possible to delay index writes until server is less busy?Dan Nelson1 Jul