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
epends upon whether
MySQL is writing to temp tables and/or doing file sorts or is simply
changing a LOT of rows.
-Is your "% idle" very low (especially in conjunction with low "bi"/"bo"
numbers)? If so, a new CPU will probably help.
-JF
> -Original Message--
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
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 anyone have a good idea of th
