You've got 1G Ram!
Guys, take a look at the my-huge.cnf in the mysql tree (I've forgot which
folder)
it's not for me :)) it's for customers and because I'm lamer sometimes is
1GB not enough ...
huge.cnf - thanx for hint : mysql-3.23.32/support-files/my-huge.cnf.sh
look at these ... Do You have any other ideas how to improve speet of my
machine ?
Jan
there is #free
total used free shared buffers cached
Mem: 1036004 396204 639800 16396 84032 277300
-/+ buffers/cache: 34872 1001132
Swap: 123900 0 123900
#dmesg
2k available (1352k kernel code, 424k reserved, 10732k data, 64k init)
Dentry hash table entries: 131072 (order 8, 1024k)
Buffer cache hash table entries: 524288 (order 9, 2048k)
Page cache hash table entries: 262144 (order 8, 1024k)
VFS: Diskquotas version dquot_6.4.0 initialized
Pentium-III serial number disabled.
Checking 386/387 coupling... OK, FPU using exception 16 error reporting.
Checking 'hlt' instruction... OK.
POSIX conformance testing by UNIFIX
mtrr: v1.35a (19990819) Richard Gooch ([EMAIL PROTECTED])
Pentium-III serial number disabled.
per-CPU timeslice cutoff: 99.97 usecs.
CPU1: Intel Pentium III (Katmai) stepping 03
calibrating APIC timer ...
..... CPU clock speed is 549.0806 MHz.
..... system bus clock speed is 99.8328 MHz.
Booting processor 0 eip 2000
Calibrating delay loop... 1097.73 BogoMIPS
Pentium-III serial number disabled.
OK.
CPU0: Intel Pentium III (Katmai) stepping 03
Total of 2 processors activated (2192.18 BogoMIPS).
enabling symmetric IO mode... ...done.
ENABLING IO-APIC IRQs
init IO_APIC IRQs
IO-APIC (apicid-pin) 2-0, 2-5, 2-10, 2-15, 2-16, 2-20, 2-21, 2-22, 2-23 not
connected.
..MP-BIOS bug: 8254 timer not connected to IO-APIC
...trying to set up timer as ExtINT... .. (found pin 0) ... works.
number of MP IRQ sources: 17.
number of IO-APIC #2 registers: 24.
testing the IO APIC.......................
IO APIC #2......
.... register #00: 02000000
....... : physical APIC id: 02
.... register #01: 00170011
....... : max redirection entries: 0017
....... : IO APIC version: 0011
.... register #02: 00000000
....... : arbitration: 00
.... IRQ redirection table:
NR Log Phy Mask Trig IRR Pol Stat Dest Deli Vect:
00 001 01 0 0 0 0 0 0 7 51
01 000 00 0 0 0 0 0 1 1 59
02 000 00 0 0 0 0 0 1 1 51
03 000 00 0 0 0 0 0 1 1 61
04 000 00 0 0 0 0 0 1 1 69
05 000 00 1 0 0 0 0 0 0 00
06 000 00 0 0 0 0 0 1 1 71
07 000 00 0 0 0 0 0 1 1 79
08 000 00 0 0 0 0 0 1 1 81
09 000 00 0 0 0 0 0 1 1 89
0a 000 00 1 0 0 0 0 0 0 00
0b 000 00 0 0 0 0 0 1 1 91
0c 000 00 0 0 0 0 0 1 1 99
0d 000 00 1 0 0 0 0 0 0 00
0e 000 00 0 0 0 0 0 1 1 A1
0f 000 00 1 0 0 0 0 0 0 00
10 000 00 1 0 0 0 0 0 0 00
11 0FF 0F 1 1 0 1 0 1 1 A9
12 0FF 0F 1 1 0 1 0 1 1 B1
13 0FF 0F 1 1 0 1 0 1 1 B9
14 000 00 1 0 0 0 0 0 0 00
15 000 00 1 0 0 0 0 0 0 00
16 000 00 1 0 0 0 0 0 0 00
17 000 00 1 0 0 0 0 0 0 00
IRQ to pin mappings:
IRQ0 -> 2
IRQ1 -> 1
IRQ3 -> 3
IRQ4 -> 4
IRQ6 -> 6
IRQ7 -> 7
IRQ8 -> 8
IRQ9 -> 9
IRQ11 -> 11
IRQ12 -> 12
IRQ13 -> 13
IRQ14 -> 14
IRQ17 -> 17
IRQ18 -> 18
IRQ19 -> 19
.................................... done.
checking TSC synchronization across CPUs: passed.
PCI: PCI BIOS revision 2.10 entry at 0xfdb02
PCI: Using configuration type 1
PCI: Probing PCI hardware
PCI->APIC IRQ transform: (B0,I4,P3) -> 19
PCI->APIC IRQ transform: (B0,I9,P0) -> 17
PCI->APIC IRQ transform: (B1,I3,P0) -> 19
PCI->APIC IRQ transform: (B1,I4,P0) -> 18
Linux NET4.0 for Linux 2.2
Based upon Swansea University Computer Society NET3.039
NET4: Unix domain sockets 1.0 for Linux NET4.0.
NET4: Linux TCP/IP 1.0 for NET4.0
IP Protocols: ICMP, UDP, TCP, IGMP
TCP: Hash tables configured (ehash 524288 bhash 65536)
IPv4 over IPv4 tunneling driver
early initialization of device tunl0 is deferred
GRE over IPv4 tunneling driver
early initialization of device gre0 is deferred
Starting kswapd v 1.5
Detected PS/2 Mouse Port.
Serial driver version 4.27 with no serial options enabled
ttyS00 at 0x03f8 (irq = 4) is a 16550A
ttyS01 at 0x02f8 (irq = 3) is a 16550A
ttyS02 at 0x03e8 (irq = 4) is a 16550A
pty: 256 Unix98 ptys configured
Software Watchdog Timer: 0.05, timer margin: 60 sec
Real Time Clock Driver v1.09
loop: registered device at major 7
Floppy drive(s): fd0 is 1.44M
FDC 0 is a National Semiconductor PC87306
sym53c8xx: at PCI bus 1, device 4, function 0
sym53c8xx: 53c895 detected with Symbios NVRAM
sym53c895-0: rev=0x01, base=0xfa201000, io_port=0x9000, irq=18
sym53c895-0: Symbios format NVRAM, ID 7, Fast-40, Parity Checking
sym53c895-0: initial SCNTL3/DMODE/DCNTL/CTEST3/4/5 = (hex) 07/4e/a0/01/00/24
sym53c895-0: final SCNTL3/DMODE/DCNTL/CTEST3/4/5 = (hex) 07/4e/80/00/08/24
sym53c895-0: on-chip RAM at 0xfa200000
sym53c895-0: resetting, command processing suspended for 2 seconds
sym53c895-0: restart (scsi reset).
sym53c895-0: enabling clock multiplier
sym53c895-0: Downloading SCSI SCRIPTS.
megaraid: v107 (December 22, 1999)
megaraid: found 0x8086:0x1960:idx 0:bus 0:slot 9:func 1
scsi1 : Found a MegaRAID controller at 0xc0004000, IRQ: 17
megaraid: [C :B ] detected 1 logical drives
scsi0 : sym53c8xx - version 1.3g
scsi1 : AMI MegaRAID C 254 commands 16 targs 3 chans 8 luns
scsi : 2 hosts.
sym53c895-0: command processing resumed
sym53c895-0-<0,*>: WIDE SCSI (16 bit) enabled.
sym53c895-0-<0,*>: FAST-40 WIDE SCSI 80.0 MB/s (25 ns, offset 15)
Vendor: HP Model: 9.10GB B 80-1205 Rev:
Type: Direct-Access ANSI SCSI revision: 02
Detected scsi disk sda at scsi0, channel 0, id 0, lun 0
Vendor: HP Model: 9.10GB A 80-F309 Rev:
Type: Direct-Access ANSI SCSI revision: 02
Detected scsi disk sdb at scsi0, channel 0, id 1, lun 0
sym53c895-0-<0,0>: tagged command queue depth set to 8
sym53c895-0-<1,0>: tagged command queue depth set to 8
scsi1: scanning channel 1 for devices.
scsi1: scanning channel 2 for devices.
Vendor: HP Model: D5989B Rev: 1.02
Type: Processor ANSI SCSI revision: 02
scsi1: scanning channel 3 for devices.
scsi1: scanning virtual channel for logical drives.
Vendor: MegaRAID Model: LD0 RAID5 34708R Rev: C
Type: Direct-Access ANSI SCSI revision: 02
Detected scsi disk sdc at scsi1, channel 3, id 0, lun 0
scsi : detected 3 SCSI disks total.
SCSI device sda: hdwr sector= 512 bytes. Sectors= 17773524 [8678 MB] [8.7
GB]
sym53c895-0-<1,*>: WIDE SCSI (16 bit) enabled.
sym53c895-0-<1,*>: FAST-40 WIDE SCSI 80.0 MB/s (25 ns, offset 31)
SCSI device sdb: hdwr sector= 512 bytes. Sectors= 17773524 [8678 MB] [8.7
GB]
SCSI device sdc: hdwr sector= 512 bytes. Sectors= 71081984 [34708 MB] [34.7
GB]
eepro100.c:v1.09j-t 9/29/99 Donald Becker
http://cesdis.gsfc.nasa.gov/linux/drivers/eepro100.html
eepro100.c: $Revision: 1.20.2.10 $ 2000/05/31 Modified by Andrey V.
Savochkin <[EMAIL PROTECTED]> and others
eth0: OEM i82557/i82558 10/100 Ethernet, 00:90:27:DD:CD:18, IRQ 19.
Board assembly 701637-001, Physical connectors present: RJ45
Primary interface chip i82555 PHY #1.
General self-test: passed.
Serial sub-system self-test: passed.
Internal registers self-test: passed.
ROM checksum self-test: passed (0x24c9f043).
Receiver lock-up workaround activated.
eepro100.c:v1.09j-t 9/29/99 Donald Becker
http://cesdis.gsfc.nasa.gov/linux/drivers/eepro100.html
eepro100.c: $Revision: 1.20.2.10 $ 2000/05/31 Modified by Andrey V.
Savochkin <[EMAIL PROTECTED]> and others
Partition check:
sda: sda1 sda2 sda3
sdb: sdb1 sdb2 sdb3
sdc: sdc1
Coda Kernel/Venus communications, v4.6.0, [EMAIL PROTECTED]
VFS: Mounted root (ext2 filesystem) readonly.
Freeing unused kernel memory: 64k freed
Adding Swap: 123900k swap-space (priority -1)
and my actual my.cnf:
[client]
#password = my_password
port = 3306
socket = /tmp/mysql.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
user = mysql
skip-locking
set-variable = key_buffer=384M
set-variable = max_allowed_packet=1M
set-variable = table_cache=512
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
set-variable = thread_cache=8
set-variable = thread_concurrency=4 # Try number of CPU's*2
set-variable = myisam_sort_buffer_size=64M
set-variable = max_connections=2048
# Start logging
# log
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
#no-auto-rehash
[isamchk]
set-variable = key_buffer=16M
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
