Jens, as a native German speaker you may want to ask your question
in de.comp.datenbanken.mysql as well.
I guess that's Hypertreading Xeons, so you have 2 physical but> I am running MySQL on a well equipped server, 2Xeon, 4G RAM and
4 logical CPUs, right?
How big is the index? (the .MYI file)> I got one real big table with 10M rows and fulltext index.
With 4 CPUs and 75% idle that means, one of the CPUs is at 100%.> When monitoring the server activity (via vmstat) when issuing the
> query, I see the cpu idle state going down from 100% to exactly 75% and
> minor read activity from the hard disk during search time.
"minor read activity" could be read as "data is cached", however
this could be misleading if your disks are doing many searches
(heads moving). iostat shows you #requests and device utilization.
However it looks as your servers performance is CPU bound.
With 4GB RAM you may set this as high as 2GB. If you're running on> key_buffer = 512M
a 32-bit platform (I guess you are) this is also the limit.
Setting those higher might take load from your disks.> read_buffer_size = 8M
> read_rnd_buffer_size = 8M
This is done automatically as long as your key_buffer is large enough.> BTW: Is there a way to tell MySQL to read the whole index file of one
> specific table into memory, so that searches are executed without any
> disk access?