Re: 6.2 Stable + Mysql 5.0 poor performance



----- Original Message ----- From: "Cheffo" <cheffo@xxxxxxxxxxxxxx>
CPU: Intel(R) Xeon(R) CPU 5130 @ 2.00GHz (2002.99-MHz K8-class CPU)
avail memory = 8265285632 (7882 MB)
FreeBSD/SMP: Multiprocessor System Detected: 4 CPUs
da0 at arcmsr0 bus 0 target 0 lun 0
da0: <Areca ARC-1110-VOL#00 R001> Fixed Direct Access SCSI-5 device
da0: 166.666MB/s transfers (83.333MHz, offset 32, 16bit), Tagged Queueing Enabled
da0: 610351MB (1249999872 512 byte sectors: 255H 63S/T 77808C)
(RAID 10 4x160GB SATA)
FreeBSD tiger.cmotd.com 6.2-STABLE FreeBSD 6.2-STABLE #5: Mon May 14 17:12:39 EEST 2007 root@xxxxxxxxxxxxxxx:/usr/obj/usr/src/sys/CORE64-SMP amd64

1)Default settings:

select_index 20000 1 0 8075.95
select_index 20000 1 0 8111.38
select_index 20000 1 0 8329.87
select_index 20000 1 0 8105.15
select_index 20000 1 0 8108.48

2)kern.timecounter.hardware: HPET -> TSC

select_index 20000 1 0 8927.00
select_index 20000 1 0 8978.22
select_index 20000 1 0 9076.20
select_index 20000 1 0 9043.15
select_index 20000 1 0 9158.74

3)Changing /etc/libmap.conf

select_index 20000 0 0 35888.48
select_index 20000 0 0 38044.08
select_index 20000 0 0 37984.83
select_index 20000 0 0 37763.64
select_index 20000 0 0 37799.25

4)cp /usr/local/share/mysql/my-large.cnf /var/db/mysql/my.cnf

select_index 20000 0 0 40816.66
select_index 20000 0 0 39808.36
select_index 20000 0 0 39508.28
select_index 20000 0 0 38147.48
select_index 20000 0 0 38002.08

This sparked me to test our machine here:

CPU: Intel(R) Xeon(R) CPU X5355 @ 2.66GHz (2666.68-MHz K8-class CPU)
real memory = 9395240960 (8960 MB)
avail memory = 8295161856 (7910 MB)
FreeBSD/SMP: Multiprocessor System Detected: 8 CPU
da0 at arcmsr0 bus 0 target 0 lun 0
da0: <Areca ARC-1220-VOL#00 R001> Fixed Direct Access SCSI-5 device
da0: 166.666MB/s transfers (83.333MHz, offset 32, 16bit), Tagged Queueing Enabled
da0: 333785MB (683591680 512 byte sectors: 255H 63S/T 42551C)
FreeBSD test 6.2-RELEASE-p3 FreeBSD 6.2-RELEASE-p3 #2: Thu Apr 26 15:20:20 BST 2007 root@test1:/usr/src/sys/amd64/compile/MPUK_SMP amd64

Using all the enhanced settings mentioned except TSC as it doesnt seem to apply even when set.
select_index 200000 0 0 23990.95
select_index 200000 0 0 21578.29
select_index 200000 0 0 21342.61
select_index 200000 0 0 20808.31
select_index 200000 0 0 22401.80

So something very bad is happening here as with 21.28Ghz of CPU its scoring half that
of your machine which only has 8Ghz. Is STABLE that much quicker than RELEASE?

Regards
Steve


================================================
This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it.

In the event of misdirection, illegible or incomplete transmission please telephone +44 845 868 1337
or return the E.mail to postmaster@xxxxxxxxxxxxxxxx

_______________________________________________
freebsd-performance@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "freebsd-performance-unsubscribe@xxxxxxxxxxx"



Relevant Pages

  • Re: Windows XP Home Edition SP2 NTFS
    ... Settings in the BIOS (software on a flash memory chip) can be set ... BIOS settings for increasing CPU speed and/or memory speed can not ...
    (microsoft.public.windowsxp.basics)
  • Re: Windows XP Home Edition SP2 NTFS
    ... Settings in the BIOS (software on a flash memory chip) can be ... BIOS settings for increasing CPU speed and/or memory speed can not ... physically damage the CPU or memory. ...
    (microsoft.public.windowsxp.basics)
  • Re: P4P800se and populating all memory slots?
    ... do you have some memory setting set to "Turbo"? ... (Turbo and other undefined settings like it). ... your CPU, ...
    (alt.comp.periphs.mainboard.asus)
  • Re: pcib allocation failure
    ... pcib1: attempting to grow prefetch window for ... attempting to grow memory window for ... cpu0: on acpi0 ... <ACPI PCI bus> on pcib0 ...
    (freebsd-current)
  • Next July 27: boot failure(hang) on x86_64 box.
    ... Freeing unused kernel memory: 1360k freed ... ACPI: PM-Timer IO Port: 0x488 ... CPU: L2 Cache: 1024K ... # AX.25 network device drivers ...
    (Linux-Kernel)