>>>>> "Numard" == Numard <[EMAIL PROTECTED]> writes:
Numard> hi all!
Numard> i have a db under mysql, where i have some tables which will be updated
Numard> daily, adding a couple thousand records, and adding another couple of
Numard> thousand records. and another table which will have thousand of records
Numard> updated / deleted per user seesion (for a web site).
Numard> what is the best way of keeping up the performance?
Numard> i know that with postgres i should run vacuum, to clean up deleted
Numard> records,etc.
Numard> what about mysql? i know i have to use hte isamchk prog., but with which
Numard> params? on all the tables? one by one? in groups?
Numard> this manteinance job will be run fron a cron job. the db is running on
Numard> FReebsd-2.2.5 ( soon 2.2.8), with mit threads. any special consideration?
Hi!
If you are using fixed length records (no VARCHAR/TEXT or BLOB) you
don't normally have to run isamchk (or very seldom) ; Deleted rows
will automaticly be reused without fragmentation in this case.
In other cases, you can run isamchk with big buffers (try isamchk
--help) at one database at a time.
Regards,
Monty
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
