From: Mathias (mathias.engvallcommprove.com)
Date: Fri Jul 01 2005 - 05:37:13 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

Do you mean converting the memory table into MyISAM on a scheduled
basis? (mysqlhotcopy only works on MyISAM and ISAM tables). Or is there
a faster way of storing the table to disk?

  - Mathias

>> 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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]