Re: Query taking long time

On Tue, Mar 11, 2014 at 3:30 AM, acanada <acanada(at)cnio(dot)es> wrote:

> Hello Evgeniy!
>
> I can move the database to another server...
> This is the cat of /proc/cpuinfo. Does it have enough power or should I go
> for a better one??
>
> (It has 32 processors like this one):
>
> cat /proc/cpuinfo
> processor : 0
> vendor_id : GenuineIntel
> cpu family : 6
> model : 45
> model name : Intel(R) Xeon(R) CPU E5-2670 0 @ 2.60GHz
> stepping : 7
> microcode : 0x70d
> cpu MHz : 1200.000
> cache size : 20480 KB
> physical id : 0
> siblings : 16
> core id : 0
> cpu cores : 8
> apicid : 0
> initial apicid : 0
> fpu : yes
> fpu_exception : yes
> cpuid level : 13
> wp : yes
> flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca
> cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx
> pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl
> xtopology nonstop_tsc aperfmperf pni pclmulqdq dtes64 monitor ds_cpl vmx
> smx est tm2 ssse3 cx16 xtpr pdcm pcid dca sse4_1 sse4_2 x2apic popcnt
> tsc_deadline_timer aes xsave avx lahf_lm ida arat epb xsaveopt pln pts
> dtherm tpr_shadow vnmi flexpriority ept vpid
> bogomips : 5187.62
> clflush size : 64
> cache_alignment : 64
> address sizes : 46 bits physical, 48 bits virtual
> power management:
>
>
> free
> total used free shared buffers cached
> Mem: 65901148 32702336 33198812 0 264936 20625024
> -/+ buffers/cache: 11812376 54088772
> Swap: 134217724 413088 133804636
>

Please let us know the Disk configuration of the server. Also, any other
processes use this server heavily ?

Venkata Balaji N

Sr. Database Administrator
Fujitsu Australia