----- Original Message -----
From: "Achilleas Mantzios" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 20, 2001 11:49 PM
Subject: [aseek-users] Mysql tuning
> From what i've seen, the tables that are likely to be simultinously opened
> for searchd are: wordurl,stats,urlword,urlwordXX, and for the mostly
common
> words the aspseek installation directory.
>
> Is it a ggod idea to place each one on a separate disk??
This idea is good if you expect many simultaneous searches. If only one
search is performed at a time, then those tables are accessed sequentially
and placing them to separate disks will not give performance improvement.
> Is there an analogous estimation for indexing??
Since "index" opens only one database connection and each SQL query is
protected by mutex, there is no sence to place database files to different
disks.
It would have sense to place tables urlwords00..15 to different disks,
if we would implement multiple database connections in "index".
> Did i miss some table??
>
Actually, most of time is required for reading binary files from
directories 00w..99w.
> Thanx ,
>
> Achilleas.
