Re: [Quickfix-developers] reloading mysql database

[Oren M. <or...@qu...>]

We had a problem like this with one of our MySQL databases.  It turns=20
out that MySQL indexes become fragmented over time as you add data.  In=20=

talking with a DBA his recommendation was to reindex periodically (once=20=

a week would probably be fine).  You can create a script to do this and=20=

stick it in a cron.

--oren

On Nov 15, 2004, at 9:35 AM, Clark Sims wrote:

> Queires of fix orders are starting to take a long time in my database=20=

> of fix orders. I thought maybe I should reload the database. After=20
> studying the way it is set up, I don't think this will do anything. I=20=

> only add records, and never delete them. The timestamp is one of the=20=

> keys used to sort the records, therefor the records are inserted in=20
> order, and the index tables should always stay in order.
>  =A0=A0 Do I understand this correctly? My impression is that the =
mysql=20
> database will always stay optimized because of the way quickfix access=20=

> the data.
>
> Do you Yahoo!?
>  Check out the new Yahoo! Front Page. www.yahoo.com=