Posted by peter |
I did not usually go to “Elite” servers on Dell web site but looking at customers system today I went to check Dell Poweredge R900. This monster takes up to 4 Quad Core CPUs and has 32 memory slots, which allows to get 128GB of memory with 4GB of memory chips. This means upgrade to default configuration to 128GB of memory will cost you just $9600 (list price). I’ve been able to configure on a web the system with 8*2.5″ hard drives RAID and 2 CPUs (just as we usually configure PowerEdge 2950) with 128GB of RAM for about $16000. This means talking to Dell Sales rep it can purchases within $15000. This may sounds as a lot but if you’re memory constrained it is cheaper per GB than buying 32GB box for $6000
[read more...]
Posted by
peter @ 9:15 pm ::
hardware ::
Posted by Baron Schwartz |
We recently examined a customer’s system to try to speed up an ETL (Extraction, Transformation and Loading) process for a big data set into a sort of datamart or DW. What we typically do is ask customers to run the process in question, and then examine what’s happening. In this case, the (very large, powerful) database server was almost completely idle, with virtually no I/O activity or CPU usage. So we looked at the server where the ETL process was running. It was running at 25% CPU usage and was writing some files to disk, but not waiting on I/O.
What’s going on here? Where’s the bottleneck? The process is slow, and neither machine is really doing much work. Why?
[read more...]
Posted by
Baron Schwartz @ 7:01 am ::
tuning ::
Posted by Evgeniy |
Recently, we added information schema support to Google’s userstats patch.
There are three information schema tables added: user_statistics, table_statistics, index_statistics.
One can now use select * from information_schema.user_statistics along with show user_statistics.
Links:
Patch for 5.0.62
Patch for 5.1.26
del.icio.us
digg