scuse the ignorance are u saying high cpu usage is better used on one query
or better be freed up for other queries ? ram is always an issue as the
queries get buffered
> Jonathan Hilgeman wrote:
>
>>Currently, I have a Celeron 1.2 Ghz server with 512 RAM, and I'm
>>considering moving to a P4 2 Gh
well the obvious difference between a celeron and a p4 is the cpu cache,
celerons are good for home linux dev box's, i have 2 now but one only has
32meg and is really slow on the queries but they are cheap and do the job i
i rebuilt one and built another box for about 180 AUD :D , i also have a
dua
Is the workload I/O bound, CPU bound, or memory bound?
On Linux, you can get a sense of this as follows:
Run "top" and "vmstat 5" on your MySQL box, and with them running have
your system perform whatever slow operations you are concerned about.
The key numbers here are the "swap used" "% iowai
Jonathan Hilgeman wrote:
>Currently, I have a Celeron 1.2 Ghz server with 512 RAM, and I'm
>considering moving to a P4 2 Ghz with the same amount of RAM. I have a
>few specific tables with several million rows of data, and it takes
>quite a long time to process that data on my current server. Does
At 07:00 PM 8/6/2003, you wrote:
Currently, I have a Celeron 1.2 Ghz server with 512 RAM, and I'm considering
moving to a P4 2 Ghz with the same amount of RAM. I have a few specific
tables with several million rows of data, and it takes quite a long time to
process that data on my current server. D
The fact that you have "several millions of rows" may indicate that you
have an I/O problem, not CPU.. do some benchmarking. and perhaps the
solution is going to (if not already) SCSI drives, or some kind of raid
configuration (recommend raid 0+1)
Or if you want to keep costs low.. perhaps using
>>Jonathan Hilgeman wrote:
>>
>>>Currently, I have a Celeron 1.2 Ghz server with 512 RAM, and I'm
>>>considering moving to a P4 2 Ghz with the same amount of RAM. I have
>>>a few specific tables with several million rows of data, and it
>>>takes quite a long time to process that data on my current